11:13:46,597 INFO [sqltiming] SELECT externalCampaignParent.description as 'amlCampaignID', `errors`.`errorJson` FROM `yjp`.`campaigns` JOIN `yjp`.`errors` ON `errors`.`campaignName` = `campaigns`.`name` JOIN clients.externalCampaign on gceCampaignID=campaigns.id JOIN tsacommon.searchEngineAccounts on searchEngineAccountID=searchEngineAccounts.id and distributionID=178 JOIN clients.externalCampaignParent on externalCampaignParentID=externalCampaignParent.id WHERE `campaigns`.`id` IN (1606,1607) {executed in 2 msec} 11:13:46,597 INFO [resultset] 19. ResultSet.new ResultSet returned 11:13:46,597 INFO [audit] 19. PreparedStatement.executeQuery() returned net.sf.log4jdbc.sql.jdbcapi.ResultSetSpy@3d0566b5 11:13:46,597 INFO [resultset] 19. ResultSet.next() returned true 11:13:46,597 INFO [resultset] 19. ResultSet.getString(errorJson) returned {"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GM","type":"AD_GROUP_ADS","key":"{KeyWord:???????????}.?????????????????1111.???ATV???????123.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096800} 11:13:46,598 INFO [resultset] 19. ResultSet.getString(amlCampaignID) returned 3176 11:13:46,736 INFO [resultset] 19. ResultSet.next() returned true 11:13:46,737 INFO [resultset] 19. ResultSet.getString(errorJson) returned {"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite1.com/"]}],"campaignName":"a300_150910_400001_3176_GM","type":"AD_GROUP_ADS","key":"??????????.???????????.???????????????.www.merchantsitetest.com.http://www.merchantsite1.com/","searchEngineId":null,"parentSearchEngineId":419096800} 11:13:46,737 INFO [resultset] 19. ResultSet.getString(amlCampaignID) returned 3176 11:13:46,737 INFO [resultset] 19. ResultSet.next() returned true 11:13:46,737 INFO [resultset] 19. ResultSet.getString(errorJson) returned {"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GM","type":"AD_GROUP_ADS","key":"{KeyWord:??????????}.???????????????.???????????.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096800} 11:13:46,737 INFO [resultset] 19. ResultSet.getString(amlCampaignID) returned 3176 11:13:46,737 INFO [resultset] 19. ResultSet.next() returned true 11:13:46,737 INFO [resultset] 19. ResultSet.getString(errorJson) returned {"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GT","type":"AD_GROUP_ADS","key":"{KeyWord:???????????}.?????????????????1111.???ATV???????123.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096801} 11:13:46,737 INFO [resultset] 19. ResultSet.getString(amlCampaignID) returned 3176 11:13:46,738 INFO [resultset] 19. ResultSet.next() returned true 11:13:46,738 INFO [resultset] 19. ResultSet.getString(errorJson) returned {"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite1.com/"]}],"campaignName":"a300_150910_400001_3176_GT","type":"AD_GROUP_ADS","key":"??????????.???????????.???????????????.www.merchantsitetest.com.http://www.merchantsite1.com/","searchEngineId":null,"parentSearchEngineId":419096801} 11:13:46,738 INFO [resultset] 19. ResultSet.getString(amlCampaignID) returned 3176 11:13:46,738 INFO [resultset] 19. ResultSet.next() returned true 11:13:46,738 INFO [resultset] 19. ResultSet.getString(errorJson) returned {"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GT","type":"AD_GROUP_ADS","key":"{KeyWord:??????????}.???????????????.???????????.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096801} 11:13:46,738 INFO [resultset] 19. ResultSet.getString(amlCampaignID) returned 3176 11:13:46,740 INFO [resultsettable] |------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| |description |errorjson | |------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| |3176 |{"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GM","type":"AD_GROUP_ADS","key":"{KeyWord:???????????}.?????????????????1111.???ATV???????123.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096800} | |3176 |{"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite1.com/"]}],"campaignName":"a300_150910_400001_3176_GM","type":"AD_GROUP_ADS","key":"??????????.???????????.???????????????.www.merchantsitetest.com.http://www.merchantsite1.com/","searchEngineId":null,"parentSearchEngineId":419096800} | |3176 |{"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GM","type":"AD_GROUP_ADS","key":"{KeyWord:??????????}.???????????????.???????????.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096800} | |3176 |{"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GT","type":"AD_GROUP_ADS","key":"{KeyWord:???????????}.?????????????????1111.???ATV???????123.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096801} | |3176 |{"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite1.com/"]}],"campaignName":"a300_150910_400001_3176_GT","type":"AD_GROUP_ADS","key":"??????????.???????????.???????????????.www.merchantsitetest.com.http://www.merchantsite1.com/","searchEngineId":null,"parentSearchEngineId":419096801} | |3176 |{"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GT","type":"AD_GROUP_ADS","key":"{KeyWord:??????????}.???????????????.???????????.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096801} | |------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| 11:13:46,740 INFO [resultset] 19. ResultSet.next() returned false 11:13:46,741 INFO [resultset] 19. ResultSet.close() returned void 11:13:46,742 INFO [audit] 19. PreparedStatement.getWarnings() returned null 11:13:46,742 INFO [audit] 19. PreparedStatement.close() returned 11:13:46,742 INFO [connection] 19. Connection closed 11:13:46,742 INFO [audit] 19. Connection.close() returned 11:13:46,745 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 187 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload: -------------------------------------- 11:13:46,770 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 188 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=[305], SOAPAction=[""], user-agent=[Apache CXF 3.0.7], Content-Type=[text/xml; charset=UTF-8], Accept=[*/*], pragma=[no-cache]} Payload: 3176 -------------------------------------- 11:13:46,771 DEBUG [JdbcTemplate] Executing prepared SQL query 11:13:46,771 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT distribution, advertID as parentCampaignID, externalCampaign.id as childCampaignID, gceCampaignID, searchEngineAccounts.description as distributionCampaignName, keywordListID from mms_common.campaigns join clients.externalCampaignParent on (campaigns.advertID = externalCampaignParent.description) join clients.externalCampaign on (externalCampaignParentID=externalCampaignParent.id) join tsacommon.searchEngineAccounts on searchEngineAccountID = searchEngineAccounts.id where campaigns.advertID in (?) AND externalCampaign.enabled=?] 11:13:46,774 DEBUG [JdbcTemplate] Executing prepared SQL query 11:13:46,774 DEBUG [JdbcTemplate] Executing prepared SQL statement [ SELECT externalCampaignParent.description as 'amlCampaignID', `errors`.`errorJson` FROM `yjp`.`campaigns` JOIN `yjp`.`errors` ON `errors`.`campaignName` = `campaigns`.`name` JOIN clients.externalCampaign on gceCampaignID=campaigns.id JOIN tsacommon.searchEngineAccounts on searchEngineAccountID=searchEngineAccounts.id and distributionID=178 JOIN clients.externalCampaignParent on externalCampaignParentID=externalCampaignParent.id WHERE `campaigns`.`id` IN (?,?)] 11:13:46,777 INFO [connection] 20. Connection opened 11:13:46,777 INFO [audit] 20. Connection.new Connection returned 11:13:46,777 INFO [audit] null. DataSource.getConnection() returned 11:13:46,777 INFO [audit] 20. PreparedStatement.new PreparedStatement returned 11:13:46,778 INFO [audit] 20. Connection.prepareStatement( SELECT externalCampaignParent.description as 'amlCampaignID', `errors`.`errorJson` FROM `yjp`.`campaigns` JOIN `yjp`.`errors` ON `errors`.`campaignName` = `campaigns`.`name` JOIN clients.externalCampaign on gceCampaignID=campaigns.id JOIN tsacommon.searchEngineAccounts on searchEngineAccountID=searchEngineAccounts.id and distributionID=178 JOIN clients.externalCampaignParent on externalCampaignParentID=externalCampaignParent.id WHERE `campaigns`.`id` IN (?,?)) returned net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy@38bd7c64 11:13:46,778 INFO [audit] 20. PreparedStatement.setObject(1, 1606) returned 11:13:46,778 INFO [audit] 20. PreparedStatement.setObject(2, 1607) returned 11:13:46,778 INFO [sqlonly] SELECT externalCampaignParent.description as 'amlCampaignID', `errors`.`errorJson` FROM `yjp`.`campaigns` JOIN `yjp`.`errors` ON `errors`.`campaignName` = `campaigns`.`name` JOIN clients.externalCampaign on gceCampaignID=campaigns.id JOIN tsacommon.searchEngineAccounts on searchEngineAccountID=searchEngineAccounts.id and distributionID=178 JOIN clients.externalCampaignParent on externalCampaignParentID=externalCampaignParent.id WHERE `campaigns`.`id` IN (1606,1607) 11:13:46,779 INFO [sqltiming] SELECT externalCampaignParent.description as 'amlCampaignID', `errors`.`errorJson` FROM `yjp`.`campaigns` JOIN `yjp`.`errors` ON `errors`.`campaignName` = `campaigns`.`name` JOIN clients.externalCampaign on gceCampaignID=campaigns.id JOIN tsacommon.searchEngineAccounts on searchEngineAccountID=searchEngineAccounts.id and distributionID=178 JOIN clients.externalCampaignParent on externalCampaignParentID=externalCampaignParent.id WHERE `campaigns`.`id` IN (1606,1607) {executed in 1 msec} 11:13:46,779 INFO [resultset] 20. ResultSet.new ResultSet returned 11:13:46,779 INFO [audit] 20. PreparedStatement.executeQuery() returned net.sf.log4jdbc.sql.jdbcapi.ResultSetSpy@2031a656 11:13:46,779 INFO [resultset] 20. ResultSet.next() returned true 11:13:46,780 INFO [resultset] 20. ResultSet.getString(errorJson) returned {"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GM","type":"AD_GROUP_ADS","key":"{KeyWord:???????????}.?????????????????1111.???ATV???????123.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096800} 11:13:46,780 INFO [resultset] 20. ResultSet.getString(amlCampaignID) returned 3176 11:13:46,780 INFO [resultset] 20. ResultSet.next() returned true 11:13:46,780 INFO [resultset] 20. ResultSet.getString(errorJson) returned {"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite1.com/"]}],"campaignName":"a300_150910_400001_3176_GM","type":"AD_GROUP_ADS","key":"??????????.???????????.???????????????.www.merchantsitetest.com.http://www.merchantsite1.com/","searchEngineId":null,"parentSearchEngineId":419096800} 11:13:46,780 INFO [resultset] 20. ResultSet.getString(amlCampaignID) returned 3176 11:13:46,781 INFO [resultset] 20. ResultSet.next() returned true 11:13:46,782 INFO [resultset] 20. ResultSet.getString(errorJson) returned {"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GM","type":"AD_GROUP_ADS","key":"{KeyWord:??????????}.???????????????.???????????.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096800} 11:13:46,782 INFO [resultset] 20. ResultSet.getString(amlCampaignID) returned 3176 11:13:46,782 INFO [resultset] 20. ResultSet.next() returned true 11:13:46,782 INFO [resultset] 20. ResultSet.getString(errorJson) returned {"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GT","type":"AD_GROUP_ADS","key":"{KeyWord:???????????}.?????????????????1111.???ATV???????123.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096801} 11:13:46,782 INFO [resultset] 20. ResultSet.getString(amlCampaignID) returned 3176 11:13:46,783 INFO [resultset] 20. ResultSet.next() returned true 11:13:46,783 INFO [resultset] 20. ResultSet.getString(errorJson) returned {"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite1.com/"]}],"campaignName":"a300_150910_400001_3176_GT","type":"AD_GROUP_ADS","key":"??????????.???????????.???????????????.www.merchantsitetest.com.http://www.merchantsite1.com/","searchEngineId":null,"parentSearchEngineId":419096801} 11:13:46,783 INFO [resultset] 20. ResultSet.getString(amlCampaignID) returned 3176 11:13:46,783 INFO [resultset] 20. ResultSet.next() returned true 11:13:46,784 INFO [resultset] 20. ResultSet.getString(errorJson) returned {"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GT","type":"AD_GROUP_ADS","key":"{KeyWord:??????????}.???????????????.???????????.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096801} 11:13:46,784 INFO [resultset] 20. ResultSet.getString(amlCampaignID) returned 3176 11:13:46,785 INFO [resultsettable] |------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| |description |errorjson | |------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| |3176 |{"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GM","type":"AD_GROUP_ADS","key":"{KeyWord:???????????}.?????????????????1111.???ATV???????123.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096800} | |3176 |{"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite1.com/"]}],"campaignName":"a300_150910_400001_3176_GM","type":"AD_GROUP_ADS","key":"??????????.???????????.???????????????.www.merchantsitetest.com.http://www.merchantsite1.com/","searchEngineId":null,"parentSearchEngineId":419096800} | |3176 |{"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GM","type":"AD_GROUP_ADS","key":"{KeyWord:??????????}.???????????????.???????????.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096800} | |3176 |{"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GT","type":"AD_GROUP_ADS","key":"{KeyWord:???????????}.?????????????????1111.???ATV???????123.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096801} | |3176 |{"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite1.com/"]}],"campaignName":"a300_150910_400001_3176_GT","type":"AD_GROUP_ADS","key":"??????????.???????????.???????????????.www.merchantsitetest.com.http://www.merchantsite1.com/","searchEngineId":null,"parentSearchEngineId":419096801} | |3176 |{"code":"211003","message":"Domain does not match with DisplayURL.","errorDetailEntityList":[{"requestKey":"ad/displayUrl","requestValues":["www.merchantsitetest.com"]},{"requestKey":"ad/advancedUrl","requestValues":["http://www.merchantsite.com/"]}],"campaignName":"a300_150910_400001_3176_GT","type":"AD_GROUP_ADS","key":"{KeyWord:??????????}.???????????????.???????????.www.merchantsitetest.com.http://www.merchantsite.com/","searchEngineId":null,"parentSearchEngineId":419096801} | |------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|