2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.connection:541 - 98. Connection opened 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. Connection.new Connection returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - null. DataSource.getConnection() returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.new PreparedStatement returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. Connection.prepareStatement(DELETE FROM `errors` WHERE `campaignName` IN (?,?)) returned net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy@14fcf3a9 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.setString(1, "a195_162547_401011_2398_GT") returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.setString(2, "a195_162547_401011_2398_GM") returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.sqlonly:228 - DELETE FROM `errors` WHERE `campaignName` IN ('a195_162547_401011_2398_GT','a195_162547_401011_2398_GM') 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.sqltiming:373 - DELETE FROM `errors` WHERE `campaignName` IN ('a195_162547_401011_2398_GT','a195_162547_401011_2398_GM') {executed in 1 msec} 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.executeUpdate() returned 0 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.close() returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] com.thesearchagency.services.client.yahoojapan.dao.YahooErrorDAO:193 - Removed '0' Previous Errors 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.new PreparedStatement returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. Connection.prepareStatement(INSERT INTO `campaigns` (`yahooId`, `name`, `status`, `lastUpdated`, `json`) VALUES (?, ?, ?, NOW(), ?)) returned net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy@5bcaeafb 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.setObject(1, 1319262) returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.setString(2, "a195_162547_401011_2398_GT") returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.setString(3, "PAUSED") returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.setString(4, "{"campaign":{"name":"a195_162547_401011_2398_GT","startDate":"20160512","endDate":null,"status":"PAUSED","budgetAmount":100,"searchEngineId":1319262},"adGroupStructures":[{"adGroup":{"name":"a195_162547_401011_2398","id":425048502,"status":"ACTIVE","keywordMaxCpc":30},"positiveKeywords":[{"url":null,"status":"ACTIVE","id":1057233579,"text":"????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233580,"text":"?? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233581,"text":"???? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233582,"text":"????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233583,"text":"???????? ??","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233584,"text":"??????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233585,"text":"?????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233586,"text":"???????? ???","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233587,"text":"???????? ?????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233588,"text":"????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233589,"text":"?? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233590,"text":"????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233591,"text":"???????? ??????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233592,"text":"?? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233593,"text":"??????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233594,"text":"?????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233595,"text":"? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233596,"text":"?????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233597,"text":"???????? ??","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233598,"text":"?????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233599,"text":"???????? ??????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233600,"text":"?????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233601,"text":"????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233602,"text":"?????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233603,"text":"????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233604,"text":"? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233605,"text":"????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233606,"text":"????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233607,"text":"?? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233608,"text":"???????? ?????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233609,"text":"?????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233610,"text":"???????? ???","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233611,"text":"???????? ??","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233612,"text":"???? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233613,"text":"?????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233614,"text":"???????? ??","matchType":"BROAD"}],"ads":[{"name":"4edc7ef8-2c3f-483f-9a89-0149a14fd1f9","id":532558181,"description":"???????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:????????????}","description2":"???????????????","displayUrl":"http://admaxlocal.com"},{"name":"00264cd3-7ea4-4f70-920f-8b508172c2f1","id":532558182,"description":"???????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"??????????????","description2":"??????????????????","displayUrl":"http://admaxlocal.com"},{"name":"c0a77a74-9073-4bf8-8c63-76dd955e1d89","id":532558183,"description":"???????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"????????????","description2":"???????????????????","displayUrl":"http://admaxlocal.com"},{"name":"7152de90-83fa-4720-90d3-5b37b935a58d","id":532558184,"description":"??????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:??????????????}","description2":"???????","displayUrl":"http://admaxlocal.com"}]}],"campaignTargets":[{"target":{"id":"JP-47-0016","type":"LOCATION","exclude":false},"campaignId":1319262,"bidMultiplier":null}],"negativeKeywords":[{"id":92295587,"text":"???","matchType":"PHRASE"},{"id":92295588,"text":"??????","matchType":"EXACT"},{"id":92295589,"text":"??","matchType":"PHRASE"},{"id":92295590,"text":"??????","matchType":"EXACT"},{"id":92295591,"text":"??","matchType":"EXACT"},{"id":92295592,"text":"????","matchType":"PHRASE"},{"id":92295593,"text":"??","matchType":"PHRASE"},{"id":92295594,"text":"2ch","matchType":"PHRASE"},{"id":92295595,"text":"????????","matchType":"EXACT"},{"id":92295596,"text":"????","matchType":"PHRASE"},{"id":92295597,"text":"???","matchType":"PHRASE"},{"id":92295598,"text":"???","matchType":"PHRASE"},{"id":92295599,"text":"??","matchType":"PHRASE"},{"id":92295600,"text":"??","matchType":"PHRASE"},{"id":92295601,"text":"??","matchType":"PHRASE"},{"id":92295602,"text":"??","matchType":"PHRASE"},{"id":92295603,"text":"??","matchType":"PHRASE"}],"callExtensions":null,"quickLinks":null,"callExtensionCampaignFeeds":null,"quickLinkCampaignFeeds":null}") returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.sqlonly:228 - INSERT INTO `campaigns` (`yahooId`, `name`, `status`, `lastUpdated`, `json`) VALUES (1319262, 'a195_162547_401011_2398_GT', 'PAUSED', NOW(), '{"campaign":{"name":"a195_162547_401011_2398_GT","startDate":"20160512","endDate":null,"status":"PAUSED","budgetAmount":100,"searchEngineId":1319262},"adGroupStructures":[{"adGroup":{"name":"a195_162547_401011_2398","id":425048502,"status":"ACTIVE","keywordMaxCpc":30},"positiveKeywords":[{"url":null,"status":"ACTIVE","id":1057233579,"text":"????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233580,"text":"?? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233581,"text":"???? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233582,"text":"????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233583,"text":"???????? ??","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233584,"text":"??????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233585,"text":"?????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233586,"text":"???????? ???","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233587,"text":"???????? ?????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233588,"text":"????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233589,"text":"?? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233590,"text":"????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233591,"text":"???????? ??????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233592,"text":"?? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233593,"text":"??????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233594,"text":"?????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233595,"text":"? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233596,"text":"?????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233597,"text":"???????? ??","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233598,"text":"?????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233599,"text":"???????? ??????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233600,"text":"?????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233601,"text":"????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233602,"text":"?????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233603,"text":"????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233604,"text":"? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233605,"text":"????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233606,"text":"????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233607,"text":"?? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233608,"text":"???????? ?????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233609,"text":"?????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233610,"text":"???????? ???","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233611,"text":"???????? ??","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233612,"text":"???? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233613,"text":"?????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233614,"text":"???????? ??","matchType":"BROAD"}],"ads":[{"name":"4edc7ef8-2c3f-483f-9a89-0149a14fd1f9","id":532558181,"description":"???????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:????????????}","description2":"???????????????","displayUrl":"http://admaxlocal.com"},{"name":"00264cd3-7ea4-4f70-920f-8b508172c2f1","id":532558182,"description":"???????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"??????????????","description2":"??????????????????","displayUrl":"http://admaxlocal.com"},{"name":"c0a77a74-9073-4bf8-8c63-76dd955e1d89","id":532558183,"description":"???????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"????????????","description2":"???????????????????","displayUrl":"http://admaxlocal.com"},{"name":"7152de90-83fa-4720-90d3-5b37b935a58d","id":532558184,"description":"??????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:??????????????}","description2":"???????","displayUrl":"http://admaxlocal.com"}]}],"campaignTargets":[{"target":{"id":"JP-47-0016","type":"LOCATION","exclude":false},"campaignId":1319262,"bidMultiplier":null}],"negativeKeywords":[{"id":92295587,"text":"???","matchType":"PHRASE"},{"id":92295588,"text":"??????","matchType":"EXACT"},{"id":92295589,"text":"??","matchType":"PHRASE"},{"id":92295590,"text":"??????","matchType":"EXACT"},{"id":92295591,"text":"??","matchType":"EXACT"},{"id":92295592,"text":"????","matchType":"PHRASE"},{"id":92295593,"text":"??","matchType":"PHRASE"},{"id":92295594,"text":"2ch","matchType":"PHRASE"},{"id":92295595,"text":"????????","matchType":"EXACT"},{"id":92295596,"text":"????","matchType":"PHRASE"},{"id":92295597,"text":"???","matchType":"PHRASE"},{"id":92295598,"text":"???","matchType":"PHRASE"},{"id":92295599,"text":"??","matchType":"PHRASE"},{"id":92295600,"text":"??","matchType":"PHRASE"},{"id":92295601,"text":"??","matchType":"PHRASE"},{"id":92295602,"text":"??","matchType":"PHRASE"},{"id":92295603,"text":"??","matchType":"PHRASE"}],"callExtensions":null,"quickLinks":null,"callExtensionCampaignFeeds":null,"quickLinkCampaignFeeds":null}') 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.sqltiming:373 - INSERT INTO `campaigns` (`yahooId`, `name`, `status`, `lastUpdated`, `json`) VALUES (1319262, 'a195_162547_401011_2398_GT', 'PAUSED', NOW(), '{"campaign":{"name":"a195_162547_401011_2398_GT","startDate":"20160512","endDate":null,"status":"PAUSED","budgetAmount":100,"searchEngineId":1319262},"adGroupStructures":[{"adGroup":{"name":"a195_162547_401011_2398","id":425048502,"status":"ACTIVE","keywordMaxCpc":30},"positiveKeywords":[{"url":null,"status":"ACTIVE","id":1057233579,"text":"????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233580,"text":"?? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233581,"text":"???? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233582,"text":"????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233583,"text":"???????? ??","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233584,"text":"??????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233585,"text":"?????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233586,"text":"???????? ???","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233587,"text":"???????? ?????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233588,"text":"????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233589,"text":"?? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233590,"text":"????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233591,"text":"???????? ??????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233592,"text":"?? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233593,"text":"??????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233594,"text":"?????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233595,"text":"? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233596,"text":"?????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233597,"text":"???????? ??","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233598,"text":"?????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233599,"text":"???????? ??????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233600,"text":"?????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233601,"text":"????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233602,"text":"?????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233603,"text":"????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233604,"text":"? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233605,"text":"????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233606,"text":"????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233607,"text":"?? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233608,"text":"???????? ?????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233609,"text":"?????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233610,"text":"???????? ???","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233611,"text":"???????? ??","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233612,"text":"???? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233613,"text":"?????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233614,"text":"???????? ??","matchType":"BROAD"}],"ads":[{"name":"4edc7ef8-2c3f-483f-9a89-0149a14fd1f9","id":532558181,"description":"???????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:????????????}","description2":"???????????????","displayUrl":"http://admaxlocal.com"},{"name":"00264cd3-7ea4-4f70-920f-8b508172c2f1","id":532558182,"description":"???????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"??????????????","description2":"??????????????????","displayUrl":"http://admaxlocal.com"},{"name":"c0a77a74-9073-4bf8-8c63-76dd955e1d89","id":532558183,"description":"???????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"????????????","description2":"???????????????????","displayUrl":"http://admaxlocal.com"},{"name":"7152de90-83fa-4720-90d3-5b37b935a58d","id":532558184,"description":"??????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:??????????????}","description2":"???????","displayUrl":"http://admaxlocal.com"}]}],"campaignTargets":[{"target":{"id":"JP-47-0016","type":"LOCATION","exclude":false},"campaignId":1319262,"bidMultiplier":null}],"negativeKeywords":[{"id":92295587,"text":"???","matchType":"PHRASE"},{"id":92295588,"text":"??????","matchType":"EXACT"},{"id":92295589,"text":"??","matchType":"PHRASE"},{"id":92295590,"text":"??????","matchType":"EXACT"},{"id":92295591,"text":"??","matchType":"EXACT"},{"id":92295592,"text":"????","matchType":"PHRASE"},{"id":92295593,"text":"??","matchType":"PHRASE"},{"id":92295594,"text":"2ch","matchType":"PHRASE"},{"id":92295595,"text":"????????","matchType":"EXACT"},{"id":92295596,"text":"????","matchType":"PHRASE"},{"id":92295597,"text":"???","matchType":"PHRASE"},{"id":92295598,"text":"???","matchType":"PHRASE"},{"id":92295599,"text":"??","matchType":"PHRASE"},{"id":92295600,"text":"??","matchType":"PHRASE"},{"id":92295601,"text":"??","matchType":"PHRASE"},{"id":92295602,"text":"??","matchType":"PHRASE"},{"id":92295603,"text":"??","matchType":"PHRASE"}],"callExtensions":null,"quickLinks":null,"callExtensionCampaignFeeds":null,"quickLinkCampaignFeeds":null}') {executed in 1 msec} 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.executeUpdate() returned 1 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.close() returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.new PreparedStatement returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. Connection.prepareStatement(SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`yahooId` = ?) returned net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy@3aabb10 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.setObject(1, 1319262) returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.sqlonly:228 - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`yahooId` = 1319262 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.sqltiming:373 - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`yahooId` = 1319262 {executed in 2 msec} 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultset:175 - 98. ResultSet.new ResultSet returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.executeQuery() returned net.sf.log4jdbc.sql.jdbcapi.ResultSetSpy@3ddf1951 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultset:175 - 98. ResultSet.next() returned true 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultset:175 - 98. ResultSet.getString(json) returned {"campaign":{"name":"a195_162547_401011_2398_GT","startDate":"20160512","endDate":null,"status":"PAUSED","budgetAmount":100,"searchEngineId":1319262},"adGroupStructures":[{"adGroup":{"name":"a195_162547_401011_2398","id":425048502,"status":"ACTIVE","keywordMaxCpc":30},"positiveKeywords":[{"url":null,"status":"ACTIVE","id":1057233579,"text":"????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233580,"text":"?? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233581,"text":"???? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233582,"text":"????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233583,"text":"???????? ??","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233584,"text":"??????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233585,"text":"?????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233586,"text":"???????? ???","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233587,"text":"???????? ?????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233588,"text":"????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233589,"text":"?? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233590,"text":"????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233591,"text":"???????? ??????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233592,"text":"?? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233593,"text":"??????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233594,"text":"?????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233595,"text":"? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233596,"text":"?????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233597,"text":"???????? ??","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233598,"text":"?????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233599,"text":"???????? ??????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233600,"text":"?????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233601,"text":"????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233602,"text":"?????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233603,"text":"????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233604,"text":"? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233605,"text":"????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233606,"text":"????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233607,"text":"?? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233608,"text":"???????? ?????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233609,"text":"?????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233610,"text":"???????? ???","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233611,"text":"???????? ??","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233612,"text":"???? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233613,"text":"?????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233614,"text":"???????? ??","matchType":"BROAD"}],"ads":[{"name":"4edc7ef8-2c3f-483f-9a89-0149a14fd1f9","id":532558181,"description":"???????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:????????????}","description2":"???????????????","displayUrl":"http://admaxlocal.com"},{"name":"00264cd3-7ea4-4f70-920f-8b508172c2f1","id":532558182,"description":"???????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"??????????????","description2":"??????????????????","displayUrl":"http://admaxlocal.com"},{"name":"c0a77a74-9073-4bf8-8c63-76dd955e1d89","id":532558183,"description":"???????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"????????????","description2":"???????????????????","displayUrl":"http://admaxlocal.com"},{"name":"7152de90-83fa-4720-90d3-5b37b935a58d","id":532558184,"description":"??????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:??????????????}","description2":"???????","displayUrl":"http://admaxlocal.com"}]}],"campaignTargets":[{"target":{"id":"JP-47-0016","type":"LOCATION","exclude":false},"campaignId":1319262,"bidMultiplier":null}],"negativeKeywords":[{"id":92295587,"text":"???","matchType":"PHRASE"},{"id":92295588,"text":"??????","matchType":"EXACT"},{"id":92295589,"text":"??","matchType":"PHRASE"},{"id":92295590,"text":"??????","matchType":"EXACT"},{"id":92295591,"text":"??","matchType":"EXACT"},{"id":92295592,"text":"????","matchType":"PHRASE"},{"id":92295593,"text":"??","matchType":"PHRASE"},{"id":92295594,"text":"2ch","matchType":"PHRASE"},{"id":92295595,"text":"????????","matchType":"EXACT"},{"id":92295596,"text":"????","matchType":"PHRASE"},{"id":92295597,"text":"???","matchType":"PHRASE"},{"id":92295598,"text":"???","matchType":"PHRASE"},{"id":92295599,"text":"??","matchType":"PHRASE"},{"id":92295600,"text":"??","matchType":"PHRASE"},{"id":92295601,"text":"??","matchType":"PHRASE"},{"id":92295602,"text":"??","matchType":"PHRASE"},{"id":92295603,"text":"??","matchType":"PHRASE"}],"callExtensions":null,"quickLinks":null,"callExtensionCampaignFeeds":null,"quickLinkCampaignFeeds":null} 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultset:175 - 98. ResultSet.getInt(id) returned 1274 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultsettable:610 - |-----|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| |id |json | |-----|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| |1274 |{"campaign":{"name":"a195_162547_401011_2398_GT","startDate":"20160512","endDate":null,"status":"PAUSED","budgetAmount":100,"searchEngineId":1319262},"adGroupStructures":[{"adGroup":{"name":"a195_162547_401011_2398","id":425048502,"status":"ACTIVE","keywordMaxCpc":30},"positiveKeywords":[{"url":null,"status":"ACTIVE","id":1057233579,"text":"????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233580,"text":"?? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233581,"text":"???? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233582,"text":"????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233583,"text":"???????? ??","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233584,"text":"??????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233585,"text":"?????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233586,"text":"???????? ???","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233587,"text":"???????? ?????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233588,"text":"????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233589,"text":"?? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233590,"text":"????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233591,"text":"???????? ??????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233592,"text":"?? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233593,"text":"??????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233594,"text":"?????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233595,"text":"? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233596,"text":"?????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233597,"text":"???????? ??","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233598,"text":"?????? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233599,"text":"???????? ??????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233600,"text":"?????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233601,"text":"????????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233602,"text":"?????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233603,"text":"????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233604,"text":"? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233605,"text":"????? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233606,"text":"????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233607,"text":"?? ????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233608,"text":"???????? ?????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233609,"text":"?????????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233610,"text":"???????? ???","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233611,"text":"???????? ??","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233612,"text":"???? ????????","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233613,"text":"?????????","matchType":"EXACT"},{"url":null,"status":"ACTIVE","id":1057233614,"text":"???????? ??","matchType":"BROAD"}],"ads":[{"name":"4edc7ef8-2c3f-483f-9a89-0149a14fd1f9","id":532558181,"description":"???????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:????????????}","description2":"???????????????","displayUrl":"http://admaxlocal.com"},{"name":"00264cd3-7ea4-4f70-920f-8b508172c2f1","id":532558182,"description":"???????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"??????????????","description2":"??????????????????","displayUrl":"http://admaxlocal.com"},{"name":"c0a77a74-9073-4bf8-8c63-76dd955e1d89","id":532558183,"description":"???????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"????????????","description2":"???????????????????","displayUrl":"http://admaxlocal.com"},{"name":"7152de90-83fa-4720-90d3-5b37b935a58d","id":532558184,"description":"??????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:??????????????}","description2":"???????","displayUrl":"http://admaxlocal.com"}]}],"campaignTargets":[{"target":{"id":"JP-47-0016","type":"LOCATION","exclude":false},"campaignId":1319262,"bidMultiplier":null}],"negativeKeywords":[{"id":92295587,"text":"???","matchType":"PHRASE"},{"id":92295588,"text":"??????","matchType":"EXACT"},{"id":92295589,"text":"??","matchType":"PHRASE"},{"id":92295590,"text":"??????","matchType":"EXACT"},{"id":92295591,"text":"??","matchType":"EXACT"},{"id":92295592,"text":"????","matchType":"PHRASE"},{"id":92295593,"text":"??","matchType":"PHRASE"},{"id":92295594,"text":"2ch","matchType":"PHRASE"},{"id":92295595,"text":"????????","matchType":"EXACT"},{"id":92295596,"text":"????","matchType":"PHRASE"},{"id":92295597,"text":"???","matchType":"PHRASE"},{"id":92295598,"text":"???","matchType":"PHRASE"},{"id":92295599,"text":"??","matchType":"PHRASE"},{"id":92295600,"text":"??","matchType":"PHRASE"},{"id":92295601,"text":"??","matchType":"PHRASE"},{"id":92295602,"text":"??","matchType":"PHRASE"},{"id":92295603,"text":"??","matchType":"PHRASE"}],"callExtensions":null,"quickLinks":null,"callExtensionCampaignFeeds":null,"quickLinkCampaignFeeds":null} | |-----|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultset:175 - 98. ResultSet.next() returned false 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultset:175 - 98. ResultSet.close() returned void 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.close() returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.new PreparedStatement returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. Connection.prepareStatement(INSERT INTO `campaigns` (`yahooId`, `name`, `status`, `lastUpdated`, `json`) VALUES (?, ?, ?, NOW(), ?)) returned net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy@33a16ecb 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.setObject(1, 1319263) returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.setString(2, "a195_162547_401011_2398_GM") returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.setString(3, "PAUSED") returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.setString(4, "{"campaign":{"name":"a195_162547_401011_2398_GM","startDate":"20160512","endDate":null,"status":"PAUSED","budgetAmount":100,"searchEngineId":1319263},"adGroupStructures":[{"adGroup":{"name":"a195_162547_401011_2398_???","id":425048503,"status":"ACTIVE","keywordMaxCpc":30},"positiveKeywords":[{"url":null,"status":"ACTIVE","id":1057233615,"text":"+?? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233616,"text":"+???????? +?? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233617,"text":"+????????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233618,"text":"+???? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233619,"text":"+????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233620,"text":"+???????? +??? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233621,"text":"+?????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233622,"text":"+????????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233623,"text":"+?? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233624,"text":"+????? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233625,"text":"+????? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233626,"text":"+???????? +?? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233627,"text":"+???????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233628,"text":"+???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233629,"text":"+???????? +?????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233630,"text":"+???????? +????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233631,"text":"+? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233632,"text":"+?????? +???????? +??? ","matchType":"BROAD"}],"ads":[{"name":"2ef2c782-1da1-4467-8468-6ba7860191ec","id":532558186,"description":"???????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:????????????}","description2":"???????????????","displayUrl":"http://admaxlocal.com"},{"name":"9cba9ed1-7087-4057-8bb9-25f2d1d7cbbe","id":532558187,"description":"???????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"??????????????","description2":"??????????????????","displayUrl":"http://admaxlocal.com"},{"name":"7a5a647d-41f4-4338-9585-e6d4dd85c8fd","id":532558188,"description":"???????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"????????????","description2":"???????????????????","displayUrl":"http://admaxlocal.com"},{"name":"607870b5-e63d-4469-8467-81795f18c48d","id":532558189,"description":"??????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:??????????????}","description2":"???????","displayUrl":"http://admaxlocal.com"}]}],"campaignTargets":null,"negativeKeywords":[{"id":92295604,"text":"???","matchType":"PHRASE"},{"id":92295605,"text":"??????","matchType":"EXACT"},{"id":92295606,"text":"??","matchType":"PHRASE"},{"id":92295607,"text":"??????","matchType":"EXACT"},{"id":92295608,"text":"??","matchType":"EXACT"},{"id":92295609,"text":"????","matchType":"PHRASE"},{"id":92295610,"text":"??","matchType":"PHRASE"},{"id":92295611,"text":"2ch","matchType":"PHRASE"},{"id":92295612,"text":"????????","matchType":"EXACT"},{"id":92295613,"text":"????","matchType":"PHRASE"},{"id":92295614,"text":"???","matchType":"PHRASE"},{"id":92295615,"text":"???","matchType":"PHRASE"},{"id":92295616,"text":"??","matchType":"PHRASE"},{"id":92295617,"text":"??","matchType":"PHRASE"},{"id":92295618,"text":"??","matchType":"PHRASE"},{"id":92295619,"text":"??","matchType":"PHRASE"},{"id":92295620,"text":"??","matchType":"PHRASE"}],"callExtensions":null,"quickLinks":null,"callExtensionCampaignFeeds":null,"quickLinkCampaignFeeds":null}") returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.sqlonly:228 - INSERT INTO `campaigns` (`yahooId`, `name`, `status`, `lastUpdated`, `json`) VALUES (1319263, 'a195_162547_401011_2398_GM', 'PAUSED', NOW(), '{"campaign":{"name":"a195_162547_401011_2398_GM","startDate":"20160512","endDate":null,"status":"PAUSED","budgetAmount":100,"searchEngineId":1319263},"adGroupStructures":[{"adGroup":{"name":"a195_162547_401011_2398_???","id":425048503,"status":"ACTIVE","keywordMaxCpc":30},"positiveKeywords":[{"url":null,"status":"ACTIVE","id":1057233615,"text":"+?? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233616,"text":"+???????? +?? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233617,"text":"+????????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233618,"text":"+???? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233619,"text":"+????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233620,"text":"+???????? +??? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233621,"text":"+?????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233622,"text":"+????????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233623,"text":"+?? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233624,"text":"+????? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233625,"text":"+????? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233626,"text":"+???????? +?? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233627,"text":"+???????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233628,"text":"+???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233629,"text":"+???????? +?????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233630,"text":"+???????? +????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233631,"text":"+? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233632,"text":"+?????? +???????? +??? ","matchType":"BROAD"}],"ads":[{"name":"2ef2c782-1da1-4467-8468-6ba7860191ec","id":532558186,"description":"???????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:????????????}","description2":"???????????????","displayUrl":"http://admaxlocal.com"},{"name":"9cba9ed1-7087-4057-8bb9-25f2d1d7cbbe","id":532558187,"description":"???????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"??????????????","description2":"??????????????????","displayUrl":"http://admaxlocal.com"},{"name":"7a5a647d-41f4-4338-9585-e6d4dd85c8fd","id":532558188,"description":"???????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"????????????","description2":"???????????????????","displayUrl":"http://admaxlocal.com"},{"name":"607870b5-e63d-4469-8467-81795f18c48d","id":532558189,"description":"??????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:??????????????}","description2":"???????","displayUrl":"http://admaxlocal.com"}]}],"campaignTargets":null,"negativeKeywords":[{"id":92295604,"text":"???","matchType":"PHRASE"},{"id":92295605,"text":"??????","matchType":"EXACT"},{"id":92295606,"text":"??","matchType":"PHRASE"},{"id":92295607,"text":"??????","matchType":"EXACT"},{"id":92295608,"text":"??","matchType":"EXACT"},{"id":92295609,"text":"????","matchType":"PHRASE"},{"id":92295610,"text":"??","matchType":"PHRASE"},{"id":92295611,"text":"2ch","matchType":"PHRASE"},{"id":92295612,"text":"????????","matchType":"EXACT"},{"id":92295613,"text":"????","matchType":"PHRASE"},{"id":92295614,"text":"???","matchType":"PHRASE"},{"id":92295615,"text":"???","matchType":"PHRASE"},{"id":92295616,"text":"??","matchType":"PHRASE"},{"id":92295617,"text":"??","matchType":"PHRASE"},{"id":92295618,"text":"??","matchType":"PHRASE"},{"id":92295619,"text":"??","matchType":"PHRASE"},{"id":92295620,"text":"??","matchType":"PHRASE"}],"callExtensions":null,"quickLinks":null,"callExtensionCampaignFeeds":null,"quickLinkCampaignFeeds":null}') 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.sqltiming:373 - INSERT INTO `campaigns` (`yahooId`, `name`, `status`, `lastUpdated`, `json`) VALUES (1319263, 'a195_162547_401011_2398_GM', 'PAUSED', NOW(), '{"campaign":{"name":"a195_162547_401011_2398_GM","startDate":"20160512","endDate":null,"status":"PAUSED","budgetAmount":100,"searchEngineId":1319263},"adGroupStructures":[{"adGroup":{"name":"a195_162547_401011_2398_???","id":425048503,"status":"ACTIVE","keywordMaxCpc":30},"positiveKeywords":[{"url":null,"status":"ACTIVE","id":1057233615,"text":"+?? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233616,"text":"+???????? +?? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233617,"text":"+????????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233618,"text":"+???? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233619,"text":"+????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233620,"text":"+???????? +??? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233621,"text":"+?????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233622,"text":"+????????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233623,"text":"+?? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233624,"text":"+????? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233625,"text":"+????? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233626,"text":"+???????? +?? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233627,"text":"+???????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233628,"text":"+???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233629,"text":"+???????? +?????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233630,"text":"+???????? +????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233631,"text":"+? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233632,"text":"+?????? +???????? +??? ","matchType":"BROAD"}],"ads":[{"name":"2ef2c782-1da1-4467-8468-6ba7860191ec","id":532558186,"description":"???????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:????????????}","description2":"???????????????","displayUrl":"http://admaxlocal.com"},{"name":"9cba9ed1-7087-4057-8bb9-25f2d1d7cbbe","id":532558187,"description":"???????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"??????????????","description2":"??????????????????","displayUrl":"http://admaxlocal.com"},{"name":"7a5a647d-41f4-4338-9585-e6d4dd85c8fd","id":532558188,"description":"???????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"????????????","description2":"???????????????????","displayUrl":"http://admaxlocal.com"},{"name":"607870b5-e63d-4469-8467-81795f18c48d","id":532558189,"description":"??????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:??????????????}","description2":"???????","displayUrl":"http://admaxlocal.com"}]}],"campaignTargets":null,"negativeKeywords":[{"id":92295604,"text":"???","matchType":"PHRASE"},{"id":92295605,"text":"??????","matchType":"EXACT"},{"id":92295606,"text":"??","matchType":"PHRASE"},{"id":92295607,"text":"??????","matchType":"EXACT"},{"id":92295608,"text":"??","matchType":"EXACT"},{"id":92295609,"text":"????","matchType":"PHRASE"},{"id":92295610,"text":"??","matchType":"PHRASE"},{"id":92295611,"text":"2ch","matchType":"PHRASE"},{"id":92295612,"text":"????????","matchType":"EXACT"},{"id":92295613,"text":"????","matchType":"PHRASE"},{"id":92295614,"text":"???","matchType":"PHRASE"},{"id":92295615,"text":"???","matchType":"PHRASE"},{"id":92295616,"text":"??","matchType":"PHRASE"},{"id":92295617,"text":"??","matchType":"PHRASE"},{"id":92295618,"text":"??","matchType":"PHRASE"},{"id":92295619,"text":"??","matchType":"PHRASE"},{"id":92295620,"text":"??","matchType":"PHRASE"}],"callExtensions":null,"quickLinks":null,"callExtensionCampaignFeeds":null,"quickLinkCampaignFeeds":null}') {executed in 2 msec} 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.executeUpdate() returned 1 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.close() returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.new PreparedStatement returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. Connection.prepareStatement(SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`yahooId` = ?) returned net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy@346777b0 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.setObject(1, 1319263) returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.sqlonly:228 - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`yahooId` = 1319263 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.sqltiming:373 - SELECT `campaigns`.`id`, `campaigns`.`json` FROM `campaigns` WHERE `campaigns`.`yahooId` = 1319263 {executed in 1 msec} 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultset:175 - 98. ResultSet.new ResultSet returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.executeQuery() returned net.sf.log4jdbc.sql.jdbcapi.ResultSetSpy@74e2deb0 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultset:175 - 98. ResultSet.next() returned true 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultset:175 - 98. ResultSet.getString(json) returned {"campaign":{"name":"a195_162547_401011_2398_GM","startDate":"20160512","endDate":null,"status":"PAUSED","budgetAmount":100,"searchEngineId":1319263},"adGroupStructures":[{"adGroup":{"name":"a195_162547_401011_2398_???","id":425048503,"status":"ACTIVE","keywordMaxCpc":30},"positiveKeywords":[{"url":null,"status":"ACTIVE","id":1057233615,"text":"+?? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233616,"text":"+???????? +?? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233617,"text":"+????????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233618,"text":"+???? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233619,"text":"+????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233620,"text":"+???????? +??? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233621,"text":"+?????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233622,"text":"+????????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233623,"text":"+?? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233624,"text":"+????? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233625,"text":"+????? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233626,"text":"+???????? +?? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233627,"text":"+???????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233628,"text":"+???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233629,"text":"+???????? +?????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233630,"text":"+???????? +????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233631,"text":"+? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233632,"text":"+?????? +???????? +??? ","matchType":"BROAD"}],"ads":[{"name":"2ef2c782-1da1-4467-8468-6ba7860191ec","id":532558186,"description":"???????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:????????????}","description2":"???????????????","displayUrl":"http://admaxlocal.com"},{"name":"9cba9ed1-7087-4057-8bb9-25f2d1d7cbbe","id":532558187,"description":"???????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"??????????????","description2":"??????????????????","displayUrl":"http://admaxlocal.com"},{"name":"7a5a647d-41f4-4338-9585-e6d4dd85c8fd","id":532558188,"description":"???????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"????????????","description2":"???????????????????","displayUrl":"http://admaxlocal.com"},{"name":"607870b5-e63d-4469-8467-81795f18c48d","id":532558189,"description":"??????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:??????????????}","description2":"???????","displayUrl":"http://admaxlocal.com"}]}],"campaignTargets":null,"negativeKeywords":[{"id":92295604,"text":"???","matchType":"PHRASE"},{"id":92295605,"text":"??????","matchType":"EXACT"},{"id":92295606,"text":"??","matchType":"PHRASE"},{"id":92295607,"text":"??????","matchType":"EXACT"},{"id":92295608,"text":"??","matchType":"EXACT"},{"id":92295609,"text":"????","matchType":"PHRASE"},{"id":92295610,"text":"??","matchType":"PHRASE"},{"id":92295611,"text":"2ch","matchType":"PHRASE"},{"id":92295612,"text":"????????","matchType":"EXACT"},{"id":92295613,"text":"????","matchType":"PHRASE"},{"id":92295614,"text":"???","matchType":"PHRASE"},{"id":92295615,"text":"???","matchType":"PHRASE"},{"id":92295616,"text":"??","matchType":"PHRASE"},{"id":92295617,"text":"??","matchType":"PHRASE"},{"id":92295618,"text":"??","matchType":"PHRASE"},{"id":92295619,"text":"??","matchType":"PHRASE"},{"id":92295620,"text":"??","matchType":"PHRASE"}],"callExtensions":null,"quickLinks":null,"callExtensionCampaignFeeds":null,"quickLinkCampaignFeeds":null} 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultset:175 - 98. ResultSet.getInt(id) returned 1275 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultsettable:610 - |-----|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| |id |json | |-----|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| |1275 |{"campaign":{"name":"a195_162547_401011_2398_GM","startDate":"20160512","endDate":null,"status":"PAUSED","budgetAmount":100,"searchEngineId":1319263},"adGroupStructures":[{"adGroup":{"name":"a195_162547_401011_2398_???","id":425048503,"status":"ACTIVE","keywordMaxCpc":30},"positiveKeywords":[{"url":null,"status":"ACTIVE","id":1057233615,"text":"+?? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233616,"text":"+???????? +?? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233617,"text":"+????????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233618,"text":"+???? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233619,"text":"+????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233620,"text":"+???????? +??? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233621,"text":"+?????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233622,"text":"+????????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233623,"text":"+?? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233624,"text":"+????? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233625,"text":"+????? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233626,"text":"+???????? +?? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233627,"text":"+???????????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233628,"text":"+???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233629,"text":"+???????? +?????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233630,"text":"+???????? +????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233631,"text":"+? +???????? +??? ","matchType":"BROAD"},{"url":null,"status":"ACTIVE","id":1057233632,"text":"+?????? +???????? +??? ","matchType":"BROAD"}],"ads":[{"name":"2ef2c782-1da1-4467-8468-6ba7860191ec","id":532558186,"description":"???????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:????????????}","description2":"???????????????","displayUrl":"http://admaxlocal.com"},{"name":"9cba9ed1-7087-4057-8bb9-25f2d1d7cbbe","id":532558187,"description":"???????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"??????????????","description2":"??????????????????","displayUrl":"http://admaxlocal.com"},{"name":"7a5a647d-41f4-4338-9585-e6d4dd85c8fd","id":532558188,"description":"???????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"????????????","description2":"???????????????????","displayUrl":"http://admaxlocal.com"},{"name":"607870b5-e63d-4469-8467-81795f18c48d","id":532558189,"description":"??????????????????","url":"http://admaxlocal.com","status":"ACTIVE","headline":"{KeyWord:??????????????}","description2":"???????","displayUrl":"http://admaxlocal.com"}]}],"campaignTargets":null,"negativeKeywords":[{"id":92295604,"text":"???","matchType":"PHRASE"},{"id":92295605,"text":"??????","matchType":"EXACT"},{"id":92295606,"text":"??","matchType":"PHRASE"},{"id":92295607,"text":"??????","matchType":"EXACT"},{"id":92295608,"text":"??","matchType":"EXACT"},{"id":92295609,"text":"????","matchType":"PHRASE"},{"id":92295610,"text":"??","matchType":"PHRASE"},{"id":92295611,"text":"2ch","matchType":"PHRASE"},{"id":92295612,"text":"????????","matchType":"EXACT"},{"id":92295613,"text":"????","matchType":"PHRASE"},{"id":92295614,"text":"???","matchType":"PHRASE"},{"id":92295615,"text":"???","matchType":"PHRASE"},{"id":92295616,"text":"??","matchType":"PHRASE"},{"id":92295617,"text":"??","matchType":"PHRASE"},{"id":92295618,"text":"??","matchType":"PHRASE"},{"id":92295619,"text":"??","matchType":"PHRASE"},{"id":92295620,"text":"??","matchType":"PHRASE"}],"callExtensions":null,"quickLinks":null,"callExtensionCampaignFeeds":null,"quickLinkCampaignFeeds":null} | |-----|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultset:175 - 98. ResultSet.next() returned false 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.resultset:175 - 98. ResultSet.close() returned void 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. PreparedStatement.close() returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.connection:568 - 98. Connection closed 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 98. Connection.close() returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 97. Connection.commit() returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 97. Connection.setAutoCommit(true) returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 97. Connection.setTransactionIsolation(4) returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 97. Connection.isReadOnly() returned false 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.connection:568 - 97. Connection closed 2016-05-12 10:24:33 INFO [pool-23-thread-1] jdbc.audit:175 - 97. Connection.close() returned 2016-05-12 10:24:33 INFO [pool-23-thread-1] com.thesearchagency.searchengines.yahoojapan.YahooJapanAccountDeployer:272 - Created Yahoo campaign structure for accountID 195 2016-05-12 10:24:33.185 (3) [pool-23-thread-1]: Completed YahooJapan Create Campaign Worker.. 2016-05-12 10:24:33.197 (3) [pool-3-thread-8]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.connection:541 - 99. Connection opened 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 99. Connection.new Connection returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - null. DataSource.getConnection() returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 99. Connection.getTransactionIsolation() returned 4 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 99. Connection.setTransactionIsolation(2) returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 99. Connection.getAutoCommit() returned true 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 99. Connection.setAutoCommit(false) returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.connection:541 - 100. Connection opened 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 100. Connection.new Connection returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - null. DataSource.getConnection() returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 100. PreparedStatement.new PreparedStatement returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 100. Connection.prepareStatement(SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (?)) returned net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy@69b738eb 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 100. PreparedStatement.setObject(1, 1274) returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.sqlonly:228 - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1274) 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.sqltiming:373 - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1274) {executed in 1 msec} 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.resultset:175 - 100. ResultSet.new ResultSet returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 100. PreparedStatement.executeQuery() returned net.sf.log4jdbc.sql.jdbcapi.ResultSetSpy@7bfa0285 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.resultsettable:610 - |----------| |errorjson | |----------| |----------| 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.resultset:175 - 100. ResultSet.next() returned false 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.resultset:175 - 100. ResultSet.close() returned void 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 100. PreparedStatement.close() returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.connection:568 - 100. Connection closed 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 100. Connection.close() returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 99. Connection.commit() returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 99. Connection.setAutoCommit(true) returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 99. Connection.setTransactionIsolation(4) returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 99. Connection.isReadOnly() returned false 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.connection:568 - 99. Connection closed 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 99. Connection.close() returned 2016-05-12 10:24:33.232 (3) [pool-3-thread-8]: 2398_GT has no applicable GCE errors. 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.connection:541 - 101. Connection opened 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 101. Connection.new Connection returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - null. DataSource.getConnection() returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 101. Connection.getTransactionIsolation() returned 4 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 101. Connection.setTransactionIsolation(2) returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 101. Connection.getAutoCommit() returned true 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 101. Connection.setAutoCommit(false) returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.connection:541 - 102. Connection opened 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 102. Connection.new Connection returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - null. DataSource.getConnection() returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 102. PreparedStatement.new PreparedStatement returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 102. Connection.prepareStatement(SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (?)) returned net.sf.log4jdbc.sql.jdbcapi.PreparedStatementSpy@165220d7 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 102. PreparedStatement.setObject(1, 1275) returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.sqlonly:228 - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1275) 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.sqltiming:373 - SELECT `errors`.`errorJson` FROM `campaigns` JOIN `errors` ON `errors`.`campaignName` = `campaigns`.`name` WHERE `campaigns`.`id` IN (1275) {executed in 1 msec} 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.resultset:175 - 102. ResultSet.new ResultSet returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 102. PreparedStatement.executeQuery() returned net.sf.log4jdbc.sql.jdbcapi.ResultSetSpy@69ea0eb3 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.resultsettable:610 - |----------| |errorjson | |----------| |----------| 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.resultset:175 - 102. ResultSet.next() returned false 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.resultset:175 - 102. ResultSet.close() returned void 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 102. PreparedStatement.close() returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.connection:568 - 102. Connection closed 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 102. Connection.close() returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 101. Connection.commit() returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 101. Connection.setAutoCommit(true) returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 101. Connection.setTransactionIsolation(4) returned 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 101. Connection.isReadOnly() returned false 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.connection:568 - 101. Connection closed 2016-05-12 10:24:33 INFO [pool-3-thread-8] jdbc.audit:175 - 101. Connection.close() returned 2016-05-12 10:24:33.245 (3) [pool-3-thread-8]: 2398_GM has no applicable GCE errors. 2016-05-12 10:24:33.248 (3) [pool-3-thread-8]: Finished DEPLOY request for campaign 70187152-372a-4696-bde8-6684282c0174_162547_401011_2398_GT: SUCCEEDED (merchant: 70187152-372a-4696-bde8-6684282c0174) 2016-05-12 10:24:33.249 (3) [pool-3-thread-8]: Finished DEPLOY request for campaign 70187152-372a-4696-bde8-6684282c0174_162547_401011_2398_GM: SUCCEEDED (merchant: 70187152-372a-4696-bde8-6684282c0174) 2016-05-12 10:24:33.249 (3) [pool-3-thread-8]: 70187152-372a-4696-bde8-6684282c0174 has 2 campaigns for a SE Update accounts sync. 2016-05-12 10:24:33.249 (3) [pool-3-thread-8]: 70187152-372a-4696-bde8-6684282c0174 has 2 campaigns for a SE Update groups-listings sync. 2016-05-12 10:24:38.250 (3) [pool-3-thread-8]: JobExecutor running job [2016-05-12_102433_a195_AccountWorkerProcessResults_syncAccountsGroupsListings_UehVHHLzGy]: /usr/local/tsa/bidmgr/seupdate.sh -d 3 --inactive --accountid 195 --accounts --seaccount 1381,1382 --groups --listings 2016-05-12 10:24:52.532 (3) [pool-3-thread-8]: JobExecutor finished running job [2016-05-12_102433_a195_AccountWorkerProcessResults_syncAccountsGroupsListings_UehVHHLzGy], exit code=0 in 14.183s 2016-05-12 10:24:52.532 (3) [pool-3-thread-8]: JobExecutor finished 2016-05-12_102433_a195_AccountWorkerProcessResults_syncAccountsGroupsListings_UehVHHLzGy. hasError=false, numTries=1 2016-05-12 10:24:52.533 (3) [pool-3-thread-8]: Finished sub-campaign processing for DEPLOY deploymentID (cb56c24d-c4cc-4b43-b29d-d260ce5db2d7). account 70187152-372a-4696-bde8-6684282c0174. 2 submitted, 2 ok. 2016-05-12 10:24:52.534 (3) [pool-3-thread-8]: Updating deployment status to 'Success' for campaignID: 2398 2016-05-12 10:24:52.535 (3) [pool-3-thread-8]: Finished DEPLOY request for 70187152-372a-4696-bde8-6684282c0174_162547_401011_2398: SUCCEEDED (merchant: 70187152-372a-4696-bde8-6684282c0174) 2016-05-12 10:24:52.536 (3) [pool-3-thread-8]: Finished DEPLOY request, deploymentID (cb56c24d-c4cc-4b43-b29d-d260ce5db2d7), account 70187152-372a-4696-bde8-6684282c0174 2016-05-12 10:24:52.536 (3) [pool-3-thread-8]: Request removed from map for customerID 70187152-372a-4696-bde8-6684282c0174 2016-05-12 10:24:52.661 (3) [pool-3-thread-8]: Initial campaign deployment for customerID: 70187152-372a-4696-bde8-6684282c0174 2016-05-12 10:24:53.578 (3) [AdMaxListener]: Sent message to response queue.