Honored Contributor.
Honored Contributor.

UCMDB to Service Now push : creates duplicates


I push cis to the default CMDB_CI_Win_computer table.. the cis getting duplicated even for a single push.. multiple nodes gets created in servicenow.

it says did not find cis of nt but still it pushes the ci but with duplicates.. could you help me to resolve this error?

in log i get this only error..

2016-02-23 08:50:02,948  DEBUG  [AdHoc:AD_HOC_TASK_PATTERN_ID-135-1456235402961] - UCMDB2SNOW >> Did not find cis from type nt
2016-02-23 08:50:02,948  DEBUG  [AdHoc:AD_HOC_TASK_PATTERN_ID-135-1456235402961] - UCMDB2SNOW >> Invoking ad hoc task...
2016-02-23 08:50:02,948  DEBUG  [AdHoc:AD_HOC_TASK_PATTERN_ID-135-1456235402961] - UCMDB2SNOW >> Result sent to jython script:
Add Result:
Update Reference Result:
[Document:  No DOCTYPE declaration, Root is [Element: <root/>]]
2016-02-23 08:50:02,948  DEBUG  [AdHoc:AD_HOC_TASK_PATTERN_ID-135-1456235402961] - UCMDB2SNOW >> Not setting query name in the task since queryDefinition is null



2 Replies
Honored Contributor.
Honored Contributor.

Re: UCMDB to Service Now push : creates duplicates

UCMDB version 10.22

Absent Member.
Absent Member.

Re: UCMDB to Service Now push : creates duplicates


ServiceNow push integration stores the id mapping in UCMDB DB after the first push to avoid the duplicates. In theory, it should not create the duplicates for a single push.

I would suggest to check if there are some duplicates in data source or some exception is raised. The details of the log are available in probeMgr-adaptersDebug.log.

Please follow the steps below to enable the debug log:

  1. Go to Data Flow Management > Adapter Management > Resources> Packages > ServiceNow_Integration > Scripts > pushToServiceNow.py.
  2. Change DEBUGLEVEL = 0 to DEBUGLEVEL = 5.
  3. The debug logs appear in the probeMgr-adaptersDebug.log file.

Below is a debug log example:
<2014-12-04 06:28:37,435> [DEBUG] [AdHoc:AD_HOC_TASK_PATTERN_ID-38-1417645713412] - ========================================================
<2014-12-04 06:28:37,454> [DEBUG] [AdHoc:AD_HOC_TASK_PATTERN_ID-38-1417645713412] - Starting Push to Service-Now...
<2014-12-04 06:28:37,487> [DEBUG] [AdHoc:AD_HOC_TASK_PATTERN_ID-38-1417645713412] - [Push_to_SN logger] [DiscoveryMain] Service-Now URL: <https://xxxxx.service-now.com:443>, using proxy <x.x.x.x:8080>
<2014-12-04 06:28:37,487> [DEBUG] [AdHoc:AD_HOC_TASK_PATTERN_ID-38-1417645713412] - [Push_to_SN logger] ****************************************************************
<2014-12-04 06:28:37,487> [DEBUG] [AdHoc:AD_HOC_TASK_PATTERN_ID-38-1417645713412] - [Push_to_SN logger] ************************* addResult ****************************
<2014-12-04 06:28:37,487> [DEBUG] [AdHoc:AD_HOC_TASK_PATTERN_ID-38-1417645713412] - [Push_to_SN logger] <?xml version="1.0" encoding="UTF-8"?>
<Object mode="" name="cmdb_ci_win_server" operation="add" mamId="fc5455b1751f6663b6607c930ca43c86" id="UCMDB%0Ant%0A1%0Ainternal_id%3DSTRING%3Dfc5455b1751f6663b6607c930ca43c86%0A">
<field name="virtual" key="false" datatype="boolean" length="">true</field>
<field name="category" key="false" datatype="String" length="">windows</field>
<field name="correlation_id" key="false" datatype="String" length="">fc5455b1751f6663b6607c930ca43c86</field>
<field name="model_number" key="false" datatype="String" length="">VMware Virtual Platform</field>
<field name="name" key="false" datatype="String" length="">xxxxx</field>
<field name="os" key="false" datatype="String" length="">Windows 2008 R2</field>
<links />


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.