[tsaapp@optus-qa-smb1 ~]$ tail -f apps/jboss-5.1.0.GA/tsa_messaging_node_server.log 18:50:24,125 DEBUG [JdbcTemplate] Executing prepared SQL statement [delete from mms_common.campUpdateResp where deploymentID = ?] 18:50:24,125 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:50:56,745 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 18:50:56,745 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 18:50:56,746 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 18:50:56,761 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 18:51:56,765 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 18:51:56,765 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 18:51:56,765 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 18:51:56,780 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 18:52:56,785 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 18:52:56,785 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 18:52:56,785 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 18:52:56,799 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 18:53:56,801 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 18:53:56,801 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 18:53:56,802 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 18:53:56,814 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT 18:54:30,192 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 409 Address: /SMB-ADS/AdMaxDeploymentService Encoding: UTF-8 Content-Type: text/xml;charset=UTF-8 Headers: {content-type=[text/xml;charset=UTF-8], host=[localhost:9997], Content-Length=[345], SOAPAction=[""], user-agent=[Jakarta Commons-HttpClient/3.1], accept-encoding=[gzip,deflate], Content-Type=[text/xml;charset=UTF-8]} Payload: 531 465 -------------------------------------- 18:54:30,194 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,194 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?] 18:54:30,197 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,197 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from accounts where description = ? ] 18:54:30,207 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,207 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where id=?] 18:54:30,209 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,209 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customizableEntity WHERE entityId = ?] 18:54:30,211 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,211 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,212 WARN [CustomerFieldDAOSpringJDBC] 531 465 2933 BUSINESS_LOCATION_ID CUSTOMER 18:54:30,212 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,212 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,212 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,212 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,213 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,213 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,213 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,213 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,214 WARN [CustomerFieldDAOSpringJDBC] 531 469 2935 KEYWORD CUSTOMER 18:54:30,214 WARN [CustomerFieldDAOSpringJDBC] 531 469 2937 KEYWORD_TYPE CUSTOMER 18:54:30,214 WARN [CustomerFieldDAOSpringJDBC] 531 469 2939 NEGATIVE CUSTOMER 18:54:30,214 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,214 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,214 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,215 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,215 WARN [CustomerFieldDAOSpringJDBC] 531 457 2927 BUSINESS_AREA_ID CUSTOMER 18:54:30,215 WARN [CustomerFieldDAOSpringJDBC] 531 457 2929 IMAGE_ID CUSTOMER 18:54:30,215 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,215 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,215 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,216 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,216 WARN [CustomerFieldDAOSpringJDBC] 531 459 2931 BUSINESS_LOCATION_ID CUSTOMER 18:54:30,216 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,216 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,216 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,216 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,217 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,217 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,217 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,217 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,218 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,218 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,218 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,218 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2871 EMAIL CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2873 BUSINESS_AREA_ID CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2875 BUSINESS_LOCATION_ID CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2877 VANITY_URL_ENABLED CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2879 VANITY_URL CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2881 VANITY_TEXT_URL CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2883 BUSINESS_NAME CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2885 LOGO_ID CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2887 TEMPLATE_ID CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2889 DOMAIN_NAME CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2891 BRANCH_NAME CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2893 ADDRESS_LINE1 CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2895 ADDRESS_LINE2 CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2897 CITY CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2899 STATE CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2901 POSTAL_CODE CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2903 COUNTRY_CODE CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2905 SUPPRESS_ADDRESS CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2907 MAP_LOCATION CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2909 SUPPRESS_MAP CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2911 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2913 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,219 WARN [CustomerFieldDAOSpringJDBC] 531 455 2915 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,220 WARN [CustomerFieldDAOSpringJDBC] 531 455 2917 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,220 WARN [CustomerFieldDAOSpringJDBC] 531 455 2919 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,220 WARN [CustomerFieldDAOSpringJDBC] 531 455 2921 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,220 WARN [CustomerFieldDAOSpringJDBC] 531 455 2923 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,220 WARN [CustomerFieldDAOSpringJDBC] 531 455 2925 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,220 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,220 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,221 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,221 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customizableEntity WHERE entityId = ?] 18:54:30,222 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,222 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,223 WARN [CustomerFieldDAOSpringJDBC] 531 457 2927 BUSINESS_AREA_ID CUSTOMER 18:54:30,223 WARN [CustomerFieldDAOSpringJDBC] 531 457 2929 IMAGE_ID CUSTOMER 18:54:30,223 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,223 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,223 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,223 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,224 WARN [CustomerFieldDAOSpringJDBC] 531 459 2931 BUSINESS_LOCATION_ID CUSTOMER 18:54:30,224 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,224 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,224 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,224 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,225 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,225 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,225 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,225 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,226 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,226 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,226 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,226 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,226 WARN [CustomerFieldDAOSpringJDBC] 531 465 2933 BUSINESS_LOCATION_ID CUSTOMER 18:54:30,227 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,227 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,227 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,227 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,228 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,228 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,228 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,228 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,229 WARN [CustomerFieldDAOSpringJDBC] 531 469 2935 KEYWORD CUSTOMER 18:54:30,229 WARN [CustomerFieldDAOSpringJDBC] 531 469 2937 KEYWORD_TYPE CUSTOMER 18:54:30,229 WARN [CustomerFieldDAOSpringJDBC] 531 469 2939 NEGATIVE CUSTOMER 18:54:30,229 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,229 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,229 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,229 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2871 EMAIL CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2873 BUSINESS_AREA_ID CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2875 BUSINESS_LOCATION_ID CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2877 VANITY_URL_ENABLED CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2879 VANITY_URL CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2881 VANITY_TEXT_URL CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2883 BUSINESS_NAME CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2885 LOGO_ID CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2887 TEMPLATE_ID CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2889 DOMAIN_NAME CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2891 BRANCH_NAME CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2893 ADDRESS_LINE1 CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2895 ADDRESS_LINE2 CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2897 CITY CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2899 STATE CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2901 POSTAL_CODE CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2903 COUNTRY_CODE CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2905 SUPPRESS_ADDRESS CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2907 MAP_LOCATION CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2909 SUPPRESS_MAP CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2911 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2913 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2915 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2917 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2919 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,230 WARN [CustomerFieldDAOSpringJDBC] 531 455 2921 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,231 WARN [CustomerFieldDAOSpringJDBC] 531 455 2923 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,231 WARN [CustomerFieldDAOSpringJDBC] 531 455 2925 MERCHANT_ATTRIBUTE CUSTOMER 18:54:30,231 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,231 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,232 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,232 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, bpID, domain from mms_common.accounts where bpID = ?] 18:54:30,233 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 18:54:30,233 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'bpID' to property 'BPID' of type class java.lang.String 18:54:30,233 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'domain' to property 'domain' of type class java.lang.String 18:54:30,282 INFO [AdMaxDeploymentServiceImpl] Saving deployment status to 'Pending' for campaignID: deletecamp6-1_BRAND 18:54:30,286 INFO [AdMaxDeploymentServiceImpl] Starting deploy campign message conversion 18:54:30,291 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,291 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.blacklist where customerBpId = ?] 18:54:30,293 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 409 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload:
J2liD7QqhwnyuB0yNye4J2liD7QqhwnyuB0yNye4
queuedqueued -------------------------------------- 18:54:30,296 DEBUG [JdbcTemplate] Executing prepared SQL update 18:54:30,296 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into accounts (bpID, domain) values (?, ?) on duplicate key update domain = ?] 18:54:30,297 DEBUG [JdbcTemplate] SQL update affected 2 rows 18:54:30,297 INFO [AdMaxDeploymentServiceImpl] 1 Campaign(s) to process. 18:54:30,297 DEBUG [AdMaxDeploymentServiceImpl] Processing Customer CampaignInfo... 18:54:30,297 DEBUG [AdMaxDeploymentServiceImpl] Retrieving PrimaryBusinessLocationId [10000] 18:54:30,297 DEBUG [AdMaxDeploymentServiceImpl] Retrieving PrimaryBusinessAreaID [2000062] 18:54:30,304 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,304 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=?] 18:54:30,312 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,312 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=?] 18:54:30,313 DEBUG [AdMaxDeploymentServiceImpl] Retrieved PrimaryBusinessLocation Location: ID: 10000 Description: Old Adaminaby Short Description: Old Adaminaby Status: active Type: locality ParentBusinessLocationID: 3835 Use SE Defined Targets: false Use Point Radius Targets: true Is Sellable: true 18:54:30,313 DEBUG [AdMaxDeploymentServiceImpl] Retrieved PrimaryBusinessArea BusinessArea: ID: 2000062 Description: Bathroom Fitting and Installation Status: active BusinessCategoryID: 1000006 18:54:30,318 INFO [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0] 18:54:30,318 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,318 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?] 18:54:30,332 INFO [CustomerCampaignServiceBD] start readAll... 18:54:30,332 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,332 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customizableEntity WHERE entityId = ? AND type LIKE ?] 18:54:30,339 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,340 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customizableEntity WHERE entityId = ?] 18:54:30,340 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,340 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,341 WARN [CustomerFieldDAOSpringJDBC] 531 469 2935 KEYWORD CUSTOMER 18:54:30,341 WARN [CustomerFieldDAOSpringJDBC] 531 469 2937 KEYWORD_TYPE CUSTOMER 18:54:30,341 WARN [CustomerFieldDAOSpringJDBC] 531 469 2939 NEGATIVE CUSTOMER 18:54:30,341 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,341 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,341 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,342 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,342 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,342 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,342 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,342 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,343 WARN [CustomerFieldDAOSpringJDBC] 531 465 2933 BUSINESS_LOCATION_ID CUSTOMER 18:54:30,343 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,343 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,343 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,343 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,344 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,344 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,344 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,344 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,345 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,345 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,345 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,345 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,346 WARN [CustomerFieldDAOSpringJDBC] 531 459 2931 BUSINESS_LOCATION_ID CUSTOMER 18:54:30,346 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,346 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,346 INFO [CustomerCampaignServiceBD] end readAll... 18:54:30,349 INFO [CustomerCampaignServiceBD] start read(entityId, campaignId)... 18:54:30,349 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,349 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customizableEntity WHERE entityId = ?] 18:54:30,350 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,350 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,351 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,351 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,351 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,351 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,351 WARN [CustomerFieldDAOSpringJDBC] 531 469 2935 KEYWORD CUSTOMER 18:54:30,352 WARN [CustomerFieldDAOSpringJDBC] 531 469 2937 KEYWORD_TYPE CUSTOMER 18:54:30,352 WARN [CustomerFieldDAOSpringJDBC] 531 469 2939 NEGATIVE CUSTOMER 18:54:30,352 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,352 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,352 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,352 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customerField WHERE customizable_entity_id = ?] 18:54:30,352 WARN [CustomerFieldDAOSpringJDBC] 531 465 2933 BUSINESS_LOCATION_ID CUSTOMER 18:54:30,353 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,353 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM contentField WHERE customizable_entity_id = ?] 18:54:30,353 INFO [CustomerCampaignServiceBD] end read(entityId, campaignId)... 18:54:30,356 DEBUG [JdbcTemplate] Executing SQL query [select id, exemptionRegexTrigger, exemptionRequest from mms_common.exemptionRequests] 18:54:30,361 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 18:54:30,362 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'exemptionRegexTrigger' to property 'exemptionRegexTrigger' of type class java.lang.String 18:54:30,362 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'exemptionRequest' to property 'exemptionRequest' of type class java.lang.String 18:54:30,364 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,364 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 = ?] 18:54:30,364 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'id' to property 'ID' of type int 18:54:30,364 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'locationID' to property 'locationID' of type int 18:54:30,364 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'latitudeDegrees' to property 'latitudeDegrees' of type float 18:54:30,364 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'longitudeDegrees' to property 'longitudeDegrees' of type float 18:54:30,365 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'radiusMeters' to property 'radiusMeters' of type int 18:54:30,365 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'multiplier' to property 'multiplier' of type float 18:54:30,365 DEBUG [ParameterizedBeanPropertyRowMapper] Mapping column 'incrementer' to property 'incrementer' of type int 18:54:30,365 DEBUG [JdbcTemplate] Executing SQL query [select multiplier from pointRadiusModifiers where advertID is null] 18:54:30,365 INFO [AdMaxDeploymentServiceImpl] Using global radius multiplier of 1.0 18:54:30,366 DEBUG [JdbcTemplate] Executing prepared SQL update 18:54:30,366 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.customerCampaignIdMap (customerCampaignId, admaxCampaignId) values (?, ?) on duplicate key update customerCampaignId=values(customerCampaignId),admaxCampaignId=values(admaxCampaignId)] 18:54:30,366 DEBUG [JdbcTemplate] SQL update affected 2 rows 18:54:30,366 INFO [AdMaxDeploymentServiceImpl] Finished deploy campaign message conversion. 1 converted. 18:54:30,367 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,367 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?] 18:54:30,368 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,368 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from mms_common.requests r where r.requestType = ? and r.deploymentID = ?] 18:54:30,368 DEBUG [JdbcTemplate] Executing prepared SQL update 18:54:30,368 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into mms_common.requests(requestType, deploymentID) values (?, ?)] 18:54:30,369 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:54:30,388 INFO [AdMaxDeploymentRequestMDB] Sent DEPLOY request to listener. BPID: deletecamp6 DeployID: J2liD7QqhwnyuB0yNye4 18:54:30,446 DEBUG [JdbcTemplate] Executing prepared SQL query 18:54:30,446 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from admaxAccountAnniversary where accountId = ? and endDate is NULL] 18:54:56,821 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 18:54:56,821 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 18:54:56,822 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 18:54:56,836 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT