Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..
758 views

UCMDB error

Caused by: appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
CMDB Operation Internal Error: class com.mercury.topaz.cmdb.server.manage.dal.CmdbDalBatchException : Can't execute BATCH prepared statement [insert into LOA(CUSTOMER_ID,CMDB_ID,CI,A1,A2,A3,A4) values (?,?,?,?,?,?,?)], failed on element at index [0] due to exception: com.mercury.jdbc.sqlserverbase.ddc: [mercury][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK_LOA'. Cannot insert duplicate key in object 'dbo.LOA'. The duplicate key value is (0x6b90a7df6efb659365c800bbf96a33e9, 1). : operation Model Update: Update model with bulk of operations in mixed OPTIMISTIC/STRICT mode
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:109)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:56)
	at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.executeInGroup(FlowManager.java:244)
	at com.mercury.topaz.cmdb.shared.manage.operation.flow.OperationInFlowGroupExecutor.execute(OperationInFlowGroupExecutor.java:23)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:148)
	... 69 more
Caused by: com.mercury.topaz.cmdb.server.manage.dal.CmdbDalBatchException: [ErrorCode [-2147483648] undefined error code]
Can't execute BATCH prepared statement [insert into LOA(CUSTOMER_ID,CMDB_ID,CI,A1,A2,A3,A4) values (?,?,?,?,?,?,?)], failed on element at index [0] due to exception: com.mercury.jdbc.sqlserverbase.ddc: [mercury][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK_LOA'. Cannot insert duplicate key in object 'dbo.LOA'. The duplicate key value is (0x6b90a7df6efb659365c800bbf96a33e9, 1).
	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.hp.ucmdb.reconciliation.maintenance.dal.LoaDao.addElements(LoaDao.java:76)
	at com.hp.ucmdb.reconciliation.maintenance.dal.LoaDao.addElements(LoaDao.java:55)
	at com.hp.ucmdb.reconciliation.maintenance.dal.LoaFacadeImpl.updateElements(LoaFacadeImpl.java:121)
	at com.hp.ucmdb.reconciliation.maintenance.dal.SynchronousModelChangesListener.onUpdateObjects(SynchronousModelChangesListener.java:84)
	at com.mercury.topaz.cmdb.shared.model.change.impl.ModelChangeUpdateObjects.execute(ModelChangeUpdateObjects.java:47)
	at com.mercury.topaz.cmdb.shared.model.change.impl.CmdbAbstractModelChange.execute(CmdbAbstractModelChange.java:38)
	at com.mercury.topaz.cmdb.shared.notification.service.util.ChangesPublisher.publish(ChangesPublisher.java:32)
	at com.mercury.topaz.cmdb.shared.model.operation.update.impl.AbstractExternalModelUpdate.notifySynchChanges(AbstractExternalModelUpdate.java:290)
	at com.mercury.topaz.cmdb.shared.model.operation.update.impl.AbstractExternalModelUpdate.modelUpdateExecute(AbstractExternalModelUpdate.java:257)
	at com.mercury.topaz.cmdb.shared.model.operation.update.impl.bulk.AbstractModelUpdateBulks.bulkExecute(AbstractModelUpdateBulks.java:91)
	at com.mercury.topaz.cmdb.shared.model.operation.update.impl.bulk.AbstractModelUpdateBulks.modelUpdateExecute(AbstractModelUpdateBulks.java:77)
	at com.mercury.topaz.cmdb.shared.model.operation.update.impl.AbstractExternalModelUpdate.doExecute(AbstractExternalModelUpdate.java:154)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractFrameworkOperation.commonExecute(AbstractFrameworkOperation.java:17)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:83)
	... 73 more
Caused by: com.mercury.jdbc.sqlserverbase.ddc: [mercury][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK_LOA'. Cannot insert duplicate key in object 'dbo.LOA'. The duplicate key value is (0x6b90a7df6efb659365c800bbf96a33e9, 1).
	at com.mercury.jdbc.sqlserver.ddj.k(Unknown Source)
	at com.mercury.jdbc.sqlserverbase.dddf.executeBatch(Unknown Source)
	at com.mercury.jdbc.sqlserverbase.dddj.executeBatch(Unknown Source)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
	at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalPreparedStatementImpl$FlowControlBatchExecuter.execute(CmdbDalPreparedStatementImpl.java:525)
	at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalPreparedStatementImpl$FlowControlBatchExecuter.execute(CmdbDalPreparedStatementImpl.java:517)
	at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:227)
	at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalPreparedStatementImpl.internalExecuteBatch(CmdbDalPreparedStatementImpl.java:329)

 We've been getting the above error when trying to populate dev ucmdb with our prod ucmdb. 

 

We are using ucmdb10.x adapter and both system are on UD10.01 CUP 7

 

Any idea?

0 Likes
3 Replies
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Re: UCMDB error

How your sync TQL is looks like?

It strange that sync is trying to push reconciliation priorities...

Regards
-Dmitry Gomel, PMP
Click the Like button at the bottom to say 'Thanks'.
0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: UCMDB error

I have a simple tql consist computer and relationship to interface and ip_address

0 Likes
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Re: UCMDB error

I'm not sure if the error is related to the probelm you have. The only known problem related to insert into LOA tables in UCMDB 10.01 is http://support.openview.hp.com/selfsolve/document/LID/QCCR1H87406. It was fixed in 10.01 CUP6.

So, you already have it. Please open support case.

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.