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

Yell Budgeting Tool: Exception in Budget_analyze

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: unspecified
    • Fix Version/s: None
    • Component/s: Yell Budgeting Tool
    • Labels:
      None
    • Environment:

      Operating System: Windows XP
      Platform: PC

    • Bugzilla Id:
      3436

      Description

      I didnt mean to run this for 11/30/09, but anyway, I got this exception when I
      did. It this because its not in current month or last month?

      tsaapp@tvvm-staging-xml1:/usr/local/tsa/bidmgr$ ./budget_analyze.sh -a 17 –
      deSUM-2 -T 2009-11-30
      2010-01-18 06:59:27.924 (3) [main]: Debug Level set to 3
      2010-01-18 06:59:27.950 (2) [main]: Unknown option d
      2010-01-18 06:59:27.957 (3) [main]: No licensing config file found, assuming
      TSA production environment
      2010-01-18 06:59:27.959 (3) [main]: Debug Level set to 4
      2010-01-18 06:59:27.965 (4) [main]: no account, or instance for
      databaseInstance, skipping lookup...
      2010-01-18 06:59:27.970 (3) [main]: DatabasePool with a limit of 80 created
      2010-01-18 06:59:28.017 (4) [ConnectionCloser]: Starting DatabasePool
      ConnectionCloserThread
      2010-01-18 06:59:28.826 (4) [main]: opened [jdbc:mysql://tsacommon-01-
      write/tsacommon?
      useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontT
      rackOpenResources=true&jdbcCompliantTruncation=false]
      2010-01-18 06:59:28.827 (4) [main]: Created new Object
      2010-01-18 06:59:28.831 (4) [main]: spike: SQL->[select @@version]
      2010-01-18 06:59:28.851 (4) [main]: time=0.019
      2010-01-18 06:59:28.852 (4) [main]: Query executed in 0.019s
      2010-01-18 06:59:28.853 (4) [main]: test query succeeded, returned "5.0.30-
      enterprise-gpl"
      2010-01-18 06:59:28.854 (4) [main]: preparing SQL statement [select
      ncm.searchEngineAccountId, pd.performanceDataID, pd.budgetID, targetSpend,
      targetSpendPercent, targetSpendDifference, MTDSpend, yesterdayTargetSpend,
      yesterdayActualSpend, projectedMonthlySpend, yesterdayCPA, lastUpdated from
      yell.PerformanceData pd join yell.Budget as b on b.budgetID=pd.budgetID join
      yell.BudgetNode as bn on bn.budgetID=b.budgetID join yell.NodeCampaignMapping
      as ncm on ncm.budgetNodeID=bn.budgetNodeID join
      tsacommon.searchEngineAccounts seacct on seacct.id=ncm.searchEngineAccountID
      where pd.lastUpdated = ? and seacct.searchEngineStatusText not in
      ('deleted', 'unknown') and seacct.accountID in (17)]
      2010-01-18 06:59:29.067 (3) [main]: Updated 0 rows of algorithm performance
      data!
      2010-01-18 06:59:29.070 (4) [main]: preparing SQL statement [INSERT INTO
      budgetUpdates (`searchEngineAccountID`, `budgetTotal`, `budgetType` `status`)
      VALUES]
      2010-01-18 06:59:29.075 (1) [main]: Exception [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 'status`) VALUES' at line
      1]: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 'status`) VALUES' at line 1
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
      at com.mysql.jdbc.PreparedStatement.executeInternal
      (PreparedStatement.java:1734)
      at com.mysql.jdbc.PreparedStatement.executeUpdate
      (PreparedStatement.java:2019)
      at com.mysql.jdbc.PreparedStatement.executeUpdate
      (PreparedStatement.java:1937)
      at com.mysql.jdbc.PreparedStatement.executeUpdate
      (PreparedStatement.java:1922)
      at
      com.thesearchagency.searchengines.budget.BudgetUpdateDAO.insertBudgetUpdateFrom
      Map(BudgetUpdateDAO.java:160)
      at
      com.thesearchagency.searchengines.budget.target.DailyTargetSetter.updateBudgets
      (DailyTargetSetter.java:51)
      at
      com.thesearchagency.searchengines.budget.target.TargetSetterRunner.run
      (TargetSetterRunner.java:95)
      at
      com.thesearchagency.searchengines.budget.target.TargetSetterRunner.main
      (TargetSetterRunner.java:34)

      2010-01-18 06:59:29.076 (3) [main]: Inserted 0 budget update rows!

        Attachments

          Activity

            People

            • Assignee:
              patrick Patrick Crane (Inactive)
              Reporter:
              jelliott Jen Clarke (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: