AnsweredAssumed Answered

DB Refresh from Clarity Prod DB to Dev DB

Question asked by jmarshall on Mar 4, 2010
Latest reply on Mar 4, 2010 by another_martink
Hi we are on Clarity PPM v12, our DBA tried doing a refresh of the Prod DB to overlay the Dev DB. When thats done the Dev Application crashes error message recived when trying to access the Dev App is listed below.   Has anyone encountered this before.   Thanks for any help you can provide with this error.   When we do the refresh from  Prod we are updating all the tables, not sure if some of the tables should not be refreshed from Prod when copying it to Dev.      Error Message received when trying to get to the Dev Application once the DB refresh is done   type Exception report message  description The server encountered an internal error () that prevented it from fulfilling this request. exception  javax.servlet.ServletException: Database is not available or not installed correctly.

com.niku.union.web.WebControlServlet.init(WebControlServlet.java:141)

javax.servlet.GenericServlet.init(GenericServlet.java:212)

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:482)

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)

org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

java.lang.Thread.run(Thread.java:595)    root cause  com.niku.union.config.ConfigurationException: Database is not available or not installed correctly.

com.niku.union.config.ConfigurationManager.verifyDatabaseConnect(ConfigurationManager.java:2623)

com.niku.union.config.ConfigurationManager.initAppServerIntern(ConfigurationManager.java:2048)

com.niku.union.config.ConfigurationManager.initAppServer(ConfigurationManager.java:1997)

com.niku.union.web.WebControlServlet.init(WebControlServlet.java:128)

javax.servlet.GenericServlet.init(GenericServlet.java:212)

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:482)

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)

org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

java.lang.Thread.run(Thread.java:595)    root cause  com.niku.union.persistence.PersistenceException:
SQL error code: 208
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'CMN_INSTALL_HISTORY'.
SQL error code: 8180
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
Executed:
SELECT BASE_RELEASE
FROM CMN_INSTALL_HISTORY H
WHERE INSTALL_TYPE = 'install'
AND INSTALL_ID = 'database'
AND INSTALLED_DATE = (SELECT MAX (INSTALLED_DATE)
FROM CMN_INSTALL_HISTORY H1
WHERE H1.INSTALL_TYPE = 'install'
AND H1.INSTALL_ID = H.INSTALL_ID)
Derived from statement:




SELECT BASE_RELEASE
FROM CMN_INSTALL_HISTORY H
WHERE INSTALL_TYPE = 'install'
AND INSTALL_ID = 'database'
AND INSTALLED_DATE = (SELECT MAX (INSTALLED_DATE)
FROM CMN_INSTALL_HISTORY H1
WHERE H1.INSTALL_TYPE = 'install'
AND H1.INSTALL_ID = H.INSTALL_ID)




Referenced by:



Using input:
None


com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:1800)

com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:1858)

com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2334)

com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:701)

com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:610)

com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:450)

com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:221)

com.niku.union.config.ConfigurationManager.verifyDatabaseConnect(ConfigurationManager.java:2574)

com.niku.union.config.ConfigurationManager.initAppServerIntern(ConfigurationManager.java:2048)

com.niku.union.config.ConfigurationManager.initAppServer(ConfigurationManager.java:1997)

com.niku.union.web.WebControlServlet.init(WebControlServlet.java:128)

javax.servlet.GenericServlet.init(GenericServlet.java:212)

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:482)

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)

org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

java.lang.Thread.run(Thread.java:595)    root cause  java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'CMN_INSTALL_HISTORY'.

com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)

com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)

com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

com.ca.clarity.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)

com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

com.ca.clarity.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)

com.ca.clarity.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)

com.ca.clarity.jdbc.base.BaseStatement.postImplExecute(Unknown Source)

com.ca.clarity.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)

com.ca.clarity.jdbc.base.BaseStatement.commonExecute(Unknown Source)

com.ca.clarity.jdbc.base.BaseStatement.executeInternal(Unknown Source)

com.ca.clarity.jdbc.base.BasePreparedStatement.execute(Unknown Source)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

java.lang.reflect.Method.invoke(Method.java:585)

org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)

org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$8cfb04dd.execute( )

com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2313)

com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:701)

com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:610)

com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:450)

com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:221)

com.niku.union.config.ConfigurationManager.verifyDatabaseConnect(ConfigurationManager.java:2574)

com.niku.union.config.ConfigurationManager.initAppServerIntern(ConfigurationManager.java:2048)

com.niku.union.config.ConfigurationManager.initAppServer(ConfigurationManager.java:1997)

com.niku.union.web.WebControlServlet.init(WebControlServlet.java:128)

javax.servlet.GenericServlet.init(GenericServlet.java:212)

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:482)

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)

org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

java.lang.Thread.run(Thread.java:595)    root cause  java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.

com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)

com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)

com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

com.ca.clarity.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)

com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

com.ca.clarity.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)

com.ca.clarity.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)

com.ca.clarity.jdbc.base.BaseStatement.postImplExecute(Unknown Source)

com.ca.clarity.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)

com.ca.clarity.jdbc.base.BaseStatement.commonExecute(Unknown Source)

com.ca.clarity.jdbc.base.BaseStatement.executeInternal(Unknown Source)

com.ca.clarity.jdbc.base.BasePreparedStatement.execute(Unknown Source)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

java.lang.reflect.Method.invoke(Method.java:585)

org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)

org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$8cfb04dd.execute( )

com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2313)

com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:701)

com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:610)

com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:450)

com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:221)

com.niku.union.config.ConfigurationManager.verifyDatabaseConnect(ConfigurationManager.java:2574)

com.niku.union.config.ConfigurationManager.initAppServerIntern(ConfigurationManager.java:2048)

com.niku.union.config.ConfigurationManager.initAppServer(ConfigurationManager.java:1997)

com.niku.union.web.WebControlServlet.init(WebControlServlet.java:128)

javax.servlet.GenericServlet.init(GenericServlet.java:212)

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:482)

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)

org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

java.lang.Thread.run(Thread.java:595)

Outcomes