Highlighted
Absent Member.. Absent Member..
Absent Member..
3661 views

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

0 Likes
23 Replies
Highlighted
New Member.

Re: Problem with UCMDB to ServiceNow push adapter

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

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Problem with UCMDB to ServiceNow push adapter

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

 


@Praveen_Shan 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


 

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: Problem with UCMDB to ServiceNow push adapter

HI Praveen

 

Sorry for addng my question here and not as seperate thread.

 

I am new for this integration in past never did third party integrations. I looked into document for adapater. My question is about Jar files, you have mentioned in some other threads (ServiceNow) that you created several jar files (HP doc also mention same but no details). I want to know more clarity on that. I couldn't find any doc explaining how to do that. I saw your post so thought to check with you as you have successfull did this integration.

 

Can you please provide guidence on this.

 

Thanks
Sushil

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: Problem with UCMDB to ServiceNow push adapter

Hi Malin

 

is your issue resolved? I am using same version and CUP and OTB adapter and getting similar error.

Having full permission on SNOW still not able to push the data.

 

please provide suggestion

 

Thanks

Sushil

0 Likes
Highlighted
New Member.

Re: Problem with UCMDB to ServiceNow push adapter

Hi Susheil,

 

Sorry, I missed this post completely.

 

Let me see if I can answer your question about .jar files.

 

1: The OOTB service now push adapter comes with the basic jar files required for the integration. But in our case, we used Scripted Web services to push CI and relationship data from uCMDB to Snow.

 

2: when we implemented scrpited web services, we also had to build custom WSDL's for each CI type. Custom WSDL's would include extra attributes on top of OOB attributes.

 

3: Once the WSDL's were built, we generated the jar files by using Apache Axis 2 software and by following a few steps that were provided by HP. The JAR files contain web service stubs.

 

(The only case in which you will NOT need to regenerate the JAR files is if the structure of your ServiceNow target tables matches the structure in the JAR files that are used by ServiceNow integration in uCMDB.)

 

4:  Once we have all the components, we build the Integration queries and the XML mapping files to match the attribute names on the WSDL's.

 

Let me know if it makes sense.


Thanks,

Praveen

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: Problem with UCMDB to ServiceNow push adapter

 

Hi Praveen

 

Thanks for your detaild response.

 

Yes I spoke with HP and doing the same.

 

I downloaded the https://abc.service-now.com/cmdb_ci_ip_address.do?WSDL and then used the AXIS 2 to create the Jar files.

I started with only node and created the Jar for cmdb_ci_win_server.do?WSDL and pushed the nodes. It created the rows in Service now database but with empty value.

 if i don't recreate the Jar files then i get error as

 

============================================================

java.lang.Exception: 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_ip_address>

============================================================

 

then i did consult support again and they mentioned the way we are doing the jar recreation used to work fine with 9. version.

Now i am waiting from HP to see if this recreation a jar need to be change or something else in this new version UCMDB 10.11 CUP 14

 

Any suggestion would appreciate and once again thanks for reply.

 

Merry Christmas!

 

-Sushil

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: Problem with UCMDB to ServiceNow push adapter

BTW,

in this thread https://community.servicenow.com/thread/163057

you have mentioned about some settings (with importSetUse = 0),

Do i need to make any chnage in jython script or such settings you mentioned above just for OTB push test?

 

THanks

Sushil

0 Likes
Highlighted
New Member.

Re: Problem with UCMDB to ServiceNow push adapter

No, you don't have to change anything on the OOTB Jython script for basic testing.

Change the Debug level to 4 or 5 for more information during testing.

 

Also, everytime you make changes to your WSDL, the .jar files have to be recreated. I haven't tried the jar file creation procedure on 10.xx, but that's a good point to keep in mind.

 

Are you by any chance pushing IP Addresses along with the Windows CIs ? Because the error you posted in your previous reply mentions the IP Address table name.

 

Thanks,

Praveen

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: Problem with UCMDB to ServiceNow push adapter

thanks for the confirmation.

 

First i tried node with IP and that's where the error came.

 but last night i just tried a simple new query node and interface and showed success without any error but all shows EMPTY in service Now. any suggetsion. BTW i saw your another thread where you mentioned that in Service Now we need a temp table to hold the data for decision point of update/delete/add

I am askign Service Now person to see how he can assist me on this. but seeing this log i think i sent the data out sucesfully.. Any thought please..

 

here is success logs-

 

 <2014-12-25 20:15:59,484> 109691198 [INFO ] [AdHoc:AD_HOC_TASK_PATTERN_ID-20-1419570959903] (AdHocProbeRequestOperation.java:55) - Starting execution of Probe operation [GenericPushProbeRequest( updateData )]
jvm 1    | Dec 25, 2014 8:16:04 PM org.apache.wink.client.internal.ResourceImpl createClientRequest
jvm 1    | INFO: Issuing client GET method request to URI at https://WIPDEVAPP01:8443/cm/rest/folders with null entity class and CaseInsensitiveMultivaluedMap [map=[]] headers
jvm 1    | Dec 25, 2014 8:16:04 PM org.apache.wink.client.internal.handlers.AcceptHeaderHandler handle
jvm 1    | INFO: Accept header automatically set to: application/xml,application/octet-stream
jvm 1    | Dec 25, 2014 8:16:04 PM org.apache.wink.client.internal.ResourceImpl createClientRequest
jvm 1    | INFO: Issuing client POST method request to URI at https://WIPDEVAPP01:8443/cm/rest/replication/folders with class [Lcom.hp.sw.bto.ast.security.cm.data.FolderReplicationRequest; entity class and CaseInsensitiveMultivaluedMap [map=[Content-Type=application/octet-stream]] headers
jvm 1    | Dec 25, 2014 8:16:04 PM org.apache.wink.client.internal.handlers.AcceptHeaderHandler handle
jvm 1    | INFO: Accept header automatically set to: application/xml,application/octet-stream
jvm 1    | <2014-12-25 20:16:14,625> 109706339 [INFO ] [AdHoc:AD_HOC_TASK_PATTERN_ID-20-1419570959903] (?:?) - [DiscoveryMain] CIs added <21>, updated <0>, deleted <0>
jvm 1    | <2014-12-25 20:16:14,625> 109706339 [INFO ] [AdHoc:AD_HOC_TASK_PATTERN_ID-20-1419570959903] (?:?) - [DiscoveryMain] Relationships added <11>, updated <0>, deleted <0>
jvm 1    | <2014-12-25 20:16:14,656> 109706370 [INFO ] [AdHoc:AD_HOC_TASK_PATTERN_ID-20-1419570959903] (AdHocProbeRequestOperation.java:69) - Execution of GenericPushProbeRequest:                     ProbeExecution[ requestConstruction = 0.063    processorConstruction = 0.0      adapterRetrieval = 0.0      processorExecution = 15.172   ]
jvm 1    | <2014-12-25 20:16:14,656> 109706370 [INFO ] [GW-AdHoc:AD_HOC_TASK_PATTERN_ID-20-1419570959903] (AdhocThread.java:63) - Sending ad hoc task results to server for request: com.hp.ucmdb.discovery.probe.agents.probemgr.adhoctasks.AdHocProbeRequestOperation calcTime= 15250ms
jvm 1    | Dec 25, 2014 8:17:04 PM org.apache.wink.client.internal.ResourceImpl createClientRequest
jvm 1    | INFO: Issuing client GET method request to URI at https://WIPDEVAPP01:8443/cm/rest/folders with null entity class and CaseInsensitiveMultivaluedMap [map=[]] headers
jvm 1    | Dec 25, 2014 8:17:04 PM org.apache.wink.client.internal.handlers.AcceptHeaderHandler handle
jvm 1    | INFO: Accept header automatically set to: application/xml,application/octet-stream
jvm 1    | Dec 25, 2014 8:17:04 PM org.apache.wink.client.internal.ResourceImpl createClientRequest
jvm 1    | INFO: Issuing client POST method request to URI at https://WIPDEVAPP01:8443/cm/rest/replication/folders with class [Lcom.hp.sw.bto.ast.security.cm.data.FolderReplicationRequest; entity class and CaseInsensitiveMultivaluedMap [map=[Content-Type=application/octet-stream]] headers
jvm 1    | Dec 25, 2014 8:17:04 PM org.apache.wink.client.internal.handlers.AcceptHeaderHandler handle
jvm 1    | INFO: Accept header automatically set to: application/xml,application/octet-stream

 

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: Problem with UCMDB to ServiceNow push adapter

http://wiki.servicenow.com/index.php?title=Direct_Web_Service_API_Functions

in this URL you mentioned two points (seems to me very imprtant and perhaps i am missing that). guessing if this is my issue..

 

2: The scripted web services provide the required response back to the uCMDB for SOAP insert operation(add, update, delete).
3: Import set tables were created to temporarily store the CI and attribute information that were pushed from uCMDB.
Web Service Transform Maps were used to determine if the CI in the Import Set Table is a CMDB add or update operation using Coalesce values.
4: Relationship pushes bypass the import set tables and are directly added from the Service Now CMDB via direct web service calls.

 

I have asked ServiceNow guy to check. do you know what specific SNOW dev did?

 

Thanks

Sushil

 

 

 

0 Likes
Highlighted
New Member.

Re: Problem with UCMDB to ServiceNow push adapter

Hi Susheil,

 

Glad to know that there is progress in your testing.

 

I think you need to look into the credentials you have setup for ucmdb in Service Now and make sure it has the right privileges.

 

Also, it is hard for me to understand what is going on with your env. without knowing the setup. Can you briefly explain what components do you have setup for service now so far ? Also, for error troubleshooting, please post the error.log and ProbeManager Adapter debug logs after testing.

 

Thanks,

Praveen

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.