Bamboo server is not starting getting 502 proxy error.

[Rajeev Kumar]

Unable to login to the Bamboo server due to the recent changes in LDAP. 

Used the suggestion mentioned to login using adminstrator. here https://confluence.atlassian.com/bamboo0512/restoring-passwords-to-recover-admin-users-838556849.html#Restoringpasswordstorecoveradminusers-external.

But after restarting Bamboo. Getting this error.

```

Caused by: org.springframework.orm.hibernate.HibernateObjectRetrievalFailureException: No row with the given identifier exists: 6XXXXX9, of class: com.atlassian.bamboo.artifact.MutableArtifactImpl; nested exception is net.sf.hibernate.UnresolvableObjectException: No row with the given identifier exists: 6XXXXX9, of class: com.atlassian.bamboo.artifact.MutableArtifactImpl

```

```

INFO: Initializing Spring root WebApplicationContext
Apr 20, 2021 8:35:22 PM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class com.atlassian.bamboo.upgrade.UpgradeLauncher
java.lang.RuntimeException: Failed to upgrade
at com.atlassian.bamboo.upgrade.UpgradeLauncher.upgradeAndStartBamboo(UpgradeLauncher.java:169)
at com.atlassian.bamboo.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:41)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4887)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5381)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: org.springframework.orm.hibernate.HibernateObjectRetrievalFailureException: No row with the given identifier exists: 6XXXXX9, of class: com.atlassian.bamboo.artifact.MutableArtifactImpl; nested exception is net.sf.hibernate.UnresolvableObjectException: No row with the given identifier exists: 6XXXXX9, of class: com.atlassian.bamboo.artifact.MutableArtifactImpl
at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:584)
at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375)
at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341)
at com.atlassian.bamboo.persistence3.HibernateDaoUtils.executeFind(HibernateDaoUtils.java:98)
at com.atlassian.bamboo.deployments.results.persistence.DeploymentResultDaoImpl.getDeploymentResultsByLifeCycleState(DeploymentResultDaoImpl.java:58)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy40.getDeploymentResultsByLifeCycleState(Unknown Source)
at com.atlassian.bamboo.deployments.results.service.DeploymentResultServiceImpl.getDeploymentResultsByLifeCycleState(DeploymentResultServiceImpl.java:172)
at com.atlassian.bamboo.deployments.container.PendingDeploymentResultsCleanupImpl.cleanUp(PendingDeploymentResultsCleanupImpl.java:21)
at com.atlassian.bamboo.container.BambooContainer.start(BambooContainer.java:268)
at com.atlassian.bamboo.upgrade.UpgradeLauncher.upgradeAndStartBamboo(UpgradeLauncher.java:154)
... 10 more
Caused by: net.sf.hibernate.UnresolvableObjectException: No row with the given identifier exists: 68884449, of class: com.atlassian.bamboo.artifact.MutableArtifactImpl
at net.sf.hibernate.UnresolvableObjectException.throwIfNull(UnresolvableObjectException.java:38)
at net.sf.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1966)
at net.sf.hibernate.type.ManyToOneType.resolveIdentifier(ManyToOneType.java:69)
at net.sf.hibernate.type.EntityType.resolveIdentifier(EntityType.java:208)
at net.sf.hibernate.impl.SessionImpl.initializeEntity(SessionImpl.java:2221)
at net.sf.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:319)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:309)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:1020)
at net.sf.hibernate.loader.Loader.loadCollection(Loader.java:995)
at net.sf.hibernate.loader.OneToManyLoader.initialize(OneToManyLoader.java:93)
at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:288)
at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3317)
at net.sf.hibernate.collection.PersistentCollection.forceInitialization(PersistentCollection.java:336)
at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3170)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:143)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:118)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3662)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
at com.atlassian.bamboo.deployments.results.persistence.DeploymentResultDaoImpl$1.doInHibernate(DeploymentResultDaoImpl.java:62)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
... 28 more

Apr 20, 2021 8:35:22 PM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext

```

How can we fix this error and what else information are required to fix or trace this issue.

[Rajeev Kumar · Accepted solution]

Just for folks who will face similar issue.

Enabled trace logs of hibernate to identify the cross linked queries.

https://confluence.atlassian.com/bamkb/how-to-enable-detailed-sql-logging-243794401.html

Able to fix this issue by deleting the reference of artifactID in the tables.

```

select * from DEPLOYMENT_VERSION_ITEM_BA where ARTIFACT_ID='6XX9';

>> get the DEPLOYMENT_VERSION_ITEM_ID that will be used in next execution.

delete from DEPLOYMENT_VERSION_ITEM_BA where ARTIFACT_ID='6XX9';

select *  from DEPLOYMENT_VERSION_ITEM where DEPLOYMENT_VERSION_ITEM_ID=6XXX8;

delete from DEPLOYMENT_VERSION_ITEM where DEPLOYMENT_VERSION_ITEM_ID=6XXX8;

```

Deleting these reference and restarting the server fix the start issue.