Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: Mercury
-
Fix Version/s: Mercury
-
Component/s: Reporting (Outbound Datafeeds)
-
Labels:None
-
Environment:
Ops Script 3895
-
Sprint:Sprint 17
Description
Account Level Order Data Script runs into error on running the following command
[amlops@aml-qa5-monman1 reports-multi-realm-dist]$ ./report-account-level-order-data.sh -h aml-qa5-mysql1 -u spike -p tar63t -o /var/local/tsa/reports/
SELECT o.id AS 'Order UUID', mer.customer_id AS 'Merchant ID', o.merchant_id AS 'Merchant UUID', '' AS 'Sale Price','' AS 'Nominal Monthly Budget', o.created_on AS 'Creation Date', o.state AS 'State', mer.display AS 'Merchant Name', re.name AS 'REALM', o.json AS 'JSON' FROM smb.orders o LEFT JOIN smb.merchants mer ON mer.id = o.merchant_id LEFT JOIN smb.resellers re ON re.id = mer.reseller_id WHERE DATE_FORMAT(o.created_on, '%Y-%m-%d') <= '2016-01-18' AND re.name='qa5amltest' ORDER BY o.created_on;
/var/local/tsa/reports/
Using /var/local/tsa/reports/ for output directory.
./report-account-level-order-data.sh: line 127: jq: command not found
./report-account-level-order-data.sh: line 128: jq: command not found
./report-account-level-order-data.sh: line 129: jq: command not found
./report-account-level-order-data.sh: line 127: jq: command not found
./report-account-level-order-data.sh: line 128: jq: command not found
./report-account-level-order-data.sh: line 129: jq: command not found
Output file is generated but no data.
Throws the above error continuously.
Verified using Ops Script #895.
