Uploaded image for project: 'SMB - Optus'
  1. SMB - Optus
  2. OPTUS-55

OPRUS_ADS: While deploying Campaign, it throws exception -Exception [Error auditing initial campaign deployment]:java.lang.reflect.UndeclaredThrowableException

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.3.0
    • Fix Version/s: 1.3.0
    • 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)

        Attachments

          Activity

            People

            • Assignee:
              therouxj Jeff Theroux
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: