=~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2013.10.21 12:48:44 =~=~=~=~=~=~=~=~=~=~=~= Payload: success100031USDencache2013-10-15T10:19:49.000Z10.244280538.73.073939.164 -------------------------------------- 07:25:29,335 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:25:29,336 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:25:29,336 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:25:29,352 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:26:29,352 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:26:29,352 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:26:29,353 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:26:29,427 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:27:29,405 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:27:29,405 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:27:29,406 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:27:29,455 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:27:39,293 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 1298 Address: /SMB-ADS/AdMaxDeploymentService Encoding: UTF-8 Content-Type: text/xml; charset=UTF-8 Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]} Payload: 0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d -------------------------------------- 07:27:39,295 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,295 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?] 07:27:39,319 WARN [CustomerDAO] Unable to find account: bpID 0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d 07:27:39,320 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=false, smb-admax-deployment-service.hostname=localhost} 07:27:39,320 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,320 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?] 07:27:39,324 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 1298 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload: 0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d -------------------------------------- 07:27:39,392 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 1299 Address: /SMB-ADS/AdMaxDeploymentService Encoding: UTF-8 Content-Type: text/xml; charset=UTF-8 Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[1198], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]} Payload:
5b19aebb-97a4-4f22-b678-b293f4d58bb8 1
0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d www.merchantsite.com 1.0 2013-10-21 USD America/New_York US 10003 1 http://www.merchantsite.com/ www.merchantsite.com en_US -------------------------------------- 07:27:39,394 INFO [AdMaxAccountDeploymentBD] deployCampaigns: customerID = 0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d, requestID = 5b19aebb-97a4-4f22-b678-b293f4d58bb8 07:27:39,421 INFO [ValidationUtils] TIMEZONE = America/New_York 07:27:39,421 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,421 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ] 07:27:39,435 DEBUG [AdMaxAccountDeploymentBD] New account [0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d] 07:27:39,436 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:39,436 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts (bpID, domain) values (?, ?) on duplicate key update domain = ?] 07:27:39,438 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:39,441 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,441 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, accountID, advertID, businessFunctionID, locationID, customerDisplayURL, customerDestinationURL from mms_common.campaigns where advertID = ?] 07:27:39,514 WARN [CustomerDAO] Unable to find campaign: advertID 0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d-voub715kce 07:27:39,514 DEBUG [JdbcTemplate] Executing SQL update and returning generated keys 07:27:39,515 DEBUG [JdbcTemplate] Executing prepared SQL statement 07:27:39,517 DEBUG [JdbcTemplate] SQL update affected 1 rows and returned 1 keys 07:27:39,517 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:39,518 DEBUG [JdbcTemplate] Executing prepared SQL statement [update mms_common.campaigns set advertID=? where id=?] 07:27:39,519 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:39,588 WARN [QueueUtils] Setting message priority to 4 07:27:39,649 INFO [AdMaxDeploymentServiceImpl] Saving deployment status to 'Pending' for campaignID: 7936 07:27:39,674 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 1299 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload:
5b19aebb-97a4-4f22-b678-b293f4d58bb81
queuedqueued -------------------------------------- 07:27:39,708 INFO [AdMaxDeploymentServiceImpl] Starting deploy campaign message conversion 07:27:39,741 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,741 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.blacklist where customerBpId = ?] 07:27:39,765 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:39,766 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts (bpID, domain) values (?, ?) on duplicate key update domain = ?] 07:27:39,767 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:39,768 INFO [AdMaxDeploymentServiceImpl] 1 Campaign(s) to process. 07:27:39,774 INFO [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0] 07:27:39,774 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,774 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?] 07:27:39,836 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:39,836 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentEntityMap(customerBpId,dateAssigned) values (?,now())] 07:27:39,837 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:39,838 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 07:27:39,840 DEBUG [AdMaxDeploymentServiceImpl] Processing CampaignInfo... 07:27:39,840 DEBUG [AdMaxDeploymentServiceImpl] Retrieving BusinessLocationId [1] 07:27:39,840 DEBUG [AdMaxDeploymentServiceImpl] Retrieving BusinessAreaID [10003] 07:27:39,847 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,848 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?] 07:27:39,850 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,850 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, target, description, type, code from mms_common.googleLocationTargets join mms_common.googleLocationTargetMap on googleLocationTargetID = id where businessLocationID = ?] 07:27:39,859 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,859 DEBUG [JdbcTemplate] Executing prepared SQL statement [select ba.id, ba.description, ba.status, bcam.businessCategoryID from businessAreas ba left join businessCategoryAreaMap bcam on bcam.businessAreaID=ba.id where ba.id=? order by bcam.businessCategoryID limit 1] 07:27:39,861 DEBUG [AdMaxDeploymentServiceImpl] Retrieved BusinessLocation Location: ID: 1 Description: United States Short Description: United States Status: active Type: Country ParentBusinessLocationID: 0 Use SE Defined Targets: true Use Point Radius Targets: false Is Sellable: true 07:27:39,861 DEBUG [AdMaxDeploymentServiceImpl] Retrieved BusinessArea BusinessArea: ID: 10003 Description: Motels Status: active BusinessCategoryID: 1 07:27:39,862 INFO [CustomerCampaignServiceBD] start readAll... 07:27:39,862 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,862 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customizableEntity WHERE entityId = ? AND type LIKE ?] 07:27:39,922 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,922 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customizableEntity WHERE entityId = ?] 07:27:39,924 INFO [DOMPersistanceManager] Parents Found : 0 07:27:39,924 INFO [CustomerCampaignServiceBD] end readAll... 07:27:39,924 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,925 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, languageCode, countryCode, variant, description from languages where languageCode = ? AND countryCode = ? AND variant = ?] 07:27:39,926 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:39,926 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageCode' to property 'languageCode' of type class java.lang.String 07:27:39,926 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'countryCode' to property 'countryCode' of type class java.lang.String 07:27:39,926 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'variant' to property 'variant' of type class java.lang.String 07:27:39,926 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'description' to property 'description' of type class java.lang.String 07:27:39,935 INFO [ContentRepositoryService] Inside getAdCopy : EntityId [2867] CompanyName [null] BusinessAreaID [10003] BusinessLocationID [0] Language [2] Regenerate Flag [false] isMobile [false] 07:27:39,937 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,937 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?] 07:27:39,939 INFO [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [2867] BusinessTypeID [0] BusinessAreaID [10003] BusinessLocationID [0] BusinessLocationType [0] Language [2] 07:27:39,939 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [2] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:39,940 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:39,940 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,001 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,001 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,001 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,001 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,001 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,001 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,002 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,002 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,002 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,002 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,002 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,005 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,005 DEBUG [JdbcTemplate] Executing prepared SQL statement [select contentElementVariations.id, contentElementTokens.token, contentElementVariations.segmentNum, contentElementVariations.variationNum, contentElementVariations.value from contentElementVariations join contentElementTokens on (contentElementTokens.id=contentElementVariations.contentElementTokenID) join contentAssignments on (contentAssignments.contentGroupID=? and contentAssignments.entityID=? and contentAssignments.instanceNum=?) join contentAssignmentElements on (contentAssignmentElements.contentAssignmentID = contentAssignments.id and contentAssignmentElements.contentElementVariationID = contentElementVariations.id) order by contentElementTokens.token, contentElementVariations.segmentNum] 07:27:40,009 INFO [ContentRepositoryServiceImpl] Regenerating content for ContentTypeID: 2 EntityID: 2867 BusinessTypeID: 0 BusinessFunctionID: 10003 LocationID: 0 LanguageID: 2 07:27:40,010 WARN [ContentSegmentDAO] Getting content by business area. 07:27:40,010 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [2] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:40,010 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,010 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,011 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,011 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,011 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,012 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,012 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,012 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,012 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,012 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,012 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,012 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,012 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,013 WARN [ContentSegmentDAO] Getting content by source group. 07:27:40,013 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,013 DEBUG [JdbcTemplate] Executing prepared SQL statement [select contentElementVariations.id,token,segmentNum,variationNum,value from contentElementVariations join contentElementTokens on (contentElementTokens.id=contentElementVariations.contentElementTokenID) where contentElementVariations.contentGroupID=? and contentElementVariations.status=? order by token,segmentNum,variationNum] 07:27:40,016 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [2] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:40,016 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,016 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,017 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,018 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,018 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,018 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,018 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,018 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,018 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,018 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,018 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,018 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,018 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,020 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,020 DEBUG [JdbcTemplate] Executing prepared SQL statement [select count(1) from contentAssignments where contentGroupID=? and hash=?] 07:27:40,022 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [2] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:40,022 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,022 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,024 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,024 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,024 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,024 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,024 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,024 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,024 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,024 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,024 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,025 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,025 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,026 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,026 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentAssignments where entityID=? and contentGroupID=? and instanceNum=? and status=?] 07:27:40,028 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,028 DEBUG [JdbcTemplate] Executing prepared SQL statement [select count(1) from contentAssignments where contentGroupID=? and hash=?] 07:27:40,030 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,030 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignments(entityID, contentGroupID, instanceNum, status, hash, dateAssigned, dateGenerated)values (?, ?, ?, ?, ?, now(), now())] 07:27:40,052 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,053 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 07:27:40,055 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,055 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignmentElements(contentAssignmentID, contentElementVariationID) values (?,?)] 07:27:40,111 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,112 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,112 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignmentElements(contentAssignmentID, contentElementVariationID) values (?,?)] 07:27:40,113 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,114 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,114 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignmentElements(contentAssignmentID, contentElementVariationID) values (?,?)] 07:27:40,115 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,116 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,116 DEBUG [JdbcTemplate] Executing prepared SQL statement [update contentGroups set usedUniqueCount = usedUniqueCount + 1 where id=?] 07:27:40,117 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,118 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,118 DEBUG [JdbcTemplate] Executing prepared SQL statement [select totalUniqueCount, usedUniqueCount, contentRequired from contentGroups where id=?] 07:27:40,121 WARN [ContentSegmentDAO] Running low on unique content: ContentGroup: 400 Percent Used: 2.3400674 07:27:40,123 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,123 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?] 07:27:40,125 INFO [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [2867] BusinessTypeID [0] BusinessAreaID [10003] BusinessLocationID [0] BusinessLocationType [0] Language [2] 07:27:40,126 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [2] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:40,126 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,126 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,127 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,128 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,128 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,128 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,128 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,128 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,128 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,128 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,128 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,128 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,129 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,129 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,130 DEBUG [JdbcTemplate] Executing prepared SQL statement [select contentElementVariations.id, contentElementTokens.token, contentElementVariations.segmentNum, contentElementVariations.variationNum, contentElementVariations.value from contentElementVariations join contentElementTokens on (contentElementTokens.id=contentElementVariations.contentElementTokenID) join contentAssignments on (contentAssignments.contentGroupID=? and contentAssignments.entityID=? and contentAssignments.instanceNum=?) join contentAssignmentElements on (contentAssignmentElements.contentAssignmentID = contentAssignments.id and contentAssignmentElements.contentElementVariationID = contentElementVariations.id) order by contentElementTokens.token, contentElementVariations.segmentNum] 07:27:40,132 INFO [ContentRepositoryServiceImpl] Regenerating content for ContentTypeID: 2 EntityID: 2867 BusinessTypeID: 0 BusinessFunctionID: 10003 LocationID: 0 LanguageID: 2 07:27:40,133 WARN [ContentSegmentDAO] Getting content by business area. 07:27:40,133 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [2] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:40,133 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,133 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,134 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,135 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,135 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,135 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,135 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,135 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,135 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,135 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,135 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,135 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,135 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,136 WARN [ContentSegmentDAO] Getting content by source group. 07:27:40,137 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,137 DEBUG [JdbcTemplate] Executing prepared SQL statement [select contentElementVariations.id,token,segmentNum,variationNum,value from contentElementVariations join contentElementTokens on (contentElementTokens.id=contentElementVariations.contentElementTokenID) where contentElementVariations.contentGroupID=? and contentElementVariations.status=? order by token,segmentNum,variationNum] 07:27:40,139 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [2] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:40,139 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,139 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,141 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,141 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,141 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,141 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,141 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,141 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,141 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,142 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,142 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,142 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,142 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,143 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,143 DEBUG [JdbcTemplate] Executing prepared SQL statement [select count(1) from contentAssignments where contentGroupID=? and hash=?] 07:27:40,145 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [2] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:40,146 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,146 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,147 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,147 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,147 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,147 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,148 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,148 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,148 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,148 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,148 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,148 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,148 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,149 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,149 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentAssignments where entityID=? and contentGroupID=? and instanceNum=? and status=?] 07:27:40,151 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,151 DEBUG [JdbcTemplate] Executing prepared SQL statement [select count(1) from contentAssignments where contentGroupID=? and hash=?] 07:27:40,153 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,154 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignments(entityID, contentGroupID, instanceNum, status, hash, dateAssigned, dateGenerated)values (?, ?, ?, ?, ?, now(), now())] 07:27:40,154 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,155 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 07:27:40,157 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,157 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignmentElements(contentAssignmentID, contentElementVariationID) values (?,?)] 07:27:40,158 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,159 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,159 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignmentElements(contentAssignmentID, contentElementVariationID) values (?,?)] 07:27:40,160 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,163 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,163 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignmentElements(contentAssignmentID, contentElementVariationID) values (?,?)] 07:27:40,164 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,165 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,165 DEBUG [JdbcTemplate] Executing prepared SQL statement [update contentGroups set usedUniqueCount = usedUniqueCount + 1 where id=?] 07:27:40,166 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,167 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,167 DEBUG [JdbcTemplate] Executing prepared SQL statement [select totalUniqueCount, usedUniqueCount, contentRequired from contentGroups where id=?] 07:27:40,169 WARN [ContentSegmentDAO] Running low on unique content: ContentGroup: 400 Percent Used: 2.3569024 07:27:40,170 INFO [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [2867] BusinessTypeID [0] BusinessAreaID [10003] BusinessLocationID [0] BusinessLocationType [0] Language [2] 07:27:40,172 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,172 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?] 07:27:40,175 INFO [CustomerCampaignServiceBD] start readAll... 07:27:40,175 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,175 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customizableEntity WHERE entityId = ? AND type LIKE ?] 07:27:40,177 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,177 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customizableEntity WHERE entityId = ?] 07:27:40,179 INFO [DOMPersistanceManager] Parents Found : 0 07:27:40,179 INFO [CustomerCampaignServiceBD] end readAll... 07:27:40,179 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,180 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, languageCode, countryCode, variant, description from languages where languageCode = ? AND countryCode = ? AND variant = ?] 07:27:40,181 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,181 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageCode' to property 'languageCode' of type class java.lang.String 07:27:40,181 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'countryCode' to property 'countryCode' of type class java.lang.String 07:27:40,181 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'variant' to property 'variant' of type class java.lang.String 07:27:40,181 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'description' to property 'description' of type class java.lang.String 07:27:40,189 INFO [ContentRepositoryService] Inside getAdCopy : EntityId [2867] CompanyName [null] BusinessAreaID [10003] BusinessLocationID [0] Language [2] Regenerate Flag [false] isMobile [true] 07:27:40,191 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,191 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?] 07:27:40,193 INFO [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [2867] BusinessTypeID [0] BusinessAreaID [10003] BusinessLocationID [0] BusinessLocationType [0] Language [2] 07:27:40,193 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [8] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:40,194 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,194 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,197 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,198 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,198 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,198 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,198 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,198 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,199 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,199 DEBUG [JdbcTemplate] Executing prepared SQL statement [select contentElementVariations.id, contentElementTokens.token, contentElementVariations.segmentNum, contentElementVariations.variationNum, contentElementVariations.value from contentElementVariations join contentElementTokens on (contentElementTokens.id=contentElementVariations.contentElementTokenID) join contentAssignments on (contentAssignments.contentGroupID=? and contentAssignments.entityID=? and contentAssignments.instanceNum=?) join contentAssignmentElements on (contentAssignmentElements.contentAssignmentID = contentAssignments.id and contentAssignmentElements.contentElementVariationID = contentElementVariations.id) order by contentElementTokens.token, contentElementVariations.segmentNum] 07:27:40,248 INFO [ContentRepositoryServiceImpl] Regenerating content for ContentTypeID: 8 EntityID: 2867 BusinessTypeID: 0 BusinessFunctionID: 10003 LocationID: 0 LanguageID: 2 07:27:40,248 WARN [ContentSegmentDAO] Getting content by business area. 07:27:40,248 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [8] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:40,249 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,249 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,250 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,251 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,251 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,251 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,251 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,251 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,251 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,251 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,251 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,251 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,252 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,252 WARN [ContentSegmentDAO] Getting content by source group. 07:27:40,253 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,253 DEBUG [JdbcTemplate] Executing prepared SQL statement [select contentElementVariations.id,token,segmentNum,variationNum,value from contentElementVariations join contentElementTokens on (contentElementTokens.id=contentElementVariations.contentElementTokenID) where contentElementVariations.contentGroupID=? and contentElementVariations.status=? order by token,segmentNum,variationNum] 07:27:40,255 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [8] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:40,256 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,256 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,257 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,257 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,257 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,258 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,258 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,258 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,258 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,258 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,258 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,258 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,258 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,259 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,260 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentAssignments where entityID=? and contentGroupID=? and instanceNum=? and status=?] 07:27:40,261 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,261 DEBUG [JdbcTemplate] Executing prepared SQL statement [select count(1) from contentAssignments where contentGroupID=? and hash=?] 07:27:40,263 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,263 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignments(entityID, contentGroupID, instanceNum, status, hash, dateAssigned, dateGenerated)values (?, ?, ?, ?, ?, now(), now())] 07:27:40,264 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,265 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 07:27:40,267 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,267 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignmentElements(contentAssignmentID, contentElementVariationID) values (?,?)] 07:27:40,268 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,268 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,268 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignmentElements(contentAssignmentID, contentElementVariationID) values (?,?)] 07:27:40,272 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,272 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,272 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignmentElements(contentAssignmentID, contentElementVariationID) values (?,?)] 07:27:40,273 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,274 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,274 DEBUG [JdbcTemplate] Executing prepared SQL statement [update contentGroups set usedUniqueCount = usedUniqueCount + 1 where id=?] 07:27:40,275 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,278 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,278 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?] 07:27:40,280 INFO [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [2867] BusinessTypeID [0] BusinessAreaID [10003] BusinessLocationID [0] BusinessLocationType [0] Language [2] 07:27:40,281 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [8] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:40,281 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,281 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,282 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,283 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,283 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,283 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,283 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,283 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,283 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,283 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,283 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,283 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,284 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,284 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,285 DEBUG [JdbcTemplate] Executing prepared SQL statement [select contentElementVariations.id, contentElementTokens.token, contentElementVariations.segmentNum, contentElementVariations.variationNum, contentElementVariations.value from contentElementVariations join contentElementTokens on (contentElementTokens.id=contentElementVariations.contentElementTokenID) join contentAssignments on (contentAssignments.contentGroupID=? and contentAssignments.entityID=? and contentAssignments.instanceNum=?) join contentAssignmentElements on (contentAssignmentElements.contentAssignmentID = contentAssignments.id and contentAssignmentElements.contentElementVariationID = contentElementVariations.id) order by contentElementTokens.token, contentElementVariations.segmentNum] 07:27:40,287 INFO [ContentRepositoryServiceImpl] Regenerating content for ContentTypeID: 8 EntityID: 2867 BusinessTypeID: 0 BusinessFunctionID: 10003 LocationID: 0 LanguageID: 2 07:27:40,287 WARN [ContentSegmentDAO] Getting content by business area. 07:27:40,287 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [8] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:40,288 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,288 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,289 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,289 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,289 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,289 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,289 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,289 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,290 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,290 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,290 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,290 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,290 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,291 WARN [ContentSegmentDAO] Getting content by source group. 07:27:40,291 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,291 DEBUG [JdbcTemplate] Executing prepared SQL statement [select contentElementVariations.id,token,segmentNum,variationNum,value from contentElementVariations join contentElementTokens on (contentElementTokens.id=contentElementVariations.contentElementTokenID) where contentElementVariations.contentGroupID=? and contentElementVariations.status=? order by token,segmentNum,variationNum] 07:27:40,294 INFO [ContentGroupDAO] Inside getContentGroup : ContentTypeID [8] BusinessAreaID [10003] LocationID [0] LocationType [0] Language [2] SubGroupID [0] 07:27:40,294 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,294 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id,contentTypeID,businessCategoryID,businessAreaID,locationID,locationType,languageID,statusID,sourceContentGroupID,totalUniqueCount,usedUniqueCount from contentGroups where contentTypeID=? and businessAreaID=? and businessAreaSubGroupID=? and locationID=? and locationType=? and languageID=?] 07:27:40,296 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,296 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'contentTypeID' to property 'contentTypeID' of type int 07:27:40,296 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessCategoryID' to property 'businessCategoryID' of type int 07:27:40,297 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessAreaID' to property 'businessAreaID' of type int 07:27:40,297 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:27:40,297 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationType' to property 'locationType' of type int 07:27:40,297 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'languageID' to property 'languageID' of type int 07:27:40,297 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'statusID' to property 'statusID' of type int 07:27:40,297 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'sourceContentGroupID' to property 'sourceContentGroupID' of type int 07:27:40,297 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'totalUniqueCount' to property 'totalUniqueCount' of type long 07:27:40,297 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'usedUniqueCount' to property 'usedUniqueCount' of type long 07:27:40,298 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,299 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentAssignments where entityID=? and contentGroupID=? and instanceNum=? and status=?] 07:27:40,301 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,301 DEBUG [JdbcTemplate] Executing prepared SQL statement [select count(1) from contentAssignments where contentGroupID=? and hash=?] 07:27:40,302 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,303 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignments(entityID, contentGroupID, instanceNum, status, hash, dateAssigned, dateGenerated)values (?, ?, ?, ?, ?, now(), now())] 07:27:40,304 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,304 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 07:27:40,306 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,306 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignmentElements(contentAssignmentID, contentElementVariationID) values (?,?)] 07:27:40,307 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,308 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,308 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignmentElements(contentAssignmentID, contentElementVariationID) values (?,?)] 07:27:40,309 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,310 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,310 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into contentAssignmentElements(contentAssignmentID, contentElementVariationID) values (?,?)] 07:27:40,311 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,312 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,312 DEBUG [JdbcTemplate] Executing prepared SQL statement [update contentGroups set usedUniqueCount = usedUniqueCount + 1 where id=?] 07:27:40,313 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,314 INFO [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [2867] BusinessTypeID [0] BusinessAreaID [10003] BusinessLocationID [0] BusinessLocationType [0] Language [2] 07:27:40,316 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,316 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?] 07:27:40,323 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,323 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id) where l.businessFunctionID = ? and k.matchType = ?] 07:27:40,336 DEBUG [KeywordServiceImpl] Getting keywords for BF: 10003 07:27:40,336 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,336 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id) where l.businessFunctionID = ? and k.matchType <> 'website' ] 07:27:40,338 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,338 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int 07:27:40,338 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String 07:27:40,339 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType 07:27:40,339 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean 07:27:40,339 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean 07:27:40,339 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean 07:27:40,339 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean 07:27:40,346 DEBUG [KeywordServiceImpl] 86 keywords found for BF: 10003 07:27:40,346 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,346 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where businessFunctionID = ?] 07:27:40,349 DEBUG [KeywordServiceImpl] 86 keywords found for BF: 10003 07:27:40,355 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,355 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, locationID, aliasType, description, descType, ordering, shortDescription from mms_common.locationAliases where locationID=? and aliasType=? order by ordering asc] 07:27:40,360 DEBUG [KeywordServiceImpl] Getting keywords for BF: 10003 07:27:40,385 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,385 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id) where l.businessFunctionID = ? and k.matchType <> 'website' ] 07:27:40,387 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:40,387 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int 07:27:40,387 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String 07:27:40,387 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType 07:27:40,387 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean 07:27:40,387 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean 07:27:40,387 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean 07:27:40,388 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean 07:27:40,394 DEBUG [KeywordServiceImpl] 86 keywords found for BF: 10003 07:27:40,394 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,394 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where businessFunctionID = ?] 07:27:40,396 DEBUG [KeywordServiceImpl] 86 keywords found for BF: 10003 07:27:40,396 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,396 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +best +motel +rate +United +States 07:27:40,397 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,397 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +best +motel +rates +United +States 07:27:40,397 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,397 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +budget +motel +United +States 07:27:40,397 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,397 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +budget +motels +United +States 07:27:40,397 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,397 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +cheap +motel +United +States 07:27:40,397 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,397 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +cheap +motels +United +States 07:27:40,397 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,398 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +cheapmotel +United +States 07:27:40,398 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,398 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +cheapmotels +United +States 07:27:40,398 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,398 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +discount +motel +United +States 07:27:40,398 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,398 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +discount +motel +rate +United +States 07:27:40,398 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,398 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +discount +motel +rates +United +States 07:27:40,398 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,398 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +discount +motels +United +States 07:27:40,399 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,399 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +motel +United +States 07:27:40,399 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,399 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +motel +discount +United +States 07:27:40,399 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,399 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +motel +discounts +United +States 07:27:40,399 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,399 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +motel +finder +United +States 07:27:40,399 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,399 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +motel +rate +United +States 07:27:40,399 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,400 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +motel +rates +United +States 07:27:40,400 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,400 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +motel +reservation +United +States 07:27:40,400 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,400 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +motel +reservations +United +States 07:27:40,400 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,400 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +motel +search +United +States 07:27:40,400 DEBUG [KeywordServiceImpl] Multi-lang support is: true and path for templates is :/usr/local/tsa/languageTemplates 07:27:40,400 DEBUG [LanguageTemplate] Geo-mod Broad keyword-location value: +motels +United +States 07:27:40,402 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,402 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.campaigns (accountID, advertID,businessFunctionID, locationID, customerDisplayURL, customerDestinationURL, localeName) select a.id, ?, ?, ?, ?, ?, ? from mms_common.accounts a where a.bpID = ? on duplicate key update customerDisplayURL = ?, customerDestinationURL = ?] 07:27:40,404 DEBUG [JdbcTemplate] SQL update affected 2 rows 07:27:40,405 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,405 DEBUG [JdbcTemplate] Executing prepared SQL statement [select p.id, p.locationID, p.latitudeDegrees, p.longitudeDegrees, p.radiusMeters, (case when m.advertID is not null then m.multiplier else 1 end) as multiplier, (case when m.advertID is not null then m.incrementer else 0 end) as incrementer from pointRadius p left join pointRadiusModifiers m on (m.advertID = ?) where locationID = ?] 07:27:40,428 DEBUG [JdbcTemplate] Executing SQL query [select multiplier from pointRadiusModifiers where advertID is null] 07:27:40,430 INFO [AdMaxDeploymentServiceImpl] Using global radius multiplier of 1.0 07:27:40,430 INFO [AdMaxDeploymentServiceImpl] Finished deploy campaign message conversion. 1 converted. 07:27:40,430 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,430 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?] 07:27:40,456 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:40,456 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?] 07:27:40,458 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:40,458 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.requests(requestType, deploymentID) values (?, ?)] 07:27:40,460 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:40,525 WARN [QueueUtils] Setting message priority to 4 07:27:40,533 INFO [AdMaxDeploymentRequestMDB] Sent DEPLOY request to listener. BPID: 0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d DeployID: 5b19aebb-97a4-4f22-b678-b293f4d58bb8 07:27:41,694 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:41,694 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts(description,tier,priority,conversionTypes,isBidManaged,isActive,perfMetric,providesConversionData,addConversionData,databaseInstance,warehouseInstance,isOnline,currencyCode) values(?,?,?,?,?,?,?,?,?,?,?,?,?)] 07:27:41,739 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 1300 Address: /SMB-BES/BudgetEstimateService Encoding: UTF-8 Content-Type: text/xml; charset=UTF-8 Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[421], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]} Payload: 100031USDen -------------------------------------- 07:27:41,743 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:41,743 DEBUG [JdbcTemplate] Executing prepared SQL statement [select ba.id, ba.description, ba.status, bcam.businessCategoryID from businessAreas ba left join businessCategoryAreaMap bcam on bcam.businessAreaID=ba.id where ba.id=? order by bcam.businessCategoryID limit 1] 07:27:41,748 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:41,749 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?] 07:27:41,750 INFO [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=? 07:27:41,751 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:41,751 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?] 07:27:41,767 DEBUG [KeywordServiceImpl] Getting keywords for BF: 10003 07:27:41,768 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:41,768 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id) where l.businessFunctionID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ] 07:27:41,770 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:41,770 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int 07:27:41,770 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String 07:27:41,771 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType 07:27:41,771 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean 07:27:41,771 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean 07:27:41,771 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean 07:27:41,771 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean 07:27:41,777 DEBUG [KeywordServiceImpl] 86 keywords found for BF: 10003 07:27:41,777 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:41,777 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where businessFunctionID = ?] 07:27:41,779 DEBUG [KeywordServiceImpl] 86 keywords found for BF: 10003 07:27:41,779 INFO [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-07 05:14:36 07:27:41,779 INFO [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.businessAreaID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.businessAreaID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.businessAreaID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1 07:27:41,779 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:41,779 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.businessAreaID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.businessAreaID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.businessAreaID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1] 07:27:41,782 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 6787.1167/9217.073 07:27:41,782 DEBUG [BudgetEstimateServiceImpl] Looking for target ID: 52 07:27:41,782 DEBUG [BudgetEstimateServiceImpl] Checking raw budget estimate for: 10003-0 07:27:41,783 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 6787.1167 07:27:41,783 DEBUG [BudgetEstimateServiceImpl] maxPrice = 9217.073 07:27:41,783 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 9217.073 07:27:41,783 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 280538.7 07:27:41,783 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE 07:27:41,783 INFO [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 44 07:27:41,783 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0 07:27:41,783 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 10.244 07:27:41,783 DEBUG [BudgetEstimateServiceImpl] maxPrice = 280538.7 07:27:41,783 DEBUG [BudgetEstimateServiceImpl] minClicks = 3.0 07:27:41,783 DEBUG [BudgetEstimateServiceImpl] maxClicks = 73939.164 07:27:41,783 INFO [BudgetEstimateServiceImpl] Request time: 42 millis 07:27:41,808 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 1300 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload: success100031USDencache2013-10-15T10:19:49.000Z10.244280538.73.073939.164 -------------------------------------- 07:27:42,275 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:42,277 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 07:27:42,279 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:42,279 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into sites(accountID,isDefault,description,internalURLPattern,ignorePixels) values(?,?,?,?,?)] 07:27:42,389 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:42,390 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 07:27:42,392 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:42,392 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into userAccountMap(userID,accountID) values(?,?)] 07:27:42,478 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:42,479 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:42,479 DEBUG [JdbcTemplate] Executing prepared SQL statement [select `tsacommon`.`accounts`.`databaseInstance` from `tsacommon`.`accounts` where `tsacommon`.`accounts`.`description` = ?] 07:27:42,481 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:42,481 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from `tsacommon`.`databaseInstances` where `tsacommon`.`databaseInstances`.`name` = ?] 07:27:42,483 INFO [DatabaseInstancePersistenceManager] Database URL: jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&characterEncoding=UTF-8 07:27:42,483 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:42,483 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accountChannelMap(accountID,channelID) values(?,?)] 07:27:42,514 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:42,515 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:42,515 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into settings(`schema`,`scope`,`scopeId`,`value`) values(?,?,?,?)] 07:27:42,541 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:42,542 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:42,542 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into settings(`schema`,`scope`,`scopeId`,`value`) values(?,?,?,?)] 07:27:42,592 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:42,593 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:42,593 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into settings(`schema`,`scope`,`scopeId`,`value`) values(?,?,?,?)] 07:27:42,639 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:42,640 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:42,640 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into waypoints(siteID,type,defaultCost,defaultValue,description,debounceWindow,limitPerWindow,testingURL,destinationURL) values(?,?,?,?,?,?,?,?,?)] 07:27:42,763 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:42,764 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 07:27:42,805 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:42,805 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into waypoints(siteID,type,defaultCost,defaultValue,description,debounceWindow,limitPerWindow,testingURL,destinationURL) values(?,?,?,?,?,?,?,?,?)] 07:27:42,852 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:42,853 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 07:27:42,892 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:42,892 DEBUG [JdbcTemplate] Executing prepared SQL statement [select `tsacommon`.`accounts`.`databaseInstance` from `tsacommon`.`accounts` where `tsacommon`.`accounts`.`id` = ?] 07:27:42,896 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:42,896 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from `tsacommon`.`databaseInstances` where `tsacommon`.`databaseInstances`.`name` = ?] 07:27:42,898 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:42,898 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxAccountAnniversary where accountId = ? and endDate is NULL] 07:27:42,978 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 1301 Address: /SMB-BES/BudgetEstimateService Encoding: UTF-8 Content-Type: text/xml; charset=UTF-8 Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[421], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]} Payload: 100031USDen -------------------------------------- 07:27:42,982 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:42,983 DEBUG [JdbcTemplate] Executing prepared SQL statement [select ba.id, ba.description, ba.status, bcam.businessCategoryID from businessAreas ba left join businessCategoryAreaMap bcam on bcam.businessAreaID=ba.id where ba.id=? order by bcam.businessCategoryID limit 1] 07:27:42,988 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:42,988 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?] 07:27:42,989 DEBUG [JdbcTemplate] Executing prepared SQL update 07:27:42,989 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into admaxAccountAnniversary(accountId,anniversaryDate,startDate) values(?,?,?) on duplicate key update endDate= ?] 07:27:42,990 INFO [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=? 07:27:42,990 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:42,990 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?] 07:27:42,996 DEBUG [KeywordServiceImpl] Getting keywords for BF: 10003 07:27:42,996 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:42,996 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id) where l.businessFunctionID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ] 07:27:42,999 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:42,999 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int 07:27:43,000 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String 07:27:43,000 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType 07:27:43,000 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean 07:27:43,000 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean 07:27:43,000 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean 07:27:43,000 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean 07:27:43,001 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:27:43,009 DEBUG [KeywordServiceImpl] 86 keywords found for BF: 10003 07:27:43,009 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:43,009 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where businessFunctionID = ?] 07:27:43,011 DEBUG [KeywordServiceImpl] 86 keywords found for BF: 10003 07:27:43,011 INFO [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-07 05:14:36 07:27:43,012 INFO [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.businessAreaID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.businessAreaID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.businessAreaID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1 07:27:43,012 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:43,012 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.businessAreaID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.businessAreaID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.businessAreaID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1] 07:27:43,016 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 6787.1167/9217.073 07:27:43,017 DEBUG [BudgetEstimateServiceImpl] Looking for target ID: 52 07:27:43,017 DEBUG [BudgetEstimateServiceImpl] Checking raw budget estimate for: 10003-0 07:27:43,017 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 6787.1167 07:27:43,017 DEBUG [BudgetEstimateServiceImpl] maxPrice = 9217.073 07:27:43,017 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 9217.073 07:27:43,017 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 280538.7 07:27:43,017 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE 07:27:43,017 INFO [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 44 07:27:43,017 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0 07:27:43,017 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 10.244 07:27:43,017 DEBUG [BudgetEstimateServiceImpl] maxPrice = 280538.7 07:27:43,021 DEBUG [BudgetEstimateServiceImpl] minClicks = 3.0 07:27:43,021 DEBUG [BudgetEstimateServiceImpl] maxClicks = 73939.164 07:27:43,021 INFO [BudgetEstimateServiceImpl] Request time: 40 millis 07:27:43,066 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 1301 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload: success100031USDencache2013-10-15T10:19:49.000Z10.244280538.73.073939.164 -------------------------------------- 07:27:47,206 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 1302 Address: /SMB-BES/BudgetEstimateService Encoding: UTF-8 Content-Type: text/xml; charset=UTF-8 Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-campaign:8080], Content-Length=[421], SOAPAction=["http://thesearchagency.com/smb/core/getBudgetEstimates"], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]} Payload: 100031USDen -------------------------------------- 07:27:47,211 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:47,211 DEBUG [JdbcTemplate] Executing prepared SQL statement [select ba.id, ba.description, ba.status, bcam.businessCategoryID from businessAreas ba left join businessCategoryAreaMap bcam on bcam.businessAreaID=ba.id where ba.id=? order by bcam.businessCategoryID limit 1] 07:27:47,222 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:47,222 DEBUG [JdbcTemplate] Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?] 07:27:47,227 INFO [BudgetEstimateDAO] Query: SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=? 07:27:47,227 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:47,227 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT glt.id, glt.target, glt.description, glt.type, glt.code, gbem.budgetEstimateMultiplier FROM mms_common.googleLocationTargets glt JOIN googleBudgetEstimateMap gbem on gbem.googleLocationTargetID = glt.id WHERE gbem.businessLocationID=?] 07:27:47,234 DEBUG [KeywordServiceImpl] Getting keywords for BF: 10003 07:27:47,236 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:47,236 DEBUG [JdbcTemplate] Executing prepared SQL statement [select k.id, k.keywordListID, k.keyword, k.matchType, k.isGeoMod, k.isGeoTarget, k.isMobile, k.isNegative from keywords k join keywordLists l on (k.keywordListID = l.id) where l.businessFunctionID = ? and k.matchType <> 'website' and k.id not in (select negative.id from keywords negative join keywords positive on (negative.keywordListID = positive.keywordListID) where negative.isGeoTarget = 1 and negative.matchType not in('broad','website') and negative.isNegative = 1 and positive.isGeoTarget = 1 and positive.isNegative = 0 and positive.matchType <> 'website' and positive.keywordListID = l.id and positive.keyword REGEXP concat('(-+|[[:<:]])',negative.keyword,'(-+|[[:>:]])')) ] 07:27:47,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:27:47,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keywordListID' to property 'keywordListID' of type int 07:27:47,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'keyword' to property 'keyword' of type class java.lang.String 07:27:47,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'matchType' to property 'matchType' of type class com.thesearchagency.core.smb.dto.KeywordMatchType 07:27:47,239 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoMod' to property 'isGeoMod' of type boolean 07:27:47,240 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isGeoTarget' to property 'isGeoTarget' of type boolean 07:27:47,240 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isMobile' to property 'isMobile' of type boolean 07:27:47,240 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'isNegative' to property 'isNegative' of type boolean 07:27:47,248 DEBUG [KeywordServiceImpl] 86 keywords found for BF: 10003 07:27:47,248 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:47,248 DEBUG [JdbcTemplate] Executing prepared SQL statement [select dateUpdated from biz_function_location.keywordLists where businessFunctionID = ?] 07:27:47,251 DEBUG [KeywordServiceImpl] 86 keywords found for BF: 10003 07:27:47,252 INFO [BudgetEstimateDAO] Requesting most recent budget estimate later than 2013-10-07 05:14:36 07:27:47,252 INFO [BudgetEstimateDAO] Query: SELECT gbe.id, gbe.businessAreaID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.businessAreaID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.businessAreaID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1 07:27:47,252 DEBUG [JdbcTemplate] Executing prepared SQL query 07:27:47,252 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT gbe.id, gbe.businessAreaID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.minPrice, gbe.maxPrice, gbe.minClicks, gbe.maxClicks, gbe.time FROM googleBudgetEstimates gbe WHERE gbe.businessAreaID=? and gbe.googleLocationTargetID=? and gbe.currencyCode=? and gbe.languageCode=? and gbe.time>? ORDER BY gbe.businessAreaID, gbe.googleLocationTargetID, gbe.currencyCode, gbe.languageCode, gbe.time DESC LIMIT 1] 07:27:47,254 ERROR [BudgetEstimateDAO] A budget estimate was found with min/max prices = 6787.1167/9217.073 07:27:47,255 DEBUG [BudgetEstimateServiceImpl] Looking for target ID: 52 07:27:47,255 DEBUG [BudgetEstimateServiceImpl] Checking raw budget estimate for: 10003-0 07:27:47,255 DEBUG [BudgetEstimateServiceImpl] Finalizing budget estimate . . . minPrice = 6787.1167 07:27:47,255 DEBUG [BudgetEstimateServiceImpl] maxPrice = 9217.073 07:27:47,255 DEBUG [BudgetEstimateServiceImpl] Daily pricing . . . maxPrice = 9217.073 07:27:47,255 DEBUG [BudgetEstimateServiceImpl] Budget estimate using multiplier (1.0) . . . maxPrice = 280538.7 07:27:47,255 DEBUG [BudgetEstimateServiceImpl] Set origin to: CACHE 07:27:47,255 INFO [BudgetEstimateServiceImpl] BES - Number of keywords in estimate request: 44 07:27:47,255 DEBUG [BudgetEstimateServiceImpl] Quota costs . . . 0.0 07:27:47,255 DEBUG [BudgetEstimateServiceImpl] Final budget estimate . . . minPrice = 10.244 07:27:47,256 DEBUG [BudgetEstimateServiceImpl] maxPrice = 280538.7 07:27:47,256 DEBUG [BudgetEstimateServiceImpl] minClicks = 3.0 07:27:47,256 DEBUG [BudgetEstimateServiceImpl] maxClicks = 73939.164 07:27:47,256 INFO [BudgetEstimateServiceImpl] Request time: 47 millis 07:27:47,369 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 1302 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload: success100031USDencache2013-10-15T10:19:49.000Z10.244280538.73.073939.164 -------------------------------------- 07:28:29,449 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:28:29,449 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:28:29,450 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:28:29,477 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:29:29,476 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:29:29,476 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:29:29,477 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:29:29,496 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:29:41,197 INFO [AuditorServiceBD] Entering the audit method... 07:29:41,197 DEBUG [JdbcTemplate] Executing prepared SQL query 07:29:41,197 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?] 07:29:41,206 DEBUG [JdbcTemplate] Executing prepared SQL query 07:29:41,206 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?] 07:29:41,208 DEBUG [JdbcTemplate] Executing prepared SQL update 07:29:41,208 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)] 07:29:41,263 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:29:41,264 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 07:29:41,267 DEBUG [JdbcTemplate] Executing prepared SQL update 07:29:41,268 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)] 07:29:41,320 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:29:41,321 INFO [AuditorServiceBD] Exiting the audit method... 07:29:41,901 INFO [AdMaxDeploymentResponseMDB] Response MDB triggered. 07:29:41,928 INFO [AdMaxDeploymentMessageConverter] Campaings for the Result: 1 07:29:41,928 INFO [AdMaxDeploymentMessageConverter] Assuming No Message Fault, Campaigns count: 1 topResultCode: null 07:29:41,947 WARN [AlertUtils] sendAlert: executing command: [/usr/local/tsa/send_alarm.sh, WARNING, APSD, AdMax_AdMaxDeploymentService: General - Failure detected during campaign deployment: 5b19aebb-97a4-4f22-b678-b293f4d58bb8. Customer bpID:0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d. Failed advertID list:7936.] 07:29:42,144 INFO [AdMaxDeploymentResponseMDB] Sent alert: Failure detected during campaign deployment: 5b19aebb-97a4-4f22-b678-b293f4d58bb8. Customer bpID:0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d. Failed advertID list:7936. 07:29:42,144 INFO [AdMaxDeploymentResponseMDB] Handling publish deploy status resp 07:30:29,495 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:30:29,495 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:30:29,496 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:30:29,549 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:31:29,538 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:31:29,538 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:31:29,539 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:31:29,729 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:32:25,137 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 1303 Address: /SMB-ADS/AdMaxDeploymentService Encoding: UTF-8 Content-Type: text/xml; charset=UTF-8 Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]} Payload: 0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d -------------------------------------- 07:32:25,139 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,139 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?] 07:32:25,154 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:32:25,154 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String 07:32:25,154 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String 07:32:25,155 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=false, smb-admax-deployment-service.hostname=localhost} 07:32:25,155 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,155 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?] 07:32:25,200 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:32:25,200 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int 07:32:25,200 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String 07:32:25,200 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int 07:32:25,200 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:32:25,200 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String 07:32:25,201 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String 07:32:25,201 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String 07:32:25,242 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 7936: Paused -> Paused 07:32:25,242 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 7936 -> PAUSED 07:32:25,243 INFO [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0] 07:32:25,243 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,243 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?] 07:32:25,263 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,263 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?] 07:32:25,265 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,265 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ] 07:32:25,268 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,268 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:32:25,277 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 1303 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload: 0dfc79cc-4c44-4d6c-b3b4-cc6ce281885dwww.merchantsite.comsuccess7936100031http://www.merchantsite.com/www.merchantsite.comFailurepauseden_US -------------------------------------- 07:32:25,305 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 1304 Address: /SMB-ADS/AdMaxDeploymentService Encoding: UTF-8 Content-Type: text/xml; charset=UTF-8 Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[293], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]} Payload: 7936 -------------------------------------- 07:32:25,338 INFO [STDOUT] GCE_CAMPAIGNS:10140, 10139, 10141 07:32:25,338 INFO [STDOUT] getOperationErrorsResponse query: SELECT `reason`, `field`, `trigger` FROM gce_campaignAdExtensionMapPendingChange INNER JOIN gce_campaignAdExtensionMapError ON gce_campaignAdExtensionMapPendingChange.campaignID = gce_campaignAdExtensionMapError.campaignID INNER JOIN gce_campaignAdExtensionMap ON gce_campaignAdExtensionMap.campaignID = gce_campaignAdExtensionMapPendingChange.campaignID WHERE gce_campaignAdExtensionMap.campaignID IN (10140, 10139, 10141) AND gce_campaignAdExtensionMapPendingChange.isFailed='true' 07:32:25,372 INFO [STDOUT] getOperationErrorsResponse query: SELECT gce_feed.name as 'category', `reason`, `trigger`, `field` FROM gce_campaignFeedPendingChange INNER JOIN gce_campaignFeedError ON gce_campaignFeedPendingChange.`campaignFeedID` = gce_campaignFeedError.`campaignFeedID` INNER JOIN gce_campaignFeed ON gce_campaignFeed.id=gce_campaignFeedPendingChange.campaignFeedID INNER JOIN gce_feed ON gce_feed.id = gce_campaignFeed.feedID WHERE gce_campaignFeed.campaignID IN (10140, 10139, 10141) AND gce_campaignFeedPendingChange.isFailed='true' 07:32:25,393 INFO [STDOUT] getOperationErrorsResponse query: SELECT gce_feed.name as 'category', `reason`, `trigger`, `field` FROM gce_feedPendingChange INNER JOIN gce_feedError ON gce_feedPendingChange.`feedID` = gce_feedError.`feedID` INNER JOIN gce_feed ON gce_feed.id=gce_feedError.`feedID` INNER JOIN gce_campaignFeed ON gce_campaignFeed.feedID=gce_feed.id WHERE gce_campaignFeed.campaignID IN (10140, 10139, 10141) AND gce_feedPendingChange.isFailed='true' 07:32:25,416 INFO [STDOUT] getOperationErrorsResponse query: SELECT gce_feed.name as 'category', `reason`, `trigger`, `field` FROM gce_feedItemPendingChange INNER JOIN gce_feedItemError ON gce_feedItemPendingChange.`feedItemID` = gce_feedItemError.`feedItemID` INNER JOIN gce_feedItem ON gce_feedItem.id=gce_feedItemError.`feedItemID` INNER JOIN gce_campaignFeed ON gce_campaignFeed.feedID=gce_feedItem.feedID INNER JOIN gce_feed ON gce_feed.id = gce_feedItem.feedID WHERE gce_campaignFeed.campaignID IN (10140, 10139, 10141) AND gce_feedItemPendingChange.isFailed='true' 07:32:25,418 INFO [STDOUT] getOperationErrorsResponse query: SELECT gce_feed.name as 'category', `reason`, `trigger`, `field` FROM gce_feedMappingPendingChange INNER JOIN gce_feedMappingError ON gce_feedMappingPendingChange.`feedMappingID` = gce_feedMappingError.`feedMappingID` INNER JOIN gce_feedMapping ON gce_feedMapping.id=gce_feedMappingError.`feedMappingID` INNER JOIN gce_campaignFeed ON gce_campaignFeed.feedID=gce_feedMapping.feedID INNER JOIN gce_feed ON gce_feed.id = gce_feedMapping.feedID WHERE gce_campaignFeed.campaignID IN (10140, 10139, 10141) AND gce_feedMappingPendingChange.isFailed='true' 07:32:25,422 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 1304 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload: -------------------------------------- 07:32:25,434 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 1305 Address: /SMB-ADS/AdMaxDeploymentService Encoding: UTF-8 Content-Type: text/xml; charset=UTF-8 Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[282], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]} Payload: 0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d -------------------------------------- 07:32:25,435 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,435 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?] 07:32:25,437 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:32:25,437 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String 07:32:25,437 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String 07:32:25,438 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=false, smb-admax-deployment-service.hostname=localhost} 07:32:25,438 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,438 DEBUG [JdbcTemplate] Executing prepared SQL statement [select campaigns.id, accountID, advertID, businessFunctionID, locationID, customerDisplayURL, customerDestinationURL, localeName from accounts join campaigns on accounts.id=campaigns.accountID where bpID=?] 07:32:25,440 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 07:32:25,440 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'accountID' to property 'accountID' of type int 07:32:25,440 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'advertID' to property 'advertID' of type class java.lang.String 07:32:25,440 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'businessFunctionID' to property 'businessFunctionID' of type int 07:32:25,440 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 07:32:25,440 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDisplayURL' to property 'customerDisplayURL' of type class java.lang.String 07:32:25,440 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'customerDestinationURL' to property 'customerDestinationURL' of type class java.lang.String 07:32:25,440 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'localeName' to property 'localeName' of type class java.lang.String 07:32:25,444 INFO [AdMaxDeploymentServiceImpl] getCampaignStatus 7936: Paused -> Paused 07:32:25,444 INFO [AdMaxDeploymentWS] getCampaignsByCustomerID: 7936 -> PAUSED 07:32:25,445 INFO [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0] 07:32:25,445 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,446 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?] 07:32:25,450 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,450 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?] 07:32:25,453 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,453 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ] 07:32:25,455 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,455 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:32:25,458 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 1305 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload: 0dfc79cc-4c44-4d6c-b3b4-cc6ce281885dwww.merchantsite.comsuccess7936100031http://www.merchantsite.com/www.merchantsite.comFailurepauseden_US -------------------------------------- 07:32:25,487 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 1306 Address: /SMB-ADS/AdMaxDeploymentService Encoding: UTF-8 Content-Type: text/xml; charset=UTF-8 Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[573], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]} Payload:
5b19aebb-97a4-4f22-b678-b293f4d58bb8
0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d 7936 paused -------------------------------------- 07:32:25,489 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,489 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ] 07:32:25,492 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,493 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from sites where accountID = ? ] 07:32:25,495 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,495 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from waypoints where siteID = ? ] 07:32:25,529 WARN [QueueUtils] Setting message priority to 4 07:32:25,544 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,544 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:25,566 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,566 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.blacklist where customerBpId = ?] 07:32:25,567 INFO [AdMaxDeploymentFauxSyncMessenger] Starting campaign status update blocking loop 07:32:25,567 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,568 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:25,571 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,571 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?] 07:32:25,602 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,602 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?] 07:32:25,604 DEBUG [JdbcTemplate] Executing prepared SQL update 07:32:25,604 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.requests(requestType, deploymentID) values (?, ?)] 07:32:25,606 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:32:25,617 WARN [QueueUtils] Setting message priority to 9 07:32:25,641 INFO [AdMaxDeploymentRequestMDB] Sent UPDATE request to listener. BPID: 0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d DeployID: 5b19aebb-97a4-4f22-b678-b293f4d58bb8 07:32:25,745 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:25,745 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxAccountAnniversary where accountId = ? and endDate is NULL] 07:32:26,570 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:26,570 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:27,573 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:27,573 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:28,575 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:28,576 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:29,578 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:29,578 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:29,729 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:32:29,729 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:32:29,729 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:32:29,749 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:32:30,654 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:30,654 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:31,659 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:31,660 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:32,662 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:32,662 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:33,664 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:33,665 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:34,667 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:34,667 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:35,670 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:35,670 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:36,672 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:36,673 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:37,675 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:37,675 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:38,677 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:38,677 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:39,680 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:39,680 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:40,697 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:40,697 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:41,702 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:41,702 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:41,916 INFO [AdMaxDeploymentResponseMDB] Response MDB triggered. 07:32:41,977 DEBUG [JdbcTemplate] Executing prepared SQL update 07:32:41,977 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.campUpdateResp(deploymentID, responseMsg) values (?, ?) on duplicate key update responseMsg = ?] 07:32:41,995 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:32:41,996 WARN [AdMaxDeploymentFauxSyncMessenger] Put update ok for deploy 5b19aebb-97a4-4f22-b678-b293f4d58bb8 07:32:41,996 INFO [AdMaxDeploymentResponseMDB] Handling update campaign status. 07:32:42,704 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:42,704 DEBUG [JdbcTemplate] Executing prepared SQL statement [select responseMsg from mms_common.campUpdateResp where deploymentID = ?] 07:32:43,737 INFO [AdMaxDeploymentFauxSyncMessenger] Exited blocking loop 07:32:43,745 DEBUG [JdbcTemplate] Executing prepared SQL update 07:32:43,745 DEBUG [JdbcTemplate] Executing prepared SQL statement [delete from mms_common.campUpdateResp where deploymentID = ?] 07:32:43,748 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:32:43,752 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 1306 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload:
5b19aebb-97a4-4f22-b678-b293f4d58bb8
0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d7936successInformation: [7936_GM:SUCCEEDED] [7936_GT:SUCCEEDED] [7936_MO:SUCCEEDED] -------------------------------------- 07:32:43,781 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 1307 Address: /SMB-ADS/AdMaxDeploymentService Encoding: UTF-8 Content-Type: text/xml; charset=UTF-8 Headers: {cache-control=[no-cache], content-type=[text/xml; charset=UTF-8], connection=[keep-alive], host=[aml-svc-deploy:8080], Content-Length=[677], SOAPAction=[""], user-agent=[Apache CXF 2.7.5], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]} Payload:
5b19aebb-97a4-4f22-b678-b293f4d58bb8
0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d 7936 active -------------------------------------- 07:32:43,790 INFO [AdMaxAccountDeploymentBD] validated: [] 07:32:43,791 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:43,791 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ] 07:32:43,799 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:43,799 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from sites where accountID = ? ] 07:32:43,802 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:43,802 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from waypoints where siteID = ? ] 07:32:43,822 INFO [AdMaxAccountDeploymentBD] Account: Account [theAccountID=2709, theDescription=0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d, theTier=1, thePriority=50, theReportClickOuts=0, theReportConversions=0, theConversionTypes=[], isBidManaged=1, isActive=true, thePerformanceMetric=cpa, theProvidesConversionData=true, theAddConversionDate=false, theFractionalConversionCounts=false, theHideNullSources=0, theNowTime=Mon Oct 21 07:32:43 UTC 2013, theWarehouseDB=warehouse_1, theDatabaseInstance=1, theWarehouseInstance=1, isOnline=true, currencyCode=, theSites=[Site [theSiteId=2708, theAccountId=2709, isDefault=true, theDescription=0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d_Main, theInternalURLPattern=, hasIgnorePixels=false, theWaypoints=[Waypoint [theWaypointId=5413, theSiteId=2708, theGroupId=0, theType=2, theConverstionType=null, theDefaultCost=0.0, theDefaultValue=0.0, theTestingURL=, theDestinationURL=, theDescription=Page View, thePassParams=, theDebounceWindow=30, theLimitPerWindow=1, theLastTestedDate=null, theTestStatus=null], Waypoint [theWaypointId=5414, theSiteId=2708, theGroupId=0, theType=4, theConverstionType=null, theDefaultCost=0.0, theDefaultValue=0.0, theTestingURL=, theDestinationURL=, theDescription=Conversion, thePassParams=, theDebounceWindow=0, theLimitPerWindow=0, theLastTestedDate=null, theTestStatus=null]]]]] 07:32:43,822 INFO [AdMaxAccountDeploymentBD] Updating CampaignID [7936] budget accrual status to [active] 07:32:43,824 INFO [CampaignBudgetAccrualStatusServiceBD] Entering CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus method. 07:32:43,827 INFO [CampaignBudgetAccrualStatusServiceBD] Searching for last CampaignBudgetAccrualStatus record for CampiagnId [3397] 07:32:43,827 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:43,827 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxCampaignBudgetAccrualStatus where admaxCampaignID = ? and endDate is NULL] 07:32:43,857 INFO [CampaignBudgetAccrualStatusServiceBD] CampaignId [3397] last CampaignBudgetAccrualStatus current status CampaignBugetAccrualStatus [theId=6339, theCampaignId=3397, theStartDate=2013-10-21, theEndDate=null, theStatus=paused] 07:32:43,857 DEBUG [JdbcTemplate] Executing prepared SQL query 07:32:43,858 DEBUG [JdbcTemplate] Executing prepared SQL statement [select accountID, currencyCode, timeZoneId from gce_googleAccount where accountID = ? ] 07:32:43,867 DEBUG [JdbcTemplate] Executing prepared SQL update 07:32:43,867 DEBUG [JdbcTemplate] Executing prepared SQL statement [update admaxCampaignBudgetAccrualStatus set endDate = ?, status = ? where id = ? ] 07:32:43,881 DEBUG [JdbcTemplate] SQL update affected 1 rows 07:32:43,882 INFO [CampaignBudgetAccrualStatusServiceBD] CampaignId [3397] updated CampaignBudgetAccrualStatus updated status CampaignBugetAccrualStatus [theId=6339, theCampaignId=3397, theStartDate=2013-10-21, theEndDate=null, theStatus=active] 07:32:43,882 INFO [CampaignBudgetAccrualStatusServiceBD] Exiting CampaignBudgetAccrualStatusServiceImpl.updateCampaignBudgetAccrualStatus method. 07:32:43,911 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 1307 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload:
5b19aebb-97a4-4f22-b678-b293f4d58bb8
0dfc79cc-4c44-4d6c-b3b4-cc6ce281885d7936success -------------------------------------- 07:33:29,747 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:33:29,747 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:33:29,748 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:33:29,831 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:34:29,830 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:34:29,830 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:34:29,831 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:34:29,911 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:35:29,888 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:35:29,888 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:35:29,889 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:35:29,907 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:36:29,906 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:36:29,906 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:36:29,908 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:36:29,930 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:37:29,927 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:37:29,927 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:37:29,928 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:37:29,962 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:38:29,959 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:38:29,959 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:38:29,960 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:38:29,999 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:39:29,990 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:39:29,990 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:39:29,990 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:39:30,018 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:40:30,011 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:40:30,012 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:40:30,012 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:40:30,049 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:41:30,041 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:41:30,041 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:41:30,042 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:41:30,128 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:42:30,127 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:42:30,128 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:42:30,128 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:42:30,148 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:43:30,146 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:43:30,146 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:43:30,147 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:43:30,168 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:44:30,165 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:44:30,165 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:44:30,168 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:44:30,188 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:45:30,184 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:45:30,184 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:45:30,184 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:45:30,378 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:46:30,202 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:46:30,202 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:46:30,202 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:46:30,220 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:47:30,219 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:47:30,219 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:47:30,220 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:47:30,249 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:48:30,248 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:48:30,248 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:48:30,249 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:48:30,265 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:49:30,265 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:49:30,266 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:49:30,266 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:49:30,320 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:50:30,319 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:50:30,319 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:50:30,320 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:50:30,409 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:51:30,378 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:51:30,378 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:51:30,379 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:51:30,396 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:52:30,395 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:52:30,395 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:52:30,395 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:52:30,449 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:53:30,440 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:53:30,440 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:53:30,441 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:53:30,460 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:54:30,460 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:54:30,461 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:54:30,461 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:54:30,661 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:55:30,660 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:55:30,660 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:55:30,660 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:55:30,793 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:56:30,792 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:56:30,792 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:56:30,793 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:56:30,811 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:57:30,810 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:57:30,811 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:57:30,811 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:57:30,843 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 07:58:30,833 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 07:58:30,833 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 07:58:30,833 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 07:58:30,851 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT