NOTICE: Significant community changes coming soon
The header menu and the home page on our community will be changing soon. Get more information HERE.
Established Member..
Established Member..
516 views

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)

Tags (1)
0 Likes
1 Reply
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

What exact DB version you are running on?

 

Regards
-Dmitry Gomel, PMP
Click the Like button at the bottom to say 'Thanks'.
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.