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 #870
-
Sprint:Sprint 16
Description
Multi-realm/distribution reports do not support reseller "-r" option
The following scripts when used with "-r" reseller option throws error.
Account Level Performance Data script
Search Engine Campaign Budget Data script
[amlops@aml-qa4-monman1 multi-tenancy-reports]$ ./searchEngine_campaign_budget_data_realms.sh -h aml-qa4-mysql1 -u spike -p tar63t -o /var/local/tsa/reports/ -d 2015-01-12 -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
order by sea.id' at line 30
[amlops@aml-qa4-monman1 multi-distribution-reports]$ ./report-account-level-performance-data-realms.sh -h aml-qa4-mysql1 -u spike -p tar63t -o /var/local/tsa/reports/ -d 2015-01-12 -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 'WHERE re.name='qa4amltest'
GROUP BY d.description, mep.merchant_uuid
ORDER BY ' at line 9
Expected Result: Should run successfully for a specific reseller
