Applies to:
HP ALM, HP QC
Issue Summary:
When trying to create new project the error "create new project" occurs. In the error log the specific error is: "Failed to create HP ALM project; DB server 'ProjectName' is of unsupported version".
When installing ALM 12.60 the license key validation failed with "unsupported database" error.
Resolution:
In order to enable unsupported databases (or remedy this error) the following parameter should be added in ALM Site Administration Site Configuration tab:
11.52:
Parameter: ALLOW_NON_SUPPORTED_DB_VERSION
Value: Y
12.x+
Parameter: ALLOW_UNSUPPORTED_DB_VERSION
Value: Y
validations.xlm. Disable database verification check, and well as license check.
11.52
If you modify the run_after_finish.bat to include the SKIP_VALIDATIONS flags -wDbSettingsValidator -wSaSchemaValidator
Set site Parameters ALLOW_NON_SUPPORTED_DB_VERSION and UPGRADE_SKIP_DB_VERSION_CHECK = Y
**** IF the LAB PROJECT on 11.52 failed to create due to unsupported database:
If you modify the run_after_finish.bat
to include the SKIP_VALIDATIONS flags -wDbSettingsValidator -wSaSchemaValidator
the Site Admin database will be created successfully after installation.
Then there is a point about 70% through the post-installation ALM deployment process
where the Server Configuration Wizard UI states “Enabling extensions on SA schema”
immediately after the Site Admin database has been created successfully.
This step takes several seconds.
If you are able to insert the Site Parameters ALLOW_NON_SUPPORTED_DB_VERSION and UPGRADE_SKIP_DB_VERSION_CHECK during that short window,
then the LAB_PROJECT creates successfully the first time
On Oracle:
YOU MUST create a new instance of ALM to create the lab project and database. Then upgrade old production. Then import the dbid.xml.
For SQL I attached a .bak and file repo.
****IFFFFFFF IFFFFF IFFFFF you are on Oracle... dont forget to commit the query.
If project fails: can try this:
Comment line: (<!-- ENTRY VALUE="com.mercury.qc.dbverify.tasks.DBSupportedCheckTask" -->) inside 2 files:
C:\Program Files (x86)\HP\Quality Center\repository\sa\DomsInfo\MaintenanceData\conf\ verify_tasks_deep.xml and verify_tasks_basic.xml
You can also update the site admin params table with this configuration parameter, also disable license validation to avoid this error in the installer.
NOTE: There is no need to restart the ALM service.
Appendix:
Creation of project failed : DB server 'xxxxxxx' is of unsupported version; Database minimal supported version is MSSQL 2008 server R2 SP2
com.hp.alm.platform.exception.CTdException
Messages:
DB server 'xxxxxxxx' is of unsupported version; Database minimal supported version is MSSQL 2008 server R2 SP2;
Stack Trace:
com.hp.alm.platform.exception.CTdException: DB server 'xxxxxxx' is of unsupported version; Database minimal supported version is MSSQL 2008 server R2 SP2
at com.hp.alm.platform.siteadmin.api.logics.CProjectLogic.assertDbVersionSupported(CProjectLogic.java:6848)
at com.hp.alm.platform.siteadmin.api.logics.CProjectLogic.createProject(CProjectLogic.java:2598)
at com.hp.alm.platform.siteadmin.api.logics.CProjectLogic.createProject(CProjectLogic.java:2416)
at com.hp.alm.platform.siteadmin.requests.CreateProject.execute(CreateProject.java:57)
at com.hp.alm.platform.web.RequestsDispatcher.execute(RequestsDispatcher.java:81)
at com.hp.alm.platform.server.web.CAbsServlet.executeFunction(CAbsServlet.java:604)
at com.hp.alm.platform.server.web.CAbsServlet.processRequest(CAbsServlet.java:594)
at com.hp.alm.platform.server.web.CAbsServlet.doPost(CAbsServlet.java:462)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:547)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1359)
at com.hp.alm.platform.util.gzipfilter.GZIPFilter.doFilter(GZIPFilter.java:31)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1330)
at com.mercury.optane.core.state.ServerStatusFilter.doFilter(ServerStatusFilter.java:35)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1330)
at com.hp.alm.platform.web.HTTPMethodsFilter.doFilter(HTTPMethodsFilter.java:52)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1330)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:478)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:520)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:941)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:409)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:875)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:312)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
at org.eclipse.jetty.server.Server.handle(Server.java:345)
at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:441)
at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:936)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:801)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:224)
at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:51)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:586)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:44)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:598)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:533)
at java.lang.Thread.run(Thread.java:722)