----------------------------
ID: 2133
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd
--------------------------------------
07:16:17,089 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,089 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:16:17,090 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:16:17,090 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:16:17,090 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:16:17,091 INFO [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
07:16:17,091 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,091 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:16:17,095 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:16:17,095 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
07:16:17,095 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
07:16:17,095 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
07:16:17,095 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
07:16:17,095 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
07:16:17,095 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
07:16:17,095 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
07:16:17,095 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
07:16:17,095 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
07:16:17,099 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23895: Deleted -> Deleted
07:16:17,099 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23895 -> TERMINATED
07:16:17,100 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23896: Deleted -> Deleted
07:16:17,100 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23896 -> TERMINATED
07:16:17,102 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23897: Deleted -> Deleted
07:16:17,102 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23897 -> TERMINATED
07:16:17,104 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23901: Deleted -> Deleted
07:16:17,104 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23901 -> TERMINATED
07:16:17,105 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23919: Deleted -> Deleted
07:16:17,105 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23919 -> TERMINATED
07:16:17,107 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23920: Deleted -> Deleted
07:16:17,107 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23920 -> TERMINATED
07:16:17,108 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23921: Deleted -> Deleted
07:16:17,109 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23921 -> TERMINATED
07:16:17,110 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23925: Active -> Active
07:16:17,110 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23925 -> ACTIVE
07:16:17,112 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23926: Active -> Active
07:16:17,112 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23926 -> ACTIVE
07:16:17,113 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23927: Active -> Active
07:16:17,113 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23927 -> ACTIVE
07:16:17,114 INFO [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:16:17,114 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,114 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:16:17,118 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,118 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:16:17,119 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,119 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:16:17,120 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,120 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID = ? AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
07:16:17,125 INFO [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2133
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: 2790da9c-fe48-4f82-ac4f-bd1602a09ecdwww.merchantsite.comsuccess2389510002299612542http://www.merchantsite.com/www.merchantsite.comSuccessterminatedBingen_USfalse2389610002299612542http://www.merchantsite.com/www.merchantsite.comSuccessterminatedGoogleen_USfalse2389710002299612542http://www.merchantsite.com/www.merchantsite.comSuccessterminatedFacebooken_USfalse2390110002299612542http://www.merchantsite.com/www.merchantsite.comSuccessterminatedFacebooken_USfalse2391912535632444http://www.merchantsite.com/www.merchantsite.comSuccessterminatedBingen_USfalse2392012535632444http://www.merchantsite.com/www.merchantsite.comSuccessterminatedGoogleen_USfalse2392112535632444http://www.merchantsite.com/www.merchantsite.comSuccessterminatedFacebooken_USfalse2392510002299612542http://www.merchantsite.com/www.merchantsite.comSuccessactiveBingen_USfalse2392610002299612542http://www.merchantsite.com/www.merchantsite.comSuccessactiveGoogleen_USfalse2392710002299612542http://www.merchantsite.com/www.merchantsite.comSuccessactiveFacebooken_USfalse
--------------------------------------
07:16:17,173 INFO [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2134
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[282], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd
--------------------------------------
07:16:17,174 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,174 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?]
07:16:17,175 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:16:17,175 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String
07:16:17,175 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String
07:16:17,175 INFO [AdMaxDeploymentServiceImpl] getCampaignsByCustomerID properties = {smb-admax-deployment-service.port=8443, smb-admax-deployment-service.protocol=https, smb-admax-deployment-service.context.root=SMB-ADS, smb-admax-deployment-service.service.endpoint=AdMaxDeploymentService, smb-admax-deployment-service.feature.siteLinks=${smb-admax-deployment-service.feature.siteLinks}, smb-admax-deployment-service.hostname=localhost}
07:16:17,176 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,176 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:16:17,176 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:16:17,176 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
07:16:17,176 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
07:16:17,176 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
07:16:17,176 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
07:16:17,177 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
07:16:17,177 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
07:16:17,177 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
07:16:17,177 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
07:16:17,177 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
07:16:17,179 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23895: Deleted -> Deleted
07:16:17,179 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23895 -> TERMINATED
07:16:17,180 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23896: Deleted -> Deleted
07:16:17,180 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23896 -> TERMINATED
07:16:17,181 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23897: Deleted -> Deleted
07:16:17,181 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23897 -> TERMINATED
07:16:17,183 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23901: Deleted -> Deleted
07:16:17,183 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23901 -> TERMINATED
07:16:17,184 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23919: Deleted -> Deleted
07:16:17,184 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23919 -> TERMINATED
07:16:17,185 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23920: Deleted -> Deleted
07:16:17,185 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23920 -> TERMINATED
07:16:17,187 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23921: Deleted -> Deleted
07:16:17,187 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23921 -> TERMINATED
07:16:17,188 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23925: Active -> Active
07:16:17,188 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23925 -> ACTIVE
07:16:17,189 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23926: Active -> Active
07:16:17,189 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23926 -> ACTIVE
07:16:17,191 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 23927: Active -> Active
07:16:17,191 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 23927 -> ACTIVE
07:16:17,191 INFO [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0]
07:16:17,191 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,191 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?]
07:16:17,194 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,194 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?]
07:16:17,195 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,195 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:16:17,196 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,196 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT count(1) FROM clients.externalCampaign LEFT JOIN clients.externalCampaignParent ON externalCampaignParentID = clients.externalCampaignParent.id WHERE clients.externalCampaign.accountID = ? AND enabled = 1 AND status <> 'Deleted' AND typeID = ? ]
07:16:17,198 INFO [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2134
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: 2790da9c-fe48-4f82-ac4f-bd1602a09ecdwww.merchantsite.comsuccess2389510002299612542http://www.merchantsite.com/www.merchantsite.comSuccessterminatedBingen_USfalse2389610002299612542http://www.merchantsite.com/www.merchantsite.comSuccessterminatedGoogleen_USfalse2389710002299612542http://www.merchantsite.com/www.merchantsite.comSuccessterminatedFacebooken_USfalse2390110002299612542http://www.merchantsite.com/www.merchantsite.comSuccessterminatedFacebooken_USfalse2391912535632444http://www.merchantsite.com/www.merchantsite.comSuccessterminatedBingen_USfalse2392012535632444http://www.merchantsite.com/www.merchantsite.comSuccessterminatedGoogleen_USfalse2392112535632444http://www.merchantsite.com/www.merchantsite.comSuccessterminatedFacebooken_USfalse2392510002299612542http://www.merchantsite.com/www.merchantsite.comSuccessactiveBingen_USfalse2392610002299612542http://www.merchantsite.com/www.merchantsite.comSuccessactiveGoogleen_USfalse2392710002299612542http://www.merchantsite.com/www.merchantsite.comSuccessactiveFacebooken_USfalse
--------------------------------------
07:16:17,210 INFO [LoggingInInterceptor] Inbound Message
----------------------------
ID: 2135
Address: /SMB-ADS/AdMaxDeploymentService
Encoding: UTF-8
Content-Type: text/xml; charset=UTF-8
Headers: {SOAPAction=[""], Accept=[*/*], host=[aml-svc-deploy:8080], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], cache-control=[no-cache], Content-Length=[850], pragma=[no-cache], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8]}
Payload:
ab9185f7-ce46-492f-9274-146867e822b4
2790da9c-fe48-4f82-ac4f-bd1602a09ecd
23925
paused
23926
paused
23927
paused
--------------------------------------
07:16:17,210 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,210 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ]
07:16:17,212 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,212 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from sites where accountID = ? ]
07:16:17,213 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,213 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from waypoints where siteID = ? ]
07:16:17,226 WARN [QueueUtils] Setting message priority to 4
07:16:17,232 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,232 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:17,234 INFO [AdMaxDeploymentFauxSyncMessenger] Starting campaign status update blocking loop
07:16:17,234 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,234 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:17,235 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,235 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.blacklist where customerBpId = ?]
07:16:17,236 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,236 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from mms_common.campaigns where advertID = ?]
07:16:17,237 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:16:17,237 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
07:16:17,237 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
07:16:17,237 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
07:16:17,237 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
07:16:17,237 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
07:16:17,237 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
07:16:17,237 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
07:16:17,237 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
07:16:17,237 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
07:16:17,237 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,237 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from mms_common.campaigns where advertID = ?]
07:16:17,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:16:17,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
07:16:17,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
07:16:17,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
07:16:17,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
07:16:17,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
07:16:17,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
07:16:17,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
07:16:17,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
07:16:17,238 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
07:16:17,238 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,238 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from mms_common.campaigns where advertID = ?]
07:16:17,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:16:17,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
07:16:17,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
07:16:17,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
07:16:17,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
07:16:17,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
07:16:17,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
07:16:17,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
07:16:17,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
07:16:17,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
07:16:17,239 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,239 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?]
07:16:17,243 WARN [AdMaxDeploymentRequestMDB] UPDATE request with deployID ab9185f7-ce46-492f-9274-146867e822b4, account 2790da9c-fe48-4f82-ac4f-bd1602a09ecd has already been sent to the listener.
07:16:17,245 WARN [QueueUtils] Setting message priority to 9
07:16:17,248 INFO [AdMaxDeploymentRequestMDB] Sent UPDATE request to listener. BPID: 2790da9c-fe48-4f82-ac4f-bd1602a09ecd DeployID: ab9185f7-ce46-492f-9274-146867e822b4
07:16:17,270 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:17,270 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxAccountAnniversary where accountId = ? and endDate is NULL]
07:16:18,235 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:18,235 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:19,236 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:19,236 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:20,238 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:20,238 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:21,240 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:21,240 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:22,241 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:22,241 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:23,242 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:23,243 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:24,244 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:24,244 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:25,245 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:25,245 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:26,247 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:26,247 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:27,248 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:27,248 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:28,250 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:28,250 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:29,251 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:29,251 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:30,252 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:30,252 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:31,254 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:31,254 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:32,255 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:32,255 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:33,257 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:33,257 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:34,258 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:34,258 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:35,260 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:35,260 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:36,261 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:36,261 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:37,262 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:37,263 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:38,264 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:38,264 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:39,265 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:39,265 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:40,267 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:40,267 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:41,268 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:41,268 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:42,269 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:42,270 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:43,271 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:43,271 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:44,272 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:44,272 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:45,274 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:45,274 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:46,275 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:46,275 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:47,277 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:47,277 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:48,278 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:48,278 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:49,280 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:49,280 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:50,281 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:50,281 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:51,283 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:51,283 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:52,284 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:52,284 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:53,286 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:53,286 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:54,287 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:54,287 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:55,288 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:55,288 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:56,290 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:56,290 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:57,291 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:57,291 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:58,293 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:58,293 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:16:59,294 DEBUG [JdbcTemplate] Executing prepared SQL query
07:16:59,294 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:00,296 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:00,296 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:01,297 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:01,297 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:02,299 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:02,299 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:03,300 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:03,300 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:04,302 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:04,302 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:05,303 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:05,303 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:06,305 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:06,305 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:07,306 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:07,306 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:08,308 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:08,308 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:09,309 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:09,309 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:10,311 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:10,311 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:11,321 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:11,321 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:11,445 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:17:11,446 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:17:11,446 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:17:11,470 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT
07:17:12,332 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:12,332 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:13,348 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:13,348 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:14,355 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:14,356 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:15,378 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:15,378 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:16,385 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:16,385 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:17,386 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:17,387 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:17,498 INFO [AdMaxDeploymentResponseMDB] Response MDB triggered.
07:17:17,507 DEBUG [JdbcTemplate] Executing prepared SQL update
07:17:17,507 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.campUpdateResp(deploymentID, responseMsg) values (?, ?) on duplicate key update responseMsg = ?]
07:17:17,508 DEBUG [JdbcTemplate] SQL update affected 1 rows
07:17:17,508 WARN [AdMaxDeploymentFauxSyncMessenger] Put update ok for deploy ab9185f7-ce46-492f-9274-146867e822b4
07:17:17,509 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:17,509 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, keywordListID, locationID, customerDisplayURL, customerDestinationURL, localeName, distribution from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?]
07:17:17,512 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int
07:17:17,512 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int
07:17:17,512 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String
07:17:17,512 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int
07:17:17,512 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int
07:17:17,512 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int
07:17:17,512 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String
07:17:17,513 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String
07:17:17,513 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String
07:17:17,513 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'distribution' to property 'distribution' of type class com.thesearchagency.core.smb.domain.structure.Distribution
07:17:17,519 INFO [AdMaxDeploymentResponseMDB] Handling update campaign status.
07:17:18,388 DEBUG [JdbcTemplate] Executing prepared SQL query
07:17:18,388 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?]
07:17:19,393 INFO [AdMaxDeploymentFauxSyncMessenger] Exited blocking loop
07:17:19,395 DEBUG [JdbcTemplate] Executing prepared SQL update
07:17:19,395 DEBUG [JdbcTemplate] Executing prepared SQL statement [delete from mms_common.campUpdateResp where deploymentID = ?]
07:17:19,396 DEBUG [JdbcTemplate] SQL update affected 1 rows
07:17:19,398 INFO [LoggingInInterceptor] Outbound Message
---------------------------
ID: 2135
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: ab9185f7-ce46-492f-9274-146867e822b42790da9c-fe48-4f82-ac4f-bd1602a09ecd23925successInformation: [23925_GM:SUCCEEDED] [23925_GT:SUCCEEDED] 23926successInformation: [23926_GM:SUCCEEDED] [23926_GT:SUCCEEDED] 23927successInformation: [23927_S1:SUCCEEDED] [23927_S2:SUCCEEDED] [23927_S3:SUCCEEDED] [23927_S4:SUCCEEDED]
--------------------------------------
07:18:11,464 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT
07:18:11,464 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED
07:18:11,464 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent]
07:18:11,472 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT