Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Daily Data Availability Phase 2
-
Fix Version/s: Daily Data Availability Phase 2
-
Component/s: None
-
Labels:None
-
Environment:
BidManager build on Staging-xm1 - /367/tsa-build-bidmgr-2011-10-17-p367-r30673
Services build on Staging-svc2 and Stagnig-jboss5 - p950-r30673
UI Build on Client-st - /31/AdMax-Time-Zone-p31-r30686
Description
Stat costs doesn't show data - showing exception in debug logs
Steps:
1.Login to Admax : https://client-st.ri.thesearchagency.com/index.php?module=statcosts&debug=4
2.Click on Stat costs link.
3.Select level: Account,
Accounts: All my accounts
View by :day
Date Range:Last year
and click on SUBMIT.
4. See debug logs
[23:13:09, 18 Oct 2011] (4) POSITIONREPORTINGSERVICE: [IN] SoapClientDebugWrapper::__call(String[getKwCostReport], Array[Size:1]) [StkD: 5]
[23:13:09, 18 Oct 2011] (1) POSITIONREPORTINGSERVICE: getKwCostReport: SoapFault message: [requestReportFailed; nested exception is:
com.thesearchagency.service.positionreporting.PositionReportingException: Error getKwCostReport ; nested exception is:
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select tsaAccountID, vendorAssignedID from accountAssignments where vendorID = ? and tsaAccountID in ()]; nested exception is 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 ')' at line 1]
[23:13:09, 18 Oct 2011] (4) POSITIONREPORTINGSERVICE: getKwCostReport SOAP Request: <?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://positionreporting.service.thesearchagency.com/"><SOAP-ENV:Body><ns1:positionReportingService_getKwCostReportRequest><arg0><accountFilter><accFilterType>ALL_ACCOUNTS_USER</accFilterType></accountFilter><dateRange><end>2011-10-18T11:34:55 05:30</end><start>2011-10-18T11:34:55 05:30</start></dateRange><dateRangeType>LASTYEAR</dateRangeType><dateResolution>DAY</dateResolution><pagingInfo><pageNumber>1</pageNumber><pageSize>10</pageSize></pagingInfo><reportLevel>ACCOUNT</reportLevel><sortRequest><sortList><column>DATE</column><direction>ASC</direction></sortList></sortRequest><userID>189</userID><vendorName>STAT</vendorName></arg0></ns1:positionReportingService_getKwCostReportRequest></SOAP-ENV:Body></SOAP-ENV:Envelope>
[23:13:09, 18 Oct 2011] (4) POSITIONREPORTINGSERVICE: getKwCostReport SOAP Response: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>requestReportFailed; nested exception is:
com.thesearchagency.service.positionreporting.PositionReportingException: Error getKwCostReport ; nested exception is:
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select tsaAccountID, vendorAssignedID from accountAssignments where vendorID = ? and tsaAccountID in ()]; nested exception is 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 ')' at line 1</faultstring></soap:Fault></soap:Body></soap:Envelope>
