[root@aml-qa4-front1 logs]# tail -f aml.log "maximumPrice" : 152.631, "minimumClicks" : 3.0, "maximumClicks" : 10.333, "campaign" : { "keywordListId" : "ac2bc3c7-deae-490e-8fb6-a9dba1923b2e", "locationId" : 4065 } } ] } -------------------------------------- 2021-05-10 09:39:47,446-1630341 [http-nio-8080-exec-51] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 67 Address: http://127.0.0.1:8080/sapi/rest/merchants?q=SELECT++WHERE+%28DisplayName+CONTAINS+%27%25sand%25%27+OR+CustomerId+CONTAINS+%27%25sand%25%27+OR+ContactEmail+CONTAINS+%27%25sand%25%27+OR+ContactPhoneNumber+CONTAINS+%27%25sand%25%27+OR+CreatedByName+CONTAINS+%27%25sand%25%27%29+AND+Active%3D%27T%27+ORDER+BY+DisplayName+ASC%2CCustomerId+ASC+LIMIT+0%2C25 Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], connection=[Keep-Alive], Content-Type=[null], host=[127.0.0.1:8080], user-agent=[Apache-HttpClient/4.5.3 (Java/1.8.0_161)], x-tsa-authenticate=[XTOPGEJTLKRB2WZJK6MFTSV2VTQIBF5QDKBVSUKR3I3I64WDHQ66K6K24IBRLSP6LPUMRCUOTA6MX5LBZFF22TCY4LXV6EYLSHDVACX6SNCIHGEDMIDLME363BGN3SDZ2XUGPTI7RWKVYJEQCSHKDTBM2RFUXL4HCXZTUCHCHNMGOGS2Q7NINK3F6MG7NQOP5QCMPDAWNHPZX4UXRHLNJCV5A4Z2UTMR5WCM23ZCJKMV7DEPWAIGYU5TATTD3VKWACMHDB4JKEBKX3LIOOFFAZ2EGKGVTFWUTHVLOI2CAUZH3UPPUC62U3ZPWYU33B4VAJ4Q5UCG4WDNLZRBCTZGD6G5TNIHZTRHY2TAGZ5T3EPWTDCNM7C7TWOZIMTLTS2APCX42O4EKUHD6K25ZHAWM7NMHWG4SH3G3RC5VSHQD6IFNFIG3NPFNAHTF2NH3CAKFGTVPN6V6CD5WP2VQRXTNH5N3W3PSJ236QXFTTZ7JEFLZMU25GVBNGZWTV7T6LTES5EQ5T6HKVGB6WIG7HQICCA5NERZZGCJILRK62ZBGREYSJ3U6B4DBY4RVQINRRH7EJL2LTRG2FQKIRK4OKMK5PATMQ2Z7HKDCVRIMSKHHPEVIC3N5BLCMNSKBZ7XJUQMVRFMDPMAHKB5NQUADMZM2OZZTA2B3CF6UIUVAYZ4GQKZ3RS7AUH5ROYUS25FPIMUVL25LVH4QR77GZKI6BNNTQPVIW3VHCEUVQIGSIK7PWNSNL76VSA5JP22PBHMVCGFW24XSPOOM462YNDP42OEW2TZYRL2ZHF5NWGHW7S5CV2NYUKLQQENLNHPBOODJV7NZQQDMSCRO5YL66427UGFHSNMXVB7LROGUQVCQZ6N76VSR7R32WC5W6U2Q25NZLLYI4C34SYZWBLBEB54R2ANVEAQKDOS2OIVWCDDH7ZK4W2HZ7PHJ546KOEVAH7U2FPTQU3FNYRLHAHLMSNYC6SBTSUSTQJMZBLD47T7NO2RS2EIUB4KVN6HNI6SGNNRJCOHNTXWB4T4XMKTQTA75XVZFYRUMPDCXEEK3WDMKPWQNIL7TD3LYCUPU5F6MMFTCPAD2I2BAGXWGOJYCQ6KXV65ONB6GCC2N5HGOJDFSNXWMK6ELGP35XRT7TRGLPP4LVJ3GZSNT7N2EXUEK4YAKQJPQOJNGAVXZOVNS5NTJXH2JH5IFWSMZLWRPZ2Q762MLNJONBLS7PR7XZOACYBJZ5UOSSFXU5ETJGERW3XPQJQWGXVXLYZDNJL326BEV7J4VRU6TNAJKWMT2VHL7G5LYBSRTRXEIFYTNQK3ADWEUBQ6DXNGJYUULMDYDN7OKZXX5Y73LDES2MGTDDYF3CM6SCNWZLPLM7XODEM6Q3ZT7PNZDS5NOM4HORMVZHYMVW7Y627K5BVBRCN5YONGTSNLGYV5HORMKRCT2WIJHLB4V2SRVHZOQJAUQUCPLFXYLPNYZWSKZAZ4OYOCR3BNXORSUWCSNAOGYERPBS7QYSJXDYBZ23NCZX5KOMMD4DGT2R2FM2PPVMO5KENI3CMBMB3APR7C4BTFICH4YCPUJT6X2KK6ZX5OKQKGDELI3PAYFS2ARY5BEJOSAOL62SYN6LLT5IGWZ5OKC3ICAZSMRLN4FFDUEVEEVJO5Y2SQ====]} -------------------------------------- 2021-05-10 09:39:47,527-1630422 [http-nio-8080-exec-51] ERROR com.thesearchagency.services.merchant.dao.MerchantDAO [hostname=127.0.0.1, requestId=2aa7e318-7927-4bf9-8248-af6dbcaacf32, timezone=UTC, authToken=XTOPGEJTLKRB2WZJK6MFTSV2VTQIBF5QDKBVSUKR3I3I64WDHQ66K6K24IBRLSP6LPUMRCUOTA6MX5LBZFF22TCY4LXV6EYLSHDVACX6SNCIHGEDMIDLME363BGN3SDZ2XUGPTI7RWKVYJEQCSHKDTBM2RFUXL4HCXZTUCHCHNMGOGS2Q7NINK3F6MG7NQOP5QCMPDAWNHPZX4UXRHLNJCV5A4Z2UTMR5WCM23ZCJKMV7DEPWAIGYU5TATTD3VKWACMHDB4JKEBKX3LIOOFFAZ2EGKGVTFWUTHVLOI2CAUZH3UPPUC62U3ZPWYU33B4VAJ4Q5UCG4WDNLZRBCTZGD6G5TNIHZTRHY2TAGZ5T3EPWTDCNM7C7TWOZIMTLTS2APCX42O4EKUHD6K25ZHAWM7NMHWG4SH3G3RC5VSHQD6IFNFIG3NPFNAHTF2NH3CAKFGTVPN6V6CD5WP2VQRXTNH5N3W3PSJ236QXFTTZ7JEFLZMU25GVBNGZWTV7T6LTES5EQ5T6HKVGB6WIG7HQICCA5NERZZGCJILRK62ZBGREYSJ3U6B4DBY4RVQINRRH7EJL2LTRG2FQKIRK4OKMK5PATMQ2Z7HKDCVRIMSKHHPEVIC3N5BLCMNSKBZ7XJUQMVRFMDPMAHKB5NQUADMZM2OZZTA2B3CF6UIUVAYZ4GQKZ3RS7AUH5ROYUS25FPIMUVL25LVH4QR77GZKI6BNNTQPVIW3VHCEUVQIGSIK7PWNSNL76VSA5JP22PBHMVCGFW24XSPOOM462YNDP42OEW2TZYRL2ZHF5NWGHW7S5CV2NYUKLQQENLNHPBOODJV7NZQQDMSCRO5YL66427UGFHSNMXVB7LROGUQVCQZ6N76VSR7R32WC5W6U2Q25NZLLYI4C34SYZWBLBEB54R2ANVEAQKDOS2OIVWCDDH7ZK4W2HZ7PHJ546KOEVAH7U2FPTQU3FNYRLHAHLMSNYC6SBTSUSTQJMZBLD47T7NO2RS2EIUB4KVN6HNI6SGNNRJCOHNTXWB4T4XMKTQTA75XVZFYRUMPDCXEEK3WDMKPWQNIL7TD3LYCUPU5F6MMFTCPAD2I2BAGXWGOJYCQ6KXV65ONB6GCC2N5HGOJDFSNXWMK6ELGP35XRT7TRGLPP4LVJ3GZSNT7N2EXUEK4YAKQJPQOJNGAVXZOVNS5NTJXH2JH5IFWSMZLWRPZ2Q762MLNJONBLS7PR7XZOACYBJZ5UOSSFXU5ETJGERW3XPQJQWGXVXLYZDNJL326BEV7J4VRU6TNAJKWMT2VHL7G5LYBSRTRXEIFYTNQK3ADWEUBQ6DXNGJYUULMDYDN7OKZXX5Y73LDES2MGTDDYF3CM6SCNWZLPLM7XODEM6Q3ZT7PNZDS5NOM4HORMVZHYMVW7Y627K5BVBRCN5YONGTSNLGYV5HORMKRCT2WIJHLB4V2SRVHZOQJAUQUCPLFXYLPNYZWSKZAZ4OYOCR3BNXORSUWCSNAOGYERPBS7QYSJXDYBZ23NCZX5KOMMD4DGT2R2FM2PPVMO5KENI3CMBMB3APR7C4BTFICH4YCPUJT6X2KK6ZX5OKQKGDELI3PAYFS2ARY5BEJOSAOL62SYN6LLT5IGWZ5OKC3ICAZSMRLN4FFDUEVEEVJO5Y2SQ====, ipAddress=127.0.0.1, principalId=17e23b95-40f4-4511-958b-38147115c39c, 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, b.businessId as _fb_businesses_id, b.name as _fb_businesses_name, b.clientPageId as _fb_businesses_client_page_id, b.leadsTOSAccepted as _fb_businesses_leads_tos_accepted, b.leadsTOSEnabled as _fb_businesses_leads_tos_enabled, b.enabled as _fb_businesses_enabled, b.inviteStatus as _fb_businesses_invite_status, b.users as _fb_businesses_users, c.accountId as _fb_customers_id, c.name as _fb_customers_name, c.businessId as _fb_customers_business_id, c.assignedSystemUserId as _fb_customers_assigned_system_user_id, c.pixelId as _fb_customers_pixel_id, c.pixelCode as _fb_customers_pixel_code 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 LEFT JOIN `facebook`.`businesses` b on b.name = merchants.id LEFT JOIN `facebook`.`customers` c on c.name = merchants.id WHERE (merchants.`realm_id` LIKE concat(?,'%')) AND ((((((merchants.display LIKE '%sand%') OR (merchants.customer_id LIKE '%sand%')) OR (merchants.contact_email LIKE '%sand%')) OR (merchants.contact_phone LIKE '%sand%')) OR (creator.display LIKE '%sand%')) AND (merchants.active = 'T')) ORDER BY merchants.display ASC, merchants.customer_id ASC LIMIT 25]; SQL state [S0022]; error code [0]; Column '_creator_email' not found.; nested exception is java.sql.SQLException: Column '_creator_email' 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.search(MerchantDAO.java:488) at com.thesearchagency.services.merchant.MerchantServiceComponent.getMerchants(MerchantServiceComponent.java:109) 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.$Proxy631.getMerchants(Unknown Source) at com.thesearchagency.sapi.services.merchant.MerchantService.doExecuteQuery(MerchantService.java:1467) at com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants(MerchantService.java:1199) 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.doGet(AbstractHTTPServlet.java:217) at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) 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.valves.rewrite.RewriteValve.invoke(RewriteValve.java:542) 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 '_creator_email' 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:234) at com.thesearchagency.services.merchant.dao.MerchantDAO$1.mapRow(MerchantDAO.java:217) 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) ... 65 common frames omitted 2021-05-10 09:39:47,529-1630424 [http-nio-8080-exec-51] ERROR com.thesearchagency.services.merchant.MerchantServiceComponent [hostname=127.0.0.1, requestId=2aa7e318-7927-4bf9-8248-af6dbcaacf32, timezone=UTC, authToken=XTOPGEJTLKRB2WZJK6MFTSV2VTQIBF5QDKBVSUKR3I3I64WDHQ66K6K24IBRLSP6LPUMRCUOTA6MX5LBZFF22TCY4LXV6EYLSHDVACX6SNCIHGEDMIDLME363BGN3SDZ2XUGPTI7RWKVYJEQCSHKDTBM2RFUXL4HCXZTUCHCHNMGOGS2Q7NINK3F6MG7NQOP5QCMPDAWNHPZX4UXRHLNJCV5A4Z2UTMR5WCM23ZCJKMV7DEPWAIGYU5TATTD3VKWACMHDB4JKEBKX3LIOOFFAZ2EGKGVTFWUTHVLOI2CAUZH3UPPUC62U3ZPWYU33B4VAJ4Q5UCG4WDNLZRBCTZGD6G5TNIHZTRHY2TAGZ5T3EPWTDCNM7C7TWOZIMTLTS2APCX42O4EKUHD6K25ZHAWM7NMHWG4SH3G3RC5VSHQD6IFNFIG3NPFNAHTF2NH3CAKFGTVPN6V6CD5WP2VQRXTNH5N3W3PSJ236QXFTTZ7JEFLZMU25GVBNGZWTV7T6LTES5EQ5T6HKVGB6WIG7HQICCA5NERZZGCJILRK62ZBGREYSJ3U6B4DBY4RVQINRRH7EJL2LTRG2FQKIRK4OKMK5PATMQ2Z7HKDCVRIMSKHHPEVIC3N5BLCMNSKBZ7XJUQMVRFMDPMAHKB5NQUADMZM2OZZTA2B3CF6UIUVAYZ4GQKZ3RS7AUH5ROYUS25FPIMUVL25LVH4QR77GZKI6BNNTQPVIW3VHCEUVQIGSIK7PWNSNL76VSA5JP22PBHMVCGFW24XSPOOM462YNDP42OEW2TZYRL2ZHF5NWGHW7S5CV2NYUKLQQENLNHPBOODJV7NZQQDMSCRO5YL66427UGFHSNMXVB7LROGUQVCQZ6N76VSR7R32WC5W6U2Q25NZLLYI4C34SYZWBLBEB54R2ANVEAQKDOS2OIVWCDDH7ZK4W2HZ7PHJ546KOEVAH7U2FPTQU3FNYRLHAHLMSNYC6SBTSUSTQJMZBLD47T7NO2RS2EIUB4KVN6HNI6SGNNRJCOHNTXWB4T4XMKTQTA75XVZFYRUMPDCXEEK3WDMKPWQNIL7TD3LYCUPU5F6MMFTCPAD2I2BAGXWGOJYCQ6KXV65ONB6GCC2N5HGOJDFSNXWMK6ELGP35XRT7TRGLPP4LVJ3GZSNT7N2EXUEK4YAKQJPQOJNGAVXZOVNS5NTJXH2JH5IFWSMZLWRPZ2Q762MLNJONBLS7PR7XZOACYBJZ5UOSSFXU5ETJGERW3XPQJQWGXVXLYZDNJL326BEV7J4VRU6TNAJKWMT2VHL7G5LYBSRTRXEIFYTNQK3ADWEUBQ6DXNGJYUULMDYDN7OKZXX5Y73LDES2MGTDDYF3CM6SCNWZLPLM7XODEM6Q3ZT7PNZDS5NOM4HORMVZHYMVW7Y627K5BVBRCN5YONGTSNLGYV5HORMKRCT2WIJHLB4V2SRVHZOQJAUQUCPLFXYLPNYZWSKZAZ4OYOCR3BNXORSUWCSNAOGYERPBS7QYSJXDYBZ23NCZX5KOMMD4DGT2R2FM2PPVMO5KENI3CMBMB3APR7C4BTFICH4YCPUJT6X2KK6ZX5OKQKGDELI3PAYFS2ARY5BEJOSAOL62SYN6LLT5IGWZ5OKC3ICAZSMRLN4FFDUEVEEVJO5Y2SQ====, ipAddress=127.0.0.1, principalId=17e23b95-40f4-4511-958b-38147115c39c, locale=en_US] - StorageManagerException thrown while searching for merchants using 'SELECT WHERE (DisplayName CONTAINS '%sand%' OR CustomerId CONTAINS '%sand%' OR ContactEmail CONTAINS '%sand%' OR ContactPhoneNumber CONTAINS '%sand%' OR CreatedByName CONTAINS '%sand%') AND Active='T' ORDER BY DisplayName ASC,CustomerId ASC LIMIT 0,25'. com.thesearchagency.database.storage.StorageManagerException: package com.thesearchagency.database.storage.INTERNAL_ERROR_EXCEPTION at com.thesearchagency.services.merchant.dao.MerchantDAO.search(MerchantDAO.java:492) at com.thesearchagency.services.merchant.MerchantServiceComponent.getMerchants(MerchantServiceComponent.java:109) 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.$Proxy631.getMerchants(Unknown Source) at com.thesearchagency.sapi.services.merchant.MerchantService.doExecuteQuery(MerchantService.java:1467) at com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants(MerchantService.java:1199) 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.doGet(AbstractHTTPServlet.java:217) at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) 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.valves.rewrite.RewriteValve.invoke(RewriteValve.java:542) 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) 2021-05-10 09:39:47,540-1630435 [http-nio-8080-exec-51] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 67 Response-Code: 304 Content-Type: text/plain;charset=UTF-8;version=3.1.23-BETA46 Headers: {Content-Type=[text/plain;charset=UTF-8;version=3.1.23-BETA46], Date=[Mon, 10 May 2021 09:39:47 GMT], X-AML-API-ID=[2aa7e318-7927-4bf9-8248-af6dbcaacf32], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]} Payload: Operation failed -------------------------------------- 2021-05-10 09:39:51,299-1634194 [OrderScheduler_Worker-3] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdateJob [] - Determining number of orders requiring update. 2021-05-10 09:39:51,375-1634270 [OrderScheduler_Worker-3] INFO com.thesearchagency.sapi.services.order.OrderStatusUpdateJob [] - Beginning update for 0 orders. 2021-05-10 09:39:57,780-1640675 [http-nio-8080-exec-53] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 68 Address: http://127.0.0.1:8080/sapi/rest/users?q=SELECT+WHERE+Email%3D%27harish.kumar%40admaxlocal.com%27 Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], connection=[Keep-Alive], Content-Type=[null], host=[127.0.0.1:8080], user-agent=[Apache-HttpClient/4.5.3 (Java/1.8.0_161)], x-tsa-authenticate=[XTOPGEJTLKRB2WZJK6MFTSV2VTQIBF5QDKBVSUKR3I3I64WDHQ66K6K24IBRLSP6LPUMRCUOTA6MX5LBZFF22TCY4LXV6EYLSHDVACX6SNCIHGEDMIDLME363BGN3SDZ2XUGPTI7RWKVYJEQCSHKDTBM2RFUXL4HCXZTUCHCHNMGOGS2Q7NINK3F6MG7NQOP5QCMPDAWNHPZX4UXRHLNJCV5A4Z2UTMR5WCM23ZCJKMV7DEPWAIGYU5TATTD3VKWACMHDB4JKEBKX3LIOOFFAZ2EGKGVTFWUTHVLOI2CAUZH3UPPUC62U3ZPWYU33B4VAJ4Q5UCG4WDNLZRBCTZGD6G5TNIHZTRHY2TAGZ5T3EPWTDCNM7C7TWOZIMTLTS2APCX42O4EKUHD6K25ZHAWM7NMHWG4SH3G3RC5VSHQD6IFNFIG3NPFNAHTF2NH3CAKFGTVPN6V6CD5WP2VQRXTNH5N3W3PSJ236QXFTTZ7JEFLZMU25GVBNGZWTV7T6LTES5EQ5T6HKVGB6WIG7HQICCA5NERZZGCJILRK62ZBGREYSJ3U6B4DBY4RVQINRRH7EJL2LTRG2FQKIRK4OKMK5PATMQ2Z7HKDCVRIMSKHHPEVIC3N5BLCMNSKBZ7XJUQMVRFMDPMAHKB5NQUADMZM2OZZTA2B3CF6UIUVAYZ4GQKZ3RS7AUH5ROYUS25FPIMUVL25LVH4QR77GZKI6BNNTQPVIW3VHCEUVQIGSIK7PWNSNL76VSA5JP22PBHMVCGFW24XSPOOM462YNDP42OEW2TZYRL2ZHF5NWGHW7S5CV2NYUKLQQENLNHPBOODJV7NZQQDMSCRO5YL66427UGFHSNMXVB7LROGUQVCQZ6N76VSR7R32WC5W6U2Q25NZLLYI4C34SYZWBLBEB54R2ANVEAQKDOS2OIVWCDDH7ZK4W2HZ7PHJ546KOEVAH7U2FPTQU3FNYRLHAHLMSNYC6SBTSUSTQJMZBLD47T7NO2RS2EIUB4KVN6HNI6SGNNRJCOHNTXWB4T4XMKTQTA75XVZFYRUMPDCXEEK3WDMKPWQNIL7TD3LYCUPU5F6MMFTCPAD2I2BAGXWGOJYCQ6KXV65ONB6GCC2N5HGOJDFSNXWMK6ELGP35XRT7TRGLPP4LVJ3GZSNT7N2EXUEK4YAKQJPQOJNGAVXZOVNS5NTJXH2JH5IFWSMZLWRPZ2Q762MLNJONBLS7PR7XZOACYBJZ5UOSSFXU5ETJGERW3XPQJQWGXVXLYZDNJL326BEV7J4VRU6TNAJKWMT2VHL7G5LYBSRTRXEIFYTNQK3ADWEUBQ6DXNGJYUULMDYDN7OKZXX5Y73LDES2MGTDDYF3CM6SCNWZLPLM7XODEM6Q3ZT7PNZDS5NOM4HORMVZHYMVW7Y627K5BVBRCN5YONGTSNLGYV5HORMKRCT2WIJHLB4V2SRVHZOQJAUQUCPLFXYLPNYZWSKZAZ4OYOCR3BNXORSUWCSNAOGYERPBS7QYSJXDYBZ23NCZX5KOMMD4DGT2R2FM2PPVMO5KENI3CMBMB3APR7C4BTFICH4YCPUJT6X2KK6ZX5OKQKGDELI3PAYFS2ARY5BEJOSAOL62SYN6LLT5IGWZ5OKC3ICAZSMRLN4FFDUEVEEVJO5Y2SQ====]} -------------------------------------- 2021-05-10 09:39:57,814-1640709 [http-nio-8080-exec-53] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 68 Response-Code: 200 Content-Type: application/json;charset=UTF-8;type=tsa-user-query-response;version=3.1.23-BETA46 Headers: {Content-Type=[application/json;charset=UTF-8;type=tsa-user-query-response;version=3.1.23-BETA46], Date=[Mon, 10 May 2021 09:39:57 GMT], X-AML-API-ID=[e97f1a2a-2fd5-4900-94ba-c84428e0f0c7], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]} Payload: { "results" : [ { "createdBy" : "344d3f74-8450-4ca5-a5a8-633074f858db", "active" : true, "createdDate" : "2020-10-23T05:47:55.000+0000", "lastModifiedDate" : "2020-10-23T05:47:55.000+0000", "lastModifiedBy" : "344d3f74-8450-4ca5-a5a8-633074f858db", "countryCode" : "US", "id" : "17e23b95-40f4-4511-958b-38147115c39c", "birthday" : null, "mobilePhone" : "", "lastLoginDate" : "1970-01-01T00:00:00.000+0000", "firstName" : null, "lastName" : null, "organization" : null, "email" : "harish.kumar@admaxlocal.com", "gender" : "M", "language" : "en", "timezone" : "America/New_York", "homePhone" : "", "workPhone" : null, "workPhoneExtension" : null, "displayName" : "Test", "realm" : "com.thesearchagency/b8a7d340-30e0-4369-97d0-8f901d238f86", "description" : "", "properties" : { } } ], "total" : 1 } -------------------------------------- 2021-05-10 09:39:58,090-1640985 [http-nio-8080-exec-48] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 69 Address: http://127.0.0.1:8080/sapi/rest/resellers?q=WHERE+Realm%3D%27com.thesearchagency%2Fb8a7d340-30e0-4369-97d0-8f901d238f86%27 Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], connection=[Keep-Alive], Content-Type=[null], host=[127.0.0.1:8080], user-agent=[Apache-HttpClient/4.5.3 (Java/1.8.0_161)], x-tsa-authenticate=[XTOPGEJTLKRB2WZJK6MFTSV2VTQIBF5QDKBVSUKR3I3I64WDHQ66K6K24IBRLSP6LPUMRCUOTA6MX5LBZFF22TCY4LXV6EYLSHDVACX6SNCIHGEDMIDLME363BGN3SDZ2XUGPTI7RWKVYJEQCSHKDTBM2RFUXL4HCXZTUCHCHNMGOGS2Q7NINK3F6MG7NQOP5QCMPDAWNHPZX4UXRHLNJCV5A4Z2UTMR5WCM23ZCJKMV7DEPWAIGYU5TATTD3VKWACMHDB4JKEBKX3LIOOFFAZ2EGKGVTFWUTHVLOI2CAUZH3UPPUC62U3ZPWYU33B4VAJ4Q5UCG4WDNLZRBCTZGD6G5TNIHZTRHY2TAGZ5T3EPWTDCNM7C7TWOZIMTLTS2APCX42O4EKUHD6K25ZHAWM7NMHWG4SH3G3RC5VSHQD6IFNFIG3NPFNAHTF2NH3CAKFGTVPN6V6CD5WP2VQRXTNH5N3W3PSJ236QXFTTZ7JEFLZMU25GVBNGZWTV7T6LTES5EQ5T6HKVGB6WIG7HQICCA5NERZZGCJILRK62ZBGREYSJ3U6B4DBY4RVQINRRH7EJL2LTRG2FQKIRK4OKMK5PATMQ2Z7HKDCVRIMSKHHPEVIC3N5BLCMNSKBZ7XJUQMVRFMDPMAHKB5NQUADMZM2OZZTA2B3CF6UIUVAYZ4GQKZ3RS7AUH5ROYUS25FPIMUVL25LVH4QR77GZKI6BNNTQPVIW3VHCEUVQIGSIK7PWNSNL76VSA5JP22PBHMVCGFW24XSPOOM462YNDP42OEW2TZYRL2ZHF5NWGHW7S5CV2NYUKLQQENLNHPBOODJV7NZQQDMSCRO5YL66427UGFHSNMXVB7LROGUQVCQZ6N76VSR7R32WC5W6U2Q25NZLLYI4C34SYZWBLBEB54R2ANVEAQKDOS2OIVWCDDH7ZK4W2HZ7PHJ546KOEVAH7U2FPTQU3FNYRLHAHLMSNYC6SBTSUSTQJMZBLD47T7NO2RS2EIUB4KVN6HNI6SGNNRJCOHNTXWB4T4XMKTQTA75XVZFYRUMPDCXEEK3WDMKPWQNIL7TD3LYCUPU5F6MMFTCPAD2I2BAGXWGOJYCQ6KXV65ONB6GCC2N5HGOJDFSNXWMK6ELGP35XRT7TRGLPP4LVJ3GZSNT7N2EXUEK4YAKQJPQOJNGAVXZOVNS5NTJXH2JH5IFWSMZLWRPZ2Q762MLNJONBLS7PR7XZOACYBJZ5UOSSFXU5ETJGERW3XPQJQWGXVXLYZDNJL326BEV7J4VRU6TNAJKWMT2VHL7G5LYBSRTRXEIFYTNQK3ADWEUBQ6DXNGJYUULMDYDN7OKZXX5Y73LDES2MGTDDYF3CM6SCNWZLPLM7XODEM6Q3ZT7PNZDS5NOM4HORMVZHYMVW7Y627K5BVBRCN5YONGTSNLGYV5HORMKRCT2WIJHLB4V2SRVHZOQJAUQUCPLFXYLPNYZWSKZAZ4OYOCR3BNXORSUWCSNAOGYERPBS7QYSJXDYBZ23NCZX5KOMMD4DGT2R2FM2PPVMO5KENI3CMBMB3APR7C4BTFICH4YCPUJT6X2KK6ZX5OKQKGDELI3PAYFS2ARY5BEJOSAOL62SYN6LLT5IGWZ5OKC3ICAZSMRLN4FFDUEVEEVJO5Y2SQ====]} -------------------------------------- 2021-05-10 09:39:58,120-1641015 [http-nio-8080-exec-48] INFO com.thesearchagency.sapi.services.reseller.ResellerService [hostname=127.0.0.1, requestId=6a2576d2-45fb-4db1-ac7b-f2c2ea9e232b, timezone=UTC, authToken=XTOPGEJTLKRB2WZJK6MFTSV2VTQIBF5QDKBVSUKR3I3I64WDHQ66K6K24IBRLSP6LPUMRCUOTA6MX5LBZFF22TCY4LXV6EYLSHDVACX6SNCIHGEDMIDLME363BGN3SDZ2XUGPTI7RWKVYJEQCSHKDTBM2RFUXL4HCXZTUCHCHNMGOGS2Q7NINK3F6MG7NQOP5QCMPDAWNHPZX4UXRHLNJCV5A4Z2UTMR5WCM23ZCJKMV7DEPWAIGYU5TATTD3VKWACMHDB4JKEBKX3LIOOFFAZ2EGKGVTFWUTHVLOI2CAUZH3UPPUC62U3ZPWYU33B4VAJ4Q5UCG4WDNLZRBCTZGD6G5TNIHZTRHY2TAGZ5T3EPWTDCNM7C7TWOZIMTLTS2APCX42O4EKUHD6K25ZHAWM7NMHWG4SH3G3RC5VSHQD6IFNFIG3NPFNAHTF2NH3CAKFGTVPN6V6CD5WP2VQRXTNH5N3W3PSJ236QXFTTZ7JEFLZMU25GVBNGZWTV7T6LTES5EQ5T6HKVGB6WIG7HQICCA5NERZZGCJILRK62ZBGREYSJ3U6B4DBY4RVQINRRH7EJL2LTRG2FQKIRK4OKMK5PATMQ2Z7HKDCVRIMSKHHPEVIC3N5BLCMNSKBZ7XJUQMVRFMDPMAHKB5NQUADMZM2OZZTA2B3CF6UIUVAYZ4GQKZ3RS7AUH5ROYUS25FPIMUVL25LVH4QR77GZKI6BNNTQPVIW3VHCEUVQIGSIK7PWNSNL76VSA5JP22PBHMVCGFW24XSPOOM462YNDP42OEW2TZYRL2ZHF5NWGHW7S5CV2NYUKLQQENLNHPBOODJV7NZQQDMSCRO5YL66427UGFHSNMXVB7LROGUQVCQZ6N76VSR7R32WC5W6U2Q25NZLLYI4C34SYZWBLBEB54R2ANVEAQKDOS2OIVWCDDH7ZK4W2HZ7PHJ546KOEVAH7U2FPTQU3FNYRLHAHLMSNYC6SBTSUSTQJMZBLD47T7NO2RS2EIUB4KVN6HNI6SGNNRJCOHNTXWB4T4XMKTQTA75XVZFYRUMPDCXEEK3WDMKPWQNIL7TD3LYCUPU5F6MMFTCPAD2I2BAGXWGOJYCQ6KXV65ONB6GCC2N5HGOJDFSNXWMK6ELGP35XRT7TRGLPP4LVJ3GZSNT7N2EXUEK4YAKQJPQOJNGAVXZOVNS5NTJXH2JH5IFWSMZLWRPZ2Q762MLNJONBLS7PR7XZOACYBJZ5UOSSFXU5ETJGERW3XPQJQWGXVXLYZDNJL326BEV7J4VRU6TNAJKWMT2VHL7G5LYBSRTRXEIFYTNQK3ADWEUBQ6DXNGJYUULMDYDN7OKZXX5Y73LDES2MGTDDYF3CM6SCNWZLPLM7XODEM6Q3ZT7PNZDS5NOM4HORMVZHYMVW7Y627K5BVBRCN5YONGTSNLGYV5HORMKRCT2WIJHLB4V2SRVHZOQJAUQUCPLFXYLPNYZWSKZAZ4OYOCR3BNXORSUWCSNAOGYERPBS7QYSJXDYBZ23NCZX5KOMMD4DGT2R2FM2PPVMO5KENI3CMBMB3APR7C4BTFICH4YCPUJT6X2KK6ZX5OKQKGDELI3PAYFS2ARY5BEJOSAOL62SYN6LLT5IGWZ5OKC3ICAZSMRLN4FFDUEVEEVJO5Y2SQ====, ipAddress=127.0.0.1, principalId=17e23b95-40f4-4511-958b-38147115c39c, locale=en_US] - Getting Social distribution properties. 2021-05-10 09:39:58,154-1641049 [http-nio-8080-exec-48] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 69 Response-Code: 200 Content-Type: application/json;charset=UTF-8;type=tsa-reseller-query-response;version=3.1.23-BETA46 Headers: {Content-Type=[application/json;charset=UTF-8;type=tsa-reseller-query-response;version=3.1.23-BETA46], Date=[Mon, 10 May 2021 09:39:58 GMT], X-AML-API-ID=[6a2576d2-45fb-4db1-ac7b-f2c2ea9e232b], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]} Payload: { "results" : [ { "id" : "b8a7d340-30e0-4369-97d0-8f901d238f86", "name" : "qa4amltest", "displayName" : "QA4 Test", "description" : "", "realm" : "com.thesearchagency/b8a7d340-30e0-4369-97d0-8f901d238f86", "active" : true, "createdBy" : "c7542d20-f6ba-4784-842b-9202a92190e2", "createdByName" : "TSA Administrator", "contactName" : "QA4 Admin User", "lastModifiedBy" : "c7542d20-f6ba-4784-842b-9202a92190e2", "lastModifiedByName" : "TSA Administrator", "contact" : null, "contactEmail" : "atul.sanagar@thesearchagency.com", "contactPhoneNumber" : "1234567890", "phoneNumber" : "1234567894", "comments" : "", "url" : "http://www.qa4amltest.com", "groupId" : "12772913-06b1-4d3f-ac8c-4e661208593c", "userId" : "f4f232db-9eb9-4b8b-a8e8-23ea009541bb", "properties" : { "BING_BUDGET_ALLOCATION" : "0.40", "BING_CAMPAIGN_MIN_MONTHLY_BUDGET" : "0.01", "BING_ENABLED" : "true", "BING_MARKUP" : "0", "BUDGET_ACCRUAL" : "false", "FACEBOOK_BUDGET_ALLOCATION" : "0.10", "FACEBOOK_ENABLED" : "true", "FACEBOOK_MARKUP" : "0", "FACEBOOK_MIN_MONTHLY_BUDGET" : "124", "FB_AWS_ACCESS_KEY_ID" : "AKIAJYTDU7GYPCWRJ6AQ", "FB_AWS_BUCKET_NAME" : "aml-qa", "FB_AWS_LOCALE" : "usa", "FB_AWS_REGION" : "us-west-1", "FB_AWS_SECRET_ACCESS_KEY" : "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", "FB_AWS_URL" : "https://s3-us-west-1.amazonaws.com", "FB_BM_SYS_USER_PERMISSIONS" : "ads_management,business_management", "FB_ENABLED" : "true", "GOOGLE_CAMPAIGN_MIN_MONTHLY_BUDGET" : "0.01", "GOOG_BUDGET_ALLOCATION" : "0.4", "GOOG_ENABLED" : "true", "GOOG_MARKUP" : "0", "PROPORTION_GOOG_EST_FOR_BING" : "0.25", "PROPORTION_GOOG_EST_FOR_FACEBOOK" : "0.20", "checkFacebookByDefault" : "flase", "checkGoogleByDefault" : "true", "countryCode" : "US", "currencyCode" : "USD", "defaultSiteLinks" : "ContactUS,AboutUS,Feedback,Offers", "language" : "en", "locale" : "en_US", "markup" : "0", "merchantDashboardEnabled" : "true", "merchantDashboardPrivacyPolicyUrl" : "http://privacylink.com", "merchantDashboardTermsUrl" : "http://termsofservicelink.com", "merchantDashboardTitle" : "QA4 Test Dash Title", "merchantSupportEmail" : "Reseller-QA@admaxlocal.com", "minPrice" : "0", "notificationsEmailSender" : "harish.kumar@admaxlocal.com", "orderExportTemplate" : "qa4amltest_order_template.docx", "partnerSupportEmail" : "harish.kumar@admaxlocal.com", "resellerBaseUrl" : "https://qa4amltest.admaxlocal.com/reseller/", "resellerProductName" : "QA4 Test", "resellerSupportPhone" : "1-800-HELP", "timezone" : "America/New_York" }, "createdDate" : "2013-10-25T05:48:18.000+0000", "lastModifiedDate" : "2013-10-25T05:48:18.000+0000" } ], "total" : 1 } -------------------------------------- 2021-05-10 09:39:59,325-1642220 [http-nio-8080-exec-51] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 70 Address: http://127.0.0.1:8080/sapi/rest/ads/cta Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], connection=[Keep-Alive], Content-Type=[null], host=[127.0.0.1:8080], user-agent=[Apache-HttpClient/4.5.3 (Java/1.8.0_161)], x-tsa-authenticate=[XTOPGEJTLKRB2WZJK6MFTSV2VTQIBF5QDKBVSUKR3I3I64WDHQ66K6K24IBRLSP6LPUMRCUOTA6MX5LBZFF22TCY4LXV6EYLSHDVACX6SNCIHGEDMIDLME363BGN3SDZ2XUGPTI7RWKVYJEQCSHKDTBM2RFUXL4HCXZTUCHCHNMGOGS2Q7NINK3F6MG7NQOP5QCMPDAWNHPZX4UXRHLNJCV5A4Z2UTMR5WCM23ZCJKMV7DEPWAIGYU5TATTD3VKWACMHDB4JKEBKX3LIOOFFAZ2EGKGVTFWUTHVLOI2CAUZH3UPPUC62U3ZPWYU33B4VAJ4Q5UCG4WDNLZRBCTZGD6G5TNIHZTRHY2TAGZ5T3EPWTDCNM7C7TWOZIMTLTS2APCX42O4EKUHD6K25ZHAWM7NMHWG4SH3G3RC5VSHQD6IFNFIG3NPFNAHTF2NH3CAKFGTVPN6V6CD5WP2VQRXTNH5N3W3PSJ236QXFTTZ7JEFLZMU25GVBNGZWTV7T6LTES5EQ5T6HKVGB6WIG7HQICCA5NERZZGCJILRK62ZBGREYSJ3U6B4DBY4RVQINRRH7EJL2LTRG2FQKIRK4OKMK5PATMQ2Z7HKDCVRIMSKHHPEVIC3N5BLCMNSKBZ7XJUQMVRFMDPMAHKB5NQUADMZM2OZZTA2B3CF6UIUVAYZ4GQKZ3RS7AUH5ROYUS25FPIMUVL25LVH4QR77GZKI6BNNTQPVIW3VHCEUVQIGSIK7PWNSNL76VSA5JP22PBHMVCGFW24XSPOOM462YNDP42OEW2TZYRL2ZHF5NWGHW7S5CV2NYUKLQQENLNHPBOODJV7NZQQDMSCRO5YL66427UGFHSNMXVB7LROGUQVCQZ6N76VSR7R32WC5W6U2Q25NZLLYI4C34SYZWBLBEB54R2ANVEAQKDOS2OIVWCDDH7ZK4W2HZ7PHJ546KOEVAH7U2FPTQU3FNYRLHAHLMSNYC6SBTSUSTQJMZBLD47T7NO2RS2EIUB4KVN6HNI6SGNNRJCOHNTXWB4T4XMKTQTA75XVZFYRUMPDCXEEK3WDMKPWQNIL7TD3LYCUPU5F6MMFTCPAD2I2BAGXWGOJYCQ6KXV65ONB6GCC2N5HGOJDFSNXWMK6ELGP35XRT7TRGLPP4LVJ3GZSNT7N2EXUEK4YAKQJPQOJNGAVXZOVNS5NTJXH2JH5IFWSMZLWRPZ2Q762MLNJONBLS7PR7XZOACYBJZ5UOSSFXU5ETJGERW3XPQJQWGXVXLYZDNJL326BEV7J4VRU6TNAJKWMT2VHL7G5LYBSRTRXEIFYTNQK3ADWEUBQ6DXNGJYUULMDYDN7OKZXX5Y73LDES2MGTDDYF3CM6SCNWZLPLM7XODEM6Q3ZT7PNZDS5NOM4HORMVZHYMVW7Y627K5BVBRCN5YONGTSNLGYV5HORMKRCT2WIJHLB4V2SRVHZOQJAUQUCPLFXYLPNYZWSKZAZ4OYOCR3BNXORSUWCSNAOGYERPBS7QYSJXDYBZ23NCZX5KOMMD4DGT2R2FM2PPVMO5KENI3CMBMB3APR7C4BTFICH4YCPUJT6X2KK6ZX5OKQKGDELI3PAYFS2ARY5BEJOSAOL62SYN6LLT5IGWZ5OKC3ICAZSMRLN4FFDUEVEEVJO5Y2SQ====]} -------------------------------------- 2021-05-10 09:39:59,354-1642249 [http-nio-8080-exec-51] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 70 Response-Code: 200 Content-Type: application/json;charset=UTF-8;type=tsa-query-response;version=3.1.23-BETA46 Headers: {Content-Type=[application/json;charset=UTF-8;type=tsa-query-response;version=3.1.23-BETA46], Date=[Mon, 10 May 2021 09:39:59 GMT], X-AML-API-ID=[78661bca-c857-43c4-81fe-63321c2d2979], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]} Payload: { "total" : 7, "count" : 7, "pages" : 0, "current" : 0, "results" : [ { "objective" : "BRAND_AWARENESS", "types" : [ "SHOP_NOW", "BOOK_TRAVEL", "LEARN_MORE", "SIGN_UP", "DOWNLOAD", "WATCH_MORE", "APPLY_NOW", "MESSAGE_PAGE", "SUBSCRIBE", "GET_QUOTE", "CONTACT_US", "REQUEST_TIME", "GET_SHOWTIMES", "LISTEN_NOW", "WHATSAPP_MESSAGE" ], "defaultType" : "LEARN_MORE" }, { "objective" : "CONVERSIONS", "types" : [ "SHOP_NOW", "PLAY_GAME", "BOOK_TRAVEL", "LEARN_MORE", "SIGN_UP", "APPLY_NOW", "GET_OFFER", "SUBSCRIBE", "DONATE_NOW", "GET_QUOTE", "CONTACT_US" ], "defaultType" : "APPLY_NOW" }, { "objective" : "LEAD_GENERATION", "types" : [ "LEARN_MORE", "SIGN_UP", "DOWNLOAD", "APPLY_NOW", "GET_OFFER", "SUBSCRIBE", "GET_QUOTE" ], "defaultType" : "DOWNLOAD" }, { "objective" : "LINK_CLICKS", "types" : [ "OPEN_LINK", "SHOP_NOW", "PLAY_GAME", "USE_APP", "CALL", "BOOK_TRAVEL", "LEARN_MORE", "SIGN_UP", "DOWNLOAD", "WATCH_MORE", "APPLY_NOW", "GET_OFFER", "BUY_TICKETS", "SUBSCRIBE", "DONATE_NOW", "GET_QUOTE", "CONTACT_US", "REQUEST_TIME", "GET_SHOWTIMES", "LISTEN_NOW" ], "defaultType" : "APPLY_NOW" }, { "objective" : "PAGE_LIKES", "types" : [ "LIKE_PAGE" ], "defaultType" : "LIKE_PAGE" }, { "objective" : "POST_ENGAGEMENT", "types" : [ "SHOP_NOW", "LEARN_MORE", "MESSAGE_PAGE", "GET_QUOTE", "WHATSAPP_MESSAGE" ], "defaultType" : "LEARN_MORE" }, { "objective" : "REACH", "types" : [ "SHOP_NOW", "BOOK_TRAVEL", "LEARN_MORE", "SIGN_UP", "DOWNLOAD", "WATCH_MORE", "APPLY_NOW", "GET_DIRECTIONS", "SUBSCRIBE", "GET_QUOTE", "CONTACT_US", "REQUEST_TIME", "GET_SHOWTIMES", "LISTEN_NOW", "WHATSAPP_MESSAGE" ], "defaultType" : "CONTACT_US" } ] } -------------------------------------- 2021-05-10 09:39:59,614-1642509 [http-nio-8080-exec-44] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 71 Address: http://127.0.0.1:8080/sapi/rest/orders/search?q=SELECT++WHERE+%281%3D0%29+ORDER+BY+modificationDate+DESC Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], connection=[Keep-Alive], Content-Type=[null], host=[127.0.0.1:8080], user-agent=[Apache-HttpClient/4.5.3 (Java/1.8.0_161)], x-tsa-authenticate=[XTOPGEJTLKRB2WZJK6MFTSV2VTQIBF5QDKBVSUKR3I3I64WDHQ66K6K24IBRLSP6LPUMRCUOTA6MX5LBZFF22TCY4LXV6EYLSHDVACX6SNCIHGEDMIDLME363BGN3SDZ2XUGPTI7RWKVYJEQCSHKDTBM2RFUXL4HCXZTUCHCHNMGOGS2Q7NINK3F6MG7NQOP5QCMPDAWNHPZX4UXRHLNJCV5A4Z2UTMR5WCM23ZCJKMV7DEPWAIGYU5TATTD3VKWACMHDB4JKEBKX3LIOOFFAZ2EGKGVTFWUTHVLOI2CAUZH3UPPUC62U3ZPWYU33B4VAJ4Q5UCG4WDNLZRBCTZGD6G5TNIHZTRHY2TAGZ5T3EPWTDCNM7C7TWOZIMTLTS2APCX42O4EKUHD6K25ZHAWM7NMHWG4SH3G3RC5VSHQD6IFNFIG3NPFNAHTF2NH3CAKFGTVPN6V6CD5WP2VQRXTNH5N3W3PSJ236QXFTTZ7JEFLZMU25GVBNGZWTV7T6LTES5EQ5T6HKVGB6WIG7HQICCA5NERZZGCJILRK62ZBGREYSJ3U6B4DBY4RVQINRRH7EJL2LTRG2FQKIRK4OKMK5PATMQ2Z7HKDCVRIMSKHHPEVIC3N5BLCMNSKBZ7XJUQMVRFMDPMAHKB5NQUADMZM2OZZTA2B3CF6UIUVAYZ4GQKZ3RS7AUH5ROYUS25FPIMUVL25LVH4QR77GZKI6BNNTQPVIW3VHCEUVQIGSIK7PWNSNL76VSA5JP22PBHMVCGFW24XSPOOM462YNDP42OEW2TZYRL2ZHF5NWGHW7S5CV2NYUKLQQENLNHPBOODJV7NZQQDMSCRO5YL66427UGFHSNMXVB7LROGUQVCQZ6N76VSR7R32WC5W6U2Q25NZLLYI4C34SYZWBLBEB54R2ANVEAQKDOS2OIVWCDDH7ZK4W2HZ7PHJ546KOEVAH7U2FPTQU3FNYRLHAHLMSNYC6SBTSUSTQJMZBLD47T7NO2RS2EIUB4KVN6HNI6SGNNRJCOHNTXWB4T4XMKTQTA75XVZFYRUMPDCXEEK3WDMKPWQNIL7TD3LYCUPU5F6MMFTCPAD2I2BAGXWGOJYCQ6KXV65ONB6GCC2N5HGOJDFSNXWMK6ELGP35XRT7TRGLPP4LVJ3GZSNT7N2EXUEK4YAKQJPQOJNGAVXZOVNS5NTJXH2JH5IFWSMZLWRPZ2Q762MLNJONBLS7PR7XZOACYBJZ5UOSSFXU5ETJGERW3XPQJQWGXVXLYZDNJL326BEV7J4VRU6TNAJKWMT2VHL7G5LYBSRTRXEIFYTNQK3ADWEUBQ6DXNGJYUULMDYDN7OKZXX5Y73LDES2MGTDDYF3CM6SCNWZLPLM7XODEM6Q3ZT7PNZDS5NOM4HORMVZHYMVW7Y627K5BVBRCN5YONGTSNLGYV5HORMKRCT2WIJHLB4V2SRVHZOQJAUQUCPLFXYLPNYZWSKZAZ4OYOCR3BNXORSUWCSNAOGYERPBS7QYSJXDYBZ23NCZX5KOMMD4DGT2R2FM2PPVMO5KENI3CMBMB3APR7C4BTFICH4YCPUJT6X2KK6ZX5OKQKGDELI3PAYFS2ARY5BEJOSAOL62SYN6LLT5IGWZ5OKC3ICAZSMRLN4FFDUEVEEVJO5Y2SQ====]} -------------------------------------- 2021-05-10 09:39:59,642-1642537 [http-nio-8080-exec-44] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 71 Response-Code: 200 Content-Type: application/json;charset=UTF-8;type=tsa-query-response;version=3.1.23-BETA46 Headers: {Content-Type=[application/json;charset=UTF-8;type=tsa-query-response;version=3.1.23-BETA46], Date=[Mon, 10 May 2021 09:39:59 GMT], X-AML-API-ID=[0efece71-30ac-4ba8-9188-5d035296706e], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]} Payload: { "total" : 0, "count" : 0, "pages" : 0, "current" : 0 } -------------------------------------- 2021-05-10 09:39:59,841-1642736 [http-nio-8080-exec-45] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 72 Address: http://127.0.0.1:8080/sapi/rest/ads/cta Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], connection=[Keep-Alive], Content-Type=[null], host=[127.0.0.1:8080], user-agent=[Apache-HttpClient/4.5.3 (Java/1.8.0_161)], x-tsa-authenticate=[XTOPGEJTLKRB2WZJK6MFTSV2VTQIBF5QDKBVSUKR3I3I64WDHQ66K6K24IBRLSP6LPUMRCUOTA6MX5LBZFF22TCY4LXV6EYLSHDVACX6SNCIHGEDMIDLME363BGN3SDZ2XUGPTI7RWKVYJEQCSHKDTBM2RFUXL4HCXZTUCHCHNMGOGS2Q7NINK3F6MG7NQOP5QCMPDAWNHPZX4UXRHLNJCV5A4Z2UTMR5WCM23ZCJKMV7DEPWAIGYU5TATTD3VKWACMHDB4JKEBKX3LIOOFFAZ2EGKGVTFWUTHVLOI2CAUZH3UPPUC62U3ZPWYU33B4VAJ4Q5UCG4WDNLZRBCTZGD6G5TNIHZTRHY2TAGZ5T3EPWTDCNM7C7TWOZIMTLTS2APCX42O4EKUHD6K25ZHAWM7NMHWG4SH3G3RC5VSHQD6IFNFIG3NPFNAHTF2NH3CAKFGTVPN6V6CD5WP2VQRXTNH5N3W3PSJ236QXFTTZ7JEFLZMU25GVBNGZWTV7T6LTES5EQ5T6HKVGB6WIG7HQICCA5NERZZGCJILRK62ZBGREYSJ3U6B4DBY4RVQINRRH7EJL2LTRG2FQKIRK4OKMK5PATMQ2Z7HKDCVRIMSKHHPEVIC3N5BLCMNSKBZ7XJUQMVRFMDPMAHKB5NQUADMZM2OZZTA2B3CF6UIUVAYZ4GQKZ3RS7AUH5ROYUS25FPIMUVL25LVH4QR77GZKI6BNNTQPVIW3VHCEUVQIGSIK7PWNSNL76VSA5JP22PBHMVCGFW24XSPOOM462YNDP42OEW2TZYRL2ZHF5NWGHW7S5CV2NYUKLQQENLNHPBOODJV7NZQQDMSCRO5YL66427UGFHSNMXVB7LROGUQVCQZ6N76VSR7R32WC5W6U2Q25NZLLYI4C34SYZWBLBEB54R2ANVEAQKDOS2OIVWCDDH7ZK4W2HZ7PHJ546KOEVAH7U2FPTQU3FNYRLHAHLMSNYC6SBTSUSTQJMZBLD47T7NO2RS2EIUB4KVN6HNI6SGNNRJCOHNTXWB4T4XMKTQTA75XVZFYRUMPDCXEEK3WDMKPWQNIL7TD3LYCUPU5F6MMFTCPAD2I2BAGXWGOJYCQ6KXV65ONB6GCC2N5HGOJDFSNXWMK6ELGP35XRT7TRGLPP4LVJ3GZSNT7N2EXUEK4YAKQJPQOJNGAVXZOVNS5NTJXH2JH5IFWSMZLWRPZ2Q762MLNJONBLS7PR7XZOACYBJZ5UOSSFXU5ETJGERW3XPQJQWGXVXLYZDNJL326BEV7J4VRU6TNAJKWMT2VHL7G5LYBSRTRXEIFYTNQK3ADWEUBQ6DXNGJYUULMDYDN7OKZXX5Y73LDES2MGTDDYF3CM6SCNWZLPLM7XODEM6Q3ZT7PNZDS5NOM4HORMVZHYMVW7Y627K5BVBRCN5YONGTSNLGYV5HORMKRCT2WIJHLB4V2SRVHZOQJAUQUCPLFXYLPNYZWSKZAZ4OYOCR3BNXORSUWCSNAOGYERPBS7QYSJXDYBZ23NCZX5KOMMD4DGT2R2FM2PPVMO5KENI3CMBMB3APR7C4BTFICH4YCPUJT6X2KK6ZX5OKQKGDELI3PAYFS2ARY5BEJOSAOL62SYN6LLT5IGWZ5OKC3ICAZSMRLN4FFDUEVEEVJO5Y2SQ====]} -------------------------------------- 2021-05-10 09:39:59,869-1642764 [http-nio-8080-exec-45] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 72 Response-Code: 200 Content-Type: application/json;charset=UTF-8;type=tsa-query-response;version=3.1.23-BETA46 Headers: {Content-Type=[application/json;charset=UTF-8;type=tsa-query-response;version=3.1.23-BETA46], Date=[Mon, 10 May 2021 09:39:59 GMT], X-AML-API-ID=[076fc215-c4b1-4e47-b7cd-2683e3abfaf0], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]} Payload: { "total" : 7, "count" : 7, "pages" : 0, "current" : 0, "results" : [ { "objective" : "BRAND_AWARENESS", "types" : [ "SHOP_NOW", "BOOK_TRAVEL", "LEARN_MORE", "SIGN_UP", "DOWNLOAD", "WATCH_MORE", "APPLY_NOW", "MESSAGE_PAGE", "SUBSCRIBE", "GET_QUOTE", "CONTACT_US", "REQUEST_TIME", "GET_SHOWTIMES", "LISTEN_NOW", "WHATSAPP_MESSAGE" ], "defaultType" : "LEARN_MORE" }, { "objective" : "CONVERSIONS", "types" : [ "SHOP_NOW", "PLAY_GAME", "BOOK_TRAVEL", "LEARN_MORE", "SIGN_UP", "APPLY_NOW", "GET_OFFER", "SUBSCRIBE", "DONATE_NOW", "GET_QUOTE", "CONTACT_US" ], "defaultType" : "APPLY_NOW" }, { "objective" : "LEAD_GENERATION", "types" : [ "LEARN_MORE", "SIGN_UP", "DOWNLOAD", "APPLY_NOW", "GET_OFFER", "SUBSCRIBE", "GET_QUOTE" ], "defaultType" : "DOWNLOAD" }, { "objective" : "LINK_CLICKS", "types" : [ "OPEN_LINK", "SHOP_NOW", "PLAY_GAME", "USE_APP", "CALL", "BOOK_TRAVEL", "LEARN_MORE", "SIGN_UP", "DOWNLOAD", "WATCH_MORE", "APPLY_NOW", "GET_OFFER", "BUY_TICKETS", "SUBSCRIBE", "DONATE_NOW", "GET_QUOTE", "CONTACT_US", "REQUEST_TIME", "GET_SHOWTIMES", "LISTEN_NOW" ], "defaultType" : "APPLY_NOW" }, { "objective" : "PAGE_LIKES", "types" : [ "LIKE_PAGE" ], "defaultType" : "LIKE_PAGE" }, { "objective" : "POST_ENGAGEMENT", "types" : [ "SHOP_NOW", "LEARN_MORE", "MESSAGE_PAGE", "GET_QUOTE", "WHATSAPP_MESSAGE" ], "defaultType" : "LEARN_MORE" }, { "objective" : "REACH", "types" : [ "SHOP_NOW", "BOOK_TRAVEL", "LEARN_MORE", "SIGN_UP", "DOWNLOAD", "WATCH_MORE", "APPLY_NOW", "GET_DIRECTIONS", "SUBSCRIBE", "GET_QUOTE", "CONTACT_US", "REQUEST_TIME", "GET_SHOWTIMES", "LISTEN_NOW", "WHATSAPP_MESSAGE" ], "defaultType" : "CONTACT_US" } ] } -------------------------------------- 2021-05-10 09:39:59,902-1642797 [http-nio-8080-exec-47] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 73 Address: http://127.0.0.1:8080/sapi/rest/orders/search?q=SELECT++WHERE+%281%3D0%29+ORDER+BY+modificationDate+DESC Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], connection=[Keep-Alive], Content-Type=[null], host=[127.0.0.1:8080], user-agent=[Apache-HttpClient/4.5.3 (Java/1.8.0_161)], x-tsa-authenticate=[XTOPGEJTLKRB2WZJK6MFTSV2VTQIBF5QDKBVSUKR3I3I64WDHQ66K6K24IBRLSP6LPUMRCUOTA6MX5LBZFF22TCY4LXV6EYLSHDVACX6SNCIHGEDMIDLME363BGN3SDZ2XUGPTI7RWKVYJEQCSHKDTBM2RFUXL4HCXZTUCHCHNMGOGS2Q7NINK3F6MG7NQOP5QCMPDAWNHPZX4UXRHLNJCV5A4Z2UTMR5WCM23ZCJKMV7DEPWAIGYU5TATTD3VKWACMHDB4JKEBKX3LIOOFFAZ2EGKGVTFWUTHVLOI2CAUZH3UPPUC62U3ZPWYU33B4VAJ4Q5UCG4WDNLZRBCTZGD6G5TNIHZTRHY2TAGZ5T3EPWTDCNM7C7TWOZIMTLTS2APCX42O4EKUHD6K25ZHAWM7NMHWG4SH3G3RC5VSHQD6IFNFIG3NPFNAHTF2NH3CAKFGTVPN6V6CD5WP2VQRXTNH5N3W3PSJ236QXFTTZ7JEFLZMU25GVBNGZWTV7T6LTES5EQ5T6HKVGB6WIG7HQICCA5NERZZGCJILRK62ZBGREYSJ3U6B4DBY4RVQINRRH7EJL2LTRG2FQKIRK4OKMK5PATMQ2Z7HKDCVRIMSKHHPEVIC3N5BLCMNSKBZ7XJUQMVRFMDPMAHKB5NQUADMZM2OZZTA2B3CF6UIUVAYZ4GQKZ3RS7AUH5ROYUS25FPIMUVL25LVH4QR77GZKI6BNNTQPVIW3VHCEUVQIGSIK7PWNSNL76VSA5JP22PBHMVCGFW24XSPOOM462YNDP42OEW2TZYRL2ZHF5NWGHW7S5CV2NYUKLQQENLNHPBOODJV7NZQQDMSCRO5YL66427UGFHSNMXVB7LROGUQVCQZ6N76VSR7R32WC5W6U2Q25NZLLYI4C34SYZWBLBEB54R2ANVEAQKDOS2OIVWCDDH7ZK4W2HZ7PHJ546KOEVAH7U2FPTQU3FNYRLHAHLMSNYC6SBTSUSTQJMZBLD47T7NO2RS2EIUB4KVN6HNI6SGNNRJCOHNTXWB4T4XMKTQTA75XVZFYRUMPDCXEEK3WDMKPWQNIL7TD3LYCUPU5F6MMFTCPAD2I2BAGXWGOJYCQ6KXV65ONB6GCC2N5HGOJDFSNXWMK6ELGP35XRT7TRGLPP4LVJ3GZSNT7N2EXUEK4YAKQJPQOJNGAVXZOVNS5NTJXH2JH5IFWSMZLWRPZ2Q762MLNJONBLS7PR7XZOACYBJZ5UOSSFXU5ETJGERW3XPQJQWGXVXLYZDNJL326BEV7J4VRU6TNAJKWMT2VHL7G5LYBSRTRXEIFYTNQK3ADWEUBQ6DXNGJYUULMDYDN7OKZXX5Y73LDES2MGTDDYF3CM6SCNWZLPLM7XODEM6Q3ZT7PNZDS5NOM4HORMVZHYMVW7Y627K5BVBRCN5YONGTSNLGYV5HORMKRCT2WIJHLB4V2SRVHZOQJAUQUCPLFXYLPNYZWSKZAZ4OYOCR3BNXORSUWCSNAOGYERPBS7QYSJXDYBZ23NCZX5KOMMD4DGT2R2FM2PPVMO5KENI3CMBMB3APR7C4BTFICH4YCPUJT6X2KK6ZX5OKQKGDELI3PAYFS2ARY5BEJOSAOL62SYN6LLT5IGWZ5OKC3ICAZSMRLN4FFDUEVEEVJO5Y2SQ====]} -------------------------------------- 2021-05-10 09:39:59,931-1642826 [http-nio-8080-exec-47] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 73 Response-Code: 200 Content-Type: application/json;charset=UTF-8;type=tsa-query-response;version=3.1.23-BETA46 Headers: {Content-Type=[application/json;charset=UTF-8;type=tsa-query-response;version=3.1.23-BETA46], Date=[Mon, 10 May 2021 09:39:59 GMT], X-AML-API-ID=[987aefdf-50f3-4a96-a85c-70320ba8158a], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]} Payload: { "total" : 0, "count" : 0, "pages" : 0, "current" : 0 } -------------------------------------- 2021-05-10 09:40:00,001-1642896 [analytics-email-scheduler-1] INFO com.admaxlocal.analytics.AnalyticsReportIMAPDownloader [] - Downloading Reports 2021-05-10 09:40:00,129-1643024 [http-nio-8080-exec-54] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 74 Address: http://127.0.0.1:8080/sapi/rest/merchants?q=SELECT+WHERE++Active%3D%27T%27+ORDER+BY+DisplayName+ASC%2CCustomerId+ASC+LIMIT+0%2C25 Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], connection=[Keep-Alive], Content-Type=[null], host=[127.0.0.1:8080], user-agent=[Apache-HttpClient/4.5.3 (Java/1.8.0_161)], x-tsa-authenticate=[XTOPGEJTLKRB2WZJK6MFTSV2VTQIBF5QDKBVSUKR3I3I64WDHQ66K6K24IBRLSP6LPUMRCUOTA6MX5LBZFF22TCY4LXV6EYLSHDVACX6SNCIHGEDMIDLME363BGN3SDZ2XUGPTI7RWKVYJEQCSHKDTBM2RFUXL4HCXZTUCHCHNMGOGS2Q7NINK3F6MG7NQOP5QCMPDAWNHPZX4UXRHLNJCV5A4Z2UTMR5WCM23ZCJKMV7DEPWAIGYU5TATTD3VKWACMHDB4JKEBKX3LIOOFFAZ2EGKGVTFWUTHVLOI2CAUZH3UPPUC62U3ZPWYU33B4VAJ4Q5UCG4WDNLZRBCTZGD6G5TNIHZTRHY2TAGZ5T3EPWTDCNM7C7TWOZIMTLTS2APCX42O4EKUHD6K25ZHAWM7NMHWG4SH3G3RC5VSHQD6IFNFIG3NPFNAHTF2NH3CAKFGTVPN6V6CD5WP2VQRXTNH5N3W3PSJ236QXFTTZ7JEFLZMU25GVBNGZWTV7T6LTES5EQ5T6HKVGB6WIG7HQICCA5NERZZGCJILRK62ZBGREYSJ3U6B4DBY4RVQINRRH7EJL2LTRG2FQKIRK4OKMK5PATMQ2Z7HKDCVRIMSKHHPEVIC3N5BLCMNSKBZ7XJUQMVRFMDPMAHKB5NQUADMZM2OZZTA2B3CF6UIUVAYZ4GQKZ3RS7AUH5ROYUS25FPIMUVL25LVH4QR77GZKI6BNNTQPVIW3VHCEUVQIGSIK7PWNSNL76VSA5JP22PBHMVCGFW24XSPOOM462YNDP42OEW2TZYRL2ZHF5NWGHW7S5CV2NYUKLQQENLNHPBOODJV7NZQQDMSCRO5YL66427UGFHSNMXVB7LROGUQVCQZ6N76VSR7R32WC5W6U2Q25NZLLYI4C34SYZWBLBEB54R2ANVEAQKDOS2OIVWCDDH7ZK4W2HZ7PHJ546KOEVAH7U2FPTQU3FNYRLHAHLMSNYC6SBTSUSTQJMZBLD47T7NO2RS2EIUB4KVN6HNI6SGNNRJCOHNTXWB4T4XMKTQTA75XVZFYRUMPDCXEEK3WDMKPWQNIL7TD3LYCUPU5F6MMFTCPAD2I2BAGXWGOJYCQ6KXV65ONB6GCC2N5HGOJDFSNXWMK6ELGP35XRT7TRGLPP4LVJ3GZSNT7N2EXUEK4YAKQJPQOJNGAVXZOVNS5NTJXH2JH5IFWSMZLWRPZ2Q762MLNJONBLS7PR7XZOACYBJZ5UOSSFXU5ETJGERW3XPQJQWGXVXLYZDNJL326BEV7J4VRU6TNAJKWMT2VHL7G5LYBSRTRXEIFYTNQK3ADWEUBQ6DXNGJYUULMDYDN7OKZXX5Y73LDES2MGTDDYF3CM6SCNWZLPLM7XODEM6Q3ZT7PNZDS5NOM4HORMVZHYMVW7Y627K5BVBRCN5YONGTSNLGYV5HORMKRCT2WIJHLB4V2SRVHZOQJAUQUCPLFXYLPNYZWSKZAZ4OYOCR3BNXORSUWCSNAOGYERPBS7QYSJXDYBZ23NCZX5KOMMD4DGT2R2FM2PPVMO5KENI3CMBMB3APR7C4BTFICH4YCPUJT6X2KK6ZX5OKQKGDELI3PAYFS2ARY5BEJOSAOL62SYN6LLT5IGWZ5OKC3ICAZSMRLN4FFDUEVEEVJO5Y2SQ====]} -------------------------------------- 2021-05-10 09:40:00,492-1643387 [http-nio-8080-exec-54] ERROR com.thesearchagency.services.merchant.dao.MerchantDAO [hostname=127.0.0.1, requestId=0b1bccc9-9984-4715-a96f-67bab0bb6714, timezone=UTC, authToken=XTOPGEJTLKRB2WZJK6MFTSV2VTQIBF5QDKBVSUKR3I3I64WDHQ66K6K24IBRLSP6LPUMRCUOTA6MX5LBZFF22TCY4LXV6EYLSHDVACX6SNCIHGEDMIDLME363BGN3SDZ2XUGPTI7RWKVYJEQCSHKDTBM2RFUXL4HCXZTUCHCHNMGOGS2Q7NINK3F6MG7NQOP5QCMPDAWNHPZX4UXRHLNJCV5A4Z2UTMR5WCM23ZCJKMV7DEPWAIGYU5TATTD3VKWACMHDB4JKEBKX3LIOOFFAZ2EGKGVTFWUTHVLOI2CAUZH3UPPUC62U3ZPWYU33B4VAJ4Q5UCG4WDNLZRBCTZGD6G5TNIHZTRHY2TAGZ5T3EPWTDCNM7C7TWOZIMTLTS2APCX42O4EKUHD6K25ZHAWM7NMHWG4SH3G3RC5VSHQD6IFNFIG3NPFNAHTF2NH3CAKFGTVPN6V6CD5WP2VQRXTNH5N3W3PSJ236QXFTTZ7JEFLZMU25GVBNGZWTV7T6LTES5EQ5T6HKVGB6WIG7HQICCA5NERZZGCJILRK62ZBGREYSJ3U6B4DBY4RVQINRRH7EJL2LTRG2FQKIRK4OKMK5PATMQ2Z7HKDCVRIMSKHHPEVIC3N5BLCMNSKBZ7XJUQMVRFMDPMAHKB5NQUADMZM2OZZTA2B3CF6UIUVAYZ4GQKZ3RS7AUH5ROYUS25FPIMUVL25LVH4QR77GZKI6BNNTQPVIW3VHCEUVQIGSIK7PWNSNL76VSA5JP22PBHMVCGFW24XSPOOM462YNDP42OEW2TZYRL2ZHF5NWGHW7S5CV2NYUKLQQENLNHPBOODJV7NZQQDMSCRO5YL66427UGFHSNMXVB7LROGUQVCQZ6N76VSR7R32WC5W6U2Q25NZLLYI4C34SYZWBLBEB54R2ANVEAQKDOS2OIVWCDDH7ZK4W2HZ7PHJ546KOEVAH7U2FPTQU3FNYRLHAHLMSNYC6SBTSUSTQJMZBLD47T7NO2RS2EIUB4KVN6HNI6SGNNRJCOHNTXWB4T4XMKTQTA75XVZFYRUMPDCXEEK3WDMKPWQNIL7TD3LYCUPU5F6MMFTCPAD2I2BAGXWGOJYCQ6KXV65ONB6GCC2N5HGOJDFSNXWMK6ELGP35XRT7TRGLPP4LVJ3GZSNT7N2EXUEK4YAKQJPQOJNGAVXZOVNS5NTJXH2JH5IFWSMZLWRPZ2Q762MLNJONBLS7PR7XZOACYBJZ5UOSSFXU5ETJGERW3XPQJQWGXVXLYZDNJL326BEV7J4VRU6TNAJKWMT2VHL7G5LYBSRTRXEIFYTNQK3ADWEUBQ6DXNGJYUULMDYDN7OKZXX5Y73LDES2MGTDDYF3CM6SCNWZLPLM7XODEM6Q3ZT7PNZDS5NOM4HORMVZHYMVW7Y627K5BVBRCN5YONGTSNLGYV5HORMKRCT2WIJHLB4V2SRVHZOQJAUQUCPLFXYLPNYZWSKZAZ4OYOCR3BNXORSUWCSNAOGYERPBS7QYSJXDYBZ23NCZX5KOMMD4DGT2R2FM2PPVMO5KENI3CMBMB3APR7C4BTFICH4YCPUJT6X2KK6ZX5OKQKGDELI3PAYFS2ARY5BEJOSAOL62SYN6LLT5IGWZ5OKC3ICAZSMRLN4FFDUEVEEVJO5Y2SQ====, ipAddress=127.0.0.1, principalId=17e23b95-40f4-4511-958b-38147115c39c, 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, b.businessId as _fb_businesses_id, b.name as _fb_businesses_name, b.clientPageId as _fb_businesses_client_page_id, b.leadsTOSAccepted as _fb_businesses_leads_tos_accepted, b.leadsTOSEnabled as _fb_businesses_leads_tos_enabled, b.enabled as _fb_businesses_enabled, b.inviteStatus as _fb_businesses_invite_status, b.users as _fb_businesses_users, c.accountId as _fb_customers_id, c.name as _fb_customers_name, c.businessId as _fb_customers_business_id, c.assignedSystemUserId as _fb_customers_assigned_system_user_id, c.pixelId as _fb_customers_pixel_id, c.pixelCode as _fb_customers_pixel_code 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 LEFT JOIN `facebook`.`businesses` b on b.name = merchants.id LEFT JOIN `facebook`.`customers` c on c.name = merchants.id WHERE (merchants.`realm_id` LIKE concat(?,'%')) AND (merchants.active = 'T') ORDER BY merchants.display ASC, merchants.customer_id ASC LIMIT 25]; SQL state [S0022]; error code [0]; Column '_creator_email' not found.; nested exception is java.sql.SQLException: Column '_creator_email' 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.search(MerchantDAO.java:488) at com.thesearchagency.services.merchant.MerchantServiceComponent.getMerchants(MerchantServiceComponent.java:109) 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.$Proxy631.getMerchants(Unknown Source) at com.thesearchagency.sapi.services.merchant.MerchantService.doExecuteQuery(MerchantService.java:1467) at com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants(MerchantService.java:1199) 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.doGet(AbstractHTTPServlet.java:217) at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) 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.valves.rewrite.RewriteValve.invoke(RewriteValve.java:542) 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 '_creator_email' 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:234) at com.thesearchagency.services.merchant.dao.MerchantDAO$1.mapRow(MerchantDAO.java:217) 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) ... 65 common frames omitted 2021-05-10 09:40:00,494-1643389 [http-nio-8080-exec-54] ERROR com.thesearchagency.services.merchant.MerchantServiceComponent [hostname=127.0.0.1, requestId=0b1bccc9-9984-4715-a96f-67bab0bb6714, timezone=UTC, authToken=XTOPGEJTLKRB2WZJK6MFTSV2VTQIBF5QDKBVSUKR3I3I64WDHQ66K6K24IBRLSP6LPUMRCUOTA6MX5LBZFF22TCY4LXV6EYLSHDVACX6SNCIHGEDMIDLME363BGN3SDZ2XUGPTI7RWKVYJEQCSHKDTBM2RFUXL4HCXZTUCHCHNMGOGS2Q7NINK3F6MG7NQOP5QCMPDAWNHPZX4UXRHLNJCV5A4Z2UTMR5WCM23ZCJKMV7DEPWAIGYU5TATTD3VKWACMHDB4JKEBKX3LIOOFFAZ2EGKGVTFWUTHVLOI2CAUZH3UPPUC62U3ZPWYU33B4VAJ4Q5UCG4WDNLZRBCTZGD6G5TNIHZTRHY2TAGZ5T3EPWTDCNM7C7TWOZIMTLTS2APCX42O4EKUHD6K25ZHAWM7NMHWG4SH3G3RC5VSHQD6IFNFIG3NPFNAHTF2NH3CAKFGTVPN6V6CD5WP2VQRXTNH5N3W3PSJ236QXFTTZ7JEFLZMU25GVBNGZWTV7T6LTES5EQ5T6HKVGB6WIG7HQICCA5NERZZGCJILRK62ZBGREYSJ3U6B4DBY4RVQINRRH7EJL2LTRG2FQKIRK4OKMK5PATMQ2Z7HKDCVRIMSKHHPEVIC3N5BLCMNSKBZ7XJUQMVRFMDPMAHKB5NQUADMZM2OZZTA2B3CF6UIUVAYZ4GQKZ3RS7AUH5ROYUS25FPIMUVL25LVH4QR77GZKI6BNNTQPVIW3VHCEUVQIGSIK7PWNSNL76VSA5JP22PBHMVCGFW24XSPOOM462YNDP42OEW2TZYRL2ZHF5NWGHW7S5CV2NYUKLQQENLNHPBOODJV7NZQQDMSCRO5YL66427UGFHSNMXVB7LROGUQVCQZ6N76VSR7R32WC5W6U2Q25NZLLYI4C34SYZWBLBEB54R2ANVEAQKDOS2OIVWCDDH7ZK4W2HZ7PHJ546KOEVAH7U2FPTQU3FNYRLHAHLMSNYC6SBTSUSTQJMZBLD47T7NO2RS2EIUB4KVN6HNI6SGNNRJCOHNTXWB4T4XMKTQTA75XVZFYRUMPDCXEEK3WDMKPWQNIL7TD3LYCUPU5F6MMFTCPAD2I2BAGXWGOJYCQ6KXV65ONB6GCC2N5HGOJDFSNXWMK6ELGP35XRT7TRGLPP4LVJ3GZSNT7N2EXUEK4YAKQJPQOJNGAVXZOVNS5NTJXH2JH5IFWSMZLWRPZ2Q762MLNJONBLS7PR7XZOACYBJZ5UOSSFXU5ETJGERW3XPQJQWGXVXLYZDNJL326BEV7J4VRU6TNAJKWMT2VHL7G5LYBSRTRXEIFYTNQK3ADWEUBQ6DXNGJYUULMDYDN7OKZXX5Y73LDES2MGTDDYF3CM6SCNWZLPLM7XODEM6Q3ZT7PNZDS5NOM4HORMVZHYMVW7Y627K5BVBRCN5YONGTSNLGYV5HORMKRCT2WIJHLB4V2SRVHZOQJAUQUCPLFXYLPNYZWSKZAZ4OYOCR3BNXORSUWCSNAOGYERPBS7QYSJXDYBZ23NCZX5KOMMD4DGT2R2FM2PPVMO5KENI3CMBMB3APR7C4BTFICH4YCPUJT6X2KK6ZX5OKQKGDELI3PAYFS2ARY5BEJOSAOL62SYN6LLT5IGWZ5OKC3ICAZSMRLN4FFDUEVEEVJO5Y2SQ====, ipAddress=127.0.0.1, principalId=17e23b95-40f4-4511-958b-38147115c39c, locale=en_US] - StorageManagerException thrown while searching for merchants using 'SELECT WHERE Active='T' ORDER BY DisplayName ASC,CustomerId ASC LIMIT 0,25'. com.thesearchagency.database.storage.StorageManagerException: package com.thesearchagency.database.storage.INTERNAL_ERROR_EXCEPTION at com.thesearchagency.services.merchant.dao.MerchantDAO.search(MerchantDAO.java:492) at com.thesearchagency.services.merchant.MerchantServiceComponent.getMerchants(MerchantServiceComponent.java:109) 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.$Proxy631.getMerchants(Unknown Source) at com.thesearchagency.sapi.services.merchant.MerchantService.doExecuteQuery(MerchantService.java:1467) at com.thesearchagency.sapi.services.merchant.MerchantService.getMerchants(MerchantService.java:1199) 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.doGet(AbstractHTTPServlet.java:217) at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) 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.valves.rewrite.RewriteValve.invoke(RewriteValve.java:542) 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) 2021-05-10 09:40:00,504-1643399 [http-nio-8080-exec-54] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 74 Response-Code: 304 Content-Type: text/plain;charset=UTF-8;version=3.1.23-BETA46 Headers: {Content-Type=[text/plain;charset=UTF-8;version=3.1.23-BETA46], Date=[Mon, 10 May 2021 09:40:00 GMT], X-AML-API-ID=[0b1bccc9-9984-4715-a96f-67bab0bb6714], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]} Payload: Operation failed -------------------------------------- 2021-05-10 09:40:01,063-1643958 [analytics-email-scheduler-1] INFO com.admaxlocal.analytics.AnalyticsReportIMAPDownloader [] - Skipping message with subject : aml-stack-that-doesnt-exist This email should not get deleted. and timestamp : 1467832357000 from sender : dev-analytics-reports as it does not contain the stackname : ${analytics-email-stackname} 2021-05-10 09:40:01,235-1644130 [analytics-email-scheduler-1] INFO com.admaxlocal.analytics.AnalyticsReportIMAPDownloader [] - Skipping message with subject : Welcome to MyAnalytics and timestamp : 1579868018000 from sender : MyAnalytics as it does not contain the stackname : ${analytics-email-stackname} 2021-05-10 09:40:01,359-1644254 [analytics-email-scheduler-1] INFO com.admaxlocal.analytics.AnalyticsReportIMAPDownloader [] - Finished Downloading Reports