Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Mercury
-
Fix Version/s: Mercury
-
Component/s: Reporting (Outbound Datafeeds)
-
Labels:None
-
Environment:
Ops Script #886
-
Sprint:Sprint 16
Description
Account level carryover data report throws error with Reseller (-r) option
[amlops@aml-qa4-monman1 reports-multi-realm-dist]$ ./report-account-level-carryover-data.sh -h aml-qa4-mysql1 -u spike -p tar63t -o /var/local/tsa/reports/ -r qa4amltest
/var/local/tsa/reports/
Using /var/local/tsa/reports/ directory.
Using /var/local/tsa/reports/ for output directory.
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''qa4amltest
GROUP BY mer.id, sea.distributionID
ORDER BY re.name, mer.id' at line 14
