adminDownloads folder not created when clicked on Download Shipping Order PL barcodes button

[rohan-morje]

adminDownloads folder not created when clicked on Download Shipping Order PL barcodes button

https://aqua137.healthkartqa.com/admin/store/ABRetailMovement.action

[Shraddhar23]

The adminDownloads folder gets created only if the below query returns some result :

SELECT DISTINCT si.barcode AS barcode, w.identifier AS storeName,pv.id AS nutId, psm.shipping_order_id AS shippingOrderId, psm.source_warehouse_name AS sourceWarehouse FROM (SELECT MAX(pvi.id) AS id FROM sku_item si INNER JOIN product_variant_inventory pvi ON pvi.sku_item_id = si.id WHERE si.sku_item_status_id = 10 AND pvi.qty = +1 GROUP BY si.id) AS pvid INNER JOIN product_variant_inventory pvi ON pvid.id = pvi.id INNER JOIN sku_item si ON pvi.sku_item_id = si.id INNER JOIN sku_group sg ON si.sku_group_id = sg.id INNER JOIN sku s ON sg.sku_id = s.id INNER JOIN product_variant pv ON s.product_variant_id = pv.id INNER JOIN product p ON pv.product_id = p.id LEFT JOIN po_so_mapping psm ON psm.barcode = si.barcode INNER JOIN warehouse w ON s.warehouse_id = w.id WHERE s.warehouse_id = 4033 AND pvi.grn_line_item_id IS NOT NULL AND p.brand IN ('HK', 'HealthKart', 'Incredio', 'Healthviva','MuscleBlaze','Nouriza','TrueBasics','TheProteinZone','Gritzo');