Loading a merchant is running the Merchant Performance Report automatically, and failing

when you click on a merchant in the UI, it seems as though the performance report is running each time, which is incorrect. It is also failing each time it is run. See stack trace below:

2013-09-17 17:36:30,711-35925904 [http-8080-5] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message
----------------------------
ID: 288
Address: http://loadtest.aq-qa-tomcat1:8080/sapi/rest/merchants/f86685ce-623a-4e48-81f8-fab52bcce734
Http-Method: GET
Content-Type:
Headers:

{Accept=[application/json, text/plain], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8,ja;q=0.6], connection=[keep-alive], Content-Type=[null], host=[loadtest.aq-qa-tomcat1:8080], referer=[http://loadtest.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.66 Safari/537.36], x-tsa-authenticate=[X2CU34D5NWDJUW2T6WIEH2QEWLFATFLOIV4WBYYUF5GWT6NQQIMOI44N3FLZ2Y2XZ2CIJ4MRH3HIXN6ZF5HJ5QLFNQDM4B2QPM4USD6JMPWS2O7H6MA4H3UNFEJV57AZT6SNZ6PIRM3RIAB72EWMWMB2XFBDETH7EQ2ZYFP4G7CMOZP3J2665BAO26Y7L6TRKPIL2LQX4UI5TJBWYMAELE7CLQHNBY6WQXKLWY2RDJIQX4AHSWH6UJW2YVDWJYD4JK6ARJ2XIK54BTEIZQK5UUF566SYW6O4EGTGDMDNGTTVGQ5MONW2G767IQOX5RYZ6LTDYNCWKAOJY6EJBZ6ZD5SED5F6O4QHCCQBNMFYPLR4NMO3RV4TV3QPID4P7HWI5RNKH7DX373ISGJ4SGW2SXGLSDTBW67OLZLG5Z2HNK5YFEM6E3NGG56R5IB42ENIX4BE5WAAMMMUFM4NQFQ4W7RAIGAYA6S6ZDULP3G6UYFNSOBXHCXAQIMEL3LE6XQALS3OAEQZWR65HJJNSU4TBVQYLT6W7TILJS72KQW6GLHZCDLT7XMRQF5VIUOSKA6URHFS5AOO3QXEF4ZDXED4CFPOSSNYKDP3EPZWQNQZUGYTB3Z2HEU4RV4FGB4FXIBSXZAMHKVAM6VNSRUMBT6AFTHLERZZW3YLDV73NX2EF6B3MYFV4CS6R2HJGCIVSOUIQKVF6GWQSILX2KBWGPYWPIX52C35BMEX235R6DM53IUJFMLVOFUCYBA7BC2BII7SHBELWWU2J23NUSMUOA7BELCT5VEBSBAOQOEOF5M4MJRNKFCZCTX2DGL3DSWFPXUHBF763NQS4DCF2X42MWORFOQIYVOTXJX7H4AMUPG5RYXXQU6HJFX4QOCZJ3RTJMPH6PVT2YY4YGVBVCTHRULBSCW3SSF2AEGHWX62A2QZXUZVDLAKKPHRJTVDU4ELRIVNP2HNOT3SEZRAKPSD5W7ADETMMTU4SAOUODO44FRTUISP74EZAJ3MPC3S4EFJEVD6TKLDKY7C6GO3VDT2O2QFF754BELC3PA27J43MRGN5A5DJPSGF7C77UQKH6BBPEJ7PR5BIXZOBDRZWBI7OME623O5ZASX2S6FUML34ZN7E3MUO2QRFMHMRYRV6U46IQ6YE3EVGIQ3JJ3JCDJDMNJTBJE5YUOFA6KEALEA3XJZOOL72KSQEXL3QHRRN5UTFTHLH7YJFBUDRVVAJB2U7QJRXH4WP34SPL4QFP4DP2HL4YE2RCXI3DQX5OSQRZSRRJESSTOCR4PNIW6C5IPSFKPCXZKE4NNTLYKRSOW55BKVIHWS267FWPKYDM7DJIFOVR6OMD6ZXAYXGIP46NBXHVTPLLPIH5UB4X7R64XLWONIR7KII4XJ5EW2KMFEFD3JE7AVVHHWSXSFB3FJTM63PTCNBYJCTPHLDZEZ6323UDIJCIXCIOARAX7FGAPOJ626WIB4ZWB4MKRRQZYVDLLFHAVWDT4UEJKJB4HWVXISGXT7743C55RTH2PVKYAEN575NCFNSKL5IOLTC4NRKNVUYXQX5WU4U5QE2NKXOK7P6A7DHY3EYCF33TG3NGBMBWC5ANRSGU2DEFONAUFQ7PNWJ2PBQRYFNUO62YMQBX2KDOBU2R76WWPBINYTN4CMKY2FFRULWSBX5DGFDXFZZVB5TI4IKGP3LYBCCY5XMIXVEXOHAEFSTPSIC56CJEWLRTKQP7ZVNC5JT5IRDRLOZAYGGPALFIVWBIJ5UOCEADQREXA=]}

--------------------------------------
2013-09-17 17:36:30,794-35925987 [http-8080-5] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message
---------------------------
ID: 288
Response-Code: 200
Content-Type: application/json;charset=UTF-8;type=tsa-merchant;version=2.2.0-SNAPSHOT
Headers:

{Content-Type=[application/json;charset=UTF-8;type=tsa-merchant;version=2.2.0-SNAPSHOT], Date=[Tue, 17 Sep 2013 17:36:30 GMT], X-AML-API-ID=[736ac603-5b66-4ce3-80b1-df54775a6186], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]}

Payload: {"name":"11activate","properties":{},"id":"f86685ce-623a-4e48-81f8-fab52bcce734","displayName":"11activate","description":null,"realm":"com.thesearchagency/7bc157c1-c90d-4215-8a0b-01a1da8232fd/f86685ce-623a-4e48-81f8-fab52bcce734","lastModifiedDate":"2013-09-04T13:59:51.000+0000","active":true,"creatorId":"df3d9279-be57-4a5b-a4b3-65b3ce833713","url":null,"customerId":"11activate","contact":{"language":"en","properties":{},"id":"eefc275a-518b-4c1a-816e-31e3e0db916a","displayName":"jeffrey.brown@thesearchagency.com","description":"Merchant user for 11activate","realm":"com.thesearchagency/7bc157c1-c90d-4215-8a0b-01a1da8232fd/f86685ce-623a-4e48-81f8-fab52bcce734","lastModifiedDate":"2013-09-04T13:59:51.000+0000","organization":"11activate","email":"jeffrey.brown@thesearchagency.com","countryCode":"US","workPhone":"4013233333","createdBy":"df3d9279-be57-4a5b-a4b3-65b3ce833713","createdDate":"2013-09-04T13:59:51.000+0000","lastModifiedBy":"df3d9279-be57-4a5b-a4b3-65b3ce833713","active":true,"timezone":"America/New_York","firstName":null,"lastName":null,"homePhone":null,"mobilePhone":null,"gender":"M","birthday":null,"lastLoginDate":"1970-01-01T00:00:00.000+0000","workPhoneExtension":null},"resellerId":"7bc157c1-c90d-4215-8a0b-01a1da8232fd","phoneNumber":"4013233333","groupId":"3f08037e-ff4f-4dda-9e68-0c210af032d9","userId":"eefc275a-518b-4c1a-816e-31e3e0db916a","createdBy":"df3d9279-be57-4a5b-a4b3-65b3ce833713","createdByName":"Load Test Admin User","createdDate":"2013-09-04T13:59:51.000+0000","lastModifiedBy":"df3d9279-be57-4a5b-a4b3-65b3ce833713","lastModifiedByName":"Load Test Admin User","contactEmail":"jeffrey.brown@thesearchagency.com","contactName":"jeffrey.brown@thesearchagency.com","contactPhoneNumber":"4013233333","comments":"update","activeFlag":true,"creatorName":"Load Test Admin User","lastModifierId":"df3d9279-be57-4a5b-a4b3-65b3ce833713","lastModifierName":"Load Test Admin User"}
--------------------------------------
2013-09-17 17:36:30,882-35926075 [http-8080-5] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message
----------------------------
ID: 289
Address: http://loadtest.aq-qa-tomcat1:8080/sapi/rest/orders?q=SELECT%20WHERE%20(associatedMerchant.id%20%3D%20'f86685ce-623a-4e48-81f8-fab52bcce734')%20AND%20NOT%20(state%20IN%20('QUOTE'%2C'CANCELLED'%2C'SCHEDULED'%2C'QUEUED'%2C'ARCHIVED'))%20ORDER%20BY%20modificationDate%20DESC%20LIMIT%201
Http-Method: GET
Content-Type:
Headers:

{Accept=[application/json, text/plain], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8,ja;q=0.6], connection=[keep-alive], Content-Type=[null], host=[loadtest.aq-qa-tomcat1:8080], referer=[http://loadtest.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.66 Safari/537.36], x-tsa-authenticate=[X2CU34D5NWDJUW2T6WIEH2QEWLFATFLOIV4WBYYUF5GWT6NQQIMOI44N3FLZ2Y2XZ2CIJ4MRH3HIXN6ZF5HJ5QLFNQDM4B2QPM4USD6JMPWS2O7H6MA4H3UNFEJV57AZT6SNZ6PIRM3RIAB72EWMWMB2XFBDETH7EQ2ZYFP4G7CMOZP3J2665BAO26Y7L6TRKPIL2LQX4UI5TJBWYMAELE7CLQHNBY6WQXKLWY2RDJIQX4AHSWH6UJW2YVDWJYD4JK6ARJ2XIK54BTEIZQK5UUF566SYW6O4EGTGDMDNGTTVGQ5MONW2G767IQOX5RYZ6LTDYNCWKAOJY6EJBZ6ZD5SED5F6O4QHCCQBNMFYPLR4NMO3RV4TV3QPID4P7HWI5RNKH7DX373ISGJ4SGW2SXGLSDTBW67OLZLG5Z2HNK5YFEM6E3NGG56R5IB42ENIX4BE5WAAMMMUFM4NQFQ4W7RAIGAYA6S6ZDULP3G6UYFNSOBXHCXAQIMEL3LE6XQALS3OAEQZWR65HJJNSU4TBVQYLT6W7TILJS72KQW6GLHZCDLT7XMRQF5VIUOSKA6URHFS5AOO3QXEF4ZDXED4CFPOSSNYKDP3EPZWQNQZUGYTB3Z2HEU4RV4FGB4FXIBSXZAMHKVAM6VNSRUMBT6AFTHLERZZW3YLDV73NX2EF6B3MYFV4CS6R2HJGCIVSOUIQKVF6GWQSILX2KBWGPYWPIX52C35BMEX235R6DM53IUJFMLVOFUCYBA7BC2BII7SHBELWWU2J23NUSMUOA7BELCT5VEBSBAOQOEOF5M4MJRNKFCZCTX2DGL3DSWFPXUHBF763NQS4DCF2X42MWORFOQIYVOTXJX7H4AMUPG5RYXXQU6HJFX4QOCZJ3RTJMPH6PVT2YY4YGVBVCTHRULBSCW3SSF2AEGHWX62A2QZXUZVDLAKKPHRJTVDU4ELRIVNP2HNOT3SEZRAKPSD5W7ADETMMTU4SAOUODO44FRTUISP74EZAJ3MPC3S4EFJEVD6TKLDKY7C6GO3VDT2O2QFF754BELC3PA27J43MRGN5A5DJPSGF7C77UQKH6BBPEJ7PR5BIXZOBDRZWBI7OME623O5ZASX2S6FUML34ZN7E3MUO2QRFMHMRYRV6U46IQ6YE3EVGIQ3JJ3JCDJDMNJTBJE5YUOFA6KEALEA3XJZOOL72KSQEXL3QHRRN5UTFTHLH7YJFBUDRVVAJB2U7QJRXH4WP34SPL4QFP4DP2HL4YE2RCXI3DQX5OSQRZSRRJESSTOCR4PNIW6C5IPSFKPCXZKE4NNTLYKRSOW55BKVIHWS267FWPKYDM7DJIFOVR6OMD6ZXAYXGIP46NBXHVTPLLPIH5UB4X7R64XLWONIR7KII4XJ5EW2KMFEFD3JE7AVVHHWSXSFB3FJTM63PTCNBYJCTPHLDZEZ6323UDIJCIXCIOARAX7FGAPOJ626WIB4ZWB4MKRRQZYVDLLFHAVWDT4UEJKJB4HWVXISGXT7743C55RTH2PVKYAEN575NCFNSKL5IOLTC4NRKNVUYXQX5WU4U5QE2NKXOK7P6A7DHY3EYCF33TG3NGBMBWC5ANRSGU2DEFONAUFQ7PNWJ2PBQRYFNUO62YMQBX2KDOBU2R76WWPBINYTN4CMKY2FFRULWSBX5DGFDXFZZVB5TI4IKGP3LYBCCY5XMIXVEXOHAEFSTPSIC56CJEWLRTKQP7ZVNC5JT5IRDRLOZAYGGPALFIVWBIJ5UOCEADQREXA=]}

--------------------------------------
2013-09-17 17:36:30,940-35926133 [http-8080-5] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message
---------------------------
ID: 289
Response-Code: 200
Content-Type: application/json;charset=UTF-8;type=tsa-query-response;version=2.2.0-SNAPSHOT
Headers:

{Content-Type=[application/json;charset=UTF-8;type=tsa-query-response;version=2.2.0-SNAPSHOT], Date=[Tue, 17 Sep 2013 17:36:30 GMT], X-AML-API-ID=[99255478-e8f8-46fc-8e15-02ecc39c404e], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]}

Payload:

{"total":0,"count":0,"pages":0,"current":1}

--------------------------------------
2013-09-17 17:36:30,956-35926149 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message
----------------------------
ID: 290
Address: http://loadtest.aq-qa-tomcat1:8080/sapi/rest/orders?q=SELECT%20%20WHERE%20(associatedMerchant.id%20%3D%20'f86685ce-623a-4e48-81f8-fab52bcce734')%20ORDER%20BY%20modificationDate%20DESC
Http-Method: GET
Content-Type:
Headers:

{Accept=[application/json, text/plain], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8,ja;q=0.6], connection=[keep-alive], Content-Type=[null], host=[loadtest.aq-qa-tomcat1:8080], referer=[http://loadtest.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.66 Safari/537.36], x-tsa-authenticate=[X2CU34D5NWDJUW2T6WIEH2QEWLFATFLOIV4WBYYUF5GWT6NQQIMOI44N3FLZ2Y2XZ2CIJ4MRH3HIXN6ZF5HJ5QLFNQDM4B2QPM4USD6JMPWS2O7H6MA4H3UNFEJV57AZT6SNZ6PIRM3RIAB72EWMWMB2XFBDETH7EQ2ZYFP4G7CMOZP3J2665BAO26Y7L6TRKPIL2LQX4UI5TJBWYMAELE7CLQHNBY6WQXKLWY2RDJIQX4AHSWH6UJW2YVDWJYD4JK6ARJ2XIK54BTEIZQK5UUF566SYW6O4EGTGDMDNGTTVGQ5MONW2G767IQOX5RYZ6LTDYNCWKAOJY6EJBZ6ZD5SED5F6O4QHCCQBNMFYPLR4NMO3RV4TV3QPID4P7HWI5RNKH7DX373ISGJ4SGW2SXGLSDTBW67OLZLG5Z2HNK5YFEM6E3NGG56R5IB42ENIX4BE5WAAMMMUFM4NQFQ4W7RAIGAYA6S6ZDULP3G6UYFNSOBXHCXAQIMEL3LE6XQALS3OAEQZWR65HJJNSU4TBVQYLT6W7TILJS72KQW6GLHZCDLT7XMRQF5VIUOSKA6URHFS5AOO3QXEF4ZDXED4CFPOSSNYKDP3EPZWQNQZUGYTB3Z2HEU4RV4FGB4FXIBSXZAMHKVAM6VNSRUMBT6AFTHLERZZW3YLDV73NX2EF6B3MYFV4CS6R2HJGCIVSOUIQKVF6GWQSILX2KBWGPYWPIX52C35BMEX235R6DM53IUJFMLVOFUCYBA7BC2BII7SHBELWWU2J23NUSMUOA7BELCT5VEBSBAOQOEOF5M4MJRNKFCZCTX2DGL3DSWFPXUHBF763NQS4DCF2X42MWORFOQIYVOTXJX7H4AMUPG5RYXXQU6HJFX4QOCZJ3RTJMPH6PVT2YY4YGVBVCTHRULBSCW3SSF2AEGHWX62A2QZXUZVDLAKKPHRJTVDU4ELRIVNP2HNOT3SEZRAKPSD5W7ADETMMTU4SAOUODO44FRTUISP74EZAJ3MPC3S4EFJEVD6TKLDKY7C6GO3VDT2O2QFF754BELC3PA27J43MRGN5A5DJPSGF7C77UQKH6BBPEJ7PR5BIXZOBDRZWBI7OME623O5ZASX2S6FUML34ZN7E3MUO2QRFMHMRYRV6U46IQ6YE3EVGIQ3JJ3JCDJDMNJTBJE5YUOFA6KEALEA3XJZOOL72KSQEXL3QHRRN5UTFTHLH7YJFBUDRVVAJB2U7QJRXH4WP34SPL4QFP4DP2HL4YE2RCXI3DQX5OSQRZSRRJESSTOCR4PNIW6C5IPSFKPCXZKE4NNTLYKRSOW55BKVIHWS267FWPKYDM7DJIFOVR6OMD6ZXAYXGIP46NBXHVTPLLPIH5UB4X7R64XLWONIR7KII4XJ5EW2KMFEFD3JE7AVVHHWSXSFB3FJTM63PTCNBYJCTPHLDZEZ6323UDIJCIXCIOARAX7FGAPOJ626WIB4ZWB4MKRRQZYVDLLFHAVWDT4UEJKJB4HWVXISGXT7743C55RTH2PVKYAEN575NCFNSKL5IOLTC4NRKNVUYXQX5WU4U5QE2NKXOK7P6A7DHY3EYCF33TG3NGBMBWC5ANRSGU2DEFONAUFQ7PNWJ2PBQRYFNUO62YMQBX2KDOBU2R76WWPBINYTN4CMKY2FFRULWSBX5DGFDXFZZVB5TI4IKGP3LYBCCY5XMIXVEXOHAEFSTPSIC56CJEWLRTKQP7ZVNC5JT5IRDRLOZAYGGPALFIVWBIJ5UOCEADQREXA=]}

--------------------------------------
2013-09-17 17:36:30,962-35926155 [http-8080-3] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message
----------------------------
ID: 291
Address: http://loadtest.aq-qa-tomcat1:8080/sapi/rest/users/eefc275a-518b-4c1a-816e-31e3e0db916a
Http-Method: GET
Content-Type:
Headers:

{Accept=[application/json, text/plain], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8,ja;q=0.6], connection=[keep-alive], Content-Type=[null], host=[loadtest.aq-qa-tomcat1:8080], referer=[http://loadtest.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.66 Safari/537.36], x-tsa-authenticate=[X2CU34D5NWDJUW2T6WIEH2QEWLFATFLOIV4WBYYUF5GWT6NQQIMOI44N3FLZ2Y2XZ2CIJ4MRH3HIXN6ZF5HJ5QLFNQDM4B2QPM4USD6JMPWS2O7H6MA4H3UNFEJV57AZT6SNZ6PIRM3RIAB72EWMWMB2XFBDETH7EQ2ZYFP4G7CMOZP3J2665BAO26Y7L6TRKPIL2LQX4UI5TJBWYMAELE7CLQHNBY6WQXKLWY2RDJIQX4AHSWH6UJW2YVDWJYD4JK6ARJ2XIK54BTEIZQK5UUF566SYW6O4EGTGDMDNGTTVGQ5MONW2G767IQOX5RYZ6LTDYNCWKAOJY6EJBZ6ZD5SED5F6O4QHCCQBNMFYPLR4NMO3RV4TV3QPID4P7HWI5RNKH7DX373ISGJ4SGW2SXGLSDTBW67OLZLG5Z2HNK5YFEM6E3NGG56R5IB42ENIX4BE5WAAMMMUFM4NQFQ4W7RAIGAYA6S6ZDULP3G6UYFNSOBXHCXAQIMEL3LE6XQALS3OAEQZWR65HJJNSU4TBVQYLT6W7TILJS72KQW6GLHZCDLT7XMRQF5VIUOSKA6URHFS5AOO3QXEF4ZDXED4CFPOSSNYKDP3EPZWQNQZUGYTB3Z2HEU4RV4FGB4FXIBSXZAMHKVAM6VNSRUMBT6AFTHLERZZW3YLDV73NX2EF6B3MYFV4CS6R2HJGCIVSOUIQKVF6GWQSILX2KBWGPYWPIX52C35BMEX235R6DM53IUJFMLVOFUCYBA7BC2BII7SHBELWWU2J23NUSMUOA7BELCT5VEBSBAOQOEOF5M4MJRNKFCZCTX2DGL3DSWFPXUHBF763NQS4DCF2X42MWORFOQIYVOTXJX7H4AMUPG5RYXXQU6HJFX4QOCZJ3RTJMPH6PVT2YY4YGVBVCTHRULBSCW3SSF2AEGHWX62A2QZXUZVDLAKKPHRJTVDU4ELRIVNP2HNOT3SEZRAKPSD5W7ADETMMTU4SAOUODO44FRTUISP74EZAJ3MPC3S4EFJEVD6TKLDKY7C6GO3VDT2O2QFF754BELC3PA27J43MRGN5A5DJPSGF7C77UQKH6BBPEJ7PR5BIXZOBDRZWBI7OME623O5ZASX2S6FUML34ZN7E3MUO2QRFMHMRYRV6U46IQ6YE3EVGIQ3JJ3JCDJDMNJTBJE5YUOFA6KEALEA3XJZOOL72KSQEXL3QHRRN5UTFTHLH7YJFBUDRVVAJB2U7QJRXH4WP34SPL4QFP4DP2HL4YE2RCXI3DQX5OSQRZSRRJESSTOCR4PNIW6C5IPSFKPCXZKE4NNTLYKRSOW55BKVIHWS267FWPKYDM7DJIFOVR6OMD6ZXAYXGIP46NBXHVTPLLPIH5UB4X7R64XLWONIR7KII4XJ5EW2KMFEFD3JE7AVVHHWSXSFB3FJTM63PTCNBYJCTPHLDZEZ6323UDIJCIXCIOARAX7FGAPOJ626WIB4ZWB4MKRRQZYVDLLFHAVWDT4UEJKJB4HWVXISGXT7743C55RTH2PVKYAEN575NCFNSKL5IOLTC4NRKNVUYXQX5WU4U5QE2NKXOK7P6A7DHY3EYCF33TG3NGBMBWC5ANRSGU2DEFONAUFQ7PNWJ2PBQRYFNUO62YMQBX2KDOBU2R76WWPBINYTN4CMKY2FFRULWSBX5DGFDXFZZVB5TI4IKGP3LYBCCY5XMIXVEXOHAEFSTPSIC56CJEWLRTKQP7ZVNC5JT5IRDRLOZAYGGPALFIVWBIJ5UOCEADQREXA=]}

--------------------------------------
2013-09-17 17:36:30,963-35926156 [http-8080-2] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message
----------------------------
ID: 292
Address: http://loadtest.aq-qa-tomcat1:8080/sapi/rest/reports/WEEKLY_PERFORMANCE_REPORT?merchantID=f86685ce-623a-4e48-81f8-fab52bcce734
Http-Method: GET
Content-Type:
Headers:

{Accept=[application/json, text/plain], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8,ja;q=0.6], connection=[keep-alive], Content-Type=[null], host=[loadtest.aq-qa-tomcat1:8080], referer=[http://loadtest.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.66 Safari/537.36], x-tsa-authenticate=[X2CU34D5NWDJUW2T6WIEH2QEWLFATFLOIV4WBYYUF5GWT6NQQIMOI44N3FLZ2Y2XZ2CIJ4MRH3HIXN6ZF5HJ5QLFNQDM4B2QPM4USD6JMPWS2O7H6MA4H3UNFEJV57AZT6SNZ6PIRM3RIAB72EWMWMB2XFBDETH7EQ2ZYFP4G7CMOZP3J2665BAO26Y7L6TRKPIL2LQX4UI5TJBWYMAELE7CLQHNBY6WQXKLWY2RDJIQX4AHSWH6UJW2YVDWJYD4JK6ARJ2XIK54BTEIZQK5UUF566SYW6O4EGTGDMDNGTTVGQ5MONW2G767IQOX5RYZ6LTDYNCWKAOJY6EJBZ6ZD5SED5F6O4QHCCQBNMFYPLR4NMO3RV4TV3QPID4P7HWI5RNKH7DX373ISGJ4SGW2SXGLSDTBW67OLZLG5Z2HNK5YFEM6E3NGG56R5IB42ENIX4BE5WAAMMMUFM4NQFQ4W7RAIGAYA6S6ZDULP3G6UYFNSOBXHCXAQIMEL3LE6XQALS3OAEQZWR65HJJNSU4TBVQYLT6W7TILJS72KQW6GLHZCDLT7XMRQF5VIUOSKA6URHFS5AOO3QXEF4ZDXED4CFPOSSNYKDP3EPZWQNQZUGYTB3Z2HEU4RV4FGB4FXIBSXZAMHKVAM6VNSRUMBT6AFTHLERZZW3YLDV73NX2EF6B3MYFV4CS6R2HJGCIVSOUIQKVF6GWQSILX2KBWGPYWPIX52C35BMEX235R6DM53IUJFMLVOFUCYBA7BC2BII7SHBELWWU2J23NUSMUOA7BELCT5VEBSBAOQOEOF5M4MJRNKFCZCTX2DGL3DSWFPXUHBF763NQS4DCF2X42MWORFOQIYVOTXJX7H4AMUPG5RYXXQU6HJFX4QOCZJ3RTJMPH6PVT2YY4YGVBVCTHRULBSCW3SSF2AEGHWX62A2QZXUZVDLAKKPHRJTVDU4ELRIVNP2HNOT3SEZRAKPSD5W7ADETMMTU4SAOUODO44FRTUISP74EZAJ3MPC3S4EFJEVD6TKLDKY7C6GO3VDT2O2QFF754BELC3PA27J43MRGN5A5DJPSGF7C77UQKH6BBPEJ7PR5BIXZOBDRZWBI7OME623O5ZASX2S6FUML34ZN7E3MUO2QRFMHMRYRV6U46IQ6YE3EVGIQ3JJ3JCDJDMNJTBJE5YUOFA6KEALEA3XJZOOL72KSQEXL3QHRRN5UTFTHLH7YJFBUDRVVAJB2U7QJRXH4WP34SPL4QFP4DP2HL4YE2RCXI3DQX5OSQRZSRRJESSTOCR4PNIW6C5IPSFKPCXZKE4NNTLYKRSOW55BKVIHWS267FWPKYDM7DJIFOVR6OMD6ZXAYXGIP46NBXHVTPLLPIH5UB4X7R64XLWONIR7KII4XJ5EW2KMFEFD3JE7AVVHHWSXSFB3FJTM63PTCNBYJCTPHLDZEZ6323UDIJCIXCIOARAX7FGAPOJ626WIB4ZWB4MKRRQZYVDLLFHAVWDT4UEJKJB4HWVXISGXT7743C55RTH2PVKYAEN575NCFNSKL5IOLTC4NRKNVUYXQX5WU4U5QE2NKXOK7P6A7DHY3EYCF33TG3NGBMBWC5ANRSGU2DEFONAUFQ7PNWJ2PBQRYFNUO62YMQBX2KDOBU2R76WWPBINYTN4CMKY2FFRULWSBX5DGFDXFZZVB5TI4IKGP3LYBCCY5XMIXVEXOHAEFSTPSIC56CJEWLRTKQP7ZVNC5JT5IRDRLOZAYGGPALFIVWBIJ5UOCEADQREXA=]}

--------------------------------------
2013-09-17 17:36:31,017-35926210 [http-8080-5] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message
----------------------------
ID: 293
Address: http://loadtest.aq-qa-tomcat1:8080/sapi/rest/orders?q=SELECT%20%20WHERE%20((state%20IN%20('SCHEDULED'%2C'QUOTE'))%20AND%20(associatedMerchant.id%20%3D%20'f86685ce-623a-4e48-81f8-fab52bcce734'))%20ORDER%20BY%20modificationDate%20DESC
Http-Method: GET
Content-Type:
Headers:

{Accept=[application/json, text/plain], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8,ja;q=0.6], connection=[keep-alive], Content-Type=[null], host=[loadtest.aq-qa-tomcat1:8080], referer=[http://loadtest.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.66 Safari/537.36], x-tsa-authenticate=[X2CU34D5NWDJUW2T6WIEH2QEWLFATFLOIV4WBYYUF5GWT6NQQIMOI44N3FLZ2Y2XZ2CIJ4MRH3HIXN6ZF5HJ5QLFNQDM4B2QPM4USD6JMPWS2O7H6MA4H3UNFEJV57AZT6SNZ6PIRM3RIAB72EWMWMB2XFBDETH7EQ2ZYFP4G7CMOZP3J2665BAO26Y7L6TRKPIL2LQX4UI5TJBWYMAELE7CLQHNBY6WQXKLWY2RDJIQX4AHSWH6UJW2YVDWJYD4JK6ARJ2XIK54BTEIZQK5UUF566SYW6O4EGTGDMDNGTTVGQ5MONW2G767IQOX5RYZ6LTDYNCWKAOJY6EJBZ6ZD5SED5F6O4QHCCQBNMFYPLR4NMO3RV4TV3QPID4P7HWI5RNKH7DX373ISGJ4SGW2SXGLSDTBW67OLZLG5Z2HNK5YFEM6E3NGG56R5IB42ENIX4BE5WAAMMMUFM4NQFQ4W7RAIGAYA6S6ZDULP3G6UYFNSOBXHCXAQIMEL3LE6XQALS3OAEQZWR65HJJNSU4TBVQYLT6W7TILJS72KQW6GLHZCDLT7XMRQF5VIUOSKA6URHFS5AOO3QXEF4ZDXED4CFPOSSNYKDP3EPZWQNQZUGYTB3Z2HEU4RV4FGB4FXIBSXZAMHKVAM6VNSRUMBT6AFTHLERZZW3YLDV73NX2EF6B3MYFV4CS6R2HJGCIVSOUIQKVF6GWQSILX2KBWGPYWPIX52C35BMEX235R6DM53IUJFMLVOFUCYBA7BC2BII7SHBELWWU2J23NUSMUOA7BELCT5VEBSBAOQOEOF5M4MJRNKFCZCTX2DGL3DSWFPXUHBF763NQS4DCF2X42MWORFOQIYVOTXJX7H4AMUPG5RYXXQU6HJFX4QOCZJ3RTJMPH6PVT2YY4YGVBVCTHRULBSCW3SSF2AEGHWX62A2QZXUZVDLAKKPHRJTVDU4ELRIVNP2HNOT3SEZRAKPSD5W7ADETMMTU4SAOUODO44FRTUISP74EZAJ3MPC3S4EFJEVD6TKLDKY7C6GO3VDT2O2QFF754BELC3PA27J43MRGN5A5DJPSGF7C77UQKH6BBPEJ7PR5BIXZOBDRZWBI7OME623O5ZASX2S6FUML34ZN7E3MUO2QRFMHMRYRV6U46IQ6YE3EVGIQ3JJ3JCDJDMNJTBJE5YUOFA6KEALEA3XJZOOL72KSQEXL3QHRRN5UTFTHLH7YJFBUDRVVAJB2U7QJRXH4WP34SPL4QFP4DP2HL4YE2RCXI3DQX5OSQRZSRRJESSTOCR4PNIW6C5IPSFKPCXZKE4NNTLYKRSOW55BKVIHWS267FWPKYDM7DJIFOVR6OMD6ZXAYXGIP46NBXHVTPLLPIH5UB4X7R64XLWONIR7KII4XJ5EW2KMFEFD3JE7AVVHHWSXSFB3FJTM63PTCNBYJCTPHLDZEZ6323UDIJCIXCIOARAX7FGAPOJ626WIB4ZWB4MKRRQZYVDLLFHAVWDT4UEJKJB4HWVXISGXT7743C55RTH2PVKYAEN575NCFNSKL5IOLTC4NRKNVUYXQX5WU4U5QE2NKXOK7P6A7DHY3EYCF33TG3NGBMBWC5ANRSGU2DEFONAUFQ7PNWJ2PBQRYFNUO62YMQBX2KDOBU2R76WWPBINYTN4CMKY2FFRULWSBX5DGFDXFZZVB5TI4IKGP3LYBCCY5XMIXVEXOHAEFSTPSIC56CJEWLRTKQP7ZVNC5JT5IRDRLOZAYGGPALFIVWBIJ5UOCEADQREXA=]}

--------------------------------------
2013-09-17 17:36:31,080-35926273 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message
---------------------------
ID: 290
Response-Code: 200
Content-Type: application/json;charset=UTF-8;type=tsa-query-response;version=2.2.0-SNAPSHOT
Headers:

{Content-Type=[application/json;charset=UTF-8;type=tsa-query-response;version=2.2.0-SNAPSHOT], Date=[Tue, 17 Sep 2013 17:36:31 GMT], X-AML-API-ID=[154a8ed6-0fd2-434e-a377-0edaa6525310], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]}

Payload:

{"total":0,"count":0,"pages":0,"current":1}

--------------------------------------
2013-09-17 17:36:31,155-35926348 [http-8080-2] ERROR com.thesearchagency.saas.core.services.reporting.internal.dao.SpringReportDao [timezone=UTC, principalId=df3d9279-be57-4a5b-a4b3-65b3ce833713, requestId=de34e7de-df15-4350-a3e9-66df849cb1bb, locale=en_US, authToken=X2CU34D5NWDJUW2T6WIEH2QEWLFATFLOIV4WBYYUF5GWT6NQQIMOI44N3FLZ2Y2XZ2CIJ4MRH3HIXN6ZF5HJ5QLFNQDM4B2QPM4USD6JMPWS2O7H6MA4H3UNFEJV57AZT6SNZ6PIRM3RIAB72EWMWMB2XFBDETH7EQ2ZYFP4G7CMOZP3J2665BAO26Y7L6TRKPIL2LQX4UI5TJBWYMAELE7CLQHNBY6WQXKLWY2RDJIQX4AHSWH6UJW2YVDWJYD4JK6ARJ2XIK54BTEIZQK5UUF566SYW6O4EGTGDMDNGTTVGQ5MONW2G767IQOX5RYZ6LTDYNCWKAOJY6EJBZ6ZD5SED5F6O4QHCCQBNMFYPLR4NMO3RV4TV3QPID4P7HWI5RNKH7DX373ISGJ4SGW2SXGLSDTBW67OLZLG5Z2HNK5YFEM6E3NGG56R5IB42ENIX4BE5WAAMMMUFM4NQFQ4W7RAIGAYA6S6ZDULP3G6UYFNSOBXHCXAQIMEL3LE6XQALS3OAEQZWR65HJJNSU4TBVQYLT6W7TILJS72KQW6GLHZCDLT7XMRQF5VIUOSKA6URHFS5AOO3QXEF4ZDXED4CFPOSSNYKDP3EPZWQNQZUGYTB3Z2HEU4RV4FGB4FXIBSXZAMHKVAM6VNSRUMBT6AFTHLERZZW3YLDV73NX2EF6B3MYFV4CS6R2HJGCIVSOUIQKVF6GWQSILX2KBWGPYWPIX52C35BMEX235R6DM53IUJFMLVOFUCYBA7BC2BII7SHBELWWU2J23NUSMUOA7BELCT5VEBSBAOQOEOF5M4MJRNKFCZCTX2DGL3DSWFPXUHBF763NQS4DCF2X42MWORFOQIYVOTXJX7H4AMUPG5RYXXQU6HJFX4QOCZJ3RTJMPH6PVT2YY4YGVBVCTHRULBSCW3SSF2AEGHWX62A2QZXUZVDLAKKPHRJTVDU4ELRIVNP2HNOT3SEZRAKPSD5W7ADETMMTU4SAOUODO44FRTUISP74EZAJ3MPC3S4EFJEVD6TKLDKY7C6GO3VDT2O2QFF754BELC3PA27J43MRGN5A5DJPSGF7C77UQKH6BBPEJ7PR5BIXZOBDRZWBI7OME623O5ZASX2S6FUML34ZN7E3MUO2QRFMHMRYRV6U46IQ6YE3EVGIQ3JJ3JCDJDMNJTBJE5YUOFA6KEALEA3XJZOOL72KSQEXL3QHRRN5UTFTHLH7YJFBUDRVVAJB2U7QJRXH4WP34SPL4QFP4DP2HL4YE2RCXI3DQX5OSQRZSRRJESSTOCR4PNIW6C5IPSFKPCXZKE4NNTLYKRSOW55BKVIHWS267FWPKYDM7DJIFOVR6OMD6ZXAYXGIP46NBXHVTPLLPIH5UB4X7R64XLWONIR7KII4XJ5EW2KMFEFD3JE7AVVHHWSXSFB3FJTM63PTCNBYJCTPHLDZEZ6323UDIJCIXCIOARAX7FGAPOJ626WIB4ZWB4MKRRQZYVDLLFHAVWDT4UEJKJB4HWVXISGXT7743C55RTH2PVKYAEN575NCFNSKL5IOLTC4NRKNVUYXQX5WU4U5QE2NKXOK7P6A7DHY3EYCF33TG3NGBMBWC5ANRSGU2DEFONAUFQ7PNWJ2PBQRYFNUO62YMQBX2KDOBU2R76WWPBINYTN4CMKY2FFRULWSBX5DGFDXFZZVB5TI4IKGP3LYBCCY5XMIXVEXOHAEFSTPSIC56CJEWLRTKQP7ZVNC5JT5IRDRLOZAYGGPALFIVWBIJ5UOCEADQREXA=, hostname=70.166.144.17, ipAddress=70.166.144.17] -
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT a.description AS `merchant_id`, w.startTime AS `start_date`, sum(w.seImpressions) AS `impression_count_total`, sum(w.seClicks) AS `click_count_total`, sum(w.seAdCost) AS `google_cost_total` FROM warehouse_1.whWeeklyGroupPerf AS w JOIN tsacommon.accounts AS a ON w.accountID = a.id GROUP BY w.startTime, a.description HAVING a.description = ? ORDER BY w.startTime DESC;]; 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.GeneratedMethodAccessor264.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) [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 $Proxy97.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.GeneratedMethodAccessor273.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: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]
... 49 common frames omitted
2013-09-17 17:36:31,172-35926365 [http-8080-2] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message
---------------------------
ID: 292
Response-Code: 500
Content-Type: text/plain;charset=UTF-8;version=2.2.0-SNAPSHOT
Headers:

{Date=[Tue, 17 Sep 2013 17:36:31 GMT], X-AML-API-ID=[de34e7de-df15-4350-a3e9-66df849cb1bb], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]}

Payload: Internal server error
--------------------------------------
2013-09-17 17:36:31,185-35926378 [http-8080-3] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message
---------------------------
ID: 291
Response-Code: 200
Content-Type: application/json;charset=UTF-8;type=tsa-user;version=2.2.0-SNAPSHOT
Headers:

{Content-Type=[application/json;charset=UTF-8;type=tsa-user;version=2.2.0-SNAPSHOT], Date=[Tue, 17 Sep 2013 17:36:31 GMT], X-AML-API-ID=[c5db2de1-4f07-4cc6-b730-89f45fa195e0], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]}

Payload: {"language":"en","properties":{},"id":"eefc275a-518b-4c1a-816e-31e3e0db916a","displayName":"jeffrey.brown@thesearchagency.com","description":"Merchant user for 11activate","realm":"com.thesearchagency/7bc157c1-c90d-4215-8a0b-01a1da8232fd/f86685ce-623a-4e48-81f8-fab52bcce734","lastModifiedDate":"2013-09-04T13:59:51.000+0000","organization":"11activate","email":"jeffrey.brown@thesearchagency.com","countryCode":"US","workPhone":"4013233333","createdBy":"df3d9279-be57-4a5b-a4b3-65b3ce833713","createdDate":"2013-09-04T13:59:51.000+0000","lastModifiedBy":"df3d9279-be57-4a5b-a4b3-65b3ce833713","active":true,"timezone":"America/New_York","firstName":null,"lastName":null,"homePhone":null,"mobilePhone":null,"gender":"M","birthday":null,"lastLoginDate":"1970-01-01T00:00:00.000+0000","workPhoneExtension":null}
--------------------------------------
2013-09-17 17:36:31,196-35926389 [http-8080-5] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message
---------------------------
ID: 293
Response-Code: 200
Content-Type: application/json;charset=UTF-8;type=tsa-query-response;version=2.2.0-SNAPSHOT
Headers:

{Content-Type=[application/json;charset=UTF-8;type=tsa-query-response;version=2.2.0-SNAPSHOT], Date=[Tue, 17 Sep 2013 17:36:31 GMT], X-AML-API-ID=[f39480d2-341b-4fa1-92d9-cd4842027493], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]}

Payload:

{"total":0,"count":0,"pages":0,"current":1}

--------------------------------------