Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:
QA2:
• Reseller UI – RC 4 (Build 89)
• Merchant UI – RC4 (Build 89)
• Sapi – RC3 (Build 289)
• Core – Johnston 2.2.1 RELEASE P1
• Listener - Johnston 2.2.1 RELEASE P1
-
Sprint:Sprint 1
Description
Seeing this exception in whsumm:
2013-10-08 10:01:35.774 (1) [P1T14]: Exception [error inserting SQL rows into `warehouse_1`.`searchEngineGroups` from file /tmp/203searchEngineGroups2216402495425256989.tmp]:java.lang.NullPointerException
at com.thesearchagency.db.util.BatchInsertUtil.getTypeClass(BatchInsertUtil.java:246)
at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:114)
at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:177)
at com.thesearchagency.perf.WarehouseSummarizer$AccountWorker.syncDimensions(WarehouseSummarizer.java:2274)
at com.thesearchagency.perf.WarehouseSummarizer$AccountWorker.run(WarehouseSummarizer.java:531)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Missing DB changes:
ALTER TABLE `warehouse_1`.`searchEngineGroups` ADD COLUMN `keywordMaxCpc` DOUBLE NOT NULL DEFAULT 0 AFTER `keywordContentMaxCpc`;
ALTER TABLE `warehouse_1`.`searchEngineGroups` ADD COLUMN `keywordContentMaxCpc` DOUBLE NOT NULL DEFAULT 0 AFTER `searchEngineStatusText`;
