2016-05-26 06:17:58,825-70209083 [http-8080-62] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 6204 Address: http://qa4amltest.aml-qa4-front1:9955/sapi/rest/perf-reports/MONTHLY_MERCHANT_PERF_REPORT.csv?merchantID=7328786f-a849-46d4-b7b8-10f703b66f03&service=BING&token=JYFB6WIE6QNYPNTXOUFGXGCYIOA3VAWA574MVSFBH2QSC5KAZSJQC6N7NNHG4522M2GOXHMC5B7V7LPBKJLBC4OE2CJZ3DJVEFL6EEXEJYTBPY4YDZXLSF5CJWTAIICIYUP5PY7QLKF3QKODI474Y426LVSTQ7QTI4AGV4OB5XGKWMAIIK3PYN74WCF2HCB5VUB3AIYO2JFOBO6NYYHDQJM54QOQ7AM5YZWO6RYBUFDCZSCKGBMT2EWGWND37D6HH3XB2NP4NKSXS2RP2WD4GAAEM2HNWHQHFMLDDQ2DGCNUC2SCDCCEDDB7RWEOTN3BR7ND33RQGIKIRKGTG53EYT4OPNLZ7HQWGFBZA46B2NYXCWGPX7S7QWAGT56E3NMKPYZBVYXV4NJ3UQMKI2VCCEIW2N4BGRHMTHB77H6JOLCDWNIFOGO4SIOLXUE4BBSQGIBOOGA3GI67UTBRPVNMLHVPE4RN4EAGMTVIDUAY5GSH4NRTUI23KBRXI7AJUYJQPSCE5RVEV2QJS5SRKWHZCDRDEDKDXS6ZMS7MHV3ZYVD3VICID6PC7TFH7SRVM6NUCIA7C54DQO26NKVR7B35CSOB4N75MAXMC3UP2TU6ZFFVQ5W4L5A7OLWHPRBB7YLX3T3LHVXVC7OKDHKPMSY34AUOVI62AL7G5CF6EYYB7YQSM757PFS7DI5OURYE7BVUT72YJLYUBE6PJLJ6YFWEA7D4FMSWW532KROFAVJHAWZ7TY4VPT76SFLJE2KAOPLJ6OSG5P5O57KGAWYAR3DRBFG45VZDLKJJHKJL3FWSL34ZAIMZP3OGMWLHFX5YCPK4VMRCSIJCHFVZ6MWHERMOO4ROLSZ7WRJ6FTH2KZ6MOWNTZMTHNUX4OOZKGAIZV4AIOW53CT33DF3T6JG6E4BHN4LHF7MIZ6ZII7AFQ4LG7UHBQA4CAZQBRHRIPAAQAWUTU7CBWQBHXFQCE35URVL5IGOU3CDGUVMKF52IRVCR7NWZ2NJG7BLAJXW7HXZ4BUCLAIBRUWXDOSO6CXWEHPKMHH2XORYPMLX32HVPFHBF6WATW5ZBZYULDRGBOLVUAIQI34NTQTV3XLYILDPT6MSF4WJGIH3MVSO6DUDTVNKWCFAJOMW3XJ3TGTZWYN4HLRYRX332ZSTHJYZCRJVHKF57GLNFMPBWFYXL2CEJOGM5F7YHWRSPZ2YS2TEMVHYYBQ7SJUGELDYSFQPLS53PGHPMOXBZRIHNALIEWSS5FCQJAJFTKGAA5Q767BF7PVQWSCBB6MX74C4OKNFFDRVPCVTFDCGBUVEGTLU66NR5FSM2E4BQFC5K5ZUTGQARXXIC7WNXL7N6JVWAQFPLW3J5SKDUO7525GYS52DN4OADL5V7BRA5N5C5EE75M2YVQBJ7SLAB4YJXHH7RK6DOWW6XFXFZUOZ6JYHT3QFFW5LMGU5AZ7L622V7P4A3CGAKNGBNR5U7SEYUCFBLXOHR2KFYFYNW5ZQRZMGIVE7GWJ2SWIN2OR6YBC7TDUUVOE2K2A2VQBWIHP66GDBQJAGPTFTCMVV6TWENXHFWY5QCKRMV2UVC3QIRV55AUAJHZYK3DP64DOU4MJG5HOQTDPB5Z6GCYI3TZSYPRQBINBWN76LEVY7SWKV33QGAEMPCHGPOXRS4GLYBZVOKK2KJF3Z3AQF4YPULMMWFESMTEX4JIDP6RCNG4GBJOPHGZX4Z6IVHEEPGOG7QME6YS4AC7MFOH75VCHVNF2XBUDBTWG45RAFGDY4455XFRWIOH5XDKR6WOPNTJUJOB465GP737N3IO=== Http-Method: GET Content-Type: Headers: {accept-encoding=[gzip, deflate, sdch], accept-language=[en-US,en;q=0.8], connection=[keep-alive], Content-Type=[null], cookie=[_ga=GA1.2.2080366053.1458733518], host=[qa4amltest.aml-qa4-front1:9955], user-agent=[Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36]} -------------------------------------- 2016-05-26 06:17:58,850-70209108 [http-8080-62] ERROR com.thesearchagency.services.report.internal.dao.SpringReportDao [timezone=Etc/UTC, principalId=, requestId=5e3d509d-6c81-4db8-b681-afbdca0fb069, 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.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [SELECT mp.merchant_uuid as merchant_uuid, '' as reporting_date, m.display as merchant_name, m.customer_id as merchant_id, SUM(mp.imps) as impression_count_total, SUM(mp.clicks) as click_count_total, SUM(mp.cost) as cost_total, SUM(mp.call_leads) as call_leads_total, SUM(mp.adwords_leads) as paid_search_leads_total, SUM(mp.analytics_leads) as analytics_leads_total, SUM(mp.adwords_leads) + SUM(mp.analytics_leads) as onsite_actions, SUM(mp.adwords_leads) + SUM(mp.analytics_leads) + SUM(mp.call_leads) as total_leads, SUM(mp.cost) / NULLIF((SUM(mp.adwords_leads) + SUM(mp.analytics_leads) + SUM(mp.call_leads)), 0) as cost_per_lead, YEAR(mp.start_date) as startYear, MONTH(mp.start_date) as startMonth FROM merchant_performance mp JOIN merchants m ON m.id = mp.merchant_uuid WHERE merchant_uuid = ? GROUP BY startYear, startMonth ORDER BY startYear desc, startMonth desc;]; Parameter index out of range (2 > number of parameters, which is 1).; nested exception is java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:686) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:698) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at com.thesearchagency.services.report.internal.dao.SpringReportDao.query(SpringReportDao.java:52) ~[aml-report-service-2.9.2.jar:2.9.2] at sun.reflect.GeneratedMethodAccessor450.invoke(Unknown Source) ~[na:na] 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) [spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [spring-tx-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [spring-aop-3.1.2.RELEASE.jar:3.1.2.RELEASE] at sun.proxy.$Proxy67.query(Unknown Source) [na:na] at com.thesearchagency.services.report.internal.ReportServiceComponent.getReport(ReportServiceComponent.java:50) [aml-report-service-2.9.2.jar:2.9.2] at com.thesearchagency.sapi.services.report.PerformanceReportService.getReport(PerformanceReportService.java:147) [PerformanceReportService.class:na] at sun.reflect.GeneratedMethodAccessor494.invoke(Unknown Source) ~[na:na] 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:181) [cxf-core-3.0.7.jar:3.0.7] at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97) [cxf-core-3.0.7.jar:3.0.7] at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:200) [cxf-rt-frontend-jaxrs-3.0.7.jar:3.0.7] at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99) [cxf-rt-frontend-jaxrs-3.0.7.jar:3.0.7] at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59) [cxf-core-3.0.7.jar:3.0.7] at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96) [cxf-core-3.0.7.jar:3.0.7] at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307) [cxf-core-3.0.7.jar:3.0.7] at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) [cxf-core-3.0.7.jar:3.0.7] at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:251) [cxf-rt-transports-http-3.0.7.jar:3.0.7] at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234) [cxf-rt-transports-http-3.0.7.jar:3.0.7] at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208) [cxf-rt-transports-http-3.0.7.jar:3.0.7] at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160) [cxf-rt-transports-http-3.0.7.jar:3.0.7] at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:180) [cxf-rt-transports-http-3.0.7.jar:3.0.7] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:293) [cxf-rt-transports-http-3.0.7.jar:3.0.7] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:217) [cxf-rt-transports-http-3.0.7.jar:3.0.7] 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:268) [cxf-rt-transports-http-3.0.7.jar:3.0.7] 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: Parameter index out of range (2 > number of parameters, which is 1). at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) ~[mysql-connector-java-5.1.23.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) ~[mysql-connector-java-5.1.23.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) ~[mysql-connector-java-5.1.23.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) ~[mysql-connector-java-5.1.23.jar:na] at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3813) ~[mysql-connector-java-5.1.23.jar:na] at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3795) ~[mysql-connector-java-5.1.23.jar:na] at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3840) ~[mysql-connector-java-5.1.23.jar:na] at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:3784) ~[mysql-connector-java-5.1.23.jar:na] at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:4052) ~[mysql-connector-java-5.1.23.jar:na] at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169) ~[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169) ~[commons-dbcp-1.4.jar:1.4] at org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:365) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:217) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:145) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.core.ArgPreparedStatementSetter.doSetValue(ArgPreparedStatementSetter.java:65) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.core.ArgPreparedStatementSetter.setValues(ArgPreparedStatementSetter.java:46) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:642) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587) ~[spring-jdbc-3.1.2.RELEASE.jar:3.1.2.RELEASE] ... 49 common frames omitted 2016-05-26 06:17:58,854-70209112 [http-8080-62] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 6204 Response-Code: 500 Content-Type: text/plain;charset=UTF-8;version=2.9.0 Headers: {Content-Type=[text/plain;charset=UTF-8;version=2.9.0], Date=[Thu, 26 May 2016 06:17:58 GMT], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[5e3d509d-6c81-4db8-b681-afbdca0fb069]} Payload: Internal server error --------------------------------------