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} |
|------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|