2013-03-01 12:34:06,804-77474506 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Locking critical region to ensure serialization.
2013-03-01 12:34:06,807-77474509 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Locked critical region.
2013-03-01 12:34:06,807-77474509 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Determining number of orders requiring update.
2013-03-01 12:34:06,808-77474510 [order-update-scheduler-5] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Searching using: {"from":0,"size":1024,"query":{"query_string":{"query":"state:\"SUBMITTED\""}}}
2013-03-01 12:34:06,825-77474527 [order-update-scheduler-5] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Search returned 0 results
2013-03-01 12:34:06,826-77474528 [order-update-scheduler-5] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - 0 matches have been identified
2013-03-01 12:34:06,826-77474528 [order-update-scheduler-5] INFO  com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Beginning update for 0 orders.
2013-03-01 12:34:06,826-77474528 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Unlocking critical region.
2013-03-01 12:34:06,827-77474529 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Unlocked critical region.
2013-03-01 12:34:09,432-77477134 [order-update-scheduler-1] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Locking critical region to ensure serialization.
2013-03-01 12:34:09,433-77477135 [order-update-scheduler-1] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Locked critical region.
2013-03-01 12:34:09,434-77477136 [order-update-scheduler-1] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Determining number of orders requiring update.
2013-03-01 12:34:09,434-77477136 [order-update-scheduler-1] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Searching using: {"from":0,"size":1024,"query":{"query_string":{"query":"state:\"SUBMITTED\""}}}
2013-03-01 12:34:09,445-77477147 [order-update-scheduler-1] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Search returned 0 results
2013-03-01 12:34:09,446-77477148 [order-update-scheduler-1] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - 0 matches have been identified
2013-03-01 12:34:09,447-77477149 [order-update-scheduler-1] INFO  com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Beginning update for 0 orders.
2013-03-01 12:34:09,448-77477150 [order-update-scheduler-1] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Unlocking critical region.
2013-03-01 12:34:09,450-77477152 [order-update-scheduler-1] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Unlocked critical region.
2013-03-01 12:34:10,167-77477869 [http-8080-9] INFO  org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message
----------------------------
ID: 579
Address: http://aq-qa2-front1:8080/sapi/rest/security/tokens?username=admin%2Btsa%40thesearchagency.com&password=admin&realm=thesearchagency
Http-Method: GET
Content-Type:
Headers: {Accept=[text/plain], accept-encoding=[gzip,deflate], connection=[Keep-Alive], Content-Type=[null], host=[aq-qa2-front1:8080]}
--------------------------------------
2013-03-01 12:34:10,167-77477869 [http-8080-9] INFO  com.thesearchagency.sapi.security.TokenParsingInterceptor [] - handleMessage
2013-03-01 12:34:10,167-77477869 [http-8080-9] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Received query string: username=admin%2Btsa%40thesearchagency.com&password=admin&realm=thesearchagency
2013-03-01 12:34:10,168-77477870 [http-8080-9] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Extracted parameters: {username=[admin+tsa@thesearchagency.com], password=[admin], realm=[thesearchagency]}
2013-03-01 12:34:10,169-77477871 [http-8080-9] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - No context found, using guest context
2013-03-01 12:34:10,169-77477871 [http-8080-9] INFO  com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Adding (token 2013-02-28T15:03:08.171Z:[e042e3b8-b281-4851-a76d-acfabb994dec]:{}) context to message
2013-03-01 12:34:10,172-77477874 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Found security context for e042e3b8-b281-4851-a76d-acfabb994dec
2013-03-01 12:34:10,173-77477875 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Found tokenized security context: (token 2013-02-28T15:03:08.171Z:[e042e3b8-b281-4851-a76d-acfabb994dec]:{})
2013-03-01 12:34:10,173-77477875 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting request context for e042e3b8-b281-4851-a76d-acfabb994dec in realm null
2013-03-01 12:34:10,173-77477875 [http-8080-9] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Property set for settings/null.properties is {}
2013-03-01 12:34:10,175-77477877 [http-8080-9] INFO  com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - handleMessage
2013-03-01 12:34:10,176-77477878 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.security.SecurityService.getSecurityToken(com.thesearchagency.saas.core.services.IRequestContext,java.lang.String,java.lang.String,java.lang.String)
2013-03-01 12:34:10,177-77477879 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Executing getSecurityToken
2013-03-01 12:34:10,177-77477879 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Checking if the principal is active
2013-03-01 12:34:10,177-77477879 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:10,209-77477911 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.security.SecurityService.getSecurityToken
2013-03-01 12:34:10,210-77477912 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager
2013-03-01 12:34:10,218-77477920 [http-8080-9] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Attempting to get permissions for principal e042e3b8-b281-4851-a76d-acfabb994dec
2013-03-01 12:34:10,246-77477948 [http-8080-9] INFO  com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - matching 'SAPI:execute:com.thesearchagency.sapi.services.security.SecurityService.getSecurityToken'.matches('SAPI:execute:com.thesearchagency.sapi.services.security.SecurityService.getForgotPasswordToken') -> false
2013-03-01 12:34:10,247-77477949 [http-8080-9] INFO  com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - matching 'SAPI:execute:com.thesearchagency.sapi.services.security.SecurityService.getSecurityToken'.matches('SAPI:execute:com.thesearchagency.sapi.services.security.SecurityService.getSecurityToken') -> true
2013-03-01 12:34:10,247-77477949 [http-8080-9] DEBUG com.thesearchagency.sapi.services.security.SecurityService [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Looking up realm for name 'thesearchagency'
2013-03-01 12:34:10,247-77477949 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager
2013-03-01 12:34:10,248-77477950 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - query: SELECT *
WHERE Realm = 'thesearchagency'

2013-03-01 12:34:10,249-77477951 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - current 0 offset 0
2013-03-01 12:34:10,249-77477951 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - ret.size() == 0 desired 1024
2013-03-01 12:34:10,249-77477951 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - snarf data: ret.size() == 0 desired 1024
2013-03-01 12:34:10,249-77477951 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Fetch objects using query sql:
SELECT realms.realm,realms.id FROM realms WHERE (realms.realm = 'thesearchagency') LIMIT 0 , 150
2013-03-01 12:34:10,250-77477952 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - snarf data: ret.size() == 1 desired 1024
2013-03-01 12:34:10,251-77477953 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Fetch objects using query sql:
SELECT realms.realm,realms.id FROM realms WHERE (realms.realm = 'thesearchagency') LIMIT 150 , 150
2013-03-01 12:34:10,252-77477954 [http-8080-9] DEBUG com.thesearchagency.sapi.services.security.SecurityService [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Realm lookup evaluated to 'com.thesearchagency'
2013-03-01 12:34:10,252-77477954 [http-8080-9] DEBUG com.thesearchagency.sapi.services.security.SecurityService [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting token for 'admin+tsa@thesearchagency.com' with password 'admin' in realm 'thesearchagency'
2013-03-01 12:34:10,252-77477954 [http-8080-9] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Attempting authentication on the 'com.thesearchagency' realm for user 'admin+tsa@thesearchagency.com' using password 'admin'
2013-03-01 12:34:10,252-77477954 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager
2013-03-01 12:34:10,254-77477956 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - query: SELECT *
WHERE (Email = 'admin+tsa@thesearchagency.com') AND (Realm = 'com.thesearchagency')

2013-03-01 12:34:10,254-77477956 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - current 0 offset 0
2013-03-01 12:34:10,254-77477956 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - ret.size() == 0 desired 1024
2013-03-01 12:34:10,254-77477956 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - snarf data: ret.size() == 0 desired 1024
2013-03-01 12:34:10,255-77477957 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Fetch objects using query sql:
SELECT users.email,users.realm_id,users.id,users.salt,users.password FROM users WHERE ((users.email = 'admin+tsa@thesearchagency.com') AND (users.realm_id = 'com.thesearchagency')) LIMIT 0 , 150
2013-03-01 12:34:10,257-77477959 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - snarf data: ret.size() == 1 desired 1024
2013-03-01 12:34:10,257-77477959 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Fetch objects using query sql:
SELECT users.email,users.realm_id,users.id,users.salt,users.password FROM users WHERE ((users.email = 'admin+tsa@thesearchagency.com') AND (users.realm_id = 'com.thesearchagency')) LIMIT 150 , 150
2013-03-01 12:34:10,259-77477961 [http-8080-9] DEBUG com.thesearchagency.saas.core.services.security.SecurityServiceComponent [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Retrieving token timeout
2013-03-01 12:34:10,259-77477961 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:10,262-77477964 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:10,266-77477968 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:10,270-77477972 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:10,271-77477973 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Count objects using query sql:
SELECT COUNT(*) AS TSA_COUNT_RESULT  FROM roles WHERE (roles.name = 'unactivated-user')
2013-03-01 12:34:10,272-77477974 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - query: SELECT *
WHERE Name = 'unactivated-user'

2013-03-01 12:34:10,272-77477974 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - current 0 offset 0
2013-03-01 12:34:10,273-77477975 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - ret.size() == 0 desired 1024
2013-03-01 12:34:10,273-77477975 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - snarf data: ret.size() == 0 desired 1024
2013-03-01 12:34:10,273-77477975 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Fetch objects using query sql:
SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display FROM roles WHERE (roles.name = 'unactivated-user') LIMIT 0 , 150
2013-03-01 12:34:10,274-77477976 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - snarf data: ret.size() == 1 desired 1024
2013-03-01 12:34:10,275-77477977 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Fetch objects using query sql:
SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display FROM roles WHERE (roles.name = 'unactivated-user') LIMIT 150 , 150
2013-03-01 12:34:10,276-77477978 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:10,277-77477979 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Count objects using query sql:
SELECT COUNT(*) AS TSA_COUNT_RESULT  FROM users WHERE (users.email = 'admin+tsa@thesearchagency.com')
2013-03-01 12:34:10,279-77477981 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - query: SELECT *
WHERE Email = 'admin+tsa@thesearchagency.com'

2013-03-01 12:34:10,279-77477981 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - current 0 offset 0
2013-03-01 12:34:10,280-77477982 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - ret.size() == 0 desired 1024
2013-03-01 12:34:10,280-77477982 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - snarf data: ret.size() == 0 desired 1024
2013-03-01 12:34:10,280-77477982 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Fetch objects using query sql:
SELECT users.work_phone,users.type,users.modified_on,users.organization,users.password,users.modified_by,users.salt,users.last_name,users.home_phone,users.birthday,users.login,users.realm_id,users.timezone,users.first_name,users.country,users.mobile_phone,users.description,users.display,users.active,users.email,users.gender,users.homepage,users.created_by,users.created_on,users.id,users.language FROM users WHERE (users.email = 'admin+tsa@thesearchagency.com') LIMIT 0 , 150
2013-03-01 12:34:10,282-77477984 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - snarf data: ret.size() == 1 desired 1024
2013-03-01 12:34:10,282-77477984 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Fetch objects using query sql:
SELECT users.work_phone,users.type,users.modified_on,users.organization,users.password,users.modified_by,users.salt,users.last_name,users.home_phone,users.birthday,users.login,users.realm_id,users.timezone,users.first_name,users.country,users.mobile_phone,users.description,users.display,users.active,users.email,users.gender,users.homepage,users.created_by,users.created_on,users.id,users.language FROM users WHERE (users.email = 'admin+tsa@thesearchagency.com') LIMIT 150 , 150
2013-03-01 12:34:10,284-77477986 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:10,287-77477989 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - update statement: net.sf.log4jdbc.PreparedStatementSpy@1c8cdb0d
2013-03-01 12:34:10,292-77477994 [http-8080-9] DEBUG com.thesearchagency.security.TokenizedSecurityContext [timezone=UTC, principalId=, requestId=1801fa02-20ae-4382-9c67-24b8d2c9b520, locale=en_US, authToken=null, hostname=10.181.146.100, ipAddress=10.181.146.100] - Encoded Token:X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ=
2013-03-01 12:34:10,292-77477994 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Headers: null
2013-03-01 12:34:10,292-77477994 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Expires header
2013-03-01 12:34:10,292-77477994 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Cache-Control header
2013-03-01 12:34:10,293-77477995 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Pragma header
2013-03-01 12:34:10,294-77477996 [http-8080-9] INFO  org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message
---------------------------
ID: 579
Response-Code: 200
Content-Type: text/plain
Headers: {Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[1801fa02-20ae-4382-9c67-24b8d2c9b520], Date=[Fri, 01 Mar 2013 12:34:10 GMT]}
Payload: X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ=
--------------------------------------
2013-03-01 12:34:10,783-77478485 [http-8080-9] INFO  org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message
----------------------------
ID: 580
Address: http://aq-qa2-front1:8080/sapi/rest/users
Encoding: ISO-8859-1
Http-Method: POST
Content-Type: application/json
Headers: {Accept=[application/json, text/plain], accept-encoding=[gzip,deflate], connection=[Keep-Alive], Content-Length=[90], content-type=[application/json], host=[aq-qa2-front1:8080], x-tsa-authenticate=[X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ]}
Payload: {"displayName":"AtulTESTing","realm":"com.reseller6","email":"atulsanagar@rediffmail.com"}
--------------------------------------
2013-03-01 12:34:10,784-77478486 [http-8080-9] INFO  com.thesearchagency.sapi.security.TokenParsingInterceptor [] - handleMessage
2013-03-01 12:34:10,784-77478486 [http-8080-9] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Received query string: null
2013-03-01 12:34:10,785-77478487 [http-8080-9] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Using context from header: X-TSA-Authenticate
2013-03-01 12:34:10,785-77478487 [http-8080-9] DEBUG com.thesearchagency.security.TokenizedSecurityContext [] - Token:X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ
2013-03-01 12:34:10,793-77478495 [http-8080-9] INFO  com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Adding (token 2013-02-28T15:03:08.171Z:[e042e3b8-b281-4851-a76d-acfabb994dec, c7542d20-f6ba-4784-842b-9202a92190e2]:{realm=com.thesearchagency}) context to message
2013-03-01 12:34:10,795-77478497 [http-8080-9] DEBUG com.thesearchagency.security.TokenizedSecurityContext [timezone=UTC, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Token:X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ
2013-03-01 12:34:10,805-77478507 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Found security context for c7542d20-f6ba-4784-842b-9202a92190e2
2013-03-01 12:34:10,805-77478507 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Found tokenized security context: (token 2013-02-28T15:03:08.171Z:[e042e3b8-b281-4851-a76d-acfabb994dec, c7542d20-f6ba-4784-842b-9202a92190e2]:{realm=com.thesearchagency})
2013-03-01 12:34:10,805-77478507 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting request context for c7542d20-f6ba-4784-842b-9202a92190e2 in realm com.thesearchagency
2013-03-01 12:34:10,805-77478507 [http-8080-9] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Property set for settings/com.thesearchagency.properties is {maxClicks=3000, maxPrice=100.00, minClicks=3, minPrice=1.0}
2013-03-01 12:34:10,806-77478508 [http-8080-9] INFO  com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - handleMessage
2013-03-01 12:34:10,806-77478508 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.user.UserService.createUser(com.thesearchagency.saas.core.services.IRequestContext,com.thesearchagency.sapi.data.User)
2013-03-01 12:34:10,806-77478508 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Executing createUser
2013-03-01 12:34:10,806-77478508 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Checking if the principal is active
2013-03-01 12:34:10,806-77478508 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:10,811-77478513 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.user.UserService.createUser
2013-03-01 12:34:10,812-77478514 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager
2013-03-01 12:34:10,816-77478518 [http-8080-9] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Attempting to get permissions for principal c7542d20-f6ba-4784-842b-9202a92190e2
2013-03-01 12:34:10,842-77478544 [http-8080-9] INFO  com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - matching 'SAPI:execute:com.thesearchagency.sapi.services.user.UserService.createUser'.matches('.*:.*:.*') -> true
2013-03-01 12:34:10,843-77478545 [http-8080-9] DEBUG com.thesearchagency.sapi.services.user.UserService [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - context:c7542d20-f6ba-4784-842b-9202a92190e2
2013-03-01 12:34:10,843-77478545 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:10,846-77478548 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:10,880-77478582 [http-8080-9] DEBUG com.thesearchagency.sapi.services.SapiServiceSecurityHelper [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Adding cached permission entries for user c7542d20-f6ba-4784-842b-9202a92190e2
2013-03-01 12:34:10,926-77478628 [http-8080-9] DEBUG com.thesearchagency.sapi.services.SapiServiceSecurityHelper [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - user: {WorkPhone=+1-111-111-1111, Type=USER, Organization=tsa, LastModifiedDate=1970-01-01 01:01:01.0, Salt=496620796f75206265636f6d6520746f6f20736572696f75732c20796f752077696c6c206c6f736520796f7572207761792e, LastModifiedBy=tsa, HashedPassword=f2778bd3dfa06fd76b5189b83a09d18d22719a9cbfbc2eb7757dbdbf1cb67679ea027e054097dd81ddc609cdebb91ae32f3b645e733d873c71accaf7006cf880, LastName=lName, HomePhone=+1-111-111-1111, LastLoginDate=2013-03-01 12:34:10.0, Birthday=1970-01-01 01:01:01.0, Timezone=EST, Realm=com.thesearchagency, FirstName=fName, CountryCode=US, MobilePhone=+1-111-111-1111, Description=Principal representing the TSA administrator, DisplayName=TSA Administrator, Active=true, Email=admin+tsa@thesearchagency.com, Gender=MALE, HomePage=http://www.thesearchagency.com, CreatedBy=tsa, CreatedDate=1970-01-01 01:01:01.0, Language=en, Id=c7542d20-f6ba-4784-842b-9202a92190e2}
2013-03-01 12:34:10,927-77478629 [http-8080-9] DEBUG com.thesearchagency.sapi.services.SapiServiceSecurityHelper [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - subject: com.thesearchagency.sapi.data.User@702e9163
2013-03-01 12:34:10,927-77478629 [http-8080-9] DEBUG com.thesearchagency.sapi.services.SapiServiceSecurityHelper [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - 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=api-impersonate-any, Data=SAPI:impersonate:*, Active=true, Description=Ability to impersonate anyone, Type=REGEX, Realm=com.*, CreatedDate=1970-01-01 01:01:01.0, CreatedBy=admin, LastModifiedDate=1970-01-01 01:01:01.0, Id=790f0924-4468-11e2-8d9a-cf49ae052000, 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-03-01 12:34:10,934-77478636 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:10,998-77478700 [http-8080-9] WARN  com.thesearchagency.database.storage.jdbc.BaseJDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - No value found for property Birthday
2013-03-01 12:34:11,002-77478704 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:11,005-77478707 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Count objects using query sql:
SELECT COUNT(*) AS TSA_COUNT_RESULT  FROM roles WHERE (roles.name = 'unactivated-user')
2013-03-01 12:34:11,007-77478709 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - query: SELECT *
WHERE Name = 'unactivated-user'

2013-03-01 12:34:11,007-77478709 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - current 0 offset 0
2013-03-01 12:34:11,007-77478709 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - ret.size() == 0 desired 1024
2013-03-01 12:34:11,008-77478710 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - snarf data: ret.size() == 0 desired 1024
2013-03-01 12:34:11,008-77478710 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Fetch objects using query sql:
SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display FROM roles WHERE (roles.name = 'unactivated-user') LIMIT 0 , 150
2013-03-01 12:34:11,009-77478711 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - snarf data: ret.size() == 1 desired 1024
2013-03-01 12:34:11,010-77478712 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.JDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Fetch objects using query sql:
SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display FROM roles WHERE (roles.name = 'unactivated-user') LIMIT 150 , 150
2013-03-01 12:34:11,011-77478713 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=2117f155-8352-4573-bf19-230da93e4ec8, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:11,015-77478717 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Headers: null
2013-03-01 12:34:11,015-77478717 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Expires header
2013-03-01 12:34:11,015-77478717 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Cache-Control header
2013-03-01 12:34:11,015-77478717 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Pragma header
2013-03-01 12:34:11,018-77478720 [http-8080-9] INFO  org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message
---------------------------
ID: 580
Response-Code: 200
Content-Type: application/json
Headers: {Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[2117f155-8352-4573-bf19-230da93e4ec8], Date=[Fri, 01 Mar 2013 12:34:11 GMT]}
Payload: {"language":"en","properties":{"password":"FTZk1I0t"},"id":"7631bca6-0c32-4ab2-8da3-2d7fc5c56e6b","displayName":"AtulTESTing","description":"","realm":"com.reseller6","lastModifiedDate":"2013-03-01T12:34:10.000+0000","lastLoginDate":"1970-01-01T00:00:00.000+0000","active":false,"email":"atulsanagar@rediffmail.com","countryCode":"US","createdBy":"c7542d20-f6ba-4784-842b-9202a92190e2","createdDate":"2013-03-01T12:34:10.000+0000","lastModifiedBy":"c7542d20-f6ba-4784-842b-9202a92190e2","workPhone":"","timezone":"EST","organization":"","gender":"M","birthday":null,"homePhone":"","mobilePhone":"","firstName":"","lastName":"","workPhoneExtension":null}
--------------------------------------
2013-03-01 12:34:11,127-77478829 [http-8080-9] INFO  org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message
----------------------------
ID: 581
Address: http://aq-qa2-front1:8080/sapi/rest/resellers?q=SELECT+WHERE+Realm+%3D%3D+%27com.reseller6%27
Http-Method: GET
Content-Type:
Headers: {Accept=[application/json, application/javascript, text/javascript], accept-encoding=[gzip,deflate], connection=[Keep-Alive], Content-Type=[null], host=[aq-qa2-front1:8080], x-tsa-authenticate=[X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ]}
--------------------------------------
2013-03-01 12:34:11,128-77478830 [http-8080-9] INFO  com.thesearchagency.sapi.security.TokenParsingInterceptor [] - handleMessage
2013-03-01 12:34:11,128-77478830 [http-8080-9] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Received query string: q=SELECT+WHERE+Realm+%3D%3D+%27com.reseller6%27
2013-03-01 12:34:11,129-77478831 [http-8080-9] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Extracted parameters: {q=[SELECT WHERE Realm == 'com.reseller6']}
2013-03-01 12:34:11,129-77478831 [http-8080-9] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Using context from header: X-TSA-Authenticate
2013-03-01 12:34:11,129-77478831 [http-8080-9] DEBUG com.thesearchagency.security.TokenizedSecurityContext [] - Token:X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ
2013-03-01 12:34:11,139-77478841 [http-8080-9] INFO  com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Adding (token 2013-02-28T15:03:08.171Z:[e042e3b8-b281-4851-a76d-acfabb994dec, c7542d20-f6ba-4784-842b-9202a92190e2]:{realm=com.thesearchagency}) context to message
2013-03-01 12:34:11,143-77478845 [http-8080-9] DEBUG com.thesearchagency.security.TokenizedSecurityContext [timezone=UTC, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Token:X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ
2013-03-01 12:34:11,147-77478849 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Found security context for c7542d20-f6ba-4784-842b-9202a92190e2
2013-03-01 12:34:11,147-77478849 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Found tokenized security context: (token 2013-02-28T15:03:08.171Z:[e042e3b8-b281-4851-a76d-acfabb994dec, c7542d20-f6ba-4784-842b-9202a92190e2]:{realm=com.thesearchagency})
2013-03-01 12:34:11,147-77478849 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting request context for c7542d20-f6ba-4784-842b-9202a92190e2 in realm com.thesearchagency
2013-03-01 12:34:11,147-77478849 [http-8080-9] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Property set for settings/com.thesearchagency.properties is {maxClicks=3000, maxPrice=100.00, minClicks=3, minPrice=1.0}
2013-03-01 12:34:11,148-77478850 [http-8080-9] INFO  com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - handleMessage
2013-03-01 12:34:11,148-77478850 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.reseller.ResellerService.getResellers(com.thesearchagency.saas.core.services.IRequestContext,java.lang.String)
2013-03-01 12:34:11,148-77478850 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Executing getResellers
2013-03-01 12:34:11,148-77478850 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Checking if the principal is active
2013-03-01 12:34:11,148-77478850 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager
2013-03-01 12:34:11,152-77478854 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.reseller.ResellerService.getResellers
2013-03-01 12:34:11,153-77478855 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager
2013-03-01 12:34:11,155-77478857 [http-8080-9] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Attempting to get permissions for principal c7542d20-f6ba-4784-842b-9202a92190e2
2013-03-01 12:34:11,177-77478879 [http-8080-9] INFO  com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - matching 'SAPI:execute:com.thesearchagency.sapi.services.reseller.ResellerService.getResellers'.matches('.*:.*:.*') -> true
2013-03-01 12:34:11,178-77478880 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_reseller_ResellerServiceComponent
2013-03-01 12:34:11,178-77478880 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - query: SELECT *
WHERE Realm = 'com.reseller6'

2013-03-01 12:34:11,178-77478880 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - current 0 offset 0
2013-03-01 12:34:11,178-77478880 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - ret.size() == 0 desired 1024
2013-03-01 12:34:11,179-77478881 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - snarf data: ret.size() == 0 desired 1024
2013-03-01 12:34:11,179-77478881 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Query SQL: SELECT resellers.comments,resellers.description,resellers.contact_name,resellers.contact_email,resellers.contact_phone,resellers.modified_on,resellers.phone,resellers.user_id,resellers.modified_by,resellers.display,resellers.group_id,resellers.name,resellers.created_by_name,resellers.active,resellers.url,resellers.modified_by_name,resellers.realm_id,resellers.created_on,resellers.created_by,resellers.id FROM resellers WHERE (resellers.realm_id = 'com.reseller6') LIMIT 0 , 150
2013-03-01 12:34:11,182-77478884 [http-8080-9] DEBUG com.thesearchagency.saas.core.services.reseller.dao.ResellerDAO [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - AFTER_GET
2013-03-01 12:34:11,185-77478887 [http-8080-9] DEBUG com.thesearchagency.saas.core.services.reseller.dao.ResellerDAO [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - fetching properties for reseller {Comments=, Description=, ContactName=Reseller Contact Name 6, ContactEmail=ashwini.sanagar@gmail.com, ContactPhoneNumber=8766988567, LastModifiedDate=2013-03-01 12:24:10.0, PhoneNumber=3657846899, UserId=291d486c-8af5-4991-b628-cfd4ff4bcddc, LastModifiedBy=c7542d20-f6ba-4784-842b-9202a92190e2, DisplayName=Reseller Display Name 6, GroupId=ce095a49-2118-412f-a50d-92a9d9a807df, Name=reseller6, CreatedByName=TSA Administrator, Active=true, Url=http://www.reseller6.com, LastModifiedByName=TSA Administrator, CreatedBy=c7542d20-f6ba-4784-842b-9202a92190e2, CreatedDate=2013-03-01 12:24:10.0, Realm=com.reseller6, Id=d7fa39f0-ee78-44cd-ac72-d4ba84e1f10f} -> {countryCode=US, language=en, markup=.3, min-price=3.50, timezone=EST}
2013-03-01 12:34:11,185-77478887 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - snarf data: ret.size() == 1 desired 1024
2013-03-01 12:34:11,185-77478887 [http-8080-9] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Query SQL: SELECT resellers.comments,resellers.description,resellers.contact_name,resellers.contact_email,resellers.contact_phone,resellers.modified_on,resellers.phone,resellers.user_id,resellers.modified_by,resellers.display,resellers.group_id,resellers.name,resellers.created_by_name,resellers.active,resellers.url,resellers.modified_by_name,resellers.realm_id,resellers.created_on,resellers.created_by,resellers.id FROM resellers WHERE (resellers.realm_id = 'com.reseller6') LIMIT 150 , 150
2013-03-01 12:34:11,188-77478890 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - Getting data source for com_thesearchagency_saas_core_services_reseller_ResellerServiceComponent
2013-03-01 12:34:11,191-77478893 [http-8080-9] DEBUG com.thesearchagency.sapi.services.reseller.ResellerService [timezone=UTC, principalId=c7542d20-f6ba-4784-842b-9202a92190e2, requestId=d2d3a7eb-6580-4a4c-91b6-4a773bc055f3, locale=en_US, authToken=X2CU34D5NWDJU24EOOKWBLYWKZLNFTZ4HVFVZBH3PXJLPBAJRU7KTS5W7SYU4XBCUBPGITCWBGLOLUTWCX7P7WTER6YS2YMV633ZHLY4SJRRDTI7GXWUFAEHZGN6APB6R7JGETUNMFAEBHBETOVFMF6CCLGPULGPDTFBHX4GE4UKGDFZP7UHHMDDPKYEE2K7EMNS67MVCD6E5KHLWFU4HBX33K27A6DEVIUL6IQ, hostname=10.181.146.100, ipAddress=10.181.146.100] - getResellers(SELECT WHERE Realm == 'com.reseller6') -> com.thesearchagency.saas.core.services.QueryResponse@5ddfa912
2013-03-01 12:34:11,191-77478893 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Headers: null
2013-03-01 12:34:11,192-77478894 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Expires header
2013-03-01 12:34:11,192-77478894 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Cache-Control header
2013-03-01 12:34:11,192-77478894 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Pragma header
2013-03-01 12:34:11,193-77478895 [http-8080-9] INFO  org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message
---------------------------
ID: 581
Response-Code: 200
Content-Type: application/json
Headers: {Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[d2d3a7eb-6580-4a4c-91b6-4a773bc055f3], Date=[Fri, 01 Mar 2013 12:34:11 GMT]}
Payload: {"total":0,"results":[]}
--------------------------------------
2013-03-01 12:34:16,828-77484530 [order-update-scheduler-1] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Locking critical region to ensure serialization.
2013-03-01 12:34:16,829-77484531 [order-update-scheduler-1] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Locked critical region.
2013-03-01 12:34:16,830-77484532 [order-update-scheduler-1] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Determining number of orders requiring update.
2013-03-01 12:34:16,830-77484532 [order-update-scheduler-1] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Searching using: {"from":0,"size":1024,"query":{"query_string":{"query":"state:\"SUBMITTED\""}}}
2013-03-01 12:34:16,850-77484552 [order-update-scheduler-1] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Search returned 0 results
2013-03-01 12:34:16,850-77484552 [order-update-scheduler-1] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - 0 matches have been identified
2013-03-01 12:34:16,850-77484552 [order-update-scheduler-1] INFO  com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Beginning update for 0 orders.
2013-03-01 12:34:16,850-77484552 [order-update-scheduler-1] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Unlocking critical region.
2013-03-01 12:34:16,851-77484553 [order-update-scheduler-1] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Unlocked critical region.
2013-03-01 12:34:26,852-77494554 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Locking critical region to ensure serialization.
2013-03-01 12:34:26,854-77494556 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Locked critical region.
2013-03-01 12:34:26,855-77494557 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Determining number of orders requiring update.
2013-03-01 12:34:26,855-77494557 [order-update-scheduler-5] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Searching using: {"from":0,"size":1024,"query":{"query_string":{"query":"state:\"SUBMITTED\""}}}
2013-03-01 12:34:26,881-77494583 [order-update-scheduler-5] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Search returned 0 results
2013-03-01 12:34:26,881-77494583 [order-update-scheduler-5] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - 0 matches have been identified
2013-03-01 12:34:26,881-77494583 [order-update-scheduler-5] INFO  com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Beginning update for 0 orders.
2013-03-01 12:34:26,881-77494583 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Unlocking critical region.
2013-03-01 12:34:26,882-77494584 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Unlocked critical region.
2013-03-01 12:34:36,883-77504585 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Locking critical region to ensure serialization.
2013-03-01 12:34:36,884-77504586 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Locked critical region.
2013-03-01 12:34:36,885-77504587 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Determining number of orders requiring update.
2013-03-01 12:34:36,885-77504587 [order-update-scheduler-5] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Searching using: {"from":0,"size":1024,"query":{"query_string":{"query":"state:\"SUBMITTED\""}}}
2013-03-01 12:34:36,894-77504596 [order-update-scheduler-5] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Search returned 0 results
2013-03-01 12:34:36,894-77504596 [order-update-scheduler-5] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - 0 matches have been identified
2013-03-01 12:34:36,894-77504596 [order-update-scheduler-5] INFO  com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Beginning update for 0 orders.
2013-03-01 12:34:36,894-77504596 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Unlocking critical region.
2013-03-01 12:34:36,896-77504598 [order-update-scheduler-5] DEBUG com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Unlocked critical region.