[TSAApp@aml-qa4-core1 bidmgr]./admax.sh -d5 -a 2964 -z America/New_York Java HotSpot(TM) 64-Bit Server VM warning: Using incremental CMS is deprecated and will likely be removed in a future release ------- Loaded DatabaseAccounts properties from file:/usr/local/tsa/bidmgr-distribution-2.9.36-BETA17-dev-t20210505103537/libs/deployment-bidmgr-shaded-jar-2.9.36-BETA17.jar!/core-jdb-datasource.properties ------- {datasource-user=spike, datasource-password=tar63t} 2021-05-11 05:18:26.063 (3) [main]: Debug Level set to 5 2021-05-11 05:18:26.064 (3) [main]: AdMax Summarizer parameters: -d5 -a 2964 -z America/New_York 2021-05-11 05:18:26.145 (4) [main]: registered MBean [thesearchagency.db.util:type=MultiplexDatabasePool4cf4f34d-a9c3-4dd8-9fa0-459379cd43e9] for class com.thesearchagency.db.util.MultiplexDatabasePool 2021-05-11 05:18:26.151 (5) [main]: ProfilerRec.start("AdMaxSummarizer",false) in Thread [main] 2021-05-11 05:18:26.156 (3) [main]: LicensingFileRefresher: modification detected on 1526883479000 for licensing.properties 2021-05-11 05:18:26.156 (3) [main]: Licensing environment detected, loading configuration. 2021-05-11 05:18:26.157 (3) [main]: Loaded property: distribution-service-url=http://aml-qa4-front1:8080/distribution 2021-05-11 05:18:26.157 (3) [main]: Loaded property: distribution-service-username=readwrite 2021-05-11 05:18:26.157 (3) [main]: Loaded property: distribution-service-password=readwrite 2021-05-11 05:18:26.157 (3) [main]: Loaded property: sapi-auth-url=http://aml-qa4-front1:8080/sapi/rest/security/tokens 2021-05-11 05:18:26.157 (3) [main]: Loaded property: sapi-merchant-service-url=http://aml-qa4-front1:8080/sapi/rest/merchants 2021-05-11 05:18:26.157 (3) [main]: Loaded property: sapi-reseller-service-url=http://aml-qa4-front1:8080/sapi/rest/resellers 2021-05-11 05:18:26.157 (3) [main]: Loaded property: sapi-username=admin+tsa@thesearchagency.com 2021-05-11 05:18:26.157 (3) [main]: Loaded property: sapi-password=admin 2021-05-11 05:18:26.158 (3) [main]: Loaded property: sapi-realm=thesearchagency 2021-05-11 05:18:26.158 (3) [main]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg 2021-05-11 05:18:26.158 (3) [main]: Loaded property: tsa.google.mcc.isReseller=true 2021-05-11 05:18:26.158 (3) [main]: Loaded property: tsa.google.mcc.userAgent=AdMaxLocal AdWords Software TSA QA 2021-05-11 05:18:26.158 (3) [main]: Loaded property: tsa.timezone=UTC 2021-05-11 05:18:26.161 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2021-05-11 05:18:26.401 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-05-11 05:18:26.401 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.403 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2021-05-11 05:18:26.404 (4) [main]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-logging") and (`type`="mysql")) limit 1] 2021-05-11 05:18:26.407 (5) [main]: recordAsSubs("db", 3, "main") 2021-05-11 05:18:26.407 (5) [main]: addSub("db") 2021-05-11 05:18:26.407 (5) [main]: ProfilerRec.end("db", true): ret=3 2021-05-11 05:18:26.408 (4) [main]: time=0.003 2021-05-11 05:18:26.408 (4) [main]: Query executed in 0.003s 2021-05-11 05:18:26.409 (5) [main]: loading 8 columns from result set: 2021-05-11 05:18:26.409 (5) [main]: loaded column: databaseInstances.id->4 2021-05-11 05:18:26.410 (5) [main]: loaded column: databaseInstances.name->global-logging 2021-05-11 05:18:26.410 (5) [main]: loaded column: databaseInstances.description->Global Logging Tables 2021-05-11 05:18:26.410 (5) [main]: loaded column: databaseInstances.type->mysql 2021-05-11 05:18:26.410 (5) [main]: loaded column: databaseInstances.database->logging 2021-05-11 05:18:26.410 (5) [main]: loaded column: databaseInstances.host->logging-01-write 2021-05-11 05:18:26.411 (5) [main]: loaded column: databaseInstances.port->3306 2021-05-11 05:18:26.411 (5) [main]: loaded column: databaseInstances.access->rw 2021-05-11 05:18:26.411 (4) [main]: Record Loaded 2021-05-11 05:18:26.411 (4) [main]: DataCache: put key global-logging 2021-05-11 05:18:26.412 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.414 (4) [main]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool3a3e1adc-f369-462f-b789-485eb0e96d9d] for class com.carldunham.jst.pooling.ObjectPool 2021-05-11 05:18:26.414 (3) [main]: DatabasePool with a limit of 18 created 2021-05-11 05:18:26.415 (4) [main]: registered MBean [com.carldunham.jst.db:type=DatabasePoolc1a8fc8b-b885-4e2c-a3ee-3a8d0bf02010] for class com.carldunham.jst.db.DatabasePool 2021-05-11 05:18:26.416 (4) [ConnectionCloser]: Starting DatabasePool ConnectionCloserThread 2021-05-11 05:18:26.432 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-05-11 05:18:26.432 (4) [main]: opened [jdbc:mysql://logging-01-write:3306/logging?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.432 (4) [main]: Created new Object 2021-05-11 05:18:26.432 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2021-05-11 05:18:26.432 (4) [main]: spike: SQL->[select @@version] 2021-05-11 05:18:26.433 (5) [main]: recordAsSubs("db", 1, "main") 2021-05-11 05:18:26.433 (5) [main]: addSub("db") 2021-05-11 05:18:26.433 (5) [main]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:26.434 (4) [main]: time=0.001 2021-05-11 05:18:26.434 (4) [main]: Query executed in 0.001s 2021-05-11 05:18:26.434 (4) [main]: test query succeeded, returned "5.5.34" 2021-05-11 05:18:26.434 (4) [main]: preparing SQL statement [insert into logging.processHistory (processID, startTime) values (?,?)], genflags=yes 2021-05-11 05:18:26.448 (3) [main]: Could not save process history start 2021-05-11 05:18:26.449 (4) [main]: Returning Object to Pool 2021-05-11 05:18:26.449 (3) [main]: =============== Starting AdMax Summarizer ================ 2021-05-11 05:18:26.449 (4) [main]: no account, or instance for databaseInstance, skipping lookup... 2021-05-11 05:18:26.449 (3) [main]: ----------------AdMax Summarizer starting 2021-05-11 05:18:26.469 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-05-11 05:18:26.469 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.469 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2021-05-11 05:18:26.469 (4) [main]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`tsacommon`.`accounts`.`id` in (2964)) and (`tsacommon`.`accounts`.`timeZoneID` in ("America/New_York"))) order by rand()] 2021-05-11 05:18:26.471 (5) [main]: recordAsSubs("db", 2, "main") 2021-05-11 05:18:26.471 (5) [main]: addSub("db") 2021-05-11 05:18:26.471 (5) [main]: ProfilerRec.end("db", true): ret=2 2021-05-11 05:18:26.471 (4) [main]: time=0.002 2021-05-11 05:18:26.471 (4) [main]: Query executed in 0.002s 2021-05-11 05:18:26.471 (5) [main]: loading 21 columns from result set: 2021-05-11 05:18:26.471 (5) [main]: loaded column: accounts.id->2964 2021-05-11 05:18:26.472 (5) [main]: loaded column: accounts.description->fc941eb4-7da1-4ba3-af44-5c15c72b77e3 2021-05-11 05:18:26.472 (5) [main]: loaded column: accounts.tier->1 2021-05-11 05:18:26.472 (5) [main]: loaded column: accounts.priority->50 2021-05-11 05:18:26.473 (5) [main]: loaded column: accounts.reportClicksOut->false 2021-05-11 05:18:26.473 (5) [main]: loaded column: accounts.reportConversions->false 2021-05-11 05:18:26.473 (5) [main]: loaded column: accounts.conversionTypes->paid 2021-05-11 05:18:26.473 (5) [main]: loaded column: accounts.isBidManaged->true 2021-05-11 05:18:26.473 (5) [main]: loaded column: accounts.isActive->true 2021-05-11 05:18:26.473 (5) [main]: loaded column: accounts.perfMetric->cpa 2021-05-11 05:18:26.473 (5) [main]: loaded column: accounts.providesConversionData->true 2021-05-11 05:18:26.473 (5) [main]: loaded column: accounts.addConversionData->true 2021-05-11 05:18:26.473 (5) [main]: loaded column: accounts.fractionalConversionCounts->false 2021-05-11 05:18:26.473 (5) [main]: loaded column: accounts.hideNullSources->false 2021-05-11 05:18:26.474 (5) [main]: loaded column: accounts.nowTime->null 2021-05-11 05:18:26.476 (5) [main]: skipping invalid column: accounts.warehouseDatabase 2021-05-11 05:18:26.476 (5) [main]: loaded column: accounts.databaseInstance->1 2021-05-11 05:18:26.476 (5) [main]: loaded column: accounts.warehouseInstance->1 2021-05-11 05:18:26.476 (5) [main]: loaded column: accounts.isOnline->true 2021-05-11 05:18:26.476 (5) [main]: loaded column: accounts.currencyCode->USD 2021-05-11 05:18:26.477 (5) [main]: loaded column: accounts.timeZoneID->America/New_York 2021-05-11 05:18:26.482 (3) [P1T1]: Starting Account ID #2964: fc941eb4-7da1-4ba3-af44-5c15c72b77e3 2021-05-11 05:18:26.483 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2021-05-11 05:18:26.504 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-05-11 05:18:26.504 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.505 (5) [P1T1]: quoteValue(), nothing special about it=>[2964], type=class java.lang.Integer 2021-05-11 05:18:26.505 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:26.505 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=2964) limit 1] 2021-05-11 05:18:26.506 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-05-11 05:18:26.506 (5) [P1T1]: addSub("db") 2021-05-11 05:18:26.506 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:26.506 (4) [P1T1]: time=0.001 2021-05-11 05:18:26.506 (4) [P1T1]: Query executed in 0.001s 2021-05-11 05:18:26.506 (5) [P1T1]: loading 21 columns from result set: 2021-05-11 05:18:26.507 (5) [P1T1]: loaded column: accounts.id->2964 2021-05-11 05:18:26.507 (5) [P1T1]: loaded column: accounts.description->fc941eb4-7da1-4ba3-af44-5c15c72b77e3 2021-05-11 05:18:26.507 (5) [P1T1]: loaded column: accounts.tier->1 2021-05-11 05:18:26.507 (5) [P1T1]: loaded column: accounts.priority->50 2021-05-11 05:18:26.507 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2021-05-11 05:18:26.507 (5) [P1T1]: loaded column: accounts.reportConversions->false 2021-05-11 05:18:26.507 (5) [P1T1]: loaded column: accounts.conversionTypes->paid 2021-05-11 05:18:26.507 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2021-05-11 05:18:26.507 (5) [P1T1]: loaded column: accounts.isActive->true 2021-05-11 05:18:26.507 (5) [P1T1]: loaded column: accounts.perfMetric->cpa 2021-05-11 05:18:26.508 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2021-05-11 05:18:26.508 (5) [P1T1]: loaded column: accounts.addConversionData->true 2021-05-11 05:18:26.508 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2021-05-11 05:18:26.509 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2021-05-11 05:18:26.509 (5) [P1T1]: loaded column: accounts.nowTime->null 2021-05-11 05:18:26.509 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2021-05-11 05:18:26.509 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2021-05-11 05:18:26.509 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2021-05-11 05:18:26.509 (5) [P1T1]: loaded column: accounts.isOnline->true 2021-05-11 05:18:26.509 (5) [P1T1]: loaded column: accounts.currencyCode->USD 2021-05-11 05:18:26.510 (5) [P1T1]: loaded column: accounts.timeZoneID->America/New_York 2021-05-11 05:18:26.510 (4) [P1T1]: Record Loaded 2021-05-11 05:18:26.510 (4) [P1T1]: DataCache: put key acct-st-tracker 2964 2021-05-11 05:18:26.510 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:26.513 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-st-tracker-1") and (`type`="mysql")) limit 1] 2021-05-11 05:18:26.514 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2021-05-11 05:18:26.514 (5) [P1T1]: addSub("db") 2021-05-11 05:18:26.514 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2021-05-11 05:18:26.514 (4) [P1T1]: time=0.004 2021-05-11 05:18:26.514 (4) [P1T1]: Query executed in 0.004s 2021-05-11 05:18:26.515 (5) [P1T1]: loading 8 columns from result set: 2021-05-11 05:18:26.515 (5) [P1T1]: loaded column: databaseInstances.id->15 2021-05-11 05:18:26.515 (5) [P1T1]: loaded column: databaseInstances.name->acct-st-tracker-1 2021-05-11 05:18:26.515 (5) [P1T1]: loaded column: databaseInstances.description->Account-specific Catch-all database 2021-05-11 05:18:26.515 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2021-05-11 05:18:26.515 (5) [P1T1]: loaded column: databaseInstances.database->st-tracker 2021-05-11 05:18:26.516 (5) [P1T1]: loaded column: databaseInstances.host->acctdb-01-write 2021-05-11 05:18:26.516 (5) [P1T1]: loaded column: databaseInstances.port->3306 2021-05-11 05:18:26.516 (5) [P1T1]: loaded column: databaseInstances.access->rw 2021-05-11 05:18:26.516 (4) [P1T1]: Record Loaded 2021-05-11 05:18:26.516 (4) [P1T1]: DataCache: put key acct-st-tracker-1 2021-05-11 05:18:26.516 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.516 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPoolbeb0a07c-632b-40b4-a7fc-a57fe26fbb86] for class com.carldunham.jst.pooling.ObjectPool 2021-05-11 05:18:26.516 (3) [P1T1]: DatabasePool with a limit of 18 created 2021-05-11 05:18:26.516 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePoolf8cabbd3-8294-44d2-b54f-c4b24af55f0f] for class com.carldunham.jst.db.DatabasePool 2021-05-11 05:18:26.525 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-05-11 05:18:26.525 (4) [P1T1]: opened [jdbc:mysql://acctdb-01-write:3306/st-tracker?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.525 (4) [P1T1]: Created new Object 2021-05-11 05:18:26.525 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:26.525 (4) [P1T1]: spike: SQL->[select @@version] 2021-05-11 05:18:26.527 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-05-11 05:18:26.527 (5) [P1T1]: addSub("db") 2021-05-11 05:18:26.527 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-05-11 05:18:26.527 (4) [P1T1]: time=0.002 2021-05-11 05:18:26.527 (4) [P1T1]: Query executed in 0.002s 2021-05-11 05:18:26.527 (4) [P1T1]: test query succeeded, returned "5.5.34" 2021-05-11 05:18:26.527 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2021-05-11 05:18:26.527 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool06a37fd8-5253-410c-b4ec-86edf13062cb] for class com.carldunham.jst.pooling.ObjectPool 2021-05-11 05:18:26.527 (3) [P1T1]: DatabasePool with a limit of 18 created 2021-05-11 05:18:26.528 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePool950a276f-40a3-49d2-8ca9-e83be8b6cc7d] for class com.carldunham.jst.db.DatabasePool 2021-05-11 05:18:26.538 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-05-11 05:18:26.538 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.538 (4) [P1T1]: Created new Object 2021-05-11 05:18:26.538 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:26.538 (4) [P1T1]: spike: SQL->[select @@version] 2021-05-11 05:18:26.541 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2021-05-11 05:18:26.541 (5) [P1T1]: addSub("db") 2021-05-11 05:18:26.541 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2021-05-11 05:18:26.541 (4) [P1T1]: time=0.003 2021-05-11 05:18:26.541 (4) [P1T1]: Query executed in 0.003s 2021-05-11 05:18:26.541 (4) [P1T1]: test query succeeded, returned "5.5.34" 2021-05-11 05:18:26.541 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2021-05-11 05:18:26.549 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-05-11 05:18:26.549 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.549 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:26.549 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-staging") and (`type`="mysql")) limit 1] 2021-05-11 05:18:26.551 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-05-11 05:18:26.552 (5) [P1T1]: addSub("db") 2021-05-11 05:18:26.552 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-05-11 05:18:26.552 (4) [P1T1]: time=0.002 2021-05-11 05:18:26.552 (4) [P1T1]: Query executed in 0.002s 2021-05-11 05:18:26.552 (5) [P1T1]: loading 8 columns from result set: 2021-05-11 05:18:26.552 (5) [P1T1]: loaded column: databaseInstances.id->3 2021-05-11 05:18:26.552 (5) [P1T1]: loaded column: databaseInstances.name->global-staging 2021-05-11 05:18:26.552 (5) [P1T1]: loaded column: databaseInstances.description->Global Staging Tables 2021-05-11 05:18:26.552 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2021-05-11 05:18:26.552 (5) [P1T1]: loaded column: databaseInstances.database->staging 2021-05-11 05:18:26.552 (5) [P1T1]: loaded column: databaseInstances.host->staging-01-write 2021-05-11 05:18:26.552 (5) [P1T1]: loaded column: databaseInstances.port->3306 2021-05-11 05:18:26.552 (5) [P1T1]: loaded column: databaseInstances.access->rw 2021-05-11 05:18:26.552 (4) [P1T1]: Record Loaded 2021-05-11 05:18:26.552 (4) [P1T1]: DataCache: put key global-staging 2021-05-11 05:18:26.553 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.553 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool30394ab6-53cc-48c6-9c05-8562bea16f00] for class com.carldunham.jst.pooling.ObjectPool 2021-05-11 05:18:26.553 (3) [P1T1]: DatabasePool with a limit of 18 created 2021-05-11 05:18:26.553 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePool3b00a9b8-2c80-42ab-959c-69aba8909324] for class com.carldunham.jst.db.DatabasePool 2021-05-11 05:18:26.562 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-05-11 05:18:26.562 (4) [P1T1]: opened [jdbc:mysql://staging-01-write:3306/staging?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.562 (4) [P1T1]: Created new Object 2021-05-11 05:18:26.562 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:26.562 (4) [P1T1]: spike: SQL->[select @@version] 2021-05-11 05:18:26.563 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-05-11 05:18:26.564 (5) [P1T1]: addSub("db") 2021-05-11 05:18:26.564 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:26.564 (4) [P1T1]: time=0.001 2021-05-11 05:18:26.564 (4) [P1T1]: Query executed in 0.001s 2021-05-11 05:18:26.564 (4) [P1T1]: test query succeeded, returned "5.5.34" 2021-05-11 05:18:26.564 (4) [P1T1]: no account, or instance for databaseInstance, skipping lookup... 2021-05-11 05:18:26.572 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-05-11 05:18:26.572 (4) [P1T1]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.572 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:26.572 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="global-clients") and (`type`="mysql")) limit 1] 2021-05-11 05:18:26.573 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-05-11 05:18:26.573 (5) [P1T1]: addSub("db") 2021-05-11 05:18:26.573 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:26.573 (4) [P1T1]: time=0.001 2021-05-11 05:18:26.573 (4) [P1T1]: Query executed in 0.001s 2021-05-11 05:18:26.574 (5) [P1T1]: loading 8 columns from result set: 2021-05-11 05:18:26.574 (5) [P1T1]: loaded column: databaseInstances.id->13 2021-05-11 05:18:26.574 (5) [P1T1]: loaded column: databaseInstances.name->global-clients 2021-05-11 05:18:26.574 (5) [P1T1]: loaded column: databaseInstances.description->Global Database for client-specific tables 2021-05-11 05:18:26.574 (5) [P1T1]: loaded column: databaseInstances.type->mysql 2021-05-11 05:18:26.574 (5) [P1T1]: loaded column: databaseInstances.database->clients 2021-05-11 05:18:26.574 (5) [P1T1]: loaded column: databaseInstances.host->clients-01-write 2021-05-11 05:18:26.574 (5) [P1T1]: loaded column: databaseInstances.port->3306 2021-05-11 05:18:26.574 (5) [P1T1]: loaded column: databaseInstances.access->rw 2021-05-11 05:18:26.574 (4) [P1T1]: Record Loaded 2021-05-11 05:18:26.574 (4) [P1T1]: DataCache: put key global-clients 2021-05-11 05:18:26.574 (4) [P1T1]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.574 (4) [P1T1]: registered MBean [com.carldunham.jst.pooling:type=ObjectPool7923ffc0-bcc7-4a1a-a281-b19e6a8633aa] for class com.carldunham.jst.pooling.ObjectPool 2021-05-11 05:18:26.574 (3) [P1T1]: DatabasePool with a limit of 18 created 2021-05-11 05:18:26.575 (4) [P1T1]: registered MBean [com.carldunham.jst.db:type=DatabasePoola4244291-1797-4830-b458-166ad5b13ef7] for class com.carldunham.jst.db.DatabasePool 2021-05-11 05:18:26.584 (3) [P1T1]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver) 2021-05-11 05:18:26.584 (4) [P1T1]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:26.584 (4) [P1T1]: Created new Object 2021-05-11 05:18:26.584 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:26.584 (4) [P1T1]: spike: SQL->[select @@version] 2021-05-11 05:18:26.587 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2021-05-11 05:18:26.587 (5) [P1T1]: addSub("db") 2021-05-11 05:18:26.587 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2021-05-11 05:18:26.587 (4) [P1T1]: time=0.003 2021-05-11 05:18:26.587 (4) [P1T1]: Query executed in 0.003s 2021-05-11 05:18:26.587 (4) [P1T1]: test query succeeded, returned "5.5.34" 2021-05-11 05:18:26.588 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:26.588 (4) [P1T1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.2964', 600)] 2021-05-11 05:18:26.590 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-05-11 05:18:26.590 (5) [P1T1]: addSub("db") 2021-05-11 05:18:26.590 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-05-11 05:18:26.590 (4) [P1T1]: time=0.002 2021-05-11 05:18:26.590 (4) [P1T1]: Query executed in 0.002s 2021-05-11 05:18:26.590 (3) [P1T1]: Got migrator lock for Account ID #2964 2021-05-11 05:18:26.592 (5) [P1T1]: quoteValue(), nothing special about it=>[2964], type=class java.lang.Integer 2021-05-11 05:18:26.598 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:26.598 (4) [P1T1]: spike: SQL->[select * from `settings` where ((((`settings`.`scope`="accounts")) and ((`settings`.`scopeId`=2964))))] 2021-05-11 05:18:26.602 (5) [P1T1]: recordAsSubs("db", 4, "P1T1") 2021-05-11 05:18:26.602 (5) [P1T1]: addSub("db") 2021-05-11 05:18:26.602 (5) [P1T1]: ProfilerRec.end("db", true): ret=4 2021-05-11 05:18:26.602 (4) [P1T1]: time=0.004 2021-05-11 05:18:26.602 (4) [P1T1]: Query executed in 0.004s 2021-05-11 05:18:26.603 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:26.603 (4) [P1T1]: spike: SQL->[select * from `settingDefaults` where (`settingDefaults`.`scope`="accounts")] 2021-05-11 05:18:26.604 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-05-11 05:18:26.605 (5) [P1T1]: addSub("db") 2021-05-11 05:18:26.605 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:26.605 (4) [P1T1]: time=0.001 2021-05-11 05:18:26.605 (4) [P1T1]: Query executed in 0.001s 2021-05-11 05:18:26.605 (4) [P1T1]: DataCache: put key accounts 2964 2021-05-11 05:18:27.055 (4) [P1T1]: DataCache: Found key accounts 2964 2021-05-11 05:18:27.055 (4) [P1T1]: Settings.getSettings: loaded from cache (key=accounts 2964) 2021-05-11 05:18:27.055 (3) [P1T1]: Applying algorithm [SABB] for Account ID #2964 in distributions [3, 178, 147, 177] 2021-05-11 05:18:27.058 (3) [P1T1]: Processing data for 2021-05-10 00:00:00 EDT 2021-05-11 05:18:27.062 (5) [P1T1]: quoteValue(), nothing special about it=>[3], type=class java.lang.Integer 2021-05-11 05:18:27.062 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:27.062 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`searchEngineAccounts` inner join `tsacommon`.`searchEngineUsers` on (((`tsacommon`.`searchEngineAccounts`.`searchEngineUserID`=`tsacommon`.`searchEngineUsers`.`id`))) inner join `tsacommon`.`accounts` on ((`tsacommon`.`accounts`.`id`=`tsacommon`.`searchEngineAccounts`.`accountID`)) where (((((`tsacommon`.`searchEngineAccounts`.`enabled`="true") and (((`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="ok") or (`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="disabled") or (`tsacommon`.`searchEngineAccounts`.`searchEngineStatus`="deleted"))) and (`tsacommon`.`searchEngineAccounts`.`accountID`="2964"))) and ((`tsacommon`.`searchEngineAccounts`.`distributionID` in (3))))) order by rand()] 2021-05-11 05:18:27.065 (5) [P1T1]: recordAsSubs("db", 3, "P1T1") 2021-05-11 05:18:27.065 (5) [P1T1]: addSub("db") 2021-05-11 05:18:27.065 (5) [P1T1]: ProfilerRec.end("db", true): ret=3 2021-05-11 05:18:27.065 (4) [P1T1]: time=0.003 2021-05-11 05:18:27.066 (4) [P1T1]: Query executed in 0.003s 2021-05-11 05:18:27.068 (5) [P1T1]: quoteValue(), nothing special about it=>[2964], type=class java.lang.Integer 2021-05-11 05:18:27.069 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:27.069 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`accountID`=2964) and (`typeID`="") and (`type`="admax")) limit 1] 2021-05-11 05:18:27.070 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-05-11 05:18:27.070 (5) [P1T1]: addSub("db") 2021-05-11 05:18:27.070 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:27.070 (4) [P1T1]: time=0.001 2021-05-11 05:18:27.070 (4) [P1T1]: Query executed in 0.001s 2021-05-11 05:18:27.070 (5) [P1T1]: loading 4 columns from result set: 2021-05-11 05:18:27.070 (5) [P1T1]: loaded column: dataSources.id->12819 2021-05-11 05:18:27.071 (5) [P1T1]: loaded column: dataSources.type->admax 2021-05-11 05:18:27.071 (5) [P1T1]: loaded column: dataSources.typeID->0 2021-05-11 05:18:27.071 (5) [P1T1]: loaded column: dataSources.accountID->2964 2021-05-11 05:18:27.071 (4) [P1T1]: Record Loaded 2021-05-11 05:18:27.071 (5) [P1T1]: quoteValue(), nothing special about it=>[2964], type=class java.lang.Integer 2021-05-11 05:18:27.071 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:27.071 (4) [P1T1]: spike: SQL->[select * from `dataSources` where ((`dataSources`.`type`="admax") and (`dataSources`.`accountID`=2964))] 2021-05-11 05:18:27.072 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-05-11 05:18:27.072 (5) [P1T1]: addSub("db") 2021-05-11 05:18:27.073 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:27.073 (4) [P1T1]: time=0.001 2021-05-11 05:18:27.073 (4) [P1T1]: Query executed in 0.001s 2021-05-11 05:18:27.073 (5) [P1T1]: loading 4 columns from result set: 2021-05-11 05:18:27.073 (5) [P1T1]: loaded column: dataSources.id->12819 2021-05-11 05:18:27.073 (5) [P1T1]: loaded column: dataSources.type->admax 2021-05-11 05:18:27.073 (5) [P1T1]: loaded column: dataSources.typeID->0 2021-05-11 05:18:27.073 (5) [P1T1]: loaded column: dataSources.accountID->2964 2021-05-11 05:18:27.074 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:27.074 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`date`="2021-05-10 00:00:00") and (`dataSourceID`="12819")) limit 1] 2021-05-11 05:18:27.076 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-05-11 05:18:27.076 (5) [P1T1]: addSub("db") 2021-05-11 05:18:27.076 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-05-11 05:18:27.076 (4) [P1T1]: time=0.002 2021-05-11 05:18:27.076 (4) [P1T1]: Query executed in 0.002s 2021-05-11 05:18:27.076 (5) [P1T1]: loading 9 columns from result set: 2021-05-11 05:18:27.076 (5) [P1T1]: loaded column: dataAvailability.id->79559 2021-05-11 05:18:27.076 (5) [P1T1]: loaded column: dataAvailability.date->2021-05-10 2021-05-11 05:18:27.077 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2021-05-11 05:18:27.077 (5) [P1T1]: loaded column: dataAvailability.updated->2021-05-11 04:50:56.0 2021-05-11 05:18:27.077 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->12819 2021-05-11 05:18:27.077 (5) [P1T1]: loaded column: dataAvailability.status->success 2021-05-11 05:18:27.077 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2021-05-11 05:18:27.077 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2021-05-11 05:18:27.077 (5) [P1T1]: loaded column: dataAvailability.override->false 2021-05-11 05:18:27.077 (4) [P1T1]: Record Loaded 2021-05-11 05:18:27.077 (5) [P1T1]: quoteValue(), nothing special about it=>[12819], type=class java.lang.Integer 2021-05-11 05:18:27.077 (5) [P1T1]: quoteValue(), nothing special about it=>[79559], type=class java.lang.Integer 2021-05-11 05:18:27.078 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:27.078 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`date`,`dataSourceID`,`statusText`,`id`,`override`,`updated`,`oldUpdated`,`status`,`needsRerun`) values ("2021-05-10",12819,null,79559,"false","2021-05-11 05:18:27","00:00:00","in progress","false")], genflags=yes 2021-05-11 05:18:27.079 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-05-11 05:18:27.079 (5) [P1T1]: addSub("db") 2021-05-11 05:18:27.079 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:27.079 (4) [P1T1]: time=0.001 2021-05-11 05:18:27.079 (4) [P1T1]: Query executed in 0.001s, 2 row(s) affected 2021-05-11 05:18:27.080 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:27.081 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`date`,`dataSourceID`,`override`,`updated`,`status`) values ("2021-05-10 00:00:00","12819","false","2021-05-11 05:18:27","in progress")], genflags=yes 2021-05-11 05:18:27.082 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-05-11 05:18:27.082 (5) [P1T1]: addSub("db") 2021-05-11 05:18:27.082 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:27.082 (4) [P1T1]: time=0.001 2021-05-11 05:18:27.082 (4) [P1T1]: Query executed in 0.001s, 1 row(s) affected 2021-05-11 05:18:27.088 (4) [P1T1]: preparing SQL statement [select admaxNominalMonthlyBudgets.ID,admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxCampaigns join `st-tracker`.admaxNominalMonthlyBudgets on admaxCampaigns.ID=admaxNominalMonthlyBudgets.admaxCampaignID where accountID=? and startDate<=? and (endDate is null or endDate>=?)] 2021-05-11 05:18:27.092 (4) [P1T1]: preparing SQL statement [select ID,accountID,admaxCampaignID,searchEngineAccountID,migrationDate,lastAdMaxRunDate from `st-tracker`.admaxCampaignMigrations where accountID=? and migrationDate>=? and lastAdMaxRunDate<=?] 2021-05-11 05:18:27.093 (4) [P1T1]: preparing SQL statement [select admaxNominalMonthlyBudgets.ID,admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxCampaigns join `st-tracker`.admaxNominalMonthlyBudgets on admaxCampaigns.ID=admaxNominalMonthlyBudgets.admaxCampaignID where accountID=? and startDate<=? and (endDate is null or endDate>=?)] 2021-05-11 05:18:27.099 (4) [P1T1]: preparing SQL statement [select ID,accountID,startDate,endDate,anniversaryDate from `st-tracker`.admaxAccountAnniversary where accountID=? and startDate<=? and (endDate is null or endDate>=?)] 2021-05-11 05:18:27.111 (4) [P1T1]: preparing SQL statement [select id, admaxCampaignID, startDate, endDate, status from `st-tracker`.admaxCampaignBudgetAccrualStatus where admaxCampaignID=? and startDate<=? and (endDate is null or endDate>=?)] 2021-05-11 05:18:27.113 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2021-05-11 05:18:27.115 (3) [P1T1]: Retrieved campaign status Active for AdMax campaign 10846 2021-05-11 05:18:27.115 (4) [P1T1]: preparing SQL statement [select id, admaxCampaignID, startDate, endDate, status from `st-tracker`.admaxCampaignBudgetAccrualStatus where admaxCampaignID=? and startDate<=? and (endDate is null or endDate>=?)] 2021-05-11 05:18:27.116 (4) [P1T1]: preparing SQL statement [SELECT status FROM `st-tracker`.admaxCampaigns WHERE id = ?] 2021-05-11 05:18:27.117 (3) [P1T1]: Retrieved campaign status Active for AdMax campaign 10846 2021-05-11 05:18:27.117 (4) [P1T1]: preparing SQL statement [select aseam.admaxCampaignID, aseam.searchEngineAccountID, sea.distributionID, ac.status from `st-tracker`.admaxCampaigns ac join `st-tracker`.admaxSearchEngineAccountMap aseam on aseam.admaxCampaignID = ac.id join tsacommon.searchEngineAccounts sea on sea.ID = aseam.searchEngineAccountID where ac.accountID = ?] 2021-05-11 05:18:27.119 (4) [P1T1]: preparing SQL statement [select changeTime from logging.searchEngineAccountChanges where `column` = 'searchEngineStatus' AND searchEngineAccountID = ? and newValue = 'deleted'] 2021-05-11 05:18:27.120 (4) [P1T1]: preparing SQL statement [select tsacommon.searchEngineAccounts.ID,staging.googleMccAdMax.date,staging.googleMccAdMax.clicks,staging.googleMccAdMax.cost,staging.googleMccAdMax.averagePosition from tsacommon.searchEngineAccounts left join staging.googleMccAdMax on staging.googleMccAdMax.campaignid=cast(tsacommon.searchEngineAccounts.searchEngineIdentifier as unsigned) where tsacommon.searchEngineAccounts.accountID=? and staging.googleMccAdMax.date=?] 2021-05-11 05:18:27.121 (4) [P1T1]: preparing SQL statement [select tsacommon.searchEngineAccounts.ID,staging.yahooJAdMax.date,staging.yahooJAdMax.clicks,staging.yahooJAdMax.cost,staging.yahooJAdMax.averagePosition from tsacommon.searchEngineAccounts left join staging.yahooJAdMax on tsacommon.searchEngineAccounts.accountID=staging.yahooJAdMax.accountID and staging.yahooJAdMax.campaignid=cast(tsacommon.searchEngineAccounts.searchEngineIdentifier as unsigned) where tsacommon.searchEngineAccounts.accountID=? and staging.yahooJAdMax.date=?] 2021-05-11 05:18:27.123 (4) [P1T1]: preparing SQL statement [select tsacommon.searchEngineAccounts.ID,staging.bingAdMax.date,staging.bingAdMax.clicks,staging.bingAdMax.cost,staging.bingAdMax.averagePosition from tsacommon.searchEngineAccounts left join staging.bingAdMax on staging.bingAdMax.campaignid=cast(tsacommon.searchEngineAccounts.searchEngineIdentifier as unsigned) where tsacommon.searchEngineAccounts.accountID=? and staging.bingAdMax.date=?] 2021-05-11 05:18:27.124 (4) [P1T1]: preparing SQL statement [select tsacommon.searchEngineAccounts.ID,staging.facebookAdMax.date,staging.facebookAdMax.clicks,staging.facebookAdMax.cost,staging.facebookAdMax.impressions from tsacommon.searchEngineAccounts left join staging.facebookAdMax on staging.facebookAdMax.campaignid=cast(tsacommon.searchEngineAccounts.searchEngineIdentifier as unsigned) where tsacommon.searchEngineAccounts.accountID=? and staging.facebookAdMax.date=?] 2021-05-11 05:18:27.126 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,type,date,pooledCarryover,dedicatedCarryover,commonCarryover from `st-tracker`.admaxCarryovers where admaxCampaignID=? and type=? and date=?] 2021-05-11 05:18:27.129 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,type,date,budget from `st-tracker`.admaxActualDailyBudgets where admaxCampaignID=? and type=? and date=?] 2021-05-11 05:18:27.131 (4) [P1T1]: preparing SQL statement [select admaxCampaignID,date,budget from `st-tracker`.admaxNominalDailyBudgets where admaxCampaignID=? and date=?] 2021-05-11 05:18:27.132 (4) [P1T1]: preparing SQL statement [select ID,searchEngineAccountID,date,balanceFactor from `st-tracker`.admaxSearchEngineAccountBalanceFactors where searchEngineAccountID=? and date=?] 2021-05-11 05:18:27.134 (4) [P1T1]: preparing SQL statement [select searchEngineAccountID,date,budget,actualSEBudget,budgetStatus from `st-tracker`.admaxSearchEngineAccountActualDailyBudgets where searchEngineAccountID=? and date=?] 2021-05-11 05:18:27.163 (3) [P1T1]: Distribution Properties Cache: Loading new properties for fc941eb4-7da1-4ba3-af44-5c15c72b77e3_ALGORITHM 2021-05-11 05:18:27,181 [P1T1] INFO o.a.c.h.auth.AuthChallengeProcessor - digest authentication scheme selected 2021-05-11 05:18:27.328 (4) [P1T1]: Using value true for property sabb.biddingEnabled.facebook of type ALGORITHM 2021-05-11 05:18:27.329 (4) [P1T1]: preparing SQL statement [select accountID,elementType,elementID,currentBid,currentBidSetDate,newBid,newBidSetDate,retryCount from `st-tracker`.admaxBids where accountID=? and elementType=? and elementID=?] 2021-05-11 05:18:27.331 (4) [P1T1]: preparing SQL statement [SELECT searchEngineUserID, accountID, distributionID, date, modifiedOn, isPaused FROM staging.adMaxReportTracker WHERE accountID = ? AND distributionID = ?] 2021-05-11 05:18:27.399 (4) [P1T1]: preparing SQL statement [select distinct admaxNominalMonthlyBudgets.ID,admaxNominalMonthlyBudgets.admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxCampaigns join `st-tracker`.admaxNominalMonthlyBudgets on admaxCampaigns.ID=admaxNominalMonthlyBudgets.admaxCampaignID join `st-tracker`.admaxSearchEngineAccountMap on admaxCampaigns.ID=admaxSearchEngineAccountMap.admaxCampaignID join tsacommon.searchEngineAccounts on admaxSearchEngineAccountMap.searchEngineAccountID=searchEngineAccounts.ID where admaxCampaigns.accountID=? and startDate<=? and (endDate is null or endDate>=?) and distributionID=?] 2021-05-11 05:18:27.401 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,createTime,type,carryoverAdjustment from `st-tracker`.admaxCarryoverAdjustments where admaxCampaignID=? and date(createTime)=?] 2021-05-11 05:18:27.402 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,createTime,type,carryoverAdjustment from `st-tracker`.admaxCarryoverAdjustments where admaxCampaignID=? and date(createTime)=?] 2021-05-11 05:18:27.408 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshFactor,budgetType,resellerID from `st-tracker`.admaxSloshFactors where elementType=? and startDate<=? and (endDate is null or endDate>=?) and sloshFactor< 1 and elementID in (10846)] 2021-05-11 05:18:27.409 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshFactor,budgetType,resellerID from `st-tracker`.admaxSloshFactors where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2021-05-11 05:18:27.411 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshFactor,budgetType,resellerID from `st-tracker`.admaxSloshFactors where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2021-05-11 05:18:27.414 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshFactor,budgetType,resellerID from `st-tracker`.admaxSloshFactors where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2021-05-11 05:18:27.422 (4) [P1T1]: preparing SQL statement [select admaxCampaignID,referenceID,createTime,refund from `st-tracker`.admaxCampaignRefunds where admaxCampaignID=? and date(createTime)=?] 2021-05-11 05:18:27.423 (4) [P1T1]: preparing SQL statement [select ID,admaxCampaignID,createTime,type,carryoverAdjustment from `st-tracker`.admaxCarryoverAdjustments where admaxCampaignID=? and date(createTime)=?] 2021-05-11 05:18:27.423 (4) [P1T1]: preparing SQL statement [select sum(data.commonCarryover) from (select distinct c.admaxCampaignID, c.commonCarryover from admaxCampaigns ac join admaxCarryovers c on c.admaxCampaignID = ac.ID and c.type=? and c.date = least(?, (select max(last_carryover.date) from admaxCarryovers last_carryover where last_carryover.admaxCampaignID = ac.ID and last_carryover.type = c.type)) join admaxNominalMonthlyBudgets anmb on anmb.admaxCampaignID = ac.ID and anmb.startDate = (select max(last_nom_budget.startDate) from admaxNominalMonthlyBudgets last_nom_budget where last_nom_budget.admaxCampaignID = ac.ID) join admaxSearchEngineAccountMap aseam on aseam.admaxCampaignID = ac.ID join tsacommon.searchEngineAccounts sea on sea.ID = aseam.searchEngineAccountID where ac.accountID=? and ac.status=? and ((anmb.endDate is null) or (? > anmb.endDate)) and sea.distributionID = ?) data] 2021-05-11 05:18:27.426 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshLimit,budgetType,resellerID from `st-tracker`.admaxSloshLimits where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2021-05-11 05:18:27.433 (4) [P1T1]: Sorted campaign order: [com.thesearchagency.admax.algorithms.common.AdMaxDataCollection@452eb10a] 2021-05-11 05:18:27.457 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,boostMultiplier,boostCap,resellerID from `st-tracker`.admaxBoosts where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2021-05-11 05:18:27.463 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,sloshLimit,budgetType,resellerID from `st-tracker`.admaxSloshLimits where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2021-05-11 05:18:27.464 (4) [P1T1]: Pooled carryover limit for AdMaxCampaignID 10846: 2888.0 2021-05-11 05:18:27.466 (4) [P1T1]: preparing SQL statement [select ID,elementType,elementID,startDate,endDate,budgetCapMultiplier,resellerID from `st-tracker`.admaxBudgetCapMultipliers where elementType=? and elementID=? and startDate<=? and (endDate is null or endDate>=?) and resellerID=?] 2021-05-11 05:18:27.473 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxCarryovers (admaxCampaignID, type, date, pooledCarryover, dedicatedCarryover, commonCarryover) values (?,?,?,?,?,?) on duplicate key update pooledCarryover=?,dedicatedCarryover=?,commonCarryover=?] 2021-05-11 05:18:27.479 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxActualDailyBudgets (admaxCampaignID, type, date, budget) values (?,?,?,?) on duplicate key update budget=?] 2021-05-11 05:18:27.480 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxNominalDailyBudgets (admaxCampaignID, date, budget) values (?,?,?) on duplicate key update budget=?] 2021-05-11 05:18:27.481 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxSearchEngineAccountBalanceFactors (searchEngineAccountID, date, balanceFactor) values (?,?,?) on duplicate key update balanceFactor=?] 2021-05-11 05:18:27.482 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxSearchEngineAccountActualDailyBudgets (searchEngineAccountID, date, budget, actualSEBudget, budgetStatus) values (?,?,?,?,?) on duplicate key update budget=?, actualSEBudget=?, budgetStatus=?] 2021-05-11 05:18:27.489 (5) [P1T1]: quoteValue(), nothing special about it=>[2964], type=class java.lang.Integer 2021-05-11 05:18:27.489 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:27.489 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=2964) limit 1] 2021-05-11 05:18:27.491 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-05-11 05:18:27.491 (5) [P1T1]: addSub("db") 2021-05-11 05:18:27.491 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-05-11 05:18:27.491 (4) [P1T1]: time=0.002 2021-05-11 05:18:27.491 (4) [P1T1]: Query executed in 0.002s 2021-05-11 05:18:27.491 (5) [P1T1]: loading 21 columns from result set: 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.id->2964 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.description->fc941eb4-7da1-4ba3-af44-5c15c72b77e3 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.tier->1 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.priority->50 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.reportConversions->false 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.conversionTypes->paid 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.isActive->true 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.perfMetric->cpa 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.addConversionData->true 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.nowTime->null 2021-05-11 05:18:27.491 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2021-05-11 05:18:27.491 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2021-05-11 05:18:27.492 (5) [P1T1]: loaded column: accounts.isOnline->true 2021-05-11 05:18:27.492 (5) [P1T1]: loaded column: accounts.currencyCode->USD 2021-05-11 05:18:27.492 (5) [P1T1]: loaded column: accounts.timeZoneID->America/New_York 2021-05-11 05:18:27.492 (4) [P1T1]: Record Loaded 2021-05-11 05:18:27.492 (4) [P1T1]: Waiting up to 7200 seconds to lock fc941eb4-7da1-4ba3-af44-5c15c72b77e3. 2021-05-11 05:18:27.492 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:27.492 (4) [P1T1]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.fc941eb4-7da1-4ba3-af44-5c15c72b77e3', 7200)] 2021-05-11 05:18:27.493 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-05-11 05:18:27.493 (5) [P1T1]: addSub("db") 2021-05-11 05:18:27.494 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:27.494 (4) [P1T1]: time=0.001 2021-05-11 05:18:27.494 (4) [P1T1]: Query executed in 0.001s 2021-05-11 05:18:27.494 (4) [P1T1]: Locked account: fc941eb4-7da1-4ba3-af44-5c15c72b77e3 2021-05-11 05:18:27.494 (4) [P1T1]: preparing SQL statement [select id,accountID,distributionID,searchEngineUserID,searchEngineIdentifier,budgetSearchEngineIdentifier,budgetAmount,searchEngineStatus from `tsacommon`.searchEngineAccounts where id=?] 2021-05-11 05:18:27.496 (5) [P1T1]: quoteValue(), nothing special about it=>[4637], type=class java.lang.Long 2021-05-11 05:18:27.496 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:27.496 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`searchEngineUsers` where (`id`=4637) limit 1] 2021-05-11 05:18:27.497 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-05-11 05:18:27.497 (5) [P1T1]: addSub("db") 2021-05-11 05:18:27.498 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:27.498 (4) [P1T1]: time=0.001 2021-05-11 05:18:27.498 (4) [P1T1]: Query executed in 0.001s 2021-05-11 05:18:27.498 (5) [P1T1]: loading 14 columns from result set: 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.id->4637 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.accountID->2964 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.distributionID->177 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.searchEngineIdentifier->780214236092310 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.description->fc941eb4-7da1-4ba3-af44-5c15c72b77e3_1_qa4amltest_SandboxTest01 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.username-> 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.password-> 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.enabled->true 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.inTsaMcc->true 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.apiKey-> 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.managerUsernames->null 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.managerIDs->null 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.lastChecked->2021-05-10 07:31:44.0 2021-05-11 05:18:27.498 (5) [P1T1]: loaded column: searchEngineUsers.lastInMcc->null 2021-05-11 05:18:27.498 (4) [P1T1]: Record Loaded 2021-05-11 05:18:27.504 (5) [P1T1]: quoteValue(), nothing special about it=>[2964], type=class java.lang.Integer 2021-05-11 05:18:27.505 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:27.505 (4) [P1T1]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=2964) limit 1] 2021-05-11 05:18:27.506 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-05-11 05:18:27.506 (5) [P1T1]: addSub("db") 2021-05-11 05:18:27.506 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:27.506 (4) [P1T1]: time=0.001 2021-05-11 05:18:27.506 (4) [P1T1]: Query executed in 0.001s 2021-05-11 05:18:27.506 (5) [P1T1]: loading 21 columns from result set: 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.id->2964 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.description->fc941eb4-7da1-4ba3-af44-5c15c72b77e3 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.tier->1 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.priority->50 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.reportClicksOut->false 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.reportConversions->false 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.conversionTypes->paid 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.isBidManaged->true 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.isActive->true 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.perfMetric->cpa 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.providesConversionData->true 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.addConversionData->true 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.fractionalConversionCounts->false 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.hideNullSources->false 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.nowTime->null 2021-05-11 05:18:27.506 (5) [P1T1]: skipping invalid column: accounts.warehouseDatabase 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.databaseInstance->1 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.warehouseInstance->1 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.isOnline->true 2021-05-11 05:18:27.506 (5) [P1T1]: loaded column: accounts.currencyCode->USD 2021-05-11 05:18:27.507 (5) [P1T1]: loaded column: accounts.timeZoneID->America/New_York 2021-05-11 05:18:27.507 (4) [P1T1]: Record Loaded 2021-05-11 05:18:28,084 [P1T1] DEBUG c.t.s.facebook.FacebookApiUtils - Getting FB properties using distribution service 2021-05-11 05:18:28.085 (3) [P1T1]: Distribution Properties Cache: Loading new properties for fc941eb4-7da1-4ba3-af44-5c15c72b77e3_CONTENT_EDITOR 2021-05-11 05:18:28.181 (4) [P1T1]: Using value TZ_AMERICA_NEW_YORK for property fb.timeZone of type CONTENT_EDITOR 2021-05-11 05:18:28.181 (4) [P1T1]: Using value en-US for property fb.locale of type CONTENT_EDITOR 2021-05-11 05:18:28.181 (4) [P1T1]: Using value true for property fb.enableInstagramStream of type CONTENT_EDITOR 2021-05-11 05:18:28.181 (4) [P1T1]: Using value null for property fb.enableRightColumn of type CONTENT_EDITOR 2021-05-11 05:18:28.181 (4) [P1T1]: Using value false for property fb.enableTravelingIn of type CONTENT_EDITOR 2021-05-11 05:18:28.181 (4) [P1T1]: Using value https://www.admaxlocal.com/ for property fb.followUpActionUrl of type CONTENT_EDITOR 2021-05-11 05:18:28.181 (4) [P1T1]: Using value https://www.admaxlocal.com/privacy-policy for property fb.privacyPolicyUrl of type CONTENT_EDITOR 2021-05-11 05:18:28.181 (4) [P1T1]: Using value LEAD for property fb.customEventType of type CONTENT_EDITOR CrashReporter : Enabled! 2021-05-11 05:18:28,187 [P1T1] DEBUG c.t.s.c.f.impl.FacebookAdsClient - Created FacebookAdsClient for 780214236092310 2021-05-11 05:18:28.191 (4) [P1T1]: preparing SQL statement [select ecp.id, ecp.description, ecp.accountID, ecp.admaxCampaignID,ecp. status, ecp.typeID from clients.externalCampaignParent ecp join clients.externalCampaign ec on ec.externalCampaignParentID = ecp.ID where ec.searchEngineAccountID = ?] 2021-05-11 05:18:28.193 (4) [P1T1]: preparing SQL statement [select id,accountID,distributionID,searchEngineUserID,searchEngineIdentifier,budgetSearchEngineIdentifier,budgetAmount,searchEngineStatus from `tsacommon`.searchEngineAccounts where id=?] 2021-05-11 05:18:28,203 [P1T1] INFO c.t.s.c.f.i.s.CampaignServiceClient - Updating 1 Facebook campaigns budget for accountID 780214236092310 Post: https://graph.facebook.com/ Content-Disposition: form-data; name="access_token" EAAJKaZCNuOywBAKB5euLcQS0FSb6xWT2XBnl71G0dgRT23ipZA7XM7KaawkFP2mfoMsh1xUCDoMBrnAyK55UeANmMrLeGLXIlN8FPKXf0zPS0O5o8wM7KvSGFMHzJZCp3fB8ctkgKqWILJeb3xj5EX2ngwefibl7oBM6t8MQwk6xVWcQUcFkr7pjGbcgicZD Content-Disposition: form-data; name="appsecret_proof" e65fd9ff8cfd2ed4fadb547107c19ff4f6c855362b924b484f9d2eaae8fa5f2c Content-Disposition: form-data; name="include_headers" false Content-Disposition: form-data; name="batch" [{"method":"POST","relative_url":"v10.0/120330000564297112/","name":"Request0","omit_response_on_success":false,"body":"daily_budget=16&status=ACTIVE","attached_files":{}}] ----------------------------4693608630826417253-- [{"code":400,"body":"{\"error\":{\"message\":\"Invalid parameter\",\"type\":\"OAuthException\",\"code\":100,\"error_subcode\":1885650,\"is_transient\":false,\"error_user_title\":\"Budget too low\",\"error_user_msg\":\"Your budget must be at least $4.00. This minimum amount is required to account for any spending that occurs while your budget is updated, which may take up to 15 minutes.\",\"fbtrace_id\":\"AN_clIsODC_1ZOxUghzV5Ye\"}}"}] 2021-05-11 05:18:32,505 [P1T1] INFO c.t.s.c.f.i.s.CampaignServiceClient - Failed to update Facebook campaign budget for accountID 780214236092310 2021-05-11 05:18:32,515 [P1T1] INFO c.t.s.c.f.u.e.i.CustomerErrorEntityFactory - Facebook ServiceException Error Found 2021-05-11 05:18:32,517 [P1T1] DEBUG c.t.s.c.f.i.request.ResponseMapper - ******* Error ******* 2021-05-11 05:18:32,517 [P1T1] DEBUG c.t.s.c.f.i.request.ResponseMapper - code = 100 2021-05-11 05:18:32,517 [P1T1] DEBUG c.t.s.c.f.i.request.ResponseMapper - message = Invalid parameter 2021-05-11 05:18:32,517 [P1T1] DEBUG c.t.s.c.f.i.request.ResponseMapper - errorType = OAuthException 2021-05-11 05:18:32,517 [P1T1] DEBUG c.t.s.c.f.i.request.ResponseMapper - errorSubCode = 1885650 2021-05-11 05:18:32,517 [P1T1] DEBUG c.t.s.c.f.i.request.ResponseMapper - errorUserTitle = Budget too low 2021-05-11 05:18:32,517 [P1T1] DEBUG c.t.s.c.f.i.request.ResponseMapper - errorUserMessage = Your budget must be at least $4.00. This minimum amount is required to account for any spending that occurs while your budget is updated, which may take up to 15 minutes. 2021-05-11 05:18:32,517 [P1T1] DEBUG c.t.s.c.f.i.request.ResponseMapper - details = 2021-05-11 05:18:32,519 [P1T1] WARN c.t.s.c.f.impl.request.Request - Could not retry FacebookResponseException with request com.thesearchagency.services.client.facebook.impl.FacebookResponseException: CustomerErrorEntityFactory Error at com.thesearchagency.services.client.facebook.impl.request.ResponseMapper.throwExceptionIfTopLevelErrors(ResponseMapper.java:76) at com.thesearchagency.services.client.facebook.impl.request.ResponseMapper.handle(ResponseMapper.java:45) at com.thesearchagency.services.client.facebook.impl.serviceclient.CampaignServiceClient$5.sendRequest(CampaignServiceClient.java:338) at com.thesearchagency.services.client.facebook.impl.request.Request.call(Request.java:16) at com.thesearchagency.services.client.facebook.impl.serviceclient.ServiceClient.executeRequest(ServiceClient.java:83) at com.thesearchagency.services.client.facebook.impl.serviceclient.CampaignServiceClient.updateCampaignBudgets(CampaignServiceClient.java:342) at com.thesearchagency.services.client.facebook.impl.FacebookAdsClient.updateCampaignBudgets(FacebookAdsClient.java:228) at com.thesearchagency.admax.algorithms.common.FacebookBudgetUpdateManager.updateCampaigns(FacebookBudgetUpdateManager.java:244) at com.thesearchagency.admax.algorithms.common.FacebookBudgetUpdateManager.updateCampaignArray(FacebookBudgetUpdateManager.java:162) at com.thesearchagency.admax.algorithms.common.FacebookBudgetUpdateManager.executeBulkUserCampaignUpdates(FacebookBudgetUpdateManager.java:105) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.updateSearchEngineAccounts(AdMaxSABBAlgorithm.java:1073) at com.thesearchagency.admax.algorithms.sabb.AdMaxSABBAlgorithm.applyAlgorithm(AdMaxSABBAlgorithm.java:344) at com.thesearchagency.admax.AdMaxSummarizer$AccountWorker.call(AdMaxSummarizer.java:644) at com.thesearchagency.admax.AdMaxSummarizer$AccountWorker.call(AdMaxSummarizer.java:505) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2021-05-11 05:18:32.519 (3) [P1T1]: Error while updating the collection of campaigns! 2021-05-11 05:18:32.519 (2) [P1T1]: Error occurred updating Facebook campaign with seID 120330000564297112. 2021-05-11 05:18:32.519 (4) [P1T1]: preparing SQL statement [update `tsacommon`.searchEngineAccounts set searchEngineStatus=?, searchEngineStatusText=? where searchEngineIdentifier=?] 2021-05-11 05:18:32.520 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:32.520 (4) [P1T1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.fc941eb4-7da1-4ba3-af44-5c15c72b77e3')] 2021-05-11 05:18:32.522 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-05-11 05:18:32.522 (5) [P1T1]: addSub("db") 2021-05-11 05:18:32.522 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-05-11 05:18:32.522 (4) [P1T1]: time=0.002 2021-05-11 05:18:32.522 (4) [P1T1]: Query executed in 0.002s 2021-05-11 05:18:32.524 (4) [P1T1]: Using value true for property sabb.biddingEnabled.facebook of type ALGORITHM 2021-05-11 05:18:32.524 (4) [P1T1]: Using value 1.1 for property sabb.bouncePosition.facebook of type ALGORITHM 2021-05-11 05:18:32.524 (4) [P1T1]: Using value 7 for property sabb.spendToBudgetDays.facebook of type ALGORITHM 2021-05-11 05:18:32.524 (4) [P1T1]: preparing SQL statement [select SUM(staging.facebookAdMax.cost) as cost from tsacommon.searchEngineAccounts left join staging.facebookAdMax on staging.facebookAdMax.campaignid=cast(tsacommon.searchEngineAccounts.searchEngineIdentifier as unsigned) where tsacommon.searchEngineAccounts.ID=? and staging.facebookAdMax.date>=? and staging.facebookAdMax.date<=?] 2021-05-11 05:18:32.535 (3) [P1T1]: Retrieved total spend(spendToBudgetDays:7, period: 04-05-2021 to 10-05-2021) :0.0 for SearchEngineAccount 21503 2021-05-11 05:18:32.535 (4) [P1T1]: preparing SQL statement [select SUM(budget) as budget from `st-tracker`.admaxSearchEngineAccountActualDailyBudgets where searchEngineAccountID=? and date>=? and date<=?] 2021-05-11 05:18:32.537 (3) [P1T1]: Retrieved total budget(spendToBudgetDays:7, period: 04-05-2021 to 10-05-2021) :8.0 for SearchEngineAccount 21503 2021-05-11 05:18:32.537 (4) [P1T1]: Using value 90 for property sabb.lowSpendBudgetRatioThreshold.facebook of type ALGORITHM 2021-05-11 05:18:32.537 (4) [P1T1]: Using value 0.50 for property sabb.maxLowSpendBudgetBidAdjustment.facebook.USD of type ALGORITHM 2021-05-11 05:18:32.537 (4) [P1T1]: Using value 0.01 for property sabb.bidAdjustmentThreshold.facebook.USD of type ALGORITHM 2021-05-11 05:18:32.537 (4) [P1T1]: Using value 0.01 for property sabb.minBid.facebook.USD of type ALGORITHM 2021-05-11 05:18:32.537 (4) [P1T1]: Using value 1000.00 for property sabb.maxBid.facebook.USD of type ALGORITHM 2021-05-11 05:18:32.537 (4) [P1T1]: preparing SQL statement [insert into `st-tracker`.admaxBids values (?,?,?,?,?,?,?,?) on duplicate key update newBid=?,newBidSetDate=?,retryCount=?] 2021-05-11 05:18:32.538 (3) [P1T1]: New bid for SE campaign 21503: 0.25 ==> 0.75 2021-05-11 05:18:32.539 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:32.539 (4) [P1T1]: spike: SQL->[select * from `dataAvailability` where ((`date`="2021-05-10 00:00:00") and (`dataSourceID`="12819")) limit 1] 2021-05-11 05:18:32.540 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-05-11 05:18:32.540 (5) [P1T1]: addSub("db") 2021-05-11 05:18:32.540 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:32.540 (4) [P1T1]: time=0.001 2021-05-11 05:18:32.541 (4) [P1T1]: Query executed in 0.001s 2021-05-11 05:18:32.541 (5) [P1T1]: loading 9 columns from result set: 2021-05-11 05:18:32.541 (5) [P1T1]: loaded column: dataAvailability.id->79559 2021-05-11 05:18:32.541 (5) [P1T1]: loaded column: dataAvailability.date->2021-05-10 2021-05-11 05:18:32.541 (5) [P1T1]: loaded column: dataAvailability.oldUpdated->00:00:00 2021-05-11 05:18:32.541 (5) [P1T1]: loaded column: dataAvailability.updated->2021-05-11 05:18:27.0 2021-05-11 05:18:32.541 (5) [P1T1]: loaded column: dataAvailability.dataSourceID->12819 2021-05-11 05:18:32.541 (5) [P1T1]: loaded column: dataAvailability.status->in progress 2021-05-11 05:18:32.541 (5) [P1T1]: loaded column: dataAvailability.statusText->null 2021-05-11 05:18:32.541 (5) [P1T1]: loaded column: dataAvailability.needsRerun->false 2021-05-11 05:18:32.541 (5) [P1T1]: loaded column: dataAvailability.override->false 2021-05-11 05:18:32.541 (4) [P1T1]: Record Loaded 2021-05-11 05:18:32.541 (5) [P1T1]: quoteValue(), nothing special about it=>[12819], type=class java.lang.Integer 2021-05-11 05:18:32.541 (5) [P1T1]: quoteValue(), nothing special about it=>[79559], type=class java.lang.Integer 2021-05-11 05:18:32.541 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:32.541 (4) [P1T1]: spike: SQL->[replace into `dataAvailability` (`date`,`dataSourceID`,`statusText`,`id`,`override`,`updated`,`oldUpdated`,`status`,`needsRerun`) values ("2021-05-10",12819,null,79559,"false","2021-05-11 05:18:32","00:00:00","success","false")], genflags=yes 2021-05-11 05:18:32.548 (5) [P1T1]: recordAsSubs("db", 7, "P1T1") 2021-05-11 05:18:32.548 (5) [P1T1]: addSub("db") 2021-05-11 05:18:32.548 (5) [P1T1]: ProfilerRec.end("db", true): ret=7 2021-05-11 05:18:32.548 (4) [P1T1]: time=0.007 2021-05-11 05:18:32.548 (4) [P1T1]: Query executed in 0.007s, 2 row(s) affected 2021-05-11 05:18:32.549 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:32.549 (4) [P1T1]: spike: SQL->[insert into `dataAvailabilityHistory` (`date`,`dataSourceID`,`override`,`updated`,`status`) values ("2021-05-10 00:00:00","12819","false","2021-05-11 05:18:32","success")], genflags=yes 2021-05-11 05:18:32.551 (5) [P1T1]: recordAsSubs("db", 2, "P1T1") 2021-05-11 05:18:32.551 (5) [P1T1]: addSub("db") 2021-05-11 05:18:32.551 (5) [P1T1]: ProfilerRec.end("db", true): ret=2 2021-05-11 05:18:32.551 (4) [P1T1]: time=0.002 2021-05-11 05:18:32.551 (4) [P1T1]: Query executed in 0.002s, 1 row(s) affected 2021-05-11 05:18:32.551 (3) [P1T1]: Finished applying algorithm [SABB] for account [2964] in distributions [3, 178, 147, 177] 2021-05-11 05:18:32.551 (5) [P1T1]: ProfilerRec.start("db",true) in Thread [P1T1] 2021-05-11 05:18:32.551 (4) [P1T1]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admax.common.AdMaxCampaignMigrator.2964')] 2021-05-11 05:18:32.552 (5) [P1T1]: recordAsSubs("db", 1, "P1T1") 2021-05-11 05:18:32.552 (5) [P1T1]: addSub("db") 2021-05-11 05:18:32.552 (5) [P1T1]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:32.552 (4) [P1T1]: time=0.001 2021-05-11 05:18:32.552 (4) [P1T1]: Query executed in 0.001s 2021-05-11 05:18:32.552 (3) [P1T1]: Released migrator lock for Account ID #2964 2021-05-11 05:18:32.552 (4) [P1T1]: Returning Object to Pool 2021-05-11 05:18:32.552 (4) [P1T1]: Returning Object to Pool 2021-05-11 05:18:32.552 (4) [P1T1]: Returning Object to Pool 2021-05-11 05:18:32.552 (4) [P1T1]: Returning Object to Pool 2021-05-11 05:18:32.552 (3) [P1T1]: Completed Account ID #2964: fc941eb4-7da1-4ba3-af44-5c15c72b77e3 2021-05-11 05:18:32.565 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true] 2021-05-11 05:18:32.565 (3) [main]: ------------AdMax Summarizer done 2021-05-11 05:18:32.565 (3) [main]: =============== Completed AdMax Summarizer ================ 2021-05-11 05:18:32.565 (4) [main]: DataCache: Found key global-logging 2021-05-11 05:18:32.565 (4) [main]: Took Existing Object from Pool 2021-05-11 05:18:32.565 (5) [main]: ProfilerRec.start("db",true) in Thread [main] 2021-05-11 05:18:32.565 (4) [main]: spike: SQL->[select @@version] 2021-05-11 05:18:32.566 (2) [main]: Warning(s) detected in statement [select @@version] executed by user [spike] 2021-05-11 05:18:32.566 (2) [main]: Table 'logging.processHistory' doesn't exist (1146) 2021-05-11 05:18:32.566 (5) [main]: recordAsSubs("db", 1, "main") 2021-05-11 05:18:32.566 (5) [main]: addSub("db") 2021-05-11 05:18:32.567 (5) [main]: ProfilerRec.end("db", true): ret=1 2021-05-11 05:18:32.567 (4) [main]: time=0.001 2021-05-11 05:18:32.567 (4) [main]: Query executed in 0.001s 2021-05-11 05:18:32.567 (4) [main]: test query succeeded, returned "5.5.34" 2021-05-11 05:18:32.567 (3) [main]: Could not save process history stop 2021-05-11 05:18:32.567 (4) [main]: Returning Object to Pool 2021-05-11 05:18:32.567 (3) [main]: =============== Stats ================ 2021-05-11 05:18:32.567 (3) [main]: --- Process --- 2021-05-11 05:18:32.567 (3) [main]: 2021-05-11 05:18:32.567 (3) [main]: ABU Process(start): Tue May 11 05:18:26 UTC 2021 2021-05-11 05:18:32.567 (3) [main]: ABU Process(stop): Tue May 11 05:18:32 UTC 2021 2021-05-11 05:18:32.567 (3) [main]: 2021-05-11 05:18:32.567 (3) [main]: --- Accounts --- 2021-05-11 05:18:32.567 (3) [main]: 2021-05-11 05:18:32.567 (3) [main]: Accounts Processed: 1 2021-05-11 05:18:32.567 (3) [main]: Accounts Skipped: 0 2021-05-11 05:18:32.567 (3) [main]: Accounts Processed Successfully: 1 2021-05-11 05:18:32.567 (3) [main]: 2021-05-11 05:18:32.567 (3) [main]: --- Campaigns --- 2021-05-11 05:18:32.567 (3) [main]: 2021-05-11 05:18:32.567 (3) [main]: Campaigns Processed: 1 2021-05-11 05:18:32.567 (3) [main]: Campaigns Processed Successfully: 1 2021-05-11 05:18:32.567 (3) [main]: Campaign Budgets Capped: 0 2021-05-11 05:18:32.567 (3) [main]: 2021-05-11 05:18:32.567 (3) [main]: --- SE Campaigns --- 2021-05-11 05:18:32.567 (3) [main]: 2021-05-11 05:18:32.567 (3) [main]: SE Campaigns Processed: 1 2021-05-11 05:18:32.567 (3) [main]: SE Campaigns Processed Successfully: 1 2021-05-11 05:18:32.567 (3) [main]: 2021-05-11 05:18:32.567 (3) [main]: --- Budget/Spend --- 2021-05-11 05:18:32.567 (3) [main]: 2021-05-11 05:18:32.567 (3) [main]: SE Campaign Budgets Updated: 1 2021-05-11 05:18:32.567 (3) [main]: SE Campaign Budgets Sent To Google: 0 2021-05-11 05:18:32.567 (3) [main]: SE Campaign Budgets Sent To Yahoo Japan:0 2021-05-11 05:18:32.567 (3) [main]: SE Campaign Budgets Sent To Bing: 0 2021-05-11 05:18:32.567 (3) [main]: SE Campaign Budgets Sent To Facebook: 1 2021-05-11 05:18:32.568 (3) [main]: 2021-05-11 05:18:32.568 (3) [main]: Spend Total: 0.0 2021-05-11 05:18:32.568 (3) [main]: Common Carryover Total: 8.0 2021-05-11 05:18:32.568 (3) [main]: 2021-05-11 05:18:32.568 (3) [main]: --- Bids --- 2021-05-11 05:18:32.568 (3) [main]: 2021-05-11 05:18:32.568 (3) [main]: New Campaign Bids: 1 2021-05-11 05:18:32.568 (3) [main]: 2021-05-11 05:18:32.568 (5) [main]: ProfilerRec.end("AdMaxSummarizer", false): ret=6416 2021-05-11 05:18:32.568 (4) [main]: time=6.416 2021-05-11 05:18:32.568 (3) [main]: AdMaxSummarizer: 6.416s 2021-05-11 05:18:32.568 (3) [main]: by key: 2021-05-11 05:18:32.568 (4) [main]: time=0.058 2021-05-11 05:18:32.568 (3) [main]: db: 0.058s 2021-05-11 05:18:32.568 (3) [main]: by thread: 2021-05-11 05:18:32.568 (4) [main]: time=0.007 2021-05-11 05:18:32.568 (3) [main]: main: 0.007s 2021-05-11 05:18:32.568 (4) [main]: time=0.051 2021-05-11 05:18:32.568 (3) [main]: P1T1: 0.051s 2021-05-11 05:18:32.568 (4) [main]: time=6.358 2021-05-11 05:18:32.568 (3) [main]: other: 6.358s [TSAApp@aml-qa4-core1 bidmgr]$