Problem with UCMDB to ServiceNow push adapter

I have tried to set up an integration of Windows CI using the out-of-the-box Service-Now Push adapter.

 

ServiceNow is accessed via https over proxy and I have checked that I have access from the data flow probe server I am using for the integration.

 

The additional classpath is added according to instructions. My query returns 258 CI´s and my mapping file have the same name as the query according to the instructions and I have also tried with the sample query/mapping.

 

A test run gives the error message pasted below.

 

 

<2014-08-22 13:33:55,433> [ERROR] [AdHoc:AD_HOC_TASK_PATTERN_ID-81-1408707266802] (ExecutionEngineImpl.java:400) - Failed execute ad hoc script: Traceback (most recent call last):
  File "<string>", line 2, in <module>
  File "pushToServiceNow", line 736, in DiscoveryMain
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)

	at org.python.core.PyReflectedConstructor.constructProxy(PyReflectedConstructor.java:210)


java.lang.Exception: java.lang.Exception: [DiscoveryMain] [processCIs] [processCIs:add] Error connecting to Service-Now while processing CIT <cmdb_ci_win_server>

<2014-08-22 13:33:55,434> [ERROR] [AdHoc:AD_HOC_TASK_PATTERN_ID-81-1408707266802] (AbstractProbeProcessor.java:62) - Failed executing probe request [com.hp.ucmdb.discovery.probe.request.GenericPushProbeRequest] for integration [ServiceNow push test]

 

Does anybody have an idea what could be wrong?

 

Kind regards,

Malin

Parents
  • Hi Malin,

     

    I have successfully integrated uCMDB 9.05, CUP 14 with Service Now Calgary.

     

    Here are a few things I'm curious about which might lead us to the solution to your problem:

    1: May I know what version of uCMDB you are on ?

     

    2: I have seen this error pop up when we did not set our proxy correctly and because of wrong previleges to write to the S-Now CMDB. So, please check on Proxy Server port and Proxy Server Name/IP.

     

    3: Are you using Direct web services that came out of the box ?

     

    Thanks,

    Praveen

  • Hi Praveen,
    1: We are on 10.11.224, content pack 14.0.168
    2: I have double checked proxy settings.
    3: We are using the adapter out-of-the box.
    Kind regards,
    Malin

     


    wrote:

    Hi Malin,

     

    I have successfully integrated uCMDB 9.05, CUP 14 with Service Now Calgary.

     

    Here are a few things I'm curious about which might lead us to the solution to your problem:

    1: May I know what version of uCMDB you are on ?

     

    2: I have seen this error pop up when we did not set our proxy correctly and because of wrong previleges to write to the S-Now CMDB. So, please check on Proxy Server port and Proxy Server Name/IP.

     

    3: Are you using Direct web services that came out of the box ?

     

    Thanks,

    Praveen


     

  • BTW forgot to mention - i am using admin id so i have full access on SNOW side.

     

    Do i need to configure in service Now for ucmdb credentials as well ?

     

    I saw your this link and share with ServiceNow as well. please share some insight

    http://h30499.www3.hp.com/t5/CMS-and-Discovery-Support-and/Creating-XML-mapping-files-for-Integration-between-ServiceNow/td-p/6255663#.VJzxxxApI 

     

    Thanks

  • Thanks issue is resolved. I figured out that with OTB nothing but had to modify query

     

    Thanks

    Sushil

  • could you please let us know what has been changed for the Query side.

  • Hi,

     

    Please make sure that your Ci attributes are selected in properties option to be pushed to SNOW. 

    By default it's unchecked so it won't work until you manually select which attribute want to be push OR select All

     

    Let me know if any question further

     

    Thanks

    Sushil

  • Hi All,

     

    we tring to do ucmdb to servicenow push and cis are going to servicenow Sucessfully  but we have issue with pushuing relationship 

     

    could you please help in this 

     

    Thanks 

    Rashmi Hegde

    rashmi.hegde-s@hpe.com

  • hi, Rashmi

    were you able to push relationship successfully? Thanks

  •  

    Hi All,

     

    we tring to do ucmdb to servicenow push and cis are going to servicenow Sucessfully  but we have issue with relationship push.

     We have checked the logs and we are getting error as:

    Ignoring RTN with parent-child (id)  because ServiceNow couldn't locate the corresponding sys_id values for UCMDB-serviceNow Push

    Priyanka

  • Hi Priyanka

    we need to see the relationship mapping in xml that you made, log file error in uCMDB and service now.

    was there any change in probe server that you are using for push data?

    Thanks

    Sushil

  • Hi Sushil,

    Please find relationship mapping

    <target_entities>
    <source_instance query-name="ServiceNow_ADMPush_Relations" root-element-name="Root_BusinessApplicationEnvironment">
    <target_entity name="service_now_rel_table>
    <target_mapping datatype="STRING" name="type" value="'contains :: contained by'"/>
    <target_mapping datatype="STRING" name="parent" value="Root_BusinessApplicationEnvironment.BusinessApplication[0]['global_id']"/>
    <target_mapping datatype="STRING" name="child" value="Root_BusinessApplicationEnvironment.BusinessApplicationEnvironment[0]['global_id']"/>
    </target_entity>
    </source_instance>

    </target_entities>

    We have successfully   pushed Linux->Interface->IPAddress relationship.But, We are getting error while pushing ADM(Application Dependency Mapping) relationship.

    In UCMDB side ,we are getting below errors in log:

    Ignoring RTN with parent-child = BA<GlobalID>-BAE<GlobalId> because ServiceNow couldn't locate the corresponding sys_id values.

    ServiceNow logs not getting any error.

    We have not made any changes to probe server.

     

    Thanks

    Priyanka

  • did you check with Service now engg or support?

Reply Children