Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-3086

Reporting: Creating reports with certain custom data setttings for last 12 months fails with MySQLSyntaxErrorException

    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

        Attachments

          Activity

            People

            • Assignee:
              squadrim Mike Squadrito (Inactive)
              Reporter:
              saravanan.t Saravanan (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: