Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-1125

User Service Exception thrown after order is deployed.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0.2
    • Fix Version/s: 2.0.2
    • Component/s: None
    • Labels:
      None
    • Environment:

      QA - 2.0.2 UI build 28. SAPI build 417. Core Trunk build 765, Bidmgr Trunk build 790.

    • Sprint:
      Sprint 2

      Description

      Update order services is throwing this exception after successfully updating the order to a deployed state. It seems to be losing its connection and throwing the exception. The order is deployed correctly, the status is correct in the UI so there is no user facing issues here.

      2013-02-05 18:15:27,846-577490 [order-update-timer-factory] DEBUG com.thesearchagency.core.common.service.clients.ads.ADSClientFactoryBean [] - <?xml version="1.0" encoding="UTF-8"?><CampaignListResponse><customerID>d949245e-d2eb-4392-adae-48bd311ec94b</customerID><domain>www.build417.com</domain><deploymentStatus>success</deploymentStatus><campaignList><campaignID>966</campaignID><businessAreaID>10346</businessAreaID><businessLocationID>28</businessLocationID><customLandingPage><destinationURL>http://www.build417.com</destinationURL><displayURL>www.build417.com</displayURL></customLandingPage><deploymentStatus>Success</deploymentStatus><campaignStatus>paused</campaignStatus></campaignList></CampaignListResponse>
      2013-02-05 18:15:27,873-577517 [order-update-timer-factory] DEBUG com.thesearchagency.sapi.services.order.DeploymentServiceHelper [] - BA/BL pair 10346_28 will be set to ACTIVE
      2013-02-05 18:15:27,884-577528 [order-update-timer-factory] DEBUG com.thesearchagency.core.common.service.clients.ads.ADSClientFactoryBean [] - <core:updateCampaignStatus xmlns:core="http://thesearchagency.com/smb/core">
      <updateCampaignStatusRequest>
      <header>
      <requestID>d1986c5f-4a14-4b60-a888-d8a7b6057513</requestID>
      </header>
      <customerID>d949245e-d2eb-4392-adae-48bd311ec94b</customerID>
      <campaignStatusList>
      <campaignID>966</campaignID>
      <campaignStatus>active</campaignStatus>
      </campaignStatusList>
      </updateCampaignStatusRequest>
      </core:updateCampaignStatus>
      2013-02-05 18:15:31,088-580732 [order-update-timer-factory] DEBUG com.thesearchagency.core.common.service.clients.ads.ADSClientFactoryBean [] - <?xml version="1.0" encoding="UTF-8"?><updateCampaignStatusResponse><header><requestID>d1986c5f-4a14-4b60-a888-d8a7b6057513</requestID></header><customerID>d949245e-d2eb-4392-adae-48bd311ec94b</customerID><campaignResult><campaignID>966</campaignID><result><resultCode>success</resultCode><resultString>Information: [966_GM:SUCCEEDED] [966_GT:SUCCEEDED] [966_MO:SUCCEEDED] </resultString></result></campaignResult></updateCampaignStatusResponse>
      2013-02-05 18:15:31,097-580741 [order-update-timer-factory] DEBUG com.thesearchagency.core.common.service.clients.ads.ADSClientFactoryBean [] - <core:updateCampaignBudgetAccrualStatus xmlns:core="http://thesearchagency.com/smb/core">
      <updateCampaignBudgetAccrualStatusRequest>
      <header>
      <requestID>d1986c5f-4a14-4b60-a888-d8a7b6057513</requestID>
      </header>
      <customerID>d949245e-d2eb-4392-adae-48bd311ec94b</customerID>
      <campaignBudgetAccrualStatusList>
      <campaignID>966</campaignID>
      <campaignBudgetAccrualStatus>active</campaignBudgetAccrualStatus>
      </campaignBudgetAccrualStatusList>
      </updateCampaignBudgetAccrualStatusRequest>
      </core:updateCampaignBudgetAccrualStatus>
      2013-02-05 18:15:31,270-580914 [order-update-timer-factory] DEBUG com.thesearchagency.core.common.service.clients.ads.ADSClientFactoryBean [] - <?xml version="1.0" encoding="UTF-8"?><updateCampaignBudgetAccrualStatusResponse><header><requestID>d1986c5f-4a14-4b60-a888-d8a7b6057513</requestID></header><customerID>d949245e-d2eb-4392-adae-48bd311ec94b</customerID><campaignResult><campaignID>966</campaignID><result><resultCode>success</resultCode></result></campaignResult></updateCampaignBudgetAccrualStatusResponse>
      2013-02-05 18:15:31,274-580918 [order-update-timer-factory] DEBUG com.thesearchagency.sapi.services.order.OrderService [] - Attempting to update order 'd1986c5f-4a14-4b60-a888-d8a7b6057513' for principal '273c4aab-e844-42d1-8c5a-2063ca535bba' in realm 'com.reseller1'.
      2013-02-05 18:15:31,292-580936 [order-update-timer-factory] DEBUG com.thesearchagency.sapi.services.order.OrderService [] - Adapted order d1986c5f-4a14-4b60-a888-d8a7b6057513 to content: Content(theId=d1986c5f-4a14-4b60-a888-d8a7b6057513, theParentId=null, theChildren=[Content(theId=b0e59dfb-4a02-4aa0-9c04-5d5e13f1f497, theParentId=d1986c5f-4a14-4b60-a888-d8a7b6057513, theChildren=[], theRevisionNumber=null, theType=merchantDisplay, theName=associatedMerchant, theValue=null, theMetaData=

      {name=build417, resellerAssignedId=build417, class=com.thesearchagency.sapi.services.order.MerchantDisplay, identifier=d949245e-d2eb-4392-adae-48bd311ec94b}

      , theRealm=null, theCreationDate=2013-02-05T18:15:31.279Z, theCreatorId=null, theModificationDate=2013-02-05T18:15:31.279Z, theModifierId=null), Content(theId=9ee4f2ab-341c-4312-9eb5-eac76d167ae4, theParentId=d1986c5f-4a14-4b60-a888-d8a7b6057513, theChildren=[Content(theId=c0ed1e1c-e4fe-49e3-bd63-2afc70280303, theParentId=9ee4f2ab-341c-4312-9eb5-eac76d167ae4, theChildren=[Content(theId=af65d77d-f611-49c5-b1ad-ec23991d47e5, theParentId=c0ed1e1c-e4fe-49e3-bd63-2afc70280303, theChildren=[], theRevisionNumber=null, theType=businessArea, theName=businessArea, theValue=null, theMetaData=

      {title=Home Construction, businessAreaId=10346, class=com.thesearchagency.sapi.services.order.BusinessArea}

      , theRealm=null, theCreationDate=2013-02-05T18:15:31.283Z, theCreatorId=null, theModificationDate=2013-02-05T18:15:31.283Z, theModifierId=null), Content(theId=2a029a28-9a18-4220-9e78-6c887acc75c6, theParentId=c0ed1e1c-e4fe-49e3-bd63-2afc70280303, theChildren=[], theRevisionNumber=null, theType=location, theName=location, theValue=null, theMetaData=

      {title=Delaware, locationId=28, class=com.thesearchagency.sapi.services.order.Location}

      , theRealm=null, theCreationDate=2013-02-05T18:15:31.286Z, theCreatorId=null, theModificationDate=2013-02-05T18:15:31.286Z, theModifierId=null)], theRevisionNumber=null, theType=campaignTarget, theName=null, theValue=null, theMetaData=

      {status=VALID, class=com.thesearchagency.sapi.services.order.CampaignTarget}

      , theRealm=null, theCreationDate=2013-02-05T18:15:31.282Z, theCreatorId=null, theModificationDate=2013-02-05T18:15:31.282Z, theModifierId=null)], theRevisionNumber=null, theType=list, theName=campaignTargets, theValue=null, theMetaData=

      {class=java.util.List}, theRealm=null, theCreationDate=2013-02-05T18:15:31.282Z, theCreatorId=null, theModificationDate=2013-02-05T18:15:31.282Z, theModifierId=null), Content(theId=c3e21b8a-19f6-4337-8d8d-a087a326c080, theParentId=d1986c5f-4a14-4b60-a888-d8a7b6057513, theChildren=[], theRevisionNumber=null, theType=displayName, theName=creator, theValue=null, theMetaData={name=Reseller1 admin user, class=com.thesearchagency.sapi.services.order.DisplayName, identifier=273c4aab-e844-42d1-8c5a-2063ca535bba}, theRealm=null, theCreationDate=2013-02-05T18:15:31.289Z, theCreatorId=null, theModificationDate=2013-02-05T18:15:31.289Z, theModifierId=null), Content(theId=9d06f5f4-d48b-451f-83d0-3697ea4607fe, theParentId=d1986c5f-4a14-4b60-a888-d8a7b6057513, theChildren=[Content(theId=ffe766f9-f16c-4012-8c4b-44d8786144a8, theParentId=9d06f5f4-d48b-451f-83d0-3697ea4607fe, theChildren=[], theRevisionNumber=null, theType=serviceBudget, theName=null, theValue=null, theMetaData={markupBudget=18, budget=18, markupMultiplier=0, service=GOOGLE, class=com.thesearchagency.sapi.services.order.ServiceBudget}, theRealm=null, theCreationDate=2013-02-05T18:15:31.290Z, theCreatorId=null, theModificationDate=2013-02-05T18:15:31.290Z, theModifierId=null)], theRevisionNumber=null, theType=list, theName=distributionBudgets, theValue=null, theMetaData={class=java.util.List}

      , theRealm=null, theCreationDate=2013-02-05T18:15:31.290Z, theCreatorId=null, theModificationDate=2013-02-05T18:15:31.290Z, theModifierId=null), Content(theId=48226adf-aacc-4653-b427-ea3a3aa23ab2, theParentId=d1986c5f-4a14-4b60-a888-d8a7b6057513, theChildren=[], theRevisionNumber=null, theType=displayName, theName=modifier, theValue=null, theMetaData=

      {name=Reseller1 admin user, class=com.thesearchagency.sapi.services.order.DisplayName, identifier=273c4aab-e844-42d1-8c5a-2063ca535bba}

      , theRealm=null, theCreationDate=2013-02-05T18:15:31.290Z, theCreatorId=null, theModificationDate=2013-02-05T18:15:31.290Z, theModifierId=null)], theRevisionNumber=null, theType=order, theName=null, theValue=null, theMetaData=

      {creationDate=1360087813000, modifierId=273c4aab-e844-42d1-8c5a-2063ca535bba, billingInfoCaptured=true, realm=com.reseller1, name=, creatorId=273c4aab-e844-42d1-8c5a-2063ca535bba, state=DEPLOYED, class=com.thesearchagency.sapi.services.order.Order, semLandingPageURL=http://www.build417.com, comment=, modificationDate=1360087813000}

      , theRealm=null, theCreationDate=2013-02-05T18:15:31.278Z, theCreatorId=null, theModificationDate=2013-02-05T18:15:31.278Z, theModifierId=null)
      2013-02-05 18:15:31,294-580938 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.content.internal.dao.HibernateContentDao [] - Attempting to find 'd1986c5f-4a14-4b60-a888-d8a7b6057513' in 'com.reseller1'.
      2013-02-05 18:15:31,319-580963 [order-update-timer-factory] DEBUG log4jdbc.debug [] - driver name is MySQL-AB JDBC Driver
      2013-02-05 18:15:31,353-580997 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.content.internal.dao.HibernateContentDao [] - Found a content record for 'd1986c5f-4a14-4b60-a888-d8a7b6057513' in 'com.reseller1'.
      2013-02-05 18:15:31,358-581002 [order-update-timer-factory] DEBUG log4jdbc.debug [] - driver name is MySQL-AB JDBC Driver
      2013-02-05 18:15:31,392-581036 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.content.internal.dao.HibernateContentDao [] - Content version is null.
      2013-02-05 18:15:31,394-581038 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.content.internal.dao.HibernateContentDao [] - Content was evicted? true
      2013-02-05 18:15:31,532-581176 [order-update-timer-factory] DEBUG com.thesearchagency.sapi.services.order.OrderService [] - Undapted order d1986c5f-4a14-4b60-a888-d8a7b6057513 to order: Order(theId=d1986c5f-4a14-4b60-a888-d8a7b6057513, theRealm=com.reseller1, theName=, theLabel=null, theComment=, theAssociatedMerchant=MerchantDisplay(theIdentifier=d949245e-d2eb-4392-adae-48bd311ec94b, theName=build417, theCustomerId=build417), theSemLandingPageURL=http://www.build417.com, theState=DEPLOYED, theBillingInfoCaptured=true, theCampaignTargets=[CampaignTarget(theStatus=VALID, theService=null, theBusinessArea=BusinessArea(theBusinessAreaId=10346, theTitle=Home Construction), theLocation=Location(theLocationId=28, theTitle=Delaware))], theDistributionBudgets=[com.thesearchagency.sapi.services.order.ServiceBudget@677784dd], theServiceEstimates=[], theCreator=DisplayName(theIdentifier=273c4aab-e844-42d1-8c5a-2063ca535bba, theName=Reseller1 admin user), theCreatorId=273c4aab-e844-42d1-8c5a-2063ca535bba, theCreationDate=2013-02-05T18:10:13.000Z, theModifier=DisplayName(theIdentifier=273c4aab-e844-42d1-8c5a-2063ca535bba, theName=Reseller1 admin user), theModifierId=273c4aab-e844-42d1-8c5a-2063ca535bba, theModificationDate=2013-02-05T18:10:13.000Z)
      2013-02-05 18:15:31,611-581255 [order-update-timer-factory] ERROR com.thesearchagency.saas.core.services.user.UserServiceComponent [] - Error fetching user
      com.thesearchagency.database.storage.StorageManagerException: package com.thesearchagency.database.storage.INTERNAL_ERROR_EXCEPTION
      at com.thesearchagency.database.storage.jdbc.JDBCStorageManager.getObjectRetrievalPreparedStatement(JDBCStorageManager.java:793) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
      at com.thesearchagency.database.storage.jdbc.JDBCStorageManager.get(JDBCStorageManager.java:107) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
      at com.thesearchagency.database.storage.jdbc.JDBCStorageManager.get(JDBCStorageManager.java:57) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
      at com.thesearchagency.database.storage.jdbc.BaseJDBCStorageManager.get(BaseJDBCStorageManager.java:78) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
      at com.thesearchagency.saas.core.services.user.managers.UserManager$2.run(UserManager.java:111) ~[saas-core-services-user-service-component-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
      at com.thesearchagency.saas.core.services.user.managers.UserManager$2.run(UserManager.java:108) ~[saas-core-services-user-service-component-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
      at com.thesearchagency.database.storage.jdbc.JDBCStorageCommandRunner.runWithReturn(JDBCStorageCommandRunner.java:16) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
      at com.thesearchagency.saas.core.services.user.managers.UserManager.getUser(UserManager.java:107) ~[saas-core-services-user-service-component-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
      at com.thesearchagency.saas.core.services.user.UserServiceComponent.getUser(UserServiceComponent.java:142) ~[saas-core-services-user-service-component-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
      at com.thesearchagency.sapi.services.order.OrderService.prepareForReturn(OrderService.java:440) [OrderService.class:na]
      at com.thesearchagency.sapi.services.order.OrderService.updateOrder(OrderService.java:417) [OrderService.class:na]
      at com.thesearchagency.sapi.services.order.DeploymentServiceHelper.checkDeploymentState(DeploymentServiceHelper.java:167) [DeploymentServiceHelper.class:na]
      at com.thesearchagency.sapi.services.order.DeploymentServiceHelper.updateStatus(DeploymentServiceHelper.java:114) [DeploymentServiceHelper.class:na]
      at com.thesearchagency.sapi.services.order.OrderStatusUpdater.run(OrderStatusUpdater.java:40) [OrderStatusUpdater.class:na]
      at java.util.TimerThread.mainLoop(Timer.java:534) [na:1.6.0_24]
      at java.util.TimerThread.run(Timer.java:484) [na:1.6.0_24]
      Caused by: java.sql.SQLException: Connection is closed.
      at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.checkOpen(PoolingDataSource.java:185) ~[commons-dbcp-1.4.jar:1.4]
      at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:312) ~[commons-dbcp-1.4.jar:1.4]
      at com.thesearchagency.database.storage.jdbc.JDBCStorageManager.getObjectRetrievalPreparedStatement(JDBCStorageManager.java:786) ~[tsa-database-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
      ... 15 common frames omitted
      2013-02-05 18:15:31,621-581265 [order-update-timer-factory] DEBUG com.thesearchagency.sapi.services.order.OrderService [] - Reindex order d1986c5f-4a14-4b60-a888-d8a7b6057513
      2013-02-05 18:15:31,679-581323 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Indexing content Order(theId=d1986c5f-4a14-4b60-a888-d8a7b6057513, theRealm=com.reseller1, theName=, theLabel=null, theComment=, theAssociatedMerchant=MerchantDisplay(theIdentifier=d949245e-d2eb-4392-adae-48bd311ec94b, theName=build417, theCustomerId=build417), theSemLandingPageURL=http://www.build417.com, theState=DEPLOYED, theBillingInfoCaptured=true, theCampaignTargets=[CampaignTarget(theStatus=VALID, theService=null, theBusinessArea=BusinessArea(theBusinessAreaId=10346, theTitle=Home Construction), theLocation=Location(theLocationId=28, theTitle=Delaware))], theDistributionBudgets=[com.thesearchagency.sapi.services.order.ServiceBudget@677784dd], theServiceEstimates=[], theCreator=DisplayName(theIdentifier=273c4aab-e844-42d1-8c5a-2063ca535bba, theName=Reseller1 admin user), theCreatorId=273c4aab-e844-42d1-8c5a-2063ca535bba, theCreationDate=2013-02-05T18:10:13.000Z, theModifier=DisplayName(theIdentifier=273c4aab-e844-42d1-8c5a-2063ca535bba, theName=COULD NOT RESOLVE), theModifierId=273c4aab-e844-42d1-8c5a-2063ca535bba, theModificationDate=2013-02-05T18:10:13.000Z)
      2013-02-05 18:15:31,680-581324 [order-update-timer-factory] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex [] - Created JSON: {"id":"d1986c5f-4a14-4b60-a888-d8a7b6057513","realm":"com.reseller1","name":"","comment":"","associatedMerchant":

      {"id":"d949245e-d2eb-4392-adae-48bd311ec94b","name":"build417","customerId":"build417"}

      ,"semLandingPageURL":"http://www.build417.com","state":"DEPLOYED","billingInfoCaptured":true,"campaignTargets":[{"status":"VALID","service":null,"businessArea":

      {"id":"10346","title":"Home Construction"}

      ,"location":{"id":"28","title":"Delaware"}}],"distributionBudgets":[

      {"service":"GOOGLE","budget":18,"markupBudget":18,"markupMultiplier":0}

      ],"serviceEstimates":[],"creator":

      {"id":"273c4aab-e844-42d1-8c5a-2063ca535bba","name":"Reseller1 admin user"}

      ,"creationDate":"2013-02-05T18:10:13.000Z","modifier":

      {"id":"273c4aab-e844-42d1-8c5a-2063ca535bba","name":"COULD NOT RESOLVE"}

      ,"modificationDate":"2013-02-05T18:10:13.000Z"}
      2013-02-05 18:15:31,683-581327 [order-update-timer-factory] DEBUG org.apache.commons.beanutils.converters.StringConverter [] - Converting 'UUID' value 'd1986c5f-4a14-4b60-a888-d8a7b6057513' to type 'String'
      2013-02-05 18:15:31,699-581343 [order-update-timer-factory] DEBUG com.thesearchagency.sapi.services.order.DeploymentServiceHelper [] - State of order d1986c5f-4a14-4b60-a888-d8a7b6057513 changed to DEPLOYED

        Attachments

          Activity

            People

            • Assignee:
              gavin.nicol Gavin Nicol (Inactive)
              Reporter:
              jeff.brown Jeff Brown (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: