Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: Graffiti v1.00
-
Fix Version/s: Graffiti v1.00
-
Component/s: Reporting
-
Labels:None
-
Environment:
Services-Tagging-Phase-I# 154
AdMax-Tagging-Phase-I# 117
DB: staging-db5, staging-db6, staging-db7
UI: Client-st
Jboss: staging-jboss5
Description
1. Login to Admax
2. Navigate to Home -> Reporting ->Create Reports
3. Submit a report for Avalon bay after selecting the following
=> Level: Account, View By:Summary, Date Range: The Last 12 Months
=> In Custom Data Set, select "All My Accounts, SEM, All Search Engines"
4. Download the report , add some account level tags and upload the tagsheet from "Apply Tags" module (attached tagsheet)
5. Now click on the "create copy of this report" image and submit it again
Observed that the report fails with an errror message as
"An error occurred in this report, which aborted its completion
(Error: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 ''') AS `c277`,SUM(`clConversions`) AS `clConversions`,SUM(`clFulfillCost`) AS `c' at line 1 ):"
Note:
1. check reports, R-364-463 is the successful initial report submitted at step# 3
R-364-464 is the failed report submitted at step# 5
2. Also tried deleting all those tags in the database, but the same error still exists when tried creating the report with the settings at step# 3