2013-02-04 19:10:45,880-3684460 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 38 Address: http://reseller1.aq-qa-tomcat1:8080/sapi/rest/merchants/8a87b44f-b9e6-457a-b2f6-6d0a5647aaff Encoding: ISO-8859-1 Http-Method: PUT Content-Type: application/json Headers: {Accept=[application/json, text/plain], accept-charset=[ISO-8859-1,utf-8;q=0.7,*;q=0.3], accept-encoding=[gzip,deflate,sdch], accept-language=[en-US,en;q=0.8,ja;q=0.6], connection=[keep-alive], Content-Length=[244], content-type=[application/json], host=[reseller1.aq-qa-tomcat1:8080], origin=[http://reseller1.aq-qa-tomcat1:8080], referer=[http://reseller1.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17], x-tsa-authenticate=[X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======]} Payload: {"active":true,"comments":"comment","contactEmail":"131test@131test.com","contactName":"131test","contactPhoneNumber":"212335565465454","customerId":"131test","displayName":"131test","id":"8a87b44f-b9e6-457a-b2f6-6d0a5647aaff","name":"131test"} -------------------------------------- 2013-02-04 19:10:45,880-3684460 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - handleMessage 2013-02-04 19:10:45,880-3684460 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Received query string: null 2013-02-04 19:10:45,880-3684460 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Using context from header: X-TSA-Authenticate 2013-02-04 19:10:45,881-3684461 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext [] - Token:X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY====== 2013-02-04 19:10:45,883-3684463 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Adding (token 2013-02-04T18:09:50.375Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) context to message 2013-02-04 19:10:45,886-3684466 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext [timezone=UTC, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Token:X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY====== 2013-02-04 19:10:45,889-3684469 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found security context for 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-04 19:10:45,890-3684470 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found tokenized security context: (token 2013-02-04T18:09:50.375Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) 2013-02-04 19:10:45,890-3684470 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting request context for 273c4aab-e844-42d1-8c5a-2063ca535bba in realm com.reseller1 2013-02-04 19:10:45,890-3684470 [http-8080-1] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Property set for settings/com.reseller1.properties is {} 2013-02-04 19:10:45,892-3684472 [http-8080-1] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - handleMessage 2013-02-04 19:10:45,892-3684472 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.merchant.MerchantService.updateMerchant(com.thesearchagency.saas.core.services.IRequestContext,java.lang.String,com.thesearchagency.sapi.data.Merchant) 2013-02-04 19:10:45,893-3684473 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Executing updateMerchant 2013-02-04 19:10:45,893-3684473 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking if the principal is active 2013-02-04 19:10:45,893-3684473 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-04 19:10:45,896-3684476 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-04 19:10:45,898-3684478 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.merchant.MerchantService.updateMerchant 2013-02-04 19:10:45,898-3684478 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager 2013-02-04 19:10:45,899-3684479 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-04 19:10:45,900-3684480 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Attempting to get permissions for principal 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-04 19:10:45,916-3684496 [http-8080-1] INFO com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - matching 'SAPI:execute:com.thesearchagency.sapi.services.merchant.MerchantService.updateMerchant'.matches('.*:.*:.*') -> true 2013-02-04 19:10:45,917-3684497 [http-8080-1] DEBUG com.thesearchagency.sapi.services.merchant.MerchantService [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - updateMerchant(8a87b44f-b9e6-457a-b2f6-6d0a5647aaff,com.thesearchagency.sapi.data.Merchant@6e098752) 2013-02-04 19:10:45,917-3684497 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-04 19:10:45,918-3684498 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-04 19:10:45,920-3684500 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-04 19:10:45,921-3684501 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-04 19:10:45,944-3684524 [http-8080-1] DEBUG com.thesearchagency.sapi.services.SapiServiceSecurityHelper [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - user: {WorkPhone=+1-111-111-1111, Type=USER, Organization=tsa, LastModifiedDate=1970-01-01 01:01:01.0, Salt=496620796f75206265636f6d6520746f6f20736572696f75732c20796f752077696c6c206c6f736520796f7572207761792e, LastModifiedBy=tsa, HashedPassword=66dfa38993e9c88db6724d9b72f6ef115ee4630ce3ce7bd87371cdf95e936a67635037f00b7068846373f7d036b34ed7001a20c731d95dcd96f44ac3046f4940, LastName=lName, HomePhone=+1-111-111-1111, LastLoginDate=2013-02-04 19:09:44.0, Birthday=1970-01-01 01:01:01.0, Timezone=EST, Realm=com.reseller1, FirstName=fName, CountryCode=US, MobilePhone=+1-111-111-1111, Description=Principal representing the reseller1 admin user, DisplayName=Reseller1 admin user, Active=true, Email=reseller1@thesearchagency.com, Gender=MALE, HomePage=http://www.thesearchagency.com, CreatedBy=tsa, CreatedDate=1970-01-01 01:01:01.0, Language=en, Id=273c4aab-e844-42d1-8c5a-2063ca535bba} 2013-02-04 19:10:45,944-3684524 [http-8080-1] DEBUG com.thesearchagency.sapi.services.SapiServiceSecurityHelper [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - subject: com.thesearchagency.sapi.data.Merchant@6e098752 2013-02-04 19:10:45,944-3684524 [http-8080-1] DEBUG com.thesearchagency.sapi.services.SapiServiceSecurityHelper [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - permissions: [{Name=any, Data=*:*:*, Active=true, Description=Ability to do anything, Type=REGEX, Realm=com.*, CreatedDate=1970-01-01 01:01:01.0, CreatedBy=admin, LastModifiedDate=1970-01-01 01:01:01.0, Id=b59fa344-7ae0-47ec-a5a3-dd8e51caac9d, LastModifiedBy=admin}, {Name=matching-realms, Data=(subject.getRealm()==null||user.getRealm().equals("com.thesearchagency"))||(user.getRealm().equals(subject.getRealm())), Active=true, Description=Checks that the user and subject are in the same realm, Type=EXPRESSION, Realm=com.*, CreatedDate=1970-01-01 01:01:01.0, CreatedBy=admin, LastModifiedDate=1970-01-01 01:01:01.0, Id=04518081-0906-4c0e-8fb4-e279b50b4829, LastModifiedBy=admin}] 2013-02-04 19:10:45,952-3684532 [http-8080-1] DEBUG com.thesearchagency.sapi.services.merchant.MerchantService [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - doValidateData 2013-02-04 19:10:45,955-3684535 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_merchant_MerchantServiceComponent 2013-02-04 19:10:45,956-3684536 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-04 19:10:45,961-3684541 [http-8080-1] WARN org.apache.cxf.phase.PhaseInterceptorChain [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Application {http://security.services.sapi.thesearchagency.com/}SecurityService has thrown exception, unwinding now org.apache.cxf.interceptor.Fault: null at org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:162) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:128) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:167) ~[cxf-rt-frontend-jaxrs-2.6.2.jar:2.6.2] at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:94) ~[cxf-rt-frontend-jaxrs-2.6.2.jar:2.6.2] at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:94) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) [cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPut(AbstractHTTPServlet.java:158) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at javax.servlet.http.HttpServlet.service(HttpServlet.java:640) [tomcat6-servlet-2.5-api-6.0.24.jar:na] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) [catalina-6.0.24.jar:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.24.jar:na] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) [catalina-6.0.24.jar:na] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina-6.0.24.jar:na] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina-6.0.24.jar:na] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina-6.0.24.jar:na] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina-6.0.24.jar:na] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) [catalina-6.0.24.jar:na] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) [tomcat-coyote-6.0.24.jar:na] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) [tomcat-coyote-6.0.24.jar:na] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) [tomcat-coyote-6.0.24.jar:na] at java.lang.Thread.run(Thread.java:679) [na:1.6.0_24] Caused by: java.lang.NullPointerException: null at com.thesearchagency.sapi.services.merchant.MerchantService.updateMerchant(MerchantService.java:199) ~[MerchantService.class:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_24] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.6.0_24] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.6.0_24] at java.lang.reflect.Method.invoke(Method.java:616) ~[na:1.6.0_24] at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) ~[cxf-api-2.6.2.jar:2.6.2] ... 26 common frames omitted 2013-02-04 19:10:45,963-3684543 [http-8080-1] WARN org.apache.cxf.phase.PhaseInterceptorChain [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Exception in handleFault on interceptor org.apache.cxf.binding.xml.interceptor.XMLFaultOutInterceptor@3b38b6cf org.apache.cxf.interceptor.Fault: null at org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:162) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:128) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:167) ~[cxf-rt-frontend-jaxrs-2.6.2.jar:2.6.2] at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:94) ~[cxf-rt-frontend-jaxrs-2.6.2.jar:2.6.2] at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:94) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) [cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPut(AbstractHTTPServlet.java:158) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at javax.servlet.http.HttpServlet.service(HttpServlet.java:640) [tomcat6-servlet-2.5-api-6.0.24.jar:na] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) [catalina-6.0.24.jar:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.24.jar:na] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) [catalina-6.0.24.jar:na] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina-6.0.24.jar:na] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina-6.0.24.jar:na] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina-6.0.24.jar:na] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina-6.0.24.jar:na] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) [catalina-6.0.24.jar:na] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) [tomcat-coyote-6.0.24.jar:na] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) [tomcat-coyote-6.0.24.jar:na] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) [tomcat-coyote-6.0.24.jar:na] at java.lang.Thread.run(Thread.java:679) [na:1.6.0_24] Caused by: java.lang.NullPointerException: null at com.thesearchagency.sapi.services.merchant.MerchantService.updateMerchant(MerchantService.java:199) ~[MerchantService.class:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_24] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.6.0_24] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.6.0_24] at java.lang.reflect.Method.invoke(Method.java:616) ~[na:1.6.0_24] at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) ~[cxf-api-2.6.2.jar:2.6.2] ... 26 common frames omitted 2013-02-04 19:10:45,965-3684545 [http-8080-1] ERROR org.apache.cxf.interceptor.AbstractFaultChainInitiatorObserver [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=71c84857-980f-4b54-a341-74d43692d5c9, locale=en_US, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVQOXERWCINJ77TZCKGHIXVUZHJDAOIQBJVO42TN67N5EXEM445JLIPQSKAK5ZBLXWZZQUDVN4WUC6YGPWX2FD5RLDCXV7SQZPBFFJOEQCJ5UU4N56MBZY======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Error occurred during error handling, give up! org.apache.cxf.interceptor.Fault: null at org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:162) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:128) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:167) ~[cxf-rt-frontend-jaxrs-2.6.2.jar:2.6.2] at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:94) ~[cxf-rt-frontend-jaxrs-2.6.2.jar:2.6.2] at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:94) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) [cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:211) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:154) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:130) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:221) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPut(AbstractHTTPServlet.java:158) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at javax.servlet.http.HttpServlet.service(HttpServlet.java:640) [tomcat6-servlet-2.5-api-6.0.24.jar:na] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:197) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) [catalina-6.0.24.jar:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.24.jar:na] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) [catalina-6.0.24.jar:na] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina-6.0.24.jar:na] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina-6.0.24.jar:na] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina-6.0.24.jar:na] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina-6.0.24.jar:na] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) [catalina-6.0.24.jar:na] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) [tomcat-coyote-6.0.24.jar:na] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) [tomcat-coyote-6.0.24.jar:na] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) [tomcat-coyote-6.0.24.jar:na] at java.lang.Thread.run(Thread.java:679) [na:1.6.0_24] Caused by: java.lang.NullPointerException: null at com.thesearchagency.sapi.services.merchant.MerchantService.updateMerchant(MerchantService.java:199) ~[MerchantService.class:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_24] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.6.0_24] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.6.0_24] at java.lang.reflect.Method.invoke(Method.java:616) ~[na:1.6.0_24] at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180) ~[cxf-api-2.6.2.jar:2.6.2] at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) ~[cxf-api-2.6.2.jar:2.6.2] ... 26 common frames omitted 2013-02-04 19:10:46,256-3684836 [http-8080-5] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 39 Address: http://optus.aq-qa-tomcat1:8080/sapi/rest/orders?q=SELECT%20WHERE%20((associatedMerchant.id%20%3D%20%27null%27)%20AND%20(state%20!%3D%20%27QUOTE%27))%20ORDER%20BY%20modificationDate%20DESC%20LIMIT%201 Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], accept-encoding=[gzip, deflate], accept-language=[en-gb], connection=[keep-alive], Content-Type=[null], host=[optus.aq-qa-tomcat1:8080], referer=[http://optus.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64; rv:18.0) Gecko/20100101 Firefox/18.0], x-tsa-authenticate=[X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======]} -------------------------------------- 2013-02-04 19:10:46,258-3684838 [http-8080-5] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - handleMessage 2013-02-04 19:10:46,258-3684838 [http-8080-5] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Received query string: q=SELECT%20WHERE%20((associatedMerchant.id%20%3D%20%27null%27)%20AND%20(state%20!%3D%20%27QUOTE%27))%20ORDER%20BY%20modificationDate%20DESC%20LIMIT%201 2013-02-04 19:10:46,258-3684838 [http-8080-5] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Extracted parameters: {q=[SELECT WHERE ((associatedMerchant.id = 'null') AND (state != 'QUOTE')) ORDER BY modificationDate DESC LIMIT 1]} 2013-02-04 19:10:46,257-3684837 [http-8080-4] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 40 Address: http://optus.aq-qa-tomcat1:8080/sapi/rest/orders?q=SELECT%20%20WHERE%20(associatedMerchant.id%20%3D%20%27null%27)%20ORDER%20BY%20modificationDate%20DESC Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], accept-encoding=[gzip, deflate], accept-language=[en-gb], connection=[keep-alive], Content-Type=[null], host=[optus.aq-qa-tomcat1:8080], referer=[http://optus.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64; rv:18.0) Gecko/20100101 Firefox/18.0], x-tsa-authenticate=[X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======]} -------------------------------------- 2013-02-04 19:10:46,258-3684838 [http-8080-4] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - handleMessage 2013-02-04 19:10:46,258-3684838 [http-8080-4] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Received query string: q=SELECT%20%20WHERE%20(associatedMerchant.id%20%3D%20%27null%27)%20ORDER%20BY%20modificationDate%20DESC 2013-02-04 19:10:46,259-3684839 [http-8080-4] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Extracted parameters: {q=[SELECT WHERE (associatedMerchant.id = 'null') ORDER BY modificationDate DESC]} 2013-02-04 19:10:46,259-3684839 [http-8080-4] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Using context from header: X-TSA-Authenticate 2013-02-04 19:10:46,259-3684839 [http-8080-4] DEBUG com.thesearchagency.security.TokenizedSecurityContext [] - Token:X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4====== 2013-02-04 19:10:46,261-3684841 [http-8080-5] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Using context from header: X-TSA-Authenticate 2013-02-04 19:10:46,262-3684842 [http-8080-5] DEBUG com.thesearchagency.security.TokenizedSecurityContext [] - Token:X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4====== 2013-02-04 19:10:46,265-3684845 [http-8080-5] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Adding (token 2013-02-04T18:09:50.375Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66]:{realm=com.optus}) context to message 2013-02-04 19:10:46,266-3684846 [http-8080-4] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Adding (token 2013-02-04T18:09:50.375Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66]:{realm=com.optus}) context to message 2013-02-04 19:10:46,269-3684849 [http-8080-5] DEBUG com.thesearchagency.security.TokenizedSecurityContext [timezone=UTC, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Token:X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4====== 2013-02-04 19:10:46,277-3684857 [http-8080-4] DEBUG com.thesearchagency.security.TokenizedSecurityContext [timezone=UTC, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Token:X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4====== 2013-02-04 19:10:46,281-3684861 [http-8080-4] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found security context for 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66 2013-02-04 19:10:46,281-3684861 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found security context for 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66 2013-02-04 19:10:46,282-3684862 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found tokenized security context: (token 2013-02-04T18:09:50.375Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66]:{realm=com.optus}) 2013-02-04 19:10:46,282-3684862 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting request context for 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66 in realm com.optus 2013-02-04 19:10:46,282-3684862 [http-8080-5] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Property set for settings/com.optus.properties is {} 2013-02-04 19:10:46,281-3684861 [http-8080-4] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found tokenized security context: (token 2013-02-04T18:09:50.375Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66]:{realm=com.optus}) 2013-02-04 19:10:46,283-3684863 [http-8080-4] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting request context for 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66 in realm com.optus 2013-02-04 19:10:46,284-3684864 [http-8080-4] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Property set for settings/com.optus.properties is {} 2013-02-04 19:10:46,284-3684864 [http-8080-4] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - handleMessage 2013-02-04 19:10:46,285-3684865 [http-8080-4] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.order.OrderService.getOrders(com.thesearchagency.saas.core.services.IRequestContext,com.thesearchagency.query.dml.Select) 2013-02-04 19:10:46,285-3684865 [http-8080-4] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Executing getOrders 2013-02-04 19:10:46,285-3684865 [http-8080-4] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking if the principal is active 2013-02-04 19:10:46,285-3684865 [http-8080-4] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-04 19:10:46,285-3684865 [http-8080-5] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - handleMessage 2013-02-04 19:10:46,286-3684866 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.order.OrderService.getOrders(com.thesearchagency.saas.core.services.IRequestContext,com.thesearchagency.query.dml.Select) 2013-02-04 19:10:46,287-3684867 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Executing getOrders 2013-02-04 19:10:46,287-3684867 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking if the principal is active 2013-02-04 19:10:46,287-3684867 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-04 19:10:46,287-3684867 [http-8080-4] DEBUG log4jdbc.debug [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-04 19:10:46,289-3684869 [http-8080-4] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.order.OrderService.getOrders 2013-02-04 19:10:46,289-3684869 [http-8080-4] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager 2013-02-04 19:10:46,289-3684869 [http-8080-5] DEBUG log4jdbc.debug [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-04 19:10:46,291-3684871 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.order.OrderService.getOrders 2013-02-04 19:10:46,291-3684871 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager 2013-02-04 19:10:46,292-3684872 [http-8080-4] DEBUG log4jdbc.debug [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-04 19:10:46,292-3684872 [http-8080-5] DEBUG log4jdbc.debug [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-04 19:10:46,293-3684873 [http-8080-5] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Attempting to get permissions for principal 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66 2013-02-04 19:10:46,293-3684873 [http-8080-4] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Attempting to get permissions for principal 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66 2013-02-04 19:10:46,311-3684891 [http-8080-4] INFO com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - matching 'SAPI:execute:com.thesearchagency.sapi.services.order.OrderService.getOrders'.matches('.*:.*:.*') -> true 2013-02-04 19:10:46,312-3684892 [http-8080-5] INFO com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - matching 'SAPI:execute:com.thesearchagency.sapi.services.order.OrderService.getOrders'.matches('.*:.*:.*') -> true 2013-02-04 19:10:46,354-3684934 [http-8080-5] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Search returned 0 results 2013-02-04 19:10:46,355-3684935 [http-8080-5] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=9a4e6bb5-5ae6-4864-b4f5-abec2512427f, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - 0 matches have been identified 2013-02-04 19:10:46,355-3684935 [http-8080-4] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Search returned 0 results 2013-02-04 19:10:46,356-3684936 [http-8080-4] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=84f5fa00-ccc7-47bb-9877-659f553e0fc2, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - 0 matches have been identified 2013-02-04 19:10:46,356-3684936 [http-8080-4] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Headers: null 2013-02-04 19:10:46,356-3684936 [http-8080-4] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Expires header 2013-02-04 19:10:46,356-3684936 [http-8080-4] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Cache-Control header 2013-02-04 19:10:46,356-3684936 [http-8080-4] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Pragma header 2013-02-04 19:10:46,356-3684936 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Headers: null 2013-02-04 19:10:46,360-3684940 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Expires header 2013-02-04 19:10:46,360-3684940 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Cache-Control header 2013-02-04 19:10:46,360-3684940 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Pragma header 2013-02-04 19:10:46,361-3684941 [http-8080-5] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 39 Response-Code: 200 Content-Type: application/json Headers: {Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[9a4e6bb5-5ae6-4864-b4f5-abec2512427f], Date=[Mon, 04 Feb 2013 19:10:46 GMT]} Payload: {"total":0,"count":0,"pages":0,"current":1} -------------------------------------- 2013-02-04 19:10:46,363-3684943 [http-8080-4] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 40 Response-Code: 200 Content-Type: application/json Headers: {Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[84f5fa00-ccc7-47bb-9877-659f553e0fc2], Date=[Mon, 04 Feb 2013 19:10:46 GMT]} Payload: {"total":0,"count":0,"pages":0,"current":1} -------------------------------------- 2013-02-04 19:10:46,452-3685032 [http-8080-5] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 41 Address: http://optus.aq-qa-tomcat1:8080/sapi/rest/orders?q=SELECT%20%20WHERE%20(state%20%3D%20%27QUOTE%27%20AND%20associatedMerchant.id%20%3D%20%27null%27)%20ORDER%20BY%20modificationDate%20DESC Http-Method: GET Content-Type: Headers: {Accept=[application/json, text/plain], accept-encoding=[gzip, deflate], accept-language=[en-gb], connection=[keep-alive], Content-Type=[null], host=[optus.aq-qa-tomcat1:8080], referer=[http://optus.aq-qa-tomcat1:8080/reseller/], user-agent=[Mozilla/5.0 (Windows NT 6.1; WOW64; rv:18.0) Gecko/20100101 Firefox/18.0], x-tsa-authenticate=[X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======]} -------------------------------------- 2013-02-04 19:10:46,452-3685032 [http-8080-5] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - handleMessage 2013-02-04 19:10:46,452-3685032 [http-8080-5] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Received query string: q=SELECT%20%20WHERE%20(state%20%3D%20%27QUOTE%27%20AND%20associatedMerchant.id%20%3D%20%27null%27)%20ORDER%20BY%20modificationDate%20DESC 2013-02-04 19:10:46,456-3685036 [http-8080-5] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Extracted parameters: {q=[SELECT WHERE (state = 'QUOTE' AND associatedMerchant.id = 'null') ORDER BY modificationDate DESC]} 2013-02-04 19:10:46,456-3685036 [http-8080-5] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Using context from header: X-TSA-Authenticate 2013-02-04 19:10:46,456-3685036 [http-8080-5] DEBUG com.thesearchagency.security.TokenizedSecurityContext [] - Token:X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4====== 2013-02-04 19:10:46,460-3685040 [http-8080-5] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Adding (token 2013-02-04T18:09:50.375Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66]:{realm=com.optus}) context to message 2013-02-04 19:10:46,464-3685044 [http-8080-5] DEBUG com.thesearchagency.security.TokenizedSecurityContext [timezone=UTC, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Token:X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4====== 2013-02-04 19:10:46,469-3685049 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found security context for 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66 2013-02-04 19:10:46,471-3685051 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found tokenized security context: (token 2013-02-04T18:09:50.375Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66]:{realm=com.optus}) 2013-02-04 19:10:46,471-3685051 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting request context for 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66 in realm com.optus 2013-02-04 19:10:46,471-3685051 [http-8080-5] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Property set for settings/com.optus.properties is {} 2013-02-04 19:10:46,473-3685053 [http-8080-5] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - handleMessage 2013-02-04 19:10:46,474-3685054 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.order.OrderService.getOrders(com.thesearchagency.saas.core.services.IRequestContext,com.thesearchagency.query.dml.Select) 2013-02-04 19:10:46,474-3685054 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Executing getOrders 2013-02-04 19:10:46,475-3685055 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking if the principal is active 2013-02-04 19:10:46,475-3685055 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-04 19:10:46,479-3685059 [http-8080-5] DEBUG log4jdbc.debug [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-04 19:10:46,481-3685061 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.order.OrderService.getOrders 2013-02-04 19:10:46,482-3685062 [http-8080-5] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager 2013-02-04 19:10:46,483-3685063 [http-8080-5] DEBUG log4jdbc.debug [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-04 19:10:46,485-3685065 [http-8080-5] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Attempting to get permissions for principal 675c1ffb-1109-4e3d-8e59-2b06c6b2ec66 2013-02-04 19:10:46,505-3685085 [http-8080-5] INFO com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - matching 'SAPI:execute:com.thesearchagency.sapi.services.order.OrderService.getOrders'.matches('.*:.*:.*') -> true 2013-02-04 19:10:46,513-3685093 [http-8080-5] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Search returned 0 results 2013-02-04 19:10:46,513-3685093 [http-8080-5] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [timezone=UTC, principalId=675c1ffb-1109-4e3d-8e59-2b06c6b2ec66, requestId=e99caa2c-770c-4daa-81ac-e902872e7ada, locale=en_GB, authToken=X2CU34D5NWDJVBJT3JRIKCCELYO5DKRBTYZULF2F62HTLKIP2XD5KGMCA4ZBL7OJ6ZTNJESFT6RXHO2OKXXQ676TQLJ45GSMMK7FJVUR23CA772CK3WCC2PJ6AWBYYF5IRDRKUA3DJNHSWIJKYT3UIDN362K4CFGJJJG7JI4ATHRIMLYXDYPBEQVFIMAOFILTYWROWAJ3ZCYXWQD7NM6ET45T4======, hostname=70.166.144.17, ipAddress=70.166.144.17] - 0 matches have been identified 2013-02-04 19:10:46,514-3685094 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Headers: null 2013-02-04 19:10:46,514-3685094 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Expires header 2013-02-04 19:10:46,514-3685094 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Cache-Control header 2013-02-04 19:10:46,514-3685094 [http-8080-5] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Pragma header 2013-02-04 19:10:46,515-3685095 [http-8080-5] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 41 Response-Code: 200 Content-Type: application/json Headers: {Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[e99caa2c-770c-4daa-81ac-e902872e7ada], Date=[Mon, 04 Feb 2013 19:10:46 GMT]} Payload: {"total":0,"count":0,"pages":0,"current":1} --------------------------------------