ID: 4631 Address: http://127.0.0.1:8080/sapi/rest/merchants Encoding: UTF-8 Http-Method: POST Content-Type: application/json; charset=utf-8 Headers: {Accept=[application/json, text/plain], connection=[Keep-Alive], content-encoding=[UTF-8], Content-Length=[373], 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=[ACUB2IBDMYLO4ISATG7DIO3Y4MHTLBFL5WR4PFYBSHCJ7N3AWDL6RDS5T4Z3NV7OHAMC4KLRFPWBHTHVVSOE7AL5OFHK2NTWCBIKQV7ZMHLKL4DPQ4UBYQKHD4BGOTEGWDBBAKU3KS7YSCIRQD6JQIC7HHQK27RLHORLQJ4PHFAMUH3CFNHY252EFCY56QFT7KNFV3A6BSXEQDA3FGXACETAIMF75DEYROAOWR45NHG5BSHTHNNNY6D4QNXJKI5FF2DM66UCIE37HVHRJD65LPVQCFGW4BPUZL6KYHOICNYKNIRUYYO6KZI5QXQFIDTFLTOYAVUV65R5FXJYS5MTHFA4GDL4MFUL33JZ435P27S4IXMMKSD5HMFXJNNZZ3CQKZEYZJRN45L5QNQTIE4O3QZL23KDEV7ZJML7BMPGWNPLMFKVQIHQIA53ZM2GJECZ7BVDUKZ3HQSENKP52BBDCHE7UB3LHLXZERF7NNIDSAPIN6XNHVVVXNMH7HBNQVHVV4L3FTI4LL7PMEDCXCY6FF45SIZT3RLEZML6W6VIG4UB3NPKGAN4LAJQAMS32WJ6XML5CRQGFHP3ZYBNC5WGUPC4GIHSMC44KRC3WFUIKVQD6EOXS4J3K7LWIOM3LPV3HBA73MB6PACFJLGG6GNY7X4PMMJJ7WXR7GAHDJIV533RAND25VIUKTTEVCRCSTL47IEYE7IJV7INAUO44GLDK2WQPB4WBQ7EYJIZSLAQ5RCSZZS4CSS35YHNSXGMXFC5VJKMWDPOTLDKV36LBDGDJNOHBZZYJOKAHNBJFRN2P63QW3UKV4WJLKEBTZYBEF3LBMT6UNDC5C56MITLGODUDJZICFX2H6IYYXLYHQJRMRFE7RKKLBBSNUZK2MA6BULXXBLQFYNEW5XTJ47L7TH4OM4PJBYIUSLPTDV64GJ2AN53YKWARHI36JKKBAQFD5CVDB3V6MVEKFN2PMJN4IOP4JTB5WHDZN2KSTE547GCHDGRBYZ37XQNM4WJ4DB6EWYV53FSCOMD4MBFQ7DEWNCUG65VZS5YP2SIWPV6HJDX4HO5NL2VDU4LKZNHGAC2EZ7L4IR2LPPQ23BOG4WIPRZM3XFVQVIVTFYITKIW46KRLFFNFYGMOWYNROZ6RKHOVYD53FQE44M4BHW6PLC2ENUAFE6QT4JUZ54QHNGK42RJGADXSGFGLGJ6E35HZVHXV5DMXYOFO3GJU66DEEKQ6LHCX5PROWMIS5NBJHV5RWMLEY7LJBJUQ55ACG3GKPVWCVKDMKL4Y6W6SFIXQ6G2CBPEV66F6OPJ56N4NBBME3OA434BO76UFZ44U567F2TVHCALTAXABYURZTWLAZPDQX7IM64LEDKVEUMF62B33N7CY2UO3L54NOSCGN3HM25XHA7FYUZG7A2PMH5BOPIAAJ2EKOPW35F2BQIBJD4I22ZWQJT25PTJBOGDEJHCELFDWFABIRGKUXW64FT4BBLWM6VTLTUAJ5VEU5S53FM7ORXTTMROG26TO4M3YTGUVLONGCRACB2SYJ3NPPLPHITYMLM7AX422HT2EJ5FUMJTIP65D3QCD2Z2BSEK4FFXCRKITPRW6QXK2DDCJ4RHR5LTPE5RLDD4RLZGSB64ZL6R5A7UXZCMHSURQAIA====]} Payload: {"comments":"","createdByName":"Rahul","customerId":"Eris_No_FB_1","displayName":"Eris_No_FB_1","properties":{"countryCode":"US","language":"en","locale":"en_US","currencyCode":"USD"},"realm":"com.thesearchagency/b8a7d340-30e0-4369-97d0-8f901d238f86","resellerId":"b8a7d340-30e0-4369-97d0-8f901d238f86","active":true,"socialCustomer":{"enabled":false,"inviteStatus":false}} -------------------------------------- 2018-08-30 12:03:14,838-89002061 [http-nio-8080-exec-58] ERROR com.thesearchagency.services.merchant.dao.MerchantDAO [hostname=127.0.0.1, requestId=dba35894-ffda-41e7-a846-d6b1d6933465, timezone=UTC, authToken=ACUB2IBDMYLO4ISATG7DIO3Y4MHTLBFL5WR4PFYBSHCJ7N3AWDL6RDS5T4Z3NV7OHAMC4KLRFPWBHTHVVSOE7AL5OFHK2NTWCBIKQV7ZMHLKL4DPQ4UBYQKHD4BGOTEGWDBBAKU3KS7YSCIRQD6JQIC7HHQK27RLHORLQJ4PHFAMUH3CFNHY252EFCY56QFT7KNFV3A6BSXEQDA3FGXACETAIMF75DEYROAOWR45NHG5BSHTHNNNY6D4QNXJKI5FF2DM66UCIE37HVHRJD65LPVQCFGW4BPUZL6KYHOICNYKNIRUYYO6KZI5QXQFIDTFLTOYAVUV65R5FXJYS5MTHFA4GDL4MFUL33JZ435P27S4IXMMKSD5HMFXJNNZZ3CQKZEYZJRN45L5QNQTIE4O3QZL23KDEV7ZJML7BMPGWNPLMFKVQIHQIA53ZM2GJECZ7BVDUKZ3HQSENKP52BBDCHE7UB3LHLXZERF7NNIDSAPIN6XNHVVVXNMH7HBNQVHVV4L3FTI4LL7PMEDCXCY6FF45SIZT3RLEZML6W6VIG4UB3NPKGAN4LAJQAMS32WJ6XML5CRQGFHP3ZYBNC5WGUPC4GIHSMC44KRC3WFUIKVQD6EOXS4J3K7LWIOM3LPV3HBA73MB6PACFJLGG6GNY7X4PMMJJ7WXR7GAHDJIV533RAND25VIUKTTEVCRCSTL47IEYE7IJV7INAUO44GLDK2WQPB4WBQ7EYJIZSLAQ5RCSZZS4CSS35YHNSXGMXFC5VJKMWDPOTLDKV36LBDGDJNOHBZZYJOKAHNBJFRN2P63QW3UKV4WJLKEBTZYBEF3LBMT6UNDC5C56MITLGODUDJZICFX2H6IYYXLYHQJRMRFE7RKKLBBSNUZK2MA6BULXXBLQFYNEW5XTJ47L7TH4OM4PJBYIUSLPTDV64GJ2AN53YKWARHI36JKKBAQFD5CVDB3V6MVEKFN2PMJN4IOP4JTB5WHDZN2KSTE547GCHDGRBYZ37XQNM4WJ4DB6EWYV53FSCOMD4MBFQ7DEWNCUG65VZS5YP2SIWPV6HJDX4HO5NL2VDU4LKZNHGAC2EZ7L4IR2LPPQ23BOG4WIPRZM3XFVQVIVTFYITKIW46KRLFFNFYGMOWYNROZ6RKHOVYD53FQE44M4BHW6PLC2ENUAFE6QT4JUZ54QHNGK42RJGADXSGFGLGJ6E35HZVHXV5DMXYOFO3GJU66DEEKQ6LHCX5PROWMIS5NBJHV5RWMLEY7LJBJUQ55ACG3GKPVWCVKDMKL4Y6W6SFIXQ6G2CBPEV66F6OPJ56N4NBBME3OA434BO76UFZ44U567F2TVHCALTAXABYURZTWLAZPDQX7IM64LEDKVEUMF62B33N7CY2UO3L54NOSCGN3HM25XHA7FYUZG7A2PMH5BOPIAAJ2EKOPW35F2BQIBJD4I22ZWQJT25PTJBOGDEJHCELFDWFABIRGKUXW64FT4BBLWM6VTLTUAJ5VEU5S53FM7ORXTTMROG26TO4M3YTGUVLONGCRACB2SYJ3NPPLPHITYMLM7AX422HT2EJ5FUMJTIP65D3QCD2Z2BSEK4FFXCRKITPRW6QXK2DDCJ4RHR5LTPE5RLDD4RLZGSB64ZL6R5A7UXZCMHSURQAIA====, ipAddress=127.0.0.1, principalId=344d3f74-8450-4ca5-a5a8-633074f858db, locale=en_US] - Exception thrown in search() org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT merchants.*, u.id as _users_id, u.realm_id as _users_realm_id,u.type as _users_type,u.first_name as _users_first_name,u.last_name as _users_last_name,u.display as _users_display,u.description as _users_description,u.created_on as _users_created_on,u.created_by as _users_created_by,u.modified_on as _users_modified_on,u.modified_by as _users_modified_by,u.active as _users_active,u.password as _users_password,u.salt as _users_salt,u.organization as _users_organization,u.language as _users_language,u.country as _users_country,u.timezone as _users_timezone,u.gender as _users_gender,u.birthday as _users_birthday,u.login as _users_login,u.email as _users_email,u.homepage as _users_homepage,u.home_phone as _users_home_phone,u.work_phone as _users_work_phone,u.mobile_phone as _users_mobile_phone, creator.display as _creator_name, m.display as _modifier_name FROM `merchants` LEFT JOIN `users` u ON u.id = merchants.user_id LEFT JOIN `users` creator ON creator.id = merchants.created_by LEFT JOIN `users` m on m.id = merchants.modified_by WHERE (merchants.`realm_id` LIKE concat(?,'%')) AND merchants.customer_id = ?]; SQL state [S0022]; error code [0]; Column '_tp_customers_id' not found.; nested exception is java.sql.SQLException: Column '_tp_customers_id' not found. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:726) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:776) at com.thesearchagency.services.merchant.dao.MerchantDAO.searchByCustomerId(MerchantDAO.java:591) at com.thesearchagency.services.merchant.MerchantServiceComponent.searchCustomersId(MerchantServiceComponent.java:130) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 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.$Proxy56.searchCustomersId(Unknown Source) at com.thesearchagency.sapi.services.merchant.MerchantService.isCustomerIdUnique(MerchantService.java:890) at com.thesearchagency.sapi.services.merchant.MerchantService.checkCustomerIdUniqueness(MerchantService.java:872) at com.thesearchagency.sapi.services.merchant.MerchantService.isMerchantUnique(MerchantService.java:850) at com.thesearchagency.sapi.services.merchant.MerchantService.access$400(MerchantService.java:89) at com.thesearchagency.sapi.services.merchant.MerchantService$3.call(MerchantService.java:248) at com.thesearchagency.sapi.services.SAPIService.doExecuteWithValidData(SAPIService.java:122) at com.thesearchagency.sapi.services.merchant.MerchantService.createMerchant(MerchantService.java:213) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 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.doPost(AbstractHTTPServlet.java:212) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) 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: java.sql.SQLException: Column '_tp_customers_id' not found. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1167) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5733) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263) at com.thesearchagency.services.merchant.dao.MerchantDAO$1.mapRow(MerchantDAO.java:310) at com.thesearchagency.services.merchant.dao.MerchantDAO$1.mapRow(MerchantDAO.java:276) at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:93) at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:60) at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:697) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633) ... 69 common frames omitted 2018-08-30 12:03:14,839-89002062 [http-nio-8080-exec-58] ERROR com.thesearchagency.services.merchant.MerchantServiceComponent [hostname=127.0.0.1, requestId=dba35894-ffda-41e7-a846-d6b1d6933465, timezone=UTC, authToken=ACUB2IBDMYLO4ISATG7DIO3Y4MHTLBFL5WR4PFYBSHCJ7N3AWDL6RDS5T4Z3NV7OHAMC4KLRFPWBHTHVVSOE7AL5OFHK2NTWCBIKQV7ZMHLKL4DPQ4UBYQKHD4BGOTEGWDBBAKU3KS7YSCIRQD6JQIC7HHQK27RLHORLQJ4PHFAMUH3CFNHY252EFCY56QFT7KNFV3A6BSXEQDA3FGXACETAIMF75DEYROAOWR45NHG5BSHTHNNNY6D4QNXJKI5FF2DM66UCIE37HVHRJD65LPVQCFGW4BPUZL6KYHOICNYKNIRUYYO6KZI5QXQFIDTFLTOYAVUV65R5FXJYS5MTHFA4GDL4MFUL33JZ435P27S4IXMMKSD5HMFXJNNZZ3CQKZEYZJRN45L5QNQTIE4O3QZL23KDEV7ZJML7BMPGWNPLMFKVQIHQIA53ZM2GJECZ7BVDUKZ3HQSENKP52BBDCHE7UB3LHLXZERF7NNIDSAPIN6XNHVVVXNMH7HBNQVHVV4L3FTI4LL7PMEDCXCY6FF45SIZT3RLEZML6W6VIG4UB3NPKGAN4LAJQAMS32WJ6XML5CRQGFHP3ZYBNC5WGUPC4GIHSMC44KRC3WFUIKVQD6EOXS4J3K7LWIOM3LPV3HBA73MB6PACFJLGG6GNY7X4PMMJJ7WXR7GAHDJIV533RAND25VIUKTTEVCRCSTL47IEYE7IJV7INAUO44GLDK2WQPB4WBQ7EYJIZSLAQ5RCSZZS4CSS35YHNSXGMXFC5VJKMWDPOTLDKV36LBDGDJNOHBZZYJOKAHNBJFRN2P63QW3UKV4WJLKEBTZYBEF3LBMT6UNDC5C56MITLGODUDJZICFX2H6IYYXLYHQJRMRFE7RKKLBBSNUZK2MA6BULXXBLQFYNEW5XTJ47L7TH4OM4PJBYIUSLPTDV64GJ2AN53YKWARHI36JKKBAQFD5CVDB3V6MVEKFN2PMJN4IOP4JTB5WHDZN2KSTE547GCHDGRBYZ37XQNM4WJ4DB6EWYV53FSCOMD4MBFQ7DEWNCUG65VZS5YP2SIWPV6HJDX4HO5NL2VDU4LKZNHGAC2EZ7L4IR2LPPQ23BOG4WIPRZM3XFVQVIVTFYITKIW46KRLFFNFYGMOWYNROZ6RKHOVYD53FQE44M4BHW6PLC2ENUAFE6QT4JUZ54QHNGK42RJGADXSGFGLGJ6E35HZVHXV5DMXYOFO3GJU66DEEKQ6LHCX5PROWMIS5NBJHV5RWMLEY7LJBJUQ55ACG3GKPVWCVKDMKL4Y6W6SFIXQ6G2CBPEV66F6OPJ56N4NBBME3OA434BO76UFZ44U567F2TVHCALTAXABYURZTWLAZPDQX7IM64LEDKVEUMF62B33N7CY2UO3L54NOSCGN3HM25XHA7FYUZG7A2PMH5BOPIAAJ2EKOPW35F2BQIBJD4I22ZWQJT25PTJBOGDEJHCELFDWFABIRGKUXW64FT4BBLWM6VTLTUAJ5VEU5S53FM7ORXTTMROG26TO4M3YTGUVLONGCRACB2SYJ3NPPLPHITYMLM7AX422HT2EJ5FUMJTIP65D3QCD2Z2BSEK4FFXCRKITPRW6QXK2DDCJ4RHR5LTPE5RLDD4RLZGSB64ZL6R5A7UXZCMHSURQAIA====, ipAddress=127.0.0.1, principalId=344d3f74-8450-4ca5-a5a8-633074f858db, locale=en_US] - StorageManagerException thrown while searching for customers id 'Eris_No_FB_1'. com.thesearchagency.database.storage.StorageManagerException: package com.thesearchagency.database.storage.INTERNAL_ERROR_EXCEPTION at com.thesearchagency.services.merchant.dao.MerchantDAO.searchByCustomerId(MerchantDAO.java:595) at com.thesearchagency.services.merchant.MerchantServiceComponent.searchCustomersId(MerchantServiceComponent.java:130) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 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.$Proxy56.searchCustomersId(Unknown Source) at com.thesearchagency.sapi.services.merchant.MerchantService.isCustomerIdUnique(MerchantService.java:890) at com.thesearchagency.sapi.services.merchant.MerchantService.checkCustomerIdUniqueness(MerchantService.java:872) at com.thesearchagency.sapi.services.merchant.MerchantService.isMerchantUnique(MerchantService.java:850) at com.thesearchagency.sapi.services.merchant.MerchantService.access$400(MerchantService.java:89) at com.thesearchagency.sapi.services.merchant.MerchantService$3.call(MerchantService.java:248) at com.thesearchagency.sapi.services.SAPIService.doExecuteWithValidData(SAPIService.java:122) at com.thesearchagency.sapi.services.merchant.MerchantService.createMerchant(MerchantService.java:213) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 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.doPost(AbstractHTTPServlet.java:212) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) 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) 2018-08-30 12:03:14,843-89002066 [http-nio-8080-exec-58] ERROR com.thesearchagency.sapi.services.merchant.MerchantService [hostname=127.0.0.1, requestId=dba35894-ffda-41e7-a846-d6b1d6933465, timezone=UTC, authToken=ACUB2IBDMYLO4ISATG7DIO3Y4MHTLBFL5WR4PFYBSHCJ7N3AWDL6RDS5T4Z3NV7OHAMC4KLRFPWBHTHVVSOE7AL5OFHK2NTWCBIKQV7ZMHLKL4DPQ4UBYQKHD4BGOTEGWDBBAKU3KS7YSCIRQD6JQIC7HHQK27RLHORLQJ4PHFAMUH3CFNHY252EFCY56QFT7KNFV3A6BSXEQDA3FGXACETAIMF75DEYROAOWR45NHG5BSHTHNNNY6D4QNXJKI5FF2DM66UCIE37HVHRJD65LPVQCFGW4BPUZL6KYHOICNYKNIRUYYO6KZI5QXQFIDTFLTOYAVUV65R5FXJYS5MTHFA4GDL4MFUL33JZ435P27S4IXMMKSD5HMFXJNNZZ3CQKZEYZJRN45L5QNQTIE4O3QZL23KDEV7ZJML7BMPGWNPLMFKVQIHQIA53ZM2GJECZ7BVDUKZ3HQSENKP52BBDCHE7UB3LHLXZERF7NNIDSAPIN6XNHVVVXNMH7HBNQVHVV4L3FTI4LL7PMEDCXCY6FF45SIZT3RLEZML6W6VIG4UB3NPKGAN4LAJQAMS32WJ6XML5CRQGFHP3ZYBNC5WGUPC4GIHSMC44KRC3WFUIKVQD6EOXS4J3K7LWIOM3LPV3HBA73MB6PACFJLGG6GNY7X4PMMJJ7WXR7GAHDJIV533RAND25VIUKTTEVCRCSTL47IEYE7IJV7INAUO44GLDK2WQPB4WBQ7EYJIZSLAQ5RCSZZS4CSS35YHNSXGMXFC5VJKMWDPOTLDKV36LBDGDJNOHBZZYJOKAHNBJFRN2P63QW3UKV4WJLKEBTZYBEF3LBMT6UNDC5C56MITLGODUDJZICFX2H6IYYXLYHQJRMRFE7RKKLBBSNUZK2MA6BULXXBLQFYNEW5XTJ47L7TH4OM4PJBYIUSLPTDV64GJ2AN53YKWARHI36JKKBAQFD5CVDB3V6MVEKFN2PMJN4IOP4JTB5WHDZN2KSTE547GCHDGRBYZ37XQNM4WJ4DB6EWYV53FSCOMD4MBFQ7DEWNCUG65VZS5YP2SIWPV6HJDX4HO5NL2VDU4LKZNHGAC2EZ7L4IR2LPPQ23BOG4WIPRZM3XFVQVIVTFYITKIW46KRLFFNFYGMOWYNROZ6RKHOVYD53FQE44M4BHW6PLC2ENUAFE6QT4JUZ54QHNGK42RJGADXSGFGLGJ6E35HZVHXV5DMXYOFO3GJU66DEEKQ6LHCX5PROWMIS5NBJHV5RWMLEY7LJBJUQ55ACG3GKPVWCVKDMKL4Y6W6SFIXQ6G2CBPEV66F6OPJ56N4NBBME3OA434BO76UFZ44U567F2TVHCALTAXABYURZTWLAZPDQX7IM64LEDKVEUMF62B33N7CY2UO3L54NOSCGN3HM25XHA7FYUZG7A2PMH5BOPIAAJ2EKOPW35F2BQIBJD4I22ZWQJT25PTJBOGDEJHCELFDWFABIRGKUXW64FT4BBLWM6VTLTUAJ5VEU5S53FM7ORXTTMROG26TO4M3YTGUVLONGCRACB2SYJ3NPPLPHITYMLM7AX422HT2EJ5FUMJTIP65D3QCD2Z2BSEK4FFXCRKITPRW6QXK2DDCJ4RHR5LTPE5RLDD4RLZGSB64ZL6R5A7UXZCMHSURQAIA====, ipAddress=127.0.0.1, principalId=344d3f74-8450-4ca5-a5a8-633074f858db, locale=en_US] - Exception caught in execution. Data is Merchant(id=null, name=null, displayName=Eris_No_FB_1, description=null, realm=com.thesearchagency/b8a7d340-30e0-4369-97d0-8f901d238f86, active=true, createdDate=null, lastModifiedDate=null, createdBy=null, createdByName=Rahul, contactFirstName=null, contactLastName=null, lastModifiedBy=null, lastModifiedByName=null, customerId=Eris_No_FB_1, contactEmail=null, contactPhoneNumber=, phoneNumber=, comments=, contact=null, url=null, groupId=null, userId=null, resellerId=b8a7d340-30e0-4369-97d0-8f901d238f86, socialCustomer=SocialCustomer(id=null, name=null, enabled=false, inviteStatus=false), properties={countryCode=US, language=en, locale=en_US, currencyCode=USD}) com.thesearchagency.services.commons.ServiceException: Operation failed at com.thesearchagency.services.merchant.MerchantServiceComponent.searchCustomersId(MerchantServiceComponent.java:136) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 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.$Proxy56.searchCustomersId(Unknown Source) at com.thesearchagency.sapi.services.merchant.MerchantService.isCustomerIdUnique(MerchantService.java:890) at com.thesearchagency.sapi.services.merchant.MerchantService.checkCustomerIdUniqueness(MerchantService.java:872) at com.thesearchagency.sapi.services.merchant.MerchantService.isMerchantUnique(MerchantService.java:850) at com.thesearchagency.sapi.services.merchant.MerchantService.access$400(MerchantService.java:89) at com.thesearchagency.sapi.services.merchant.MerchantService$3.call(MerchantService.java:248) at com.thesearchagency.sapi.services.SAPIService.doExecuteWithValidData(SAPIService.java:122) at com.thesearchagency.sapi.services.merchant.MerchantService.createMerchant(MerchantService.java:213) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 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.doPost(AbstractHTTPServlet.java:212) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) 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.INTERNAL_ERROR_EXCEPTION at com.thesearchagency.services.merchant.dao.MerchantDAO.searchByCustomerId(MerchantDAO.java:595) at com.thesearchagency.services.merchant.MerchantServiceComponent.searchCustomersId(MerchantServiceComponent.java:130) ... 63 common frames omitted 2018-08-30 12:03:14,845-89002068 [http-nio-8080-exec-58] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message ---------------------------