ID: 15472
Address: http:Http-Method: GET
Content-Type:
Headers: {Accept=[text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8], Authorization=[Basic YXV0dW1uLmZyYW5jZXNjYUB0aGVzZWFyY2hhZ2VuY3kuY29tOk4wZXhwZWN0YXRpb25z], connection=[Keep-Alive], Content-Type=[null], host=[amldemo.admaxlocal.com], user-agent=[Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.114 Safari/537.36], x-cluster-client-ip=[70.166.144.17], x-forwarded-for=[70.166.144.17, 10.183.248.5], x-forwarded-host=[amldemo.admaxlocal.com], x-forwarded-port=[80], x-forwarded-proto=[http], x-forwarded-server=[2001:4800:7811:513:dd9d:596:ff04:e422]}
--------------------------------------
2013-11-15 15:15:54,294-752839072 [http-8080-3] ERROR com.thesearchagency.saas.core.services.reporting.internal.dao.SpringReportDao [timezone=UTC, principalId=, requestId=810c32d0-ba93-4d86-97ee-5faebbaed844, locale=en_US, authToken=null, hostname=0:0:0:0:0:0:0:1, ipAddress=0:0:0:0:0:0:0:1] -
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT a.description AS `merchant_uuid`, m.customer_id AS `mechant_id`, sum(w.seImpressions) AS `impression_count_total`, sum(w.seClicks) AS `click_count_total`, sum(w.seAdCost) AS `google_cost_total` FROM warehouse_1.whDailyGroupPerf AS w JOIN tsacommon.accounts AS a ON w.accountID = a.id JOIN merchants AS m ON m.id = a.description JOIN resellers AS r ON r.id = m.reseller_id JOIN realms AS rm ON rm.id = r.realm_id WHERE rm.realm LIKE CONCAT(?, '%') AND w.startTime >= ? AND w.startTime < ? GROUP BY a.description, m.customer_id;]; nested exception is java.sql.SQLException: No value specified for parameter 1
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:686) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:698) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at com.thesearchagency.saas.core.services.reporting.internal.dao.SpringReportDao.query(SpringReportDao.java:50) ~[aml-report-service-2.2.0.jar:2.2.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_24]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.6.0_24]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.6.0_24]
at java.lang.reflect.Method.invoke(Method.java:616) ~[na:1.6.0_24]
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319) [aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at sun.proxy.$Proxy91.query(Unknown Source) [na:na]
at com.thesearchagency.saas.core.services.reporting.internal.ReportServiceComponent.getReport(ReportServiceComponent.java:38) [aml-report-service-2.2.0.jar:2.2.0]
at com.thesearchagency.sapi.services.report.ReportService.getReport(ReportService.java:104) [ReportService.class:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_24]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.6.0_24]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.6.0_24]
at java.lang.reflect.Method.invoke(Method.java:616) ~[na:1.6.0_24]
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180) [cxf-api-2.7.5.jar:2.7.5]
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) [cxf-api-2.7.5.jar:2.7.5]
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:198) [cxf-rt-frontend-jaxrs-2.7.5.jar:2.7.5]
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:100) [cxf-rt-frontend-jaxrs-2.7.5.jar:2.7.5]
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58) [cxf-api-2.7.5.jar:2.7.5]
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:94) [cxf-api-2.7.5.jar:2.7.5]
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:271) [cxf-api-2.7.5.jar:2.7.5]
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) [cxf-api-2.7.5.jar:2.7.5]
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:239) [cxf-rt-transports-http-2.7.5.jar:2.7.5]
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:223) [cxf-rt-transports-http-2.7.5.jar:2.7.5]
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:203) [cxf-rt-transports-http-2.7.5.jar:2.7.5]
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:137) [cxf-rt-transports-http-2.7.5.jar:2.7.5]
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:158) [cxf-rt-transports-http-2.7.5.jar:2.7.5]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:243) [cxf-rt-transports-http-2.7.5.jar:2.7.5]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:168) [cxf-rt-transports-http-2.7.5.jar:2.7.5]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) [tomcat6-servlet-2.5-api-6.0.24.jar:na]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:219) [cxf-rt-transports-http-2.7.5.jar:2.7.5]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina-6.0.24.jar:na]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina-6.0.24.jar:na]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina-6.0.24.jar:na]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) [catalina-6.0.24.jar:na]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) [tomcat-coyote-6.0.24.jar:na]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) [tomcat-coyote-6.0.24.jar:na]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) [tomcat-coyote-6.0.24.jar:na]
at java.lang.Thread.run(Thread.java:679) [na:1.6.0_24]
Caused by: java.sql.SQLException: No value specified for parameter 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2611) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2586) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2510) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2259) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4]
at net.sf.log4jdbc.PreparedStatementSpy.executeQuery(PreparedStatementSpy.java:735) ~[log4jdbc-remix-0.2.7.jar:na]
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587) ~[aml-data-tool-2.2.0-BETA3.jar:2.2.0-BETA3]
... 51 common frames omitted
2013-11-15 15:15:54,301-752839079 [http-8080-3] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message
---------------------------
ID: 15472
Response-Code: 500
Content-Type: text/plain;charset=UTF-8;version=2.2.0
Headers: {Date=[Fri, 15 Nov 2013 15:15:54 GMT], X-AML-API-ID=[810c32d0-ba93-4d86-97ee-5faebbaed844], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]}
Payload: Internal server error
--------------------------------------
Bug
Major
