Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: Fuji
-
Fix Version/s: Fuji
-
Component/s: Admax (bidding/budgeting)
-
Labels:None
-
Environment:
Sapi – RC - Build 836
Reseller UI – RC - Build 216
Core – Build 254
BidMgr – Build 482
-
Sprint:Sprint 10
Description
sebidupdater.sh does not notify errors when bogus value/mismatch happens.
This will not be missed when the alarm script runs for notification.
Steps:
1) Create an order and deploy
2) Run ABU
3) Update SEIdentifier in `st-tracker`.searchEngineGroups to some bogus value
4) Run sebidupdater.sh
Log seen:
2014-11-05 14:34:47,712 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - ******* Error *******
2014-11-05 14:34:47,712 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - code = 10100
2014-11-05 14:34:47,712 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - message = DEACTIVATED
2014-11-05 14:34:47,713 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - ******* Error Detail *******
2014-11-05 14:34:47,713 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - request key = adGroupId
2014-11-05 14:34:47,713 [P1T1] DEBUG c.t.s.c.yahoojapan.util.SoapUtils - request value = 161010010
2014-11-05 14:34:47.713 (4) [P1T1]: preparing SQL statement [update `st-tracker`.admaxBids ab join `tsacommon`.searchEngineAccounts sea on sea.id = ab.elementID set ab.currentBid=ab.newBid,ab.newBid=NULL,ab.newBidSetDate=NULL,ab.currentBidSetDate=?,ab.retryCount=0 where ab.newBid IS NOT NULL and sea.distributionID=? and ab.elementID in (983,982)]
2014-11-05 14:34:47.717 (3) [P1T1]: Updated rows (2) matched the number of pending updates (2)
2014-11-05 14:34:47.717 (3) [P1T1]: Completed User (620) "1cf066db-53c9-4e64-a7fe-f731f51367ce_1"
2014-11-05 14:34:47.717 (4) [P1T1]: Returning Object to Pool
2014-11-05 14:34:47.718 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2014-11-05 14:34:47.718 (3) [main]: ------------Search Engine Bid Updater done
2014-11-05 14:34:47.718 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2014-11-05 14:34:47.718 (4) [main]: Took Existing Object from Pool
2014-11-05 14:34:47.718 (5) [main]: ProfilerRec.start("db",true) in Thread [main]
2014-11-05 14:34:47.718 (4) [main]: spike: SQL->[select @@version]
2014-11-05 14:34:47.720 (5) [main]: recordAsSubs("db", 2, "main")
2014-11-05 14:34:47.720 (5) [main]: ProfilerRec.end("db", true): ret=2
2014-11-05 14:34:47.720 (4) [main]: time=0.0020
2014-11-05 14:34:47.720 (4) [main]: Query executed in 0.002s
2014-11-05 14:34:47.720 (4) [main]: test query succeeded, returned "5.5.34"
2014-11-05 14:34:47.720 (4) [main]: Instantiating an AdmaxBidErrorDAO object for Database: jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true
2014-11-05 14:34:47.720 (4) [main]: preparing SQL statement [ select `st-tracker`.admaxBidErrors.admaxBidAccountID,`st-tracker`.admaxBidErrors.admaxBidElementType,`st-tracker`.admaxBidErrors.admaxBidElementID,`st-tracker`.admaxBidErrors.errorCode,`st-tracker`.admaxBidErrors.errorText,`st-tracker`.admaxBidErrors.reason,`st-tracker`.admaxBidErrors.field,`st-tracker`.admaxBidErrors.trigger,`st-tracker`.admaxBidErrors.runDate from `st-tracker`.admaxBidErrors]
2014-11-05 14:34:47.730 (4) [main]: Returning Object to Pool
admaxBids table has no retruCount entry and no entry in admaxBidErrors table as well.
