2013-02-06 21:43:18,705-254111 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 27 Address: http://reseller1.aq-qa-tomcat1:8080/sapi/rest/orders/26bcd0c5-2d61-4475-8b9e-feefd5cf1081 Http-Method: GET Content-Type: 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-Type=[null], host=[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=[X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======]} -------------------------------------- 2013-02-06 21:43:18,705-254111 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - handleMessage 2013-02-06 21:43:18,705-254111 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Received query string: null 2013-02-06 21:43:18,706-254112 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Using context from header: X-TSA-Authenticate 2013-02-06 21:43:18,706-254112 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext [] - Token:X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q====== 2013-02-06 21:43:18,709-254115 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Adding (token 2013-02-06T21:39:33.825Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) context to message 2013-02-06 21:43:18,710-254116 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext [timezone=UTC, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Token:X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q====== 2013-02-06 21:43:18,714-254120 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found security context for 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-06 21:43:18,714-254120 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found tokenized security context: (token 2013-02-06T21:39:33.825Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) 2013-02-06 21:43:18,714-254120 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, 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-06 21:43:18,715-254121 [http-8080-1] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Property set for settings/com.reseller1.properties is {} 2013-02-06 21:43:18,715-254121 [http-8080-1] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - handleMessage 2013-02-06 21:43:18,715-254121 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.order.OrderService.getOrder(com.thesearchagency.saas.core.services.IRequestContext,java.util.UUID) 2013-02-06 21:43:18,716-254122 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Executing getOrder 2013-02-06 21:43:18,716-254122 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking if the principal is active 2013-02-06 21:43:18,717-254123 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-06 21:43:18,721-254127 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-06 21:43:18,723-254129 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.order.OrderService.getOrder 2013-02-06 21:43:18,723-254129 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager 2013-02-06 21:43:18,725-254131 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-06 21:43:18,726-254132 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Attempting to get permissions for principal 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-06 21:43:18,744-254150 [http-8080-1] INFO com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - matching 'SAPI:execute:com.thesearchagency.sapi.services.order.OrderService.getOrder'.matches('.*:.*:.*') -> true 2013-02-06 21:43:18,745-254151 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.content.internal.ContentServiceComponent [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Attempting to locate content in com.reseller1 using the id '26bcd0c5-2d61-4475-8b9e-feefd5cf1081' 2013-02-06 21:43:18,746-254152 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.content.internal.dao.HibernateContentDao [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Attempting to find '26bcd0c5-2d61-4475-8b9e-feefd5cf1081' in 'com.reseller1'. 2013-02-06 21:43:18,748-254154 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-06 21:43:18,768-254174 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.content.internal.dao.HibernateContentDao [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found a content record for '26bcd0c5-2d61-4475-8b9e-feefd5cf1081' in 'com.reseller1'. 2013-02-06 21:43:18,771-254177 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.content.internal.ContentServiceComponent [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found content by ID 26bcd0c5-2d61-4475-8b9e-feefd5cf1081? true! 2013-02-06 21:43:18,773-254179 [http-8080-1] DEBUG com.thesearchagency.sapi.services.order.OrderService [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Order content: Content(theId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theParentId=null, theChildren=[Content(theId=976ef504-696e-4fa8-8182-38c0d5b36c14, theParentId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theChildren=[], theRevisionNumber=null, theType=merchantDisplay, theName=associatedMerchant, theValue=, theMetaData={name=11251, resellerAssignedId=11251, class=com.thesearchagency.sapi.services.order.MerchantDisplay, identifier=dcbca1ba-d30a-4356-860e-d0d6ecc1b734}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095), Content(theId=976ef504-696e-4fa8-8182-38c0d5b36c14, theParentId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theChildren=[], theRevisionNumber=null, theType=merchantDisplay, theName=associatedMerchant, theValue=, theMetaData={name=11251, resellerAssignedId=11251, class=com.thesearchagency.sapi.services.order.MerchantDisplay, identifier=dcbca1ba-d30a-4356-860e-d0d6ecc1b734}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095), Content(theId=976ef504-696e-4fa8-8182-38c0d5b36c14, theParentId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theChildren=[], theRevisionNumber=null, theType=merchantDisplay, theName=associatedMerchant, theValue=, theMetaData={name=11251, resellerAssignedId=11251, class=com.thesearchagency.sapi.services.order.MerchantDisplay, identifier=dcbca1ba-d30a-4356-860e-d0d6ecc1b734}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095), Content(theId=976ef504-696e-4fa8-8182-38c0d5b36c14, theParentId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theChildren=[], theRevisionNumber=null, theType=merchantDisplay, theName=associatedMerchant, theValue=, theMetaData={name=11251, resellerAssignedId=11251, class=com.thesearchagency.sapi.services.order.MerchantDisplay, identifier=dcbca1ba-d30a-4356-860e-d0d6ecc1b734}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095), Content(theId=a4313366-d8f7-4c3c-80ac-a537aaeed1a0, theParentId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theChildren=[Content(theId=d9c894ad-79ac-4c4f-b506-7fbe6273a18a, theParentId=a4313366-d8f7-4c3c-80ac-a537aaeed1a0, theChildren=[Content(theId=1746b011-8b53-459c-b8e3-7e5386349db4, theParentId=d9c894ad-79ac-4c4f-b506-7fbe6273a18a, theChildren=[], theRevisionNumber=null, theType=businessArea, theName=businessArea, theValue=, theMetaData={title=Roof Repair, class=com.thesearchagency.sapi.services.order.BusinessArea, businessAreaId=10961}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095), Content(theId=bae0c924-46b1-4a6c-b5d1-540b34cf13b2, theParentId=d9c894ad-79ac-4c4f-b506-7fbe6273a18a, theChildren=[], theRevisionNumber=null, theType=location, theName=location, theValue=, theMetaData={title=Florida, locationId=51, class=com.thesearchagency.sapi.services.order.Location}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095)], theRevisionNumber=null, theType=campaignTarget, theName=null, theValue=, theMetaData={status=VALID, class=com.thesearchagency.sapi.services.order.CampaignTarget}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095)], theRevisionNumber=null, theType=list, theName=campaignTargets, theValue=, theMetaData={class=java.util.List}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095), Content(theId=0efe9e80-d185-4c08-b67c-f7d8f87b2db5, theParentId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theChildren=[], theRevisionNumber=null, theType=displayName, theName=creator, theValue=, theMetaData={name=JJB, class=com.thesearchagency.sapi.services.order.DisplayName, identifier=d2a7171d-e4f2-428b-930f-cf82fff8c095}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095), Content(theId=0efe9e80-d185-4c08-b67c-f7d8f87b2db5, theParentId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theChildren=[], theRevisionNumber=null, theType=displayName, theName=creator, theValue=, theMetaData={name=JJB, class=com.thesearchagency.sapi.services.order.DisplayName, identifier=d2a7171d-e4f2-428b-930f-cf82fff8c095}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095), Content(theId=0efe9e80-d185-4c08-b67c-f7d8f87b2db5, theParentId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theChildren=[], theRevisionNumber=null, theType=displayName, theName=creator, theValue=, theMetaData={name=JJB, class=com.thesearchagency.sapi.services.order.DisplayName, identifier=d2a7171d-e4f2-428b-930f-cf82fff8c095}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095), Content(theId=1c5601a6-834f-4060-bf42-af3f898bce4c, theParentId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theChildren=[Content(theId=d31360cc-1d09-4ab7-86b6-f8a02b0e467d, theParentId=1c5601a6-834f-4060-bf42-af3f898bce4c, theChildren=[], theRevisionNumber=null, theType=serviceBudget, theName=null, theValue=, theMetaData={markupBudget=27, budget=27, markupMultiplier=0, service=GOOGLE, class=com.thesearchagency.sapi.services.order.ServiceBudget}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095)], theRevisionNumber=null, theType=list, theName=distributionBudgets, theValue=, theMetaData={class=java.util.List}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095), Content(theId=95bdc747-5921-490e-adfc-5e58c655f133, theParentId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theChildren=[], theRevisionNumber=null, theType=displayName, theName=modifier, theValue=, theMetaData={name=JJB, class=com.thesearchagency.sapi.services.order.DisplayName, identifier=d2a7171d-e4f2-428b-930f-cf82fff8c095}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095), Content(theId=95bdc747-5921-490e-adfc-5e58c655f133, theParentId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theChildren=[], theRevisionNumber=null, theType=displayName, theName=modifier, theValue=, theMetaData={name=JJB, class=com.thesearchagency.sapi.services.order.DisplayName, identifier=d2a7171d-e4f2-428b-930f-cf82fff8c095}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095), Content(theId=95bdc747-5921-490e-adfc-5e58c655f133, theParentId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theChildren=[], theRevisionNumber=null, theType=displayName, theName=modifier, theValue=, theMetaData={name=JJB, class=com.thesearchagency.sapi.services.order.DisplayName, identifier=d2a7171d-e4f2-428b-930f-cf82fff8c095}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:44:15.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095)], theRevisionNumber=null, theType=order, theName=null, theValue=, theMetaData={creationDate=1360176011000, modifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095, billingInfoCaptured=true, realm=com.reseller1, name=, state=DEPLOYED, creatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, class=com.thesearchagency.sapi.services.order.Order, semLandingPageURL=http://11251.com, modificationDate=1360176011000, comment=}, theRealm=com.reseller1, theCreationDate=2013-02-06T18:40:11.000Z, theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:44:15.000Z, theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095) 2013-02-06 21:43:18,778-254184 [http-8080-1] DEBUG com.thesearchagency.sapi.services.order.OrderService [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Unadapted order: Order(theId=26bcd0c5-2d61-4475-8b9e-feefd5cf1081, theRealm=com.reseller1, theName=, theLabel=null, theComment=, theAssociatedMerchant=MerchantDisplay(theIdentifier=dcbca1ba-d30a-4356-860e-d0d6ecc1b734, theName=11251, theCustomerId=null), theSemLandingPageURL=http://11251.com, theState=DEPLOYED, theBillingInfoCaptured=true, theCampaignTargets=[CampaignTarget(theStatus=VALID, theService=null, theBusinessArea=BusinessArea(theBusinessAreaId=10961, theTitle=Roof Repair), theLocation=Location(theLocationId=51, theTitle=Florida))], theDistributionBudgets=[com.thesearchagency.sapi.services.order.ServiceBudget@50b944e2], theServiceEstimates=[], theCreator=DisplayName(theIdentifier=d2a7171d-e4f2-428b-930f-cf82fff8c095, theName=JJB), theCreatorId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theCreationDate=2013-02-06T18:40:11.000Z, theModifier=DisplayName(theIdentifier=d2a7171d-e4f2-428b-930f-cf82fff8c095, theName=JJB), theModifierId=d2a7171d-e4f2-428b-930f-cf82fff8c095, theModificationDate=2013-02-06T18:40:11.000Z) 2013-02-06 21:43:18,779-254185 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-06 21:43:18,780-254186 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-06 21:43:18,782-254188 [http-8080-1] WARN com.thesearchagency.database.storage.jdbc.BaseJDBCStorageManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - No value found for property Birthday 2013-02-06 21:43:18,782-254188 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-06 21:43:18,783-254189 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-06 21:43:18,784-254190 [http-8080-1] WARN com.thesearchagency.database.storage.jdbc.BaseJDBCStorageManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - No value found for property Birthday 2013-02-06 21:43:18,785-254191 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_merchant_MerchantServiceComponent 2013-02-06 21:43:18,786-254192 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=497119f3-873e-4513-b76b-fbfb12fa6875, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-06 21:43:18,788-254194 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Headers: null 2013-02-06 21:43:18,788-254194 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Expires header 2013-02-06 21:43:18,789-254195 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Cache-Control header 2013-02-06 21:43:18,789-254195 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Pragma header 2013-02-06 21:43:18,791-254197 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 27 Response-Code: 200 Content-Type: application/json Headers: {Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[497119f3-873e-4513-b76b-fbfb12fa6875], Date=[Wed, 06 Feb 2013 21:43:18 GMT]} Payload: {"id":"26bcd0c5-2d61-4475-8b9e-feefd5cf1081","realm":"com.reseller1","name":"","comment":"","associatedMerchant":{"id":"dcbca1ba-d30a-4356-860e-d0d6ecc1b734","name":"11251","customerId":"11251"},"semLandingPageURL":"http://11251.com","state":"DEPLOYED","billingInfoCaptured":true,"campaignTargets":[{"status":"VALID","service":null,"businessArea":{"id":"10961","title":"Roof Repair"},"location":{"id":"51","title":"Florida"}}],"distributionBudgets":[{"service":"GOOGLE","budget":27,"markupBudget":27,"markupMultiplier":0}],"serviceEstimates":[],"creator":{"id":"d2a7171d-e4f2-428b-930f-cf82fff8c095","name":"JJB"},"creationDate":"2013-02-06T18:40:11.000Z","modifier":{"id":"d2a7171d-e4f2-428b-930f-cf82fff8c095","name":"JJB"}} -------------------------------------- 2013-02-06 21:43:18,897-254303 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message ---------------------------- ID: 28 Address: http://reseller1.aq-qa-tomcat1:8080/sapi/rest/campaign/estimates Encoding: ISO-8859-1 Http-Method: POST Content-Type: text/plain 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=[91], content-type=[text/plain], 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=[X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======]} Payload: campaigns (services in ('GOOGLE') and businessAreaId in ('10961') and locationId in ('51')) -------------------------------------- 2013-02-06 21:43:18,897-254303 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - handleMessage 2013-02-06 21:43:18,898-254304 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Received query string: null 2013-02-06 21:43:18,898-254304 [http-8080-1] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Using context from header: X-TSA-Authenticate 2013-02-06 21:43:18,898-254304 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext [] - Token:X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q====== 2013-02-06 21:43:18,901-254307 [http-8080-1] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor [] - Adding (token 2013-02-06T21:39:33.825Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) context to message 2013-02-06 21:43:18,902-254308 [http-8080-1] DEBUG com.thesearchagency.security.TokenizedSecurityContext [timezone=UTC, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Token:X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q====== 2013-02-06 21:43:18,906-254312 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found security context for 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-06 21:43:18,906-254312 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Found tokenized security context: (token 2013-02-06T21:39:33.825Z:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}) 2013-02-06 21:43:18,906-254312 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, 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-06 21:43:18,906-254312 [http-8080-1] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Property set for settings/com.reseller1.properties is {} 2013-02-06 21:43:18,908-254314 [http-8080-1] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - handleMessage 2013-02-06 21:43:18,908-254314 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.campaign.CampaignService.getCampaignEstimate(com.thesearchagency.saas.core.services.IRequestContext,java.lang.String) 2013-02-06 21:43:18,908-254314 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Executing getCampaignEstimate 2013-02-06 21:43:18,908-254314 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking if the principal is active 2013-02-06 21:43:18,908-254314 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_user_managers_UserManager 2013-02-06 21:43:18,910-254316 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-06 21:43:18,912-254318 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.campaign.CampaignService.getCampaignEstimate 2013-02-06 21:43:18,912-254318 [http-8080-1] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager 2013-02-06 21:43:18,913-254319 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-06 21:43:18,914-254320 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Attempting to get permissions for principal 273c4aab-e844-42d1-8c5a-2063ca535bba 2013-02-06 21:43:18,932-254338 [http-8080-1] INFO com.thesearchagency.saas.core.services.security.manager.TSASecurityManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - matching 'SAPI:execute:com.thesearchagency.sapi.services.campaign.CampaignService.getCampaignEstimate'.matches('.*:.*:.*') -> true 2013-02-06 21:43:18,933-254339 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.JAXRSContextProvider [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Getting data source for com_thesearchagency_saas_core_services_reseller_ResellerServiceComponent 2013-02-06 21:43:18,934-254340 [http-8080-1] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - query: SELECT * WHERE Realm = 'com.reseller1' 2013-02-06 21:43:18,934-254340 [http-8080-1] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - current 0 offset 0 2013-02-06 21:43:18,934-254340 [http-8080-1] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - ret.size() == 0 desired 1024 2013-02-06 21:43:18,934-254340 [http-8080-1] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - snarf data: ret.size() == 0 desired 1024 2013-02-06 21:43:18,935-254341 [http-8080-1] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - 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.reseller1') LIMIT 0 , 150 2013-02-06 21:43:18,936-254342 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-06 21:43:18,937-254343 [http-8080-1] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - snarf data: ret.size() == 1 desired 1024 2013-02-06 21:43:18,938-254344 [http-8080-1] DEBUG com.thesearchagency.database.storage.jdbc.SpringJDBCStorageManager [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - 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.reseller1') LIMIT 150 , 150 2013-02-06 21:43:18,939-254345 [http-8080-1] DEBUG log4jdbc.debug [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - driver name is MySQL-AB JDBC Driver 2013-02-06 21:43:18,941-254347 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.campaign.CampaignServiceComponent [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - New Campaign found 2013-02-06 21:43:18,941-254347 [http-8080-1] DEBUG com.thesearchagency.saas.core.services.campaign.CampaignServiceComponent [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - New campaign target: {businessAreaID: 10961 businessLocationID: 51} 2013-02-06 21:43:19,007-254413 [http-8080-1] WARN com.thesearchagency.saas.core.services.campaign.TSABudgetEstimateResultTranslator [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Unable to get the Minimum Price property (minPrice) from reseller properties! Defaulting to 0F: com.reseller1 java.lang.NullPointerException: null at com.thesearchagency.saas.core.services.campaign.TSABudgetEstimateResultTranslator.translate(TSABudgetEstimateResultTranslator.java:35) ~[saas-core-services-campaign-service-component-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT] at com.thesearchagency.saas.core.services.campaign.CampaignServiceComponent.getCampaignEstimate(CampaignServiceComponent.java:135) [saas-core-services-campaign-service-component-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT] at com.thesearchagency.sapi.services.campaign.CampaignService.getCampaignEstimate(CampaignService.java:119) [CampaignService.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] 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.doPost(AbstractHTTPServlet.java:141) [cxf-rt-transports-http-2.6.2.jar:2.6.2] at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) [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] 2013-02-06 21:43:19,010-254416 [http-8080-1] INFO com.thesearchagency.saas.core.services.campaign.CampaignServiceComponent [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Google Aggregate Estimate min price: 26.65 max price: 40320.78 min clicks: 3.0 max clicks: 4084.958 2013-02-06 21:43:19,010-254416 [http-8080-1] DEBUG com.thesearchagency.sapi.services.campaign.CampaignService [timezone=UTC, principalId=273c4aab-e844-42d1-8c5a-2063ca535bba, requestId=a909b66d-f2d9-406f-982f-573ab80365d4, locale=en_US, authToken=X2CU34D5NWDJURNEZTRYRPYI2HBGW5VYXJU6UVCODRSMOAZL45JRDJD2AX5OZXQ5P3TA5LDDT4IG3M27HICXSOK2HE27FL5WVTBFKPIHYDK5SOL7JCHIEZUV7UKGHJROA5PDOH5KCJU5YO7WDGAWU2R2IHN5YA4GAK5IBILP3OMDR5IH2T7SCH4VAFGT56HKPJUT3FHSW4HTNNQ6GCF542VZ7Q======, hostname=70.166.144.17, ipAddress=70.166.144.17] - Core returned: {Status=VALID, ComponentEstimates=[{Status=VALID, Service=GOOGLE, ComponentEstimates=[{LocationId=51, Status=VALID, Service=GOOGLE, MinimumClicks=3.0, BusinessAreaId=10961, MaximumClicks=4084.958, MinimumPrice=26.65, MaximumPrice=40320.78, Criteria=campaigns (businessAreaId in ('10961') and locationId in ('51') and services in ('GOOGLE'))}], MinimumClicks=3.0, MaximumClicks=4084.958, MinimumPrice=26.65, MaximumPrice=40320.78, Criteria=campaigns (businessAreaId in ('10961') and locationId in ('51') and services in ('GOOGLE'))}], MinimumClicks=3.0, MaximumClicks=4084.958, MinimumPrice=26.65, MaximumPrice=40320.78, Criteria=campaigns (services in ('GOOGLE') and businessAreaId in ('10961') and locationId in ('51'))} 2013-02-06 21:43:19,017-254423 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Headers: null 2013-02-06 21:43:19,017-254423 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Expires header 2013-02-06 21:43:19,017-254423 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Cache-Control header 2013-02-06 21:43:19,019-254425 [http-8080-1] DEBUG com.thesearchagency.sapi.jaxrs.CacheControlResponseHandler [] - Adding Pragma header 2013-02-06 21:43:19,021-254427 [http-8080-1] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message --------------------------- ID: 28 Response-Code: 200 Content-Type: application/json Headers: {Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache], X-AML-API-ID=[a909b66d-f2d9-406f-982f-573ab80365d4], Date=[Wed, 06 Feb 2013 21:43:19 GMT]} Payload: {"service":"","status":"VALID","criteria":"campaigns (services in ('GOOGLE') and businessAreaId in ('10961') and locationId in ('51'))","businessAreaId":-1,"locationId":-1,"minimumPrice":26.65,"maximumPrice":40320.78,"minimumClicks":3.0,"maximumClicks":4084.958,"components":[{"service":"GOOGLE","status":"VALID","criteria":"campaigns (businessAreaId in ('10961') and locationId in ('51') and services in ('GOOGLE'))","businessAreaId":-1,"locationId":-1,"minimumPrice":26.65,"maximumPrice":40320.78,"minimumClicks":3.0,"maximumClicks":4084.958,"components":[{"service":"GOOGLE","status":"VALID","criteria":"campaigns (businessAreaId in ('10961') and locationId in ('51') and services in ('GOOGLE'))","businessAreaId":10961,"locationId":51,"minimumPrice":26.65,"maximumPrice":40320.78,"minimumClicks":3.0,"maximumClicks":4084.958,"components":null}]}]} -------------------------------------- 2013-02-06 21:43:43,030-278436 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Searching using: {"from":0,"size":1024,"query":{"query_string":{"query":"state:\"SUBMITTED\""}}} 2013-02-06 21:43:43,035-278441 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Search returned 0 results 2013-02-06 21:43:43,036-278442 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - 0 matches have been identified 2013-02-06 21:43:43,036-278442 [order-update-timer-factory] INFO com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Beginning update for 0 orders. 2013-02-06 21:44:43,031-338437 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Searching using: {"from":0,"size":1024,"query":{"query_string":{"query":"state:\"SUBMITTED\""}}} 2013-02-06 21:44:43,036-338442 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Search returned 0 results 2013-02-06 21:44:43,036-338442 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - 0 matches have been identified 2013-02-06 21:44:43,037-338443 [order-update-timer-factory] INFO com.thesearchagency.sapi.services.order.OrderStatusUpdater [] - Beginning update for 0 orders.