Details
-
Type: Bug
-
Status: Closed
-
Priority: Minor
-
Resolution: Cannot Reproduce
-
Affects Version/s: 1.3.0
-
Fix Version/s: 1.3.0
-
Component/s: AdMax Deployment Service
-
Labels:None
-
Environment:
QA Environment
smb-datafeed-ear-1.3.0-SNAPSHOT-p525-t20120612-110225-CI.ear
optus-ear-1.3.0-SNAPSHOT-p716-t20120627-161550-CI.ear
Description
While deploying Campaign, it throws exception -Exception [Error auditing initial campaign deployment]:java.lang.reflect.UndeclaredThrowableException
ADS request attached.
Partial Listener log
2012-07-02 21:42:44.006 (4) [pool-3-thread-4]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2012-07-02 21:42:44.007 (3) [pool-3-thread-4]: Finished DEPLOY request for campaign QARadiusLess1000_2000062_10005_QARadi1000_GT: SUCCEEDED
2012-07-02 21:42:44.007 (4) [pool-3-thread-4]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2012-07-02 21:42:44.009 (3) [pool-3-thread-4]: Finished DEPLOY request for campaign QARadiusLess1000_2000062_10005_QARadi1000_GM: SUCCEEDED
2012-07-02 21:42:44.009 (4) [pool-3-thread-4]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2012-07-02 21:42:44.010 (3) [pool-3-thread-4]: Finished DEPLOY request for campaign QARadiusLess1000_2000062_10005_QARadi1000_MO: SUCCEEDED
2012-07-02 21:42:44.010 (3) [pool-3-thread-4]: QARadiusLess1000 has 3 campaigns for a SE Update accounts sync.
2012-07-02 21:42:44.010 (3) [pool-3-thread-4]: QARadiusLess1000 has 3 campaigns for a SE Update groups-listings sync.
2012-07-02 21:42:49.015 (3) [pool-3-thread-4]: JobExecutor running job [2012-07-02_214244_a5910_AccountWorkerProcessResults_syncAccountsGroupsListings_5snq9Q9EmS]: /usr/bin/java -Xms256m -Xmx1536m -Xincgc -cp /usr/local/tsa/bidmgr/libs/jst.jar:/usr/local/tsa/bidmgr/libs/tsa.jar:/usr/local/tsa/bidmgr/libs/bidmgrtsa.jar:/usr/local/tsa/bidmgr/libs/jdb.jar:/usr/local/tsa/bidmgr/libs/bidmgrse.jar:/usr/local/tsa/bidmgr/libs/bidmgrclients.jar:/usr/local/tsa/bidmgr/libs/bidmgrseov.jar:/usr/local/tsa/bidmgr/libs/bidmgrsefwht.jar:/usr/local/tsa/bidmgr/libs/bidmgrsegoogle.jar:/usr/local/tsa/bidmgr/libs/adwords-api-reseller-8.4.2R1.jar:/usr/local/tsa/bidmgr/libs/bidmgrsemsn.jar:/usr/local/tsa/bidmgr/libs/bidmgrsemsnwsdl.jar:/usr/local/tsa/bidmgr/libs/bidmgrseyahoo.jar:/usr/local/tsa/bidmgr/libs/bidmgrseyahoowsdl.jar:/usr/local/tsa/bidmgr/libs/bidmgrsessp.jar:/usr/local/tsa/bidmgr/libs/bidmgrsesspwsdl.jar:/usr/local/tsa/bidmgr/libs/bidmgrseask.jar:/usr/local/tsa/bidmgr/libs/bidmgrseaskwsdl.jar:/usr/local/tsa/bidmgr/libs/model.jar:/usr/local/tsa/bidmgr/libs/log4j.jar:/usr/local/tsa/bidmgr/libs/axis14/axis.jar:/usr/local/tsa/bidmgr/libs/thirdparty/xercesImpl.jar:/usr/local/tsa/bidmgr/libs/thirdparty/jaxp-1.2.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-httpclient.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-codec.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-logging.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-collections-3.2.1.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-discovery.jar:/usr/local/tsa/bidmgr/libs/thirdparty/wsdl4j.jar:/usr/local/tsa/bidmgr/libs/thirdparty/jaxrpc.jar:/usr/local/tsa/bidmgr/libs/thirdparty/saaj.jar:/usr/local/tsa/bidmgr/libs/thirdparty/mysql.jar:/usr/local/tsa/bidmgr/libs/thirdparty/commons-cli.jar:/usr/local/tsa/bidmgr/libs/thirdparty/activation.jar:/usr/local/tsa/bidmgr/libs/thirdparty/mail.jar com.thesearchagency.searchengines.SearchEngineUpdater -d 3 --inactive --accountid 5910 --accounts --seaccount 405791,405792,405793 --groups --listings
.
..
2012-07-02 21:44:13.973 (4) [pool-3-thread-4]: Query executed in 0.002s
2012-07-02 21:44:13.973 (4) [pool-3-thread-4]: test query succeeded, returned "5.1.60-rel13.1-log"
2012-07-02 21:44:13.973 (3) [pool-3-thread-4]: Updating deployment status to 'Success' for campaignID: QARadi1000
2012-07-02 21:44:13.973 (4) [pool-3-thread-4]: preparing SQL statement [update clients.externalCampaignParentDeployStatus set status = ? where description = ?]
2012-07-02 21:44:13.978 (3) [pool-3-thread-4]: Finished DEPLOY request for QARadiusLess1000_2000062_10005_QARadi1000: SUCCEEDED
2012-07-02 21:44:13.979 (3) [pool-3-thread-4]: Finished DEPLOY request, deploymentID (1), account QARadiusLess1000
2012-07-02 21:44:13.979 (4) [pool-3-thread-4]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where accountID = ? and status != ?]
2012-07-02 21:44:13.980 (4) [pool-3-thread-4]: preparing SQL statement [select c.id from clients.externalCampaignParent p join clients.externalCampaign c on(p.id = c.externalCampaignParentID) where p.description = ?]
2012-07-02 21:44:13.981 (4) [pool-3-thread-4]: preparing SQL statement [select id, externalCampaignParentID, gceCampaignID, searchEngineAccountID, accountID, enabled from clients.externalCampaign where id = ?]
2012-07-02 21:44:14.118 (2) [pool-3-thread-4]: Exception [Error auditing initial campaign deployment]:java.lang.reflect.UndeclaredThrowableException
at $Proxy8.audit(Unknown Source)
at com.thesearchagency.admaxlistener.worker.RequestWorker.auditEvent(RequestWorker.java:794)
at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:229)
at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:69)
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)
Caused by: java.lang.ClassNotFoundException: com.thesearchagency.core.smb.dao.DAOException
at org.jboss.remoting.serialization.ClassLoaderUtility.loadClass(ClassLoaderUtility.java:103)
at org.jboss.remoting.loading.RemotingClassLoader.loadClass(RemotingClassLoader.java:86)
... 9 more
SMB1- Jboss partial log
11:42:02,061 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)]
11:42:02,065 ERROR [TxPolicy] javax.ejb.EJBTransactionRolledbackException: Event already exists with ID :: Event [id=0, source=Source [id=0, sourceType=INTERNAL, system=ClientSystem [theName=Optus]], action=Action [id=0, description=SMB ADS - successfully deployed campaigns], theUser=null, customerID=QARadiusLess1000, internalRequestID=, externalRequestID=null, startTime=java.util.GregorianCalendar[time=1341229322048,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2012,MONTH=6,WEEK_OF_YEAR=27,WEEK_OF_MONTH=1,DAY_OF_MONTH=2,DAY_OF_YEAR=184,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=11,HOUR_OF_DAY=11,MINUTE=42,SECOND=2,MILLISECOND=48,ZONE_OFFSET=0,DST_OFFSET=0], status=SUCCESS, context=com.thesearchagency.core.smb.domain.audit.Context@8f75521]
11:42:02,065 ERROR [AdMaxDeploymentResponseMDB] Error during response. Message will be replayed.
javax.ejb.EJBTransactionRolledbackException: Event already exists with ID :: Event [id=0, source=Source [id=0, sourceType=INTERNAL, system=ClientSystem [theName=Optus]], action=Action [id=0, description=SMB ADS - successfully deployed campaigns], theUser=null, customerID=QARadiusLess1000, internalRequestID=, externalRequestID=null, startTime=java.util.GregorianCalendar[time=1341229322048,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2012,MONTH=6,WEEK_OF_YEAR=27,WEEK_OF_MONTH=1,DAY_OF_MONTH=2,DAY_OF_YEAR=184,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=11,HOUR_OF_DAY=11,MINUTE=42,SECOND=2,MILLISECOND=48,ZONE_OFFSET=0,DST_OFFSET=0], status=SUCCESS, context=com.thesearchagency.core.smb.domain.audit.Context@8f75521]
at org.jboss.ejb3.tx.Ejb3TxPolicy.handleInCallerTx(Ejb3TxPolicy.java:115)
at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:130)
at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:194)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186)