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!