NOTICE: COMMUNITY PERFORMANCE DEGRADATION
Our community is currently experiencing some performance degradation with slow page loading. Our platform SaaS vendor is working on the issue.
Highlighted
Absent Member.
Absent Member.
2378 views

Cannot restore Lab Project duing HP ALM 12.5 Upgrade

Jump to solution

As part of our HP ALM Upgrade we are creating a new Development enviroment usign a copy of our current produciton enviroment.


The following steps have been performed:

1. Backup Produciton databases and repository. Note due to the new enviroment not being the new production environment the produciton projects are not made inactive.

2. Restore databases to new development database and rename databases

3. Copy repository to new HP ALM server.

4. Install new HP ALM on new server. Note that during the install the existing production Lab Project is not available as the development enviroment has sepertate credentials, as a result a new Lab Project is created.

5. Update dbid.xml files

6. In HP ALM remove the newly created Lab Project.

When I try to restore the existing Lab Project I am given the very undescriptive message "Failed to Restore Project". I cannot find much helpful information in the upgrade guide about the issue. I'm fairly new to HP ALM so haven't any experience solving such issues. From checking online it looks like folder E:\ProgramData\HP\ALM\log\sa is the place to look, I'll attach a copy of this.

The logs seem to indicate that the fault is not occuring with the Lab Project at all, instead it is trying to connect to the database for one of the other projects and it is failing because it is still set to use the produciton database. I've double checked and the dbid.xml file I am specifiying is definately for the Lab Project and has been updated to use the new database.

0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.
Absent Member.

Re: Cannot restore Lab Project duing HP ALM 12.5 Upgrade

Jump to solution

I solved this problem by removing all the other projects first. Once I did that I was able to restore the Lab Project and then the other projects.

Not sure why HP ALM insisted on the other projects being able to connect to the database.

View solution in original post

5 Replies
Highlighted
Absent Member.
Absent Member.

Re: Cannot restore Lab Project duing HP ALM 12.5 Upgrade

Jump to solution

For some reason I cannot attach the error log, so here it is

Sep 26
10:49:31.930 Sep 26
10:49:32.195 qtp1579767949-23 [RestoreProject] [login_id:1564886] [connect_id:-1] [call_id:28] FREC matthew.niejalke 0:0:0:0:0:0:0:1 WRN CTdUserLogic.createTDUsers(1130) User '_pc_system_' already exists. Sep 26
10:49:31.931 Sep 26
10:49:32.196 qtp1579767949-23 [RestoreProject] [login_id:1564886] [connect_id:-1] [call_id:28] FREC matthew.niejalke 0:0:0:0:0:0:0:1 WRN CTdUserLogic.createTDUsers(1130) User '_system_user_' already exists. Sep 26
10:49:31.931 Sep 26
10:49:32.196 qtp1579767949-23 [RestoreProject] [login_id:1564886] [connect_id:-1] [call_id:28] FREC matthew.niejalke 0:0:0:0:0:0:0:1 WRN CTdUserLogic.createTDUsers(1130) User 'siteadmin' already exists. Sep 26
10:49:31.931 Sep 26
10:49:32.196 qtp1579767949-23 [RestoreProject] [login_id:1564886] [connect_id:-1] [call_id:28] FREC matthew.niejalke 0:0:0:0:0:0:0:1 WRN CTdUserLogic.createTDUsers(1130) User 'venkata.nallam' already exists. Sep 26
10:49:32.266 Sep 26
10:49:32.531 qtp1579767949-23 [RestoreProject] [login_id:1564886] [connect_id:-1] [call_id:28] FREC matthew.niejalke 0:0:0:0:0:0:0:1 ERR CConnectionManager.getNotTransactedConnection(243) Can't create a new database connection for url 'jdbc:mercury:sqlserver://SQLPRDSAP001\S01:56403' on getting connection to database server (jdbc:mercury:sqlserver://SQLPRDSAP001\S01:56403)

com.hp.alm.platform.exception.CTdException

Messages:
[Mercury][SQLServer JDBC Driver][SQLServer]Login failed for user 'INTERNAL\_sHPALM_Dev'.;

Stack Trace:
java.sql.SQLInvalidAuthorizationSpecException: [Mercury][SQLServer JDBC Driver][SQLServer]Login failed for user 'INTERNAL\_sHPALM_Dev'.
at com.mercury.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddj.a(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddj.a(Unknown Source)
at com.mercury.jdbc.sqlserver.SQLServerImplConnection.f(Unknown Source)
at com.mercury.jdbc.sqlserverbase.BaseConnection.b(Unknown Source)
at com.mercury.jdbc.sqlserverbase.BaseConnection.k(Unknown Source)
at com.mercury.jdbc.sqlserverbase.BaseConnection.a(Unknown Source)
at com.mercury.jdbc.sqlserverbase.BaseConnection.a(Unknown Source)
at com.mercury.jdbc.sqlserverbase.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at com.hp.alm.platform.db.CTdDriverManager.getConnection(CTdDriverManager.java:88)
wrapped in com.hp.alm.platform.exception.CTdException:
at com.hp.alm.platform.db.CTdDriverManager.getConnection(CTdDriverManager.java:95)
at com.hp.alm.platform.db.CConnectionPool.newConnection(CConnectionPool.java:821)
at com.hp.alm.platform.db.CConnectionPool.tryToGetConnection(CConnectionPool.java:610)
at com.hp.alm.platform.db.CConnectionPool.getConnection(CConnectionPool.java:377)
at com.hp.alm.platform.db.CConnectionManager.getNotTransactedConnection(CConnectionManager.java:243)
at com.hp.alm.platform.db.CConnectionManager.getConnection(CConnectionManager.java:217)
at com.hp.alm.platform.db.CAbsStatement.<init>(CAbsStatement.java:87)
at com.hp.alm.platform.db.CTdPreparedStatement.<init>(CTdPreparedStatement.java:97)
at com.hp.alm.platform.db.CTdPreparedStatement.<init>(CTdPreparedStatement.java:89)
at com.hp.alm.platform.db.jdbc.JDBCTemplate$AbstractPreparedStatementCreator.create(JDBCTemplate.java:1252)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.executeQuery(JDBCTemplate.java:1051)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry.access$101(JDBCTemplateWithRetry.java:19)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry$2.exec(JDBCTemplateWithRetry.java:56)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry.executeWithRetry(JDBCTemplateWithRetry.java:98)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry.executeQuery(JDBCTemplateWithRetry.java:52)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.executeQuery(JDBCTemplate.java:908)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.executeQuery(JDBCTemplate.java:893)
at com.hp.alm.platform.directory.EnabledExtensions.formatExtensionsVersion(EnabledExtensions.java:84)
at com.hp.alm.platform.directory.EnabledExtensions.<init>(EnabledExtensions.java:63)
at com.hp.alm.platform.directory.EnabledExtensionsDirectory.createDirectoryItem(EnabledExtensionsDirectory.java:45)
at com.hp.alm.platform.directory.EnabledExtensionsDirectory.createDirectoryItem(EnabledExtensionsDirectory.java:15)
at com.mercury.optane.core.directory.CAbsDirectory$CacheResult.getOrCreate(CAbsDirectory.java:123)
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:329)
at com.mercury.optane.core.directory.CAbsReloadableDirectory.getDirectoryItem(CAbsReloadableDirectory.java:27)
at com.hp.alm.platform.directory.EnabledExtensionsDirectory.getEnabledExtensions(EnabledExtensionsDirectory.java:40)
at com.hp.alm.platform.extension.CQcExtensionsLogic.getEnabledExtensionNames(CQcExtensionsLogic.java:125)
at com.hp.alm.platform.siteadmin.directory.CProject.getEnabledExtensionsNames(CProject.java:2210)
at com.mercury.td.pcextension.PCSAExtension.restoreLabProjectLinks(PCSAExtension.java:267)
at com.mercury.td.pcextension.PCSAExtension.afterRestoreProject(PCSAExtension.java:258)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at com.hp.alm.platform.extension.BaseExtensionEventDispatcher.invokeMethod(BaseExtensionEventDispatcher.java:108)
at com.hp.alm.platform.extension.BaseExtensionEventDispatcher.dispatchEvent(BaseExtensionEventDispatcher.java:71)
at com.hp.alm.platform.siteadmin.plugin.SAExtensionEventDispatcher.dispatchEvent(SAExtensionEventDispatcher.java:92)
at com.hp.alm.platform.siteadmin.plugin.SAExtensionEventDispatcher.afterRestoreProject(SAExtensionEventDispatcher.java:145)
at com.hp.alm.platform.siteadmin.api.logics.CProjectLogic.restoreProject(CProjectLogic.java:1546)
at com.hp.alm.platform.siteadmin.api.logics.CProjectLogic.restoreProject(CProjectLogic.java:1396)
at com.hp.alm.platform.siteadmin.requests.RestoreProject.execute(RestoreProject.java:29)
at com.hp.alm.platform.web.RequestsDispatcher.execute(RequestsDispatcher.java:81)
at com.hp.alm.platform.server.web.CAbsServlet.executeFunction(CAbsServlet.java:590)
at com.hp.alm.platform.server.web.CAbsServlet.processRequest(CAbsServlet.java:580)
at com.hp.alm.platform.server.web.CAbsServlet.doPost(CAbsServlet.java:433)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651)
at com.hp.alm.platform.util.gzipfilter.GZIPFilter.doFilter(GZIPFilter.java:31)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1631)
at com.mercury.optane.core.state.ServerStatusFilter.doFilter(ServerStatusFilter.java:34)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
at org.hp.qc.web.restapi.authentication.LwssoRedirectFilter.doFilter(LwssoRedirectFilter.java:26)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
at com.hp.alm.platform.web.HTTPMethodsFilter.doFilter(HTTPMethodsFilter.java:52)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:568)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:309)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:159)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:462)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536)
at java.lang.Thread.run(Thread.java:745)

Sep 26
10:49:32.272 Sep 26
10:49:32.537 qtp1579767949-23 [RestoreProject] [login_id:1564886] [connect_id:-1] [call_id:28] FREC matthew.niejalke 0:0:0:0:0:0:0:1 ERR CProjectLogic.restoreProject(1566) Failed to restore project. Project will be removed

com.hp.alm.platform.exception.CTdException

Messages:
Cannot build directory item for key '[sap_implementation_projects::bulk_fuel_management_system]' in Enabled Extensions Directory; Failed to format extensions version of project 'sap_implementation_projects_bu'; Failed to obtain a connection to schema 'sap_implementation_projects_bu'; com.hp.alm.platform.db.CTdDbException: Can't create a new database connection.; Can't create a new database connection.;

Stack Trace:
com.hp.alm.platform.db.CTdDbException: Can't create a new database connection.
at com.hp.alm.platform.db.CConnectionPool.newConnection(CConnectionPool.java:878)
at com.hp.alm.platform.db.CConnectionPool.tryToGetConnection(CConnectionPool.java:610)
at com.hp.alm.platform.db.CConnectionPool.getConnection(CConnectionPool.java:377)
wrapped in com.hp.alm.platform.db.CTdDbException: Failed to obtain a connection to schema 'sap_implementation_projects_bu'; com.hp.alm.platform.db.CTdDbException: Can't create a new database connection.
at com.hp.alm.platform.db.CConnectionPool.getConnection(CConnectionPool.java:406)
at com.hp.alm.platform.db.CConnectionManager.getNotTransactedConnection(CConnectionManager.java:243)
at com.hp.alm.platform.db.CConnectionManager.getConnection(CConnectionManager.java:217)
at com.hp.alm.platform.db.CAbsStatement.<init>(CAbsStatement.java:87)
at com.hp.alm.platform.db.CTdPreparedStatement.<init>(CTdPreparedStatement.java:97)
at com.hp.alm.platform.db.CTdPreparedStatement.<init>(CTdPreparedStatement.java:89)
at com.hp.alm.platform.db.jdbc.JDBCTemplate$AbstractPreparedStatementCreator.create(JDBCTemplate.java:1252)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.executeQuery(JDBCTemplate.java:1051)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry.access$101(JDBCTemplateWithRetry.java:19)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry$2.exec(JDBCTemplateWithRetry.java:56)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry.executeWithRetry(JDBCTemplateWithRetry.java:98)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry.executeQuery(JDBCTemplateWithRetry.java:52)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.executeQuery(JDBCTemplate.java:908)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.executeQuery(JDBCTemplate.java:893)
at com.hp.alm.platform.directory.EnabledExtensions.formatExtensionsVersion(EnabledExtensions.java:84)
wrapped in com.hp.alm.platform.exception.CTdException: Failed to format extensions version of project 'sap_implementation_projects_bu'
at com.hp.alm.platform.directory.EnabledExtensions.formatExtensionsVersion(EnabledExtensions.java:112)
at com.hp.alm.platform.directory.EnabledExtensions.<init>(EnabledExtensions.java:63)
at com.hp.alm.platform.directory.EnabledExtensionsDirectory.createDirectoryItem(EnabledExtensionsDirectory.java:45)
at com.hp.alm.platform.directory.EnabledExtensionsDirectory.createDirectoryItem(EnabledExtensionsDirectory.java:15)
at com.mercury.optane.core.directory.CAbsDirectory$CacheResult.getOrCreate(CAbsDirectory.java:123)
wrapped in com.hp.alm.platform.exception.CTdException: Cannot build directory item for key '[sap_implementation_projects::bulk_fuel_management_system]' in Enabled Extensions Directory
at com.mercury.optane.core.directory.CAbsDirectory$CacheResult.getOrCreate(CAbsDirectory.java:141)
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:329)
at com.mercury.optane.core.directory.CAbsReloadableDirectory.getDirectoryItem(CAbsReloadableDirectory.java:27)
at com.hp.alm.platform.directory.EnabledExtensionsDirectory.getEnabledExtensions(EnabledExtensionsDirectory.java:40)
at com.hp.alm.platform.extension.CQcExtensionsLogic.getEnabledExtensionNames(CQcExtensionsLogic.java:125)
at com.hp.alm.platform.siteadmin.directory.CProject.getEnabledExtensionsNames(CProject.java:2210)
at com.mercury.td.pcextension.PCSAExtension.restoreLabProjectLinks(PCSAExtension.java:267)
at com.mercury.td.pcextension.PCSAExtension.afterRestoreProject(PCSAExtension.java:258)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at com.hp.alm.platform.extension.BaseExtensionEventDispatcher.invokeMethod(BaseExtensionEventDispatcher.java:108)
at com.hp.alm.platform.extension.BaseExtensionEventDispatcher.dispatchEvent(BaseExtensionEventDispatcher.java:71)
at com.hp.alm.platform.siteadmin.plugin.SAExtensionEventDispatcher.dispatchEvent(SAExtensionEventDispatcher.java:92)
at com.hp.alm.platform.siteadmin.plugin.SAExtensionEventDispatcher.afterRestoreProject(SAExtensionEventDispatcher.java:145)
at com.hp.alm.platform.siteadmin.api.logics.CProjectLogic.restoreProject(CProjectLogic.java:1546)
at com.hp.alm.platform.siteadmin.api.logics.CProjectLogic.restoreProject(CProjectLogic.java:1396)
at com.hp.alm.platform.siteadmin.requests.RestoreProject.execute(RestoreProject.java:29)
at com.hp.alm.platform.web.RequestsDispatcher.execute(RequestsDispatcher.java:81)
at com.hp.alm.platform.server.web.CAbsServlet.executeFunction(CAbsServlet.java:590)
at com.hp.alm.platform.server.web.CAbsServlet.processRequest(CAbsServlet.java:580)
at com.hp.alm.platform.server.web.CAbsServlet.doPost(CAbsServlet.java:433)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651)
at com.hp.alm.platform.util.gzipfilter.GZIPFilter.doFilter(GZIPFilter.java:31)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1631)
at com.mercury.optane.core.state.ServerStatusFilter.doFilter(ServerStatusFilter.java:34)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
at org.hp.qc.web.restapi.authentication.LwssoRedirectFilter.doFilter(LwssoRedirectFilter.java:26)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
at com.hp.alm.platform.web.HTTPMethodsFilter.doFilter(HTTPMethodsFilter.java:52)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:568)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:309)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:159)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:462)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536)
at java.lang.Thread.run(Thread.java:745)

Sep 26
10:49:32.502 Sep 26
10:49:32.767 qtp1579767949-23 [RestoreProject] [login_id:1564886] [connect_id:-1] [call_id:28] FREC matthew.niejalke 0:0:0:0:0:0:0:1 ERR CAbsServlet.doPost(463)  

com.hp.alm.platform.exception.CTdException

Messages:
Failed to Restore Project; Failed to restore project. Cannot build directory item for key '[sap_implementation_projects::bulk_fuel_management_system]' in Enabled Extensions Directory; Cannot build directory item for key '[sap_implementation_projects::bulk_fuel_management_system]' in Enabled Extensions Directory; Failed to format extensions version of project 'sap_implementation_projects_bu'; Failed to obtain a connection to schema 'sap_implementation_projects_bu'; com.hp.alm.platform.db.CTdDbException: Can't create a new database connection.; Can't create a new database connection.;

Stack Trace:
com.hp.alm.platform.db.CTdDbException: Can't create a new database connection.
at com.hp.alm.platform.db.CConnectionPool.newConnection(CConnectionPool.java:878)
at com.hp.alm.platform.db.CConnectionPool.tryToGetConnection(CConnectionPool.java:610)
at com.hp.alm.platform.db.CConnectionPool.getConnection(CConnectionPool.java:377)
wrapped in com.hp.alm.platform.db.CTdDbException: Failed to obtain a connection to schema 'sap_implementation_projects_bu'; com.hp.alm.platform.db.CTdDbException: Can't create a new database connection.
at com.hp.alm.platform.db.CConnectionPool.getConnection(CConnectionPool.java:406)
at com.hp.alm.platform.db.CConnectionManager.getNotTransactedConnection(CConnectionManager.java:243)
at com.hp.alm.platform.db.CConnectionManager.getConnection(CConnectionManager.java:217)
at com.hp.alm.platform.db.CAbsStatement.<init>(CAbsStatement.java:87)
at com.hp.alm.platform.db.CTdPreparedStatement.<init>(CTdPreparedStatement.java:97)
at com.hp.alm.platform.db.CTdPreparedStatement.<init>(CTdPreparedStatement.java:89)
at com.hp.alm.platform.db.jdbc.JDBCTemplate$AbstractPreparedStatementCreator.create(JDBCTemplate.java:1252)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.executeQuery(JDBCTemplate.java:1051)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry.access$101(JDBCTemplateWithRetry.java:19)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry$2.exec(JDBCTemplateWithRetry.java:56)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry.executeWithRetry(JDBCTemplateWithRetry.java:98)
at com.hp.alm.platform.db.jdbc.JDBCTemplateWithRetry.executeQuery(JDBCTemplateWithRetry.java:52)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.executeQuery(JDBCTemplate.java:908)
at com.hp.alm.platform.db.jdbc.JDBCTemplate.executeQuery(JDBCTemplate.java:893)
at com.hp.alm.platform.directory.EnabledExtensions.formatExtensionsVersion(EnabledExtensions.java:84)
wrapped in com.hp.alm.platform.exception.CTdException: Failed to format extensions version of project 'sap_implementation_projects_bu'
at com.hp.alm.platform.directory.EnabledExtensions.formatExtensionsVersion(EnabledExtensions.java:112)
at com.hp.alm.platform.directory.EnabledExtensions.<init>(EnabledExtensions.java:63)
at com.hp.alm.platform.directory.EnabledExtensionsDirectory.createDirectoryItem(EnabledExtensionsDirectory.java:45)
at com.hp.alm.platform.directory.EnabledExtensionsDirectory.createDirectoryItem(EnabledExtensionsDirectory.java:15)
at com.mercury.optane.core.directory.CAbsDirectory$CacheResult.getOrCreate(CAbsDirectory.java:123)
wrapped in com.hp.alm.platform.exception.CTdException: Cannot build directory item for key '[sap_implementation_projects::bulk_fuel_management_system]' in Enabled Extensions Directory
at com.mercury.optane.core.directory.CAbsDirectory$CacheResult.getOrCreate(CAbsDirectory.java:141)
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:329)
at com.mercury.optane.core.directory.CAbsReloadableDirectory.getDirectoryItem(CAbsReloadableDirectory.java:27)
at com.hp.alm.platform.directory.EnabledExtensionsDirectory.getEnabledExtensions(EnabledExtensionsDirectory.java:40)
at com.hp.alm.platform.extension.CQcExtensionsLogic.getEnabledExtensionNames(CQcExtensionsLogic.java:125)
at com.hp.alm.platform.siteadmin.directory.CProject.getEnabledExtensionsNames(CProject.java:2210)
at com.mercury.td.pcextension.PCSAExtension.restoreLabProjectLinks(PCSAExtension.java:267)
at com.mercury.td.pcextension.PCSAExtension.afterRestoreProject(PCSAExtension.java:258)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at com.hp.alm.platform.extension.BaseExtensionEventDispatcher.invokeMethod(BaseExtensionEventDispatcher.java:108)
at com.hp.alm.platform.extension.BaseExtensionEventDispatcher.dispatchEvent(BaseExtensionEventDispatcher.java:71)
at com.hp.alm.platform.siteadmin.plugin.SAExtensionEventDispatcher.dispatchEvent(SAExtensionEventDispatcher.java:92)
at com.hp.alm.platform.siteadmin.plugin.SAExtensionEventDispatcher.afterRestoreProject(SAExtensionEventDispatcher.java:145)
at com.hp.alm.platform.siteadmin.api.logics.CProjectLogic.restoreProject(CProjectLogic.java:1546)
wrapped in com.hp.alm.platform.exception.CTdException: Failed to restore project. Cannot build directory item for key '[sap_implementation_projects::bulk_fuel_management_system]' in Enabled Extensions Directory
at com.hp.alm.platform.siteadmin.api.logics.CProjectLogic.restoreProject(CProjectLogic.java:1598)
at com.hp.alm.platform.siteadmin.api.logics.CProjectLogic.restoreProject(CProjectLogic.java:1396)
at com.hp.alm.platform.siteadmin.requests.RestoreProject.execute(RestoreProject.java:29)
at com.hp.alm.platform.web.RequestsDispatcher.execute(RequestsDispatcher.java:81)
wrapped in com.hp.alm.platform.exception.CTdException: Failed to Restore Project
at com.hp.alm.platform.web.RequestsDispatcher.execute(RequestsDispatcher.java:92)
at com.hp.alm.platform.server.web.CAbsServlet.executeFunction(CAbsServlet.java:590)
at com.hp.alm.platform.server.web.CAbsServlet.processRequest(CAbsServlet.java:580)
at com.hp.alm.platform.server.web.CAbsServlet.doPost(CAbsServlet.java:433)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651)
at com.hp.alm.platform.util.gzipfilter.GZIPFilter.doFilter(GZIPFilter.java:31)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1631)
at com.mercury.optane.core.state.ServerStatusFilter.doFilter(ServerStatusFilter.java:34)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
at org.hp.qc.web.restapi.authentication.LwssoRedirectFilter.doFilter(LwssoRedirectFilter.java:26)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
at com.hp.alm.platform.web.HTTPMethodsFilter.doFilter(HTTPMethodsFilter.java:52)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:568)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:309)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:159)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:462)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536)
at java.lang.Thread.run(Thread.java:745)

0 Likes
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Re: Cannot restore Lab Project duing HP ALM 12.5 Upgrade

Jump to solution

From the error - Login failed for INTERNAL\_sHPALM_Dev - this looks like user access issue. 

What is the db admin user id for the old and new databases? make sure the ID you use has all the righ privileges (creation & security access) for the db schema. Compare the privileges from your old db to the new one to get a better idea. 

(If this post solves or helps solve your issue, mark the thread as solved and give kudos to the author for their assistance. Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.)
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Cannot restore Lab Project duing HP ALM 12.5 Upgrade

Jump to solution

Bipin,

Yes it is an access issue to a different project on the produciton database. Question is why is it trying to access the wrong project and if I do grant access to the production database will it update it? Obviously that would be very bad so I really dont want to grant the access.

More importantly how do I get HP ALM to convert the Lab Project?

Mat.

 

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Cannot restore Lab Project duing HP ALM 12.5 Upgrade

Jump to solution

I solved this problem by removing all the other projects first. Once I did that I was able to restore the Lab Project and then the other projects.

Not sure why HP ALM insisted on the other projects being able to connect to the database.

View solution in original post

Respected Contributor.
Respected Contributor.

Re: Cannot restore Lab Project duing HP ALM 12.5 Upgrade

Jump to solution

Recently the same issue I have observed while restoring the Lab Project.

After observing the SA and wrapper logs we have found that it was pointing to incorrect database with incorrect DB_user. I logged in with the correct DB_user for LAB project via SQL Developer tool.

And changed the DB parameters in dbid.xml file of the Lab Management project.

Also changed the <DB_USER_PASS>TXT:password</DB_USER_PASS>

Kept PROJECT_UID blank as below:
<PROJECT_UID></PROJECT_UID>

Post changes I restored the Lab project successfully.

 

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.