Details
-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: Premium Portal 2
-
Component/s: None
-
Labels:None
-
Environment:
Build:tsa-build-bidmgr-2010-09-14-p60-r1462
System:yell-dev-xml and yell-dev-mms1
Description
Redeploying of the campaign doesn't update location name of AdGroup,
also newly created textAds rows have "NULL" searchEngineIdenitifer and previously created textAds have status - Enabled instead of "Disabled"
Steps to reproduce:
1)Deploy the campaign using AdmaxserviceBinding (E.g. gptest81) with location- "testReading" [Note: deploy Campaign is attached.]
2)Update the locations from "reading" to "testReading"
UPDATE locations SET description='Reading' WHERE id=733;
3)Deploy the campaign using BS_ProcessDeployEventBinding
4)Check the listener log
tail -f /var/log/tsa-admax-jmslistener.log
2010-09-17 12:20:57.990 (2) [P12T1]: Exception [Exception running content editor, quitting]:java.lang.Exception: adgroup does not exist for campaign.id(45421) adgroup.name(gptest81_1000000003_733_gptest-81_Reading)
at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditorHelper.replaceKeywords(GoogleContentEditorHelper.java:300)
at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditorHelper.replace(GoogleContentEditorHelper.java:226)
at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditor$SearchEngineUserWorker.handlePreRunActions(GoogleContentEditor.java:886)
at com.thesearchagency.searchengines.google.contenteditor.GoogleContentEditor$SearchEngineUserWorker.run(GoogleContentEditor.java:822)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
5)Check the table
SELECT * FROM gce_adGroup WHERE Campaignid = 45421 ;
and
SELECT * FROM gce_textAd WHERE adGroupID IN (SELECT id FROM gce_adGroup WHERE Campaignid = 45421);