The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
UCMDB and UD Practitioners Forum (Previously CMS)
cancel
Showing results for 
Search instead for 
Did you mean: 

state_management fails on start up after uCMDB 10 upgrade to 10.01 CUP4

Highlighted
Ben.Shirley
Occasional Visitor

state_management fails on start up after uCMDB 10 upgrade to 10.01 CUP4

We have applied service pack 10.1 to  our v10 uCMDB, and then applied CUP4 now the product wont start and the state_management service is showing as failed. The error.log contains the following:-

 

2013-06-27 13:19:17,593 [Starter for "state_management" (during Writer server startup). (customer 1, id name: Default Client)] (DalAbstractCommand.java:64) ERROR - Failed to execute command [com.mercury.topaz.cmdb.server.manage.dal.dao.DaoFactory$TransactionProxy$ProxyDalAbstractCommand@6c5ec62a] time [64 ms] customer ID [1, id name: Default Client] operation stack [N/A]
com.mercury.topaz.cmdb.server.manage.dal.CmdbDalBatchException: [ErrorCode [-2147483648] undefined error code]
Can't execute BATCH prepared statement [MERGE INTO HA_REVISIONS R using (SELECT ? as MODEL_ID, ? as REVISION ) S ON (R.MODEL_ID = S.MODEL_ID) when not matched then insert (MODEL_ID, REVISION) values (S.MODEL_ID, S.REVISION) when matched then update set R.REVISION = S.REVISION;], failed on element at index [0] due to exception: com.mercury.jdbc.sqlserverbase.ddc: [mercury][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'MERGE'.
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalPreparedStatementImpl.internalExecuteBatch(CmdbDalPreparedStatementImpl.java:355)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalPreparedStatementImpl.executeBatch(CmdbDalPreparedStatementImpl.java:319)
at com.mercury.topaz.cmdb.server.dal.dao.impl.HADaoImpl.getNextModelRevisions(HADaoImpl.java:62)
at com.mercury.topaz.cmdb.server.dal.dao.impl.HADaoImpl.updateHAChangesRevisions(HADaoImpl.java:32)
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:601)
at com.mercury.topaz.cmdb.server.manage.dal.dao.DaoFactory$TransactionProxy$ProxyDalAbstractCommand.perform(DaoFactory.java:150)
at com.mercury.topaz.cmdb.server.manage.dal.DalAbstractCommand$FlowControlDalCommandExecutor.execute(DalAbstractCommand.java:36)
at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:227)
at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:222)
at com.mercury.topaz.cmdb.server.manage.dal.DalAbstractCommand.execute(DalAbstractCommand.java:54)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalJdbcDAO$CmdbDalDeadlockRetriable.performAction(CmdbDalJdbcDAO.java:120)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalJdbcDAO$CmdbDalDeadlockRetriable.performAction(CmdbDalJdbcDAO.java:105)
at com.mercury.topaz.cmdb.shared.util.retry.impl.DefaultRetriableExecutorImpl.doExecute(DefaultRetriableExecutorImpl.java:37)
at com.mercury.topaz.cmdb.shared.util.retry.impl.AbstractRetriableExecutor.execute(AbstractRetriableExecutor.java:37)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalJdbcDAO.executeQuery(CmdbDalJdbcDAO.java:61)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalJdbcDAO.executeQuery(CmdbDalJdbcDAO.java:53)
at com.mercury.topaz.cmdb.server.manage.dal.dao.DaoFactory$TransactionProxy.invoke(DaoFactory.java:130)
at $Proxy153.updateHAChangesRevisions(Unknown Source)
at com.mercury.topaz.cmdb.server.manage.ha.transactions.HAGatherAndPersistChanges.commit(HAGatherAndPersistChanges.java:49)
at com.mercury.topaz.cmdb.server.transaction.Transaction.commit(Transaction.java:77)
at com.mercury.topaz.cmdb.server.transaction.TransactionManager.commit(TransactionManager.java:88)
at com.mercury.topaz.cmdb.server.urm.impl.UnifiedResourceManagerImpl.commitTransaction(UnifiedResourceManagerImpl.java:405)
at com.mercury.topaz.cmdb.server.urm.impl.UnifiedResourceManagerImpl.commitTransaction(UnifiedResourceManagerImpl.java:388)
at com.mercury.topaz.cmdb.server.urm.transactions.URMTransactionWrapper.execute(URMTransactionWrapper.java:25)
at com.mercury.topaz.cmdb.server.urm.impl.UnifiedResourceManagerImpl.put(UnifiedResourceManagerImpl.java:96)
at com.mercury.topaz.cmdb.server.urm.impl.UnifiedResourceManagerStatisticsDecorator$5.callDecoratedMethod(UnifiedResourceManagerStatisticsDecorator.java:213)
at com.mercury.topaz.cmdb.server.urm.impl.UnifiedResourceManagerStatisticsDecorator$StatisticsMethodWrapper.<init>(UnifiedResourceManagerStatisticsDecorator.java:60)
at com.mercury.topaz.cmdb.server.urm.impl.UnifiedResourceManagerStatisticsDecorator$5.<init>(UnifiedResourceManagerStatisticsDecorator.java:211)
at com.mercury.topaz.cmdb.server.urm.impl.UnifiedResourceManagerStatisticsDecorator.put(UnifiedResourceManagerStatisticsDecorator.java:211)
at com.mercury.topaz.cmdb.server.util.URMOfflineTool.put(URMOfflineTool.java:111)
at com.mercury.topaz.cmdb.server.manage.settings.InternalSettings.setSystemParameter(InternalSettings.java:148)
at com.mercury.topaz.cmdb.server.base.cfg.impl.InternalSettingsProvider.setValue(InternalSettingsProvider.java:52)
at com.mercury.topaz.cmdb.server.base.cfg.impl.SettingsReaderImpl.setProperty(SettingsReaderImpl.java:137)
at com.mercury.topaz.cmdb.server.upgrade.impl.SubsystemManagersUpgrader.updateUpgraderVersion(SubsystemManagersUpgrader.java:266)
at com.mercury.topaz.cmdb.server.upgrade.impl.SubsystemManagersUpgrader.performPostStartupUpgrade(SubsystemManagersUpgrader.java:152)
at com.mercury.topaz.cmdb.server.upgrade.impl.SubsystemManagersUpgrader.postStartup(SubsystemManagersUpgrader.java:140)
at com.mercury.topaz.cmdb.server.manage.service.impl.ServiceComponentImpl.startup(ServiceComponentImpl.java:123)
at com.mercury.topaz.cmdb.server.manage.service.impl.ServiceComponentImpl.startupSubsystemManagers(ServiceComponentImpl.java:110)
at com.mercury.topaz.cmdb.server.manage.service.impl.ServiceComponentImpl.startUp(ServiceComponentImpl.java:72)
at com.mercury.topaz.cmdb.server.manage.instance.CustomerInstanceImpl.startComponentLocally(CustomerInstanceImpl.java:104)
at com.mercury.topaz.cmdb.server.manage.instance.CustomerInstanceImpl.startComponentLocally(CustomerInstanceImpl.java:94)
at com.mercury.topaz.cmdb.server.manage.instance.Controller$ComponentLifecycleImpl.startComponent(Controller.java:291)
at com.mercury.topaz.cmdb.server.manage.instance.CustomerController.startComponent(CustomerController.java:442)
at com.mercury.topaz.cmdb.server.manage.instance.CustomerController.access$200(CustomerController.java:27)
at com.mercury.topaz.cmdb.server.manage.instance.CustomerController$RunnerWrapper.run(CustomerController.java:404)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:599)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:534)
at java.lang.Thread.run(Thread.java:722)

1 REPLY
Dima Gomel
New Member

Re: state_management fails on start up after uCMDB 10 upgrade to 10.01 CUP4

What exact DB version you are running on?

 

Regards
-Dmitry Gomel, PMP
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Click the Like button at the bottom to say 'Thanks'.
//Add this to "OnDomLoad" event