Highlighted
Absent Member.. Absent Member..
Absent Member..
126 views

cms to rtsm sync error in ucmdb and bsm integration for globalid sync

Hi,

 

Working on UD 10.10 cp13 cup2

 

BSM 9.23 

 

Working on globalid sync from ucmdb to BSM .

 

Installed CMS to RTSM sync package o ucmdb and bsm and created integration point successfully but all jobs are showing below error from BSM side. Even tried to pull single CI but no luck.

 

"Integration[CMS to RTSM Sync]: Unable to calculate Query [BasicInfrastructure_Sync] result in source UCMDB after 200 seconds"

 

Please suggest.

 

ERROR MESSAGE :

ailed running population. destID:CMS to RTSM Sync, Failed during query:BasicInfrastructure_Sync, all queries:[BasicInfrastructure_Sync], finished queries:[] ERROR:appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [802] General Integration Error]
CMDB Operation Internal Error: class com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.exception.AdapterAccessGeneralException : Integration[CMS to RTSM Sync]: Unable to calculate Query [BasicInfrastructure_Sync] result in source UCMDB after 200 seconds
com.mercury.topaz.cmdb.shared.base.CmdbException: [ErrorCode [-2147483648] undefined error code]
Unable to calculate Query [BasicInfrastructure_Sync] result in source UCMDB after 200 seconds
at com.hp.ucmdb.adapters.cmdbAdapter.CmdbAdapter.validateResultIsCalculated(CmdbAdapter.java:448)
at com.hp.ucmdb.adapters.cmdbAdapter.CmdbAdapter.getChangesFromFullQuery(CmdbAdapter.java:425)
at com.hp.ucmdb.adapters.cmdbAdapter.CmdbAdapter.getChanges(CmdbAdapter.java:307)
at com.mercury.topaz.cmdb.server.fcmdb.dataAccess.operation.query.impl.DataAccessAdapterQueryRetrieveChanges.getChangesResult(DataAccessAdapterQueryRetrieveChanges.java:48)
at com.mercury.topaz.cmdb.server.fcmdb.dataAccess.operation.query.impl.DataAccessAdapterQueryRetrieveChanges.doDataAccessQueryExecute(DataAccessAdapterQueryRetrieveChanges.java:38)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.query.impl.AbstractDataAccessLifeCycleAdapterQuery.doLifeCycleExecute(AbstractDataAccessLifeCycleAdapterQuery.java:36)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.impl.AbstractDataAccessLifeCycleAdapterOperation.doDataAccessExecute(AbstractDataAccessLifeCycleAdapterOperation.java:60)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.impl.AbstractDataAccessAdapterOperation.dataAccessExecute(AbstractDataAccessAdapterOperation.java:62)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.impl.AbstractDataAccessAdapterOperation.doExecute(AbstractDataAccessAdapterOperation.java:39)
at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractFrameworkOperation.commonExecute(AbstractFrameworkOperation.java:17)
at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:62)
at com.mercury.topaz.cmdb.server.fcmdb.dataAccess.manager.impl.DataAccessAdapterManagerProbeImpl.executeOperation(DataAccessAdapterManagerProbeImpl.java:51)
at com.hp.ucmdb.discovery.probe.agents.probemgr.adapters.DataAccessAdaptersFacade.invokeOperation(DataAccessAdaptersFacade.java:369)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runChangesOnPopulateChangesAdapter(AdapterService.java:872)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueriesOnPopulateChangesAdapter(AdapterService.java:838)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueries(AdapterService.java:288)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runDiscovery(AdapterService.java:185)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.discover(AdapterService.java:140)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter.launchTask(JobExecuter.java:1238)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.launch(JobExecuter.java:993)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.executeTask(JobExecuter.java:930)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.run(JobExecuter.java:836)
: operation Data Access Adapter Query: Retrieve Changed Data
at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:88)
at com.mercury.topaz.cmdb.server.fcmdb.dataAccess.manager.impl.DataAccessAdapterManagerProbeImpl.executeOperation(DataAccessAdapterManagerProbeImpl.java:51)
at com.hp.ucmdb.discovery.probe.agents.probemgr.adapters.DataAccessAdaptersFacade.invokeOperation(DataAccessAdaptersFacade.java:369)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runChangesOnPopulateChangesAdapter(AdapterService.java:872)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueriesOnPopulateChangesAdapter(AdapterService.java:838)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueries(AdapterService.java:288)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runDiscovery(AdapterService.java:185)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.discover(AdapterService.java:140)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter.launchTask(JobExecuter.java:1238)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.launch(JobExecuter.java:993)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.executeTask(JobExecuter.java:930)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.run(JobExecuter.java:836)
Caused by: com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.exception.AdapterAccessGeneralException: [ErrorCode [802] General Integration Error]
Integration[CMS to RTSM Sync]: Unable to calculate Query [BasicInfrastructure_Sync] result in source UCMDB after 200 seconds
com.mercury.topaz.cmdb.shared.base.CmdbException: [ErrorCode [-2147483648] undefined error code]
Unable to calculate Query [BasicInfrastructure_Sync] result in source UCMDB after 200 seconds
at com.hp.ucmdb.adapters.cmdbAdapter.CmdbAdapter.validateResultIsCalculated(CmdbAdapter.java:448)
at com.hp.ucmdb.adapters.cmdbAdapter.CmdbAdapter.getChangesFromFullQuery(CmdbAdapter.java:425)
at com.hp.ucmdb.adapters.cmdbAdapter.CmdbAdapter.getChanges(CmdbAdapter.java:307)
at com.mercury.topaz.cmdb.server.fcmdb.dataAccess.operation.query.impl.DataAccessAdapterQueryRetrieveChanges.getChangesResult(DataAccessAdapterQueryRetrieveChanges.java:48)
at com.mercury.topaz.cmdb.server.fcmdb.dataAccess.operation.query.impl.DataAccessAdapterQueryRetrieveChanges.doDataAccessQueryExecute(DataAccessAdapterQueryRetrieveChanges.java:38)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.query.impl.AbstractDataAccessLifeCycleAdapterQuery.doLifeCycleExecute(AbstractDataAccessLifeCycleAdapterQuery.java:36)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.impl.AbstractDataAccessLifeCycleAdapterOperation.doDataAccessExecute(AbstractDataAccessLifeCycleAdapterOperation.java:60)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.impl.AbstractDataAccessAdapterOperation.dataAccessExecute(AbstractDataAccessAdapterOperation.java:62)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.impl.AbstractDataAccessAdapterOperation.doExecute(AbstractDataAccessAdapterOperation.java:39)
at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractFrameworkOperation.commonExecute(AbstractFrameworkOperation.java:17)
at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:62)
at com.mercury.topaz.cmdb.server.fcmdb.dataAccess.manager.impl.DataAccessAdapterManagerProbeImpl.executeOperation(DataAccessAdapterManagerProbeImpl.java:51)
at com.hp.ucmdb.discovery.probe.agents.probemgr.adapters.DataAccessAdaptersFacade.invokeOperation(DataAccessAdaptersFacade.java:369)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runChangesOnPopulateChangesAdapter(AdapterService.java:872)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueriesOnPopulateChangesAdapter(AdapterService.java:838)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueries(AdapterService.java:288)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runDiscovery(AdapterService.java:185)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.discover(AdapterService.java:140)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter.launchTask(JobExecuter.java:1238)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.launch(JobExecuter.java:993)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.executeTask(JobExecuter.java:930)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.run(JobExecuter.java:836)

at com.mercury.topaz.cmdb.server.fcmdb.util.ExceptionConverter.createAdapterAccessGeneralException(ExceptionConverter.java:238)
at com.mercury.topaz.cmdb.server.fcmdb.util.ExceptionConverter.createAdapterAccessException(ExceptionConverter.java:96)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.impl.AbstractDataAccessAdapterOperation.createAdapterAccessException(AbstractDataAccessAdapterOperation.java:57)
at com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.operation.impl.AbstractDataAccessAdapterOperation.doExecute(AbstractDataAccessAdapterOperation.java:42)
at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractFrameworkOperation.commonExecute(AbstractFrameworkOperation.java:17)
at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:62)
... 11 more

 

0 Likes
3 Replies
Highlighted
Absent Member.
Absent Member.

Re: cms to rtsm sync error in ucmdb and bsm integration for globalid sync

Hello Nick,

 

Can you please let me know  if the count for TQL BasicInfrastructure_Sync from UI(MOdeling Studio ) or jmx (retrieveTqlResultCount) is working ? Is the query active/ persistent?

 

Regarding this issue there can be several causes:

    1 the TQL is in invalid state

    2. the connection with DB is too slow

    3. ucmdb is working slow

 

We need more data in order to find the cause. A quick suggestion is to restart uCMDB. In this way if the TQL got in an invalid state it should recover.

 

If the problem is reproducible after restart I suggest to open a support case to have this investigated. We need:

in the CMS:
1- open the cmdb.pattern.log, cmdb.pattern.management.log and cmdb.scheduler.decisionmaking.log for DEBUG
2- open the cmdb.operation.log for DEBUG and the number of log filed to 100
3- rerun the sync untill it fails
4- move the cmdb.operation.log back to ERROR
5- send the log files again (both CMS and RTSM probe)
 
Best Regards,
Gabi Medan

 

 

 

0 Likes
Highlighted
New Member.

Re: cms to rtsm sync error in ucmdb and bsm integration for globalid sync

Hi Nick,

 

Could you please check your query?, and please let me know is it the query BasicInfrastructure_Sync that you created manually?

 

Best Regards,

Hoang.

-------------------------------------------------------------------------------
*HP Support
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution.*
*If you feel the post is helpful, please assign a KUDO star to say "Thanks"*
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: cms to rtsm sync error in ucmdb and bsm integration for globalid sync

Hi Guys.

 

Thanks for quick reply.

 

But all jobs has run at night successfuly.  

 

 

Regards,

Nick

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.