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=
, 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":
,"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