2018-09-19 07:04:19,358-415860923 [http-nio-8080-exec-129] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 1394 Address: http://127.0.0.1:8080/sapi/rest/merchants/e9a2d16c-6713-4bfb-a439-18baeb4142b8?delete=true&update=true Encoding: UTF-8 Http-Method: PUT Content-Type: application/json; charset=utf-8 Headers: {Accept=[application/json, text/plain], connection=[Keep-Alive], content-encoding=[UTF-8], Content-Length=[1116], content-type=[application/json; charset=utf-8], host=[127.0.0.1:8080], user-agent=[Apache-HttpClient/4.5.3 (Java/1.8.0_161)], x-tsa-authenticate=[ACUB2IBDMYLO54TCE3PE2LEFIFOI2UGFYVRURS726PJFCKC2ZUWF3WODOSORYBQ4HHEODCUJWPJP7BKWGMJ7R3AKYCGDMITSMHFSBE44YAA4OYW4XYJL2HWDMUXT7ZL57HNNAB5BF7G3GDDNMOEPV2PXGZ7WJ262ICVKKHAJ4CVPI77JCWEOKXTO2JHUUPPSE5RP5YQKQRQOAKHHGEWTGSKFPEZKBUZAESO5BZYK2YKHZCO2PPHXOPUPLK2STQGYXUXXHRT24HSHD3PDW7NV5W6UZS5JTL2EGOQX6CZY4A72TKBNKGGIEBSGNOSVUE7PJ232FXJCTYXDLG5LI4IWBS64CV33FCNM6IQ47KWVQI5IU5EWJZYE2KV447HSSA5C5B2LLSZRQRT7RUSLP3JGD53BQUK3U2IEJR2NSLC2PMIO7B5XFR63QEDZWJINXBM4BS5VQIEB5LLENDADJ2PC6PTQQORK3DOWWSVJICIZCXPFLUQQB6QLAJPEFGUUXLOFEUBN7P4ZRCF7O4NQQ7EWH55QUXAS66MX3J4D2IMTAHDTLKJYVH4PWS4HI55VD6OKNOR73QCITLSTQGPDXAWD6CLBWQEGMTGU4EHAZ3E5HQCULSMNBYBBUAIYEWVXGWO7BYQYQLJIVOSSCCJN6IICCJ7UD2ZULRNUULHJKMUY4Q6WA2J47PC3T2KJDOUFRV7TIFVWGYY6HIXZNZBBQC7LKSMJ7UQSBMLLKAE5ZGPPEBUJS5U4A7VWZ5FWQQE6MCWDCOXUCBJ6D53ZUN4ZJQSUFNS5PTDWZ6RJ5YWUISZ5OGFADQNBIBLNS2HIQPS2DULZT7DOLSOYQZBERS4QPJUOCEZGHYQCFAPQ2JVTUGAMC3COWY4RXUQ4OSVM6W5SSUPZ24DPWFYLU7XPURQFOY4KNQFYVSV6JKZHMQG2KSXEUKUVPIBXBGTPPVGVYWKIW2SWCNDTOHFHBEPKB4X5YLOKOX67PX7PPBEA2WR26YIWUDYEZZML43ZCY3TZOHJZOOT6ASDUZ6CPUV7SH2ENFXVNXXTGNM5KR2AAHC7GNUZ5FQ5D6FMI3XXFFZU7IGQCKJFYOKWSUQ3WEFAAJM67W2MLTSQXNCWYNWDCLIM7SZEV5MZBAQUQ4DR3BQZDOTBTRJKTQIK5ZH3ZH4JKCYUEDDVCNOFURPL7JQ6YS2LWX27HOBLWECMBNKA5HUWODT6H3CZ5Y3YPGEG5UVJMJLUYZQETHKO7W7243A3DRFY22ZFIFHSRGD6E5XABV5HVZU6ZIF5IGQA4PSAIF7T3QNZLTC5DZEPK3RPGX2LCTXKZLXIGIBDD43PHOI562FGQXP5XAI2XBIXY5ATSRBEBFHGYVZCLKF6CMAMENYAKYOICRQHRFB7UMHJLKL3FEHUECXWOJG2HYLNRARLDZRTPHASC4WEECCNIFCFPIJ25O2YQWEV3DV2FERLRSRSYYJHELQMAK3TYNCXJDZYO2FAZOMKEEECV6VDHTTNKJSJZRUBBKMTIIFFMV6TU6VIMH2QL4ATQ3VXHK6A6ZHTHDPA5P3HU3E6N75YY4HJNPC3Z2KYCT3AFCIZNRZIJLBAOHFOBAQXFJZFVXHFQLZR5Q5WJTF4ZUM6JIO5WWWTETAHBQIDFPXXPUE6X25RLM7SQ====]} Payload: {"comments":"Merchant API Test","contact":{"realm":"com.thesearchagency/33146f19-22f8-4b98-96f7-6cb4f0da283b","active":false,"firstName":"API","lastName":"Zeus","displayName":"API Zeus","description":"Merchant user for Merchant API","createdDate":"2018-09-17","createdBy":"51834f20-37e8-4c5d-b4a9-b57fe7d20f8c","lastModifiedDate":"2018-09-17","lastModifiedBy":"51834f20-37e8-4c5d-b4a9-b57fe7d20f8c","id":"499dadf3-6bc4-44fe-bd7a-b3a0b5c04221","email":"zeus1234@gmail.com","gender":"F","language":"en","countryCode":"CA","workPhone":"9876543211","lastLoginDate":"1970-01-01"},"contactEmail":"zeus1234@gmail.com","contactFirstName":"API","contactLastName":"Zeus","contactPhoneNumber":"9876543211","customerId":"Merchant_API_1","displayName":"Merchant API Testing","id":"e9a2d16c-6713-4bfb-a439-18baeb4142b8","properties":{"countryCode":"CA","language":"en","locale":"fr_CA","currencyCode":"CAD"},"realm":"com.thesearchagency/33146f19-22f8-4b98-96f7-6cb4f0da283b","active":true,"socialCustomer":{"id":"5284218108f84bc89f930f6eae2fcc32","name":"e9a2d16c-6713-4bfb-a439-18baeb4142b8","enabled":true,"inviteStatus":false}} -------------------------------------- 2018-09-19 07:04:19,384-415860949 [http-nio-8080-exec-129] ERROR com.thesearchagency.services.merchant.MerchantServiceComponent [hostname=127.0.0.1, requestId=98e43fc5-5864-4cc7-90ff-df2f7734c499, timezone=UTC, authToken=ACUB2IBDMYLO54TCE3PE2LEFIFOI2UGFYVRURS726PJFCKC2ZUWF3WODOSORYBQ4HHEODCUJWPJP7BKWGMJ7R3AKYCGDMITSMHFSBE44YAA4OYW4XYJL2HWDMUXT7ZL57HNNAB5BF7G3GDDNMOEPV2PXGZ7WJ262ICVKKHAJ4CVPI77JCWEOKXTO2JHUUPPSE5RP5YQKQRQOAKHHGEWTGSKFPEZKBUZAESO5BZYK2YKHZCO2PPHXOPUPLK2STQGYXUXXHRT24HSHD3PDW7NV5W6UZS5JTL2EGOQX6CZY4A72TKBNKGGIEBSGNOSVUE7PJ232FXJCTYXDLG5LI4IWBS64CV33FCNM6IQ47KWVQI5IU5EWJZYE2KV447HSSA5C5B2LLSZRQRT7RUSLP3JGD53BQUK3U2IEJR2NSLC2PMIO7B5XFR63QEDZWJINXBM4BS5VQIEB5LLENDADJ2PC6PTQQORK3DOWWSVJICIZCXPFLUQQB6QLAJPEFGUUXLOFEUBN7P4ZRCF7O4NQQ7EWH55QUXAS66MX3J4D2IMTAHDTLKJYVH4PWS4HI55VD6OKNOR73QCITLSTQGPDXAWD6CLBWQEGMTGU4EHAZ3E5HQCULSMNBYBBUAIYEWVXGWO7BYQYQLJIVOSSCCJN6IICCJ7UD2ZULRNUULHJKMUY4Q6WA2J47PC3T2KJDOUFRV7TIFVWGYY6HIXZNZBBQC7LKSMJ7UQSBMLLKAE5ZGPPEBUJS5U4A7VWZ5FWQQE6MCWDCOXUCBJ6D53ZUN4ZJQSUFNS5PTDWZ6RJ5YWUISZ5OGFADQNBIBLNS2HIQPS2DULZT7DOLSOYQZBERS4QPJUOCEZGHYQCFAPQ2JVTUGAMC3COWY4RXUQ4OSVM6W5SSUPZ24DPWFYLU7XPURQFOY4KNQFYVSV6JKZHMQG2KSXEUKUVPIBXBGTPPVGVYWKIW2SWCNDTOHFHBEPKB4X5YLOKOX67PX7PPBEA2WR26YIWUDYEZZML43ZCY3TZOHJZOOT6ASDUZ6CPUV7SH2ENFXVNXXTGNM5KR2AAHC7GNUZ5FQ5D6FMI3XXFFZU7IGQCKJFYOKWSUQ3WEFAAJM67W2MLTSQXNCWYNWDCLIM7SZEV5MZBAQUQ4DR3BQZDOTBTRJKTQIK5ZH3ZH4JKCYUEDDVCNOFURPL7JQ6YS2LWX27HOBLWECMBNKA5HUWODT6H3CZ5Y3YPGEG5UVJMJLUYZQETHKO7W7243A3DRFY22ZFIFHSRGD6E5XABV5HVZU6ZIF5IGQA4PSAIF7T3QNZLTC5DZEPK3RPGX2LCTXKZLXIGIBDD43PHOI562FGQXP5XAI2XBIXY5ATSRBEBFHGYVZCLKF6CMAMENYAKYOICRQHRFB7UMHJLKL3FEHUECXWOJG2HYLNRARLDZRTPHASC4WEECCNIFCFPIJ25O2YQWEV3DV2FERLRSRSYYJHELQMAK3TYNCXJDZYO2FAZOMKEEECV6VDHTTNKJSJZRUBBKMTIIFFMV6TU6VIMH2QL4ATQ3VXHK6A6ZHTHDPA5P3HU3E6N75YY4HJNPC3Z2KYCT3AFCIZNRZIJLBAOHFOBAQXFJZFVXHFQLZR5Q5WJTF4ZUM6JIO5WWWTETAHBQIDFPXXPUE6X25RLM7SQ====, ipAddress=127.0.0.1, principalId=51834f20-37e8-4c5d-b4a9-b57fe7d20f8c, locale=en_US] - StorageManagerException thrown while fetching merchant e9a2d16c-6713-4bfb-a439-18baeb4142b8. com.thesearchagency.database.storage.StorageManagerException: package com.thesearchagency.database.storage.OBJECT_NOT_FOUND_EXCEPTION at com.thesearchagency.services.merchant.dao.MerchantDAO.get(MerchantDAO.java:398) at com.thesearchagency.services.merchant.MerchantServiceComponent.getMerchant(MerchantServiceComponent.java:85) at sun.reflect.GeneratedMethodAccessor376.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) at com.sun.proxy.$Proxy369.getMerchant(Unknown Source) at com.thesearchagency.sapi.services.merchant.MerchantService.getMerchant(MerchantService.java:916) at com.thesearchagency.sapi.services.merchant.MerchantService$4.call(MerchantService.java:316) at com.thesearchagency.sapi.services.SAPIService.doExecuteWithValidData(SAPIService.java:122) at com.thesearchagency.sapi.services.merchant.MerchantService.updateMerchant(MerchantService.java:311) at sun.reflect.GeneratedMethodAccessor537.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:181) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97) at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:200) at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99) at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59) at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307) at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:251) at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234) at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208) at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160) at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:180) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:293) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPut(AbstractHTTPServlet.java:229) at javax.servlet.http.HttpServlet.service(HttpServlet.java:664) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:268) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1457) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 2 at org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:74) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:795) at com.thesearchagency.services.merchant.dao.MerchantDAO.get(MerchantDAO.java:388) ... 59 common frames omitted 2018-09-19 07:04:19,388-415860953 [http-nio-8080-exec-129] ERROR com.thesearchagency.sapi.services.merchant.MerchantService [hostname=127.0.0.1, requestId=98e43fc5-5864-4cc7-90ff-df2f7734c499, timezone=UTC, authToken=ACUB2IBDMYLO54TCE3PE2LEFIFOI2UGFYVRURS726PJFCKC2ZUWF3WODOSORYBQ4HHEODCUJWPJP7BKWGMJ7R3AKYCGDMITSMHFSBE44YAA4OYW4XYJL2HWDMUXT7ZL57HNNAB5BF7G3GDDNMOEPV2PXGZ7WJ262ICVKKHAJ4CVPI77JCWEOKXTO2JHUUPPSE5RP5YQKQRQOAKHHGEWTGSKFPEZKBUZAESO5BZYK2YKHZCO2PPHXOPUPLK2STQGYXUXXHRT24HSHD3PDW7NV5W6UZS5JTL2EGOQX6CZY4A72TKBNKGGIEBSGNOSVUE7PJ232FXJCTYXDLG5LI4IWBS64CV33FCNM6IQ47KWVQI5IU5EWJZYE2KV447HSSA5C5B2LLSZRQRT7RUSLP3JGD53BQUK3U2IEJR2NSLC2PMIO7B5XFR63QEDZWJINXBM4BS5VQIEB5LLENDADJ2PC6PTQQORK3DOWWSVJICIZCXPFLUQQB6QLAJPEFGUUXLOFEUBN7P4ZRCF7O4NQQ7EWH55QUXAS66MX3J4D2IMTAHDTLKJYVH4PWS4HI55VD6OKNOR73QCITLSTQGPDXAWD6CLBWQEGMTGU4EHAZ3E5HQCULSMNBYBBUAIYEWVXGWO7BYQYQLJIVOSSCCJN6IICCJ7UD2ZULRNUULHJKMUY4Q6WA2J47PC3T2KJDOUFRV7TIFVWGYY6HIXZNZBBQC7LKSMJ7UQSBMLLKAE5ZGPPEBUJS5U4A7VWZ5FWQQE6MCWDCOXUCBJ6D53ZUN4ZJQSUFNS5PTDWZ6RJ5YWUISZ5OGFADQNBIBLNS2HIQPS2DULZT7DOLSOYQZBERS4QPJUOCEZGHYQCFAPQ2JVTUGAMC3COWY4RXUQ4OSVM6W5SSUPZ24DPWFYLU7XPURQFOY4KNQFYVSV6JKZHMQG2KSXEUKUVPIBXBGTPPVGVYWKIW2SWCNDTOHFHBEPKB4X5YLOKOX67PX7PPBEA2WR26YIWUDYEZZML43ZCY3TZOHJZOOT6ASDUZ6CPUV7SH2ENFXVNXXTGNM5KR2AAHC7GNUZ5FQ5D6FMI3XXFFZU7IGQCKJFYOKWSUQ3WEFAAJM67W2MLTSQXNCWYNWDCLIM7SZEV5MZBAQUQ4DR3BQZDOTBTRJKTQIK5ZH3ZH4JKCYUEDDVCNOFURPL7JQ6YS2LWX27HOBLWECMBNKA5HUWODT6H3CZ5Y3YPGEG5UVJMJLUYZQETHKO7W7243A3DRFY22ZFIFHSRGD6E5XABV5HVZU6ZIF5IGQA4PSAIF7T3QNZLTC5DZEPK3RPGX2LCTXKZLXIGIBDD43PHOI562FGQXP5XAI2XBIXY5ATSRBEBFHGYVZCLKF6CMAMENYAKYOICRQHRFB7UMHJLKL3FEHUECXWOJG2HYLNRARLDZRTPHASC4WEECCNIFCFPIJ25O2YQWEV3DV2FERLRSRSYYJHELQMAK3TYNCXJDZYO2FAZOMKEEECV6VDHTTNKJSJZRUBBKMTIIFFMV6TU6VIMH2QL4ATQ3VXHK6A6ZHTHDPA5P3HU3E6N75YY4HJNPC3Z2KYCT3AFCIZNRZIJLBAOHFOBAQXFJZFVXHFQLZR5Q5WJTF4ZUM6JIO5WWWTETAHBQIDFPXXPUE6X25RLM7SQ====, ipAddress=127.0.0.1, principalId=51834f20-37e8-4c5d-b4a9-b57fe7d20f8c, locale=en_US] - Exception caught in execution. Data is Merchant(id=e9a2d16c-6713-4bfb-a439-18baeb4142b8, name=null, displayName=Merchant API Testing, description=null, realm=com.thesearchagency/33146f19-22f8-4b98-96f7-6cb4f0da283b, active=true, createdDate=null, lastModifiedDate=null, createdBy=null, createdByName=null, contactFirstName=API, contactLastName=Zeus, lastModifiedBy=null, lastModifiedByName=null, customerId=Merchant_API_1, contactEmail=zeus1234@gmail.com, contactPhoneNumber=9876543211, phoneNumber=null, comments=Merchant API Test, contact=User(theId=499dadf3-6bc4-44fe-bd7a-b3a0b5c04221, theDisplayName=API Zeus, theFirstName=API, theLastName=Zeus, theDescription=Merchant user for Merchant API, theOrganization=null, theRealm=com.thesearchagency/33146f19-22f8-4b98-96f7-6cb4f0da283b, theEmail=zeus1234@gmail.com, theActiveFlag=false, theGender=F, theLanguage=en, theCountry=CA, theTimezone=America/New_York, theHomePhone=null, theWorkPhone=9876543211, theWorkPhoneExtension=null, theMobilePhone=null, theBirthday=null, theLastLoginDate=Thu Jan 01 00:00:00 UTC 1970, theCreatedDate=Mon Sep 17 00:00:00 UTC 2018, theLastModifiedDate=Mon Sep 17 00:00:00 UTC 2018, theCreatorId=51834f20-37e8-4c5d-b4a9-b57fe7d20f8c, theLastModifierId=51834f20-37e8-4c5d-b4a9-b57fe7d20f8c, theProperties={}), url=null, groupId=null, userId=null, resellerId=null, socialCustomer=SocialCustomer(id=5284218108f84bc89f930f6eae2fcc32, name=e9a2d16c-6713-4bfb-a439-18baeb4142b8, enabled=true, inviteStatus=false), properties={countryCode=CA, language=en, locale=fr_CA, currencyCode=CAD}) com.thesearchagency.services.commons.ServiceException: Operation failed at com.thesearchagency.services.merchant.MerchantServiceComponent.getMerchant(MerchantServiceComponent.java:89) at sun.reflect.GeneratedMethodAccessor376.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) at com.sun.proxy.$Proxy369.getMerchant(Unknown Source) at com.thesearchagency.sapi.services.merchant.MerchantService.getMerchant(MerchantService.java:916) at com.thesearchagency.sapi.services.merchant.MerchantService$4.call(MerchantService.java:316) at com.thesearchagency.sapi.services.SAPIService.doExecuteWithValidData(SAPIService.java:122) at com.thesearchagency.sapi.services.merchant.MerchantService.updateMerchant(MerchantService.java:311) at sun.reflect.GeneratedMethodAccessor537.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:181) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97) at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:200) at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99) at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59) at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307) at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:251) at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234) at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208) at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160) at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:180) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:293) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPut(AbstractHTTPServlet.java:229) at javax.servlet.http.HttpServlet.service(HttpServlet.java:664) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:268) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1457) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: com.thesearchagency.database.storage.StorageManagerException: package com.thesearchagency.database.storage.OBJECT_NOT_FOUND_EXCEPTION at com.thesearchagency.services.merchant.dao.MerchantDAO.get(MerchantDAO.java:398) at com.thesearchagency.services.merchant.MerchantServiceComponent.getMerchant(MerchantServiceComponent.java:85) ... 58 common frames omitted Caused by: org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 1, actual 2 at org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:74) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:795) at com.thesearchagency.services.merchant.dao.MerchantDAO.get(MerchantDAO.java:388) ... 59 common frames omitted 2018-09-19 07:04:19,389-415860954 [http-nio-8080-exec-129] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 1394 Response-Code: 304 Content-Type: text/plain;charset=UTF-8;version=3.1.15-BETA3 Headers: {Content-Type=[text/plain;charset=UTF-8;version=3.1.15-BETA3], Date=[Wed, 19 Sep 2018 07:04:19 GMT], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[98e43fc5-5864-4cc7-90ff-df2f7734c499]} Payload: Operation failed --------------------------------------