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!