Executing grloader from a Process Automation process results in a Non-null exit code

book

Article ID: 109525

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Consider an example grloader syntax that works perfectly via a command line:
 
java -Xmx512M -cp "%JAVA_HOME%\lib" -jar D:\GRLoader\lib\GRLoader.jar -N D:\GRLoader\ -cfg D:\GRLoader\site\cfg\ sqlserverdb.cfg -u servicedesk -p password -E -s http://SDMHostName:8080/ -dbstmt "SELECT * FROM z_ci_list" -lttwa" 

Let's pass this same through PAM 

<Please see attached file for image>

User-added image
 



When the above PAM process executes, it results in an error:  Non-null exit code

<Please see attached file for image>

User-added image

Grloader log has an error too:
 
08/01 10:31:19.545 ERROR grCIRelationPending 179 grCIRelationPending2000 The system cannot find the path specified 
08/01 10:31:19.547 ERROR GRLoader 1161 java.lang.NullPointerException 
java.lang.NullPointerException 
at com.ca.CMDB.GRLoader.grCIRelationPending.createPendingRelationshipFile(grCIRelationPending.java:183) 
at com.ca.CMDB.GRLoader.grCIRelationPending.<init>(grCIRelationPending.java:76) 
at com.ca.CMDB.GRLoader.grGenericRdr.<init>(grGenericRdr.java:118) 
at com.ca.CMDB.GRLoader.grJDBCrdr.<init>(grJDBCrdr.java:85) 
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 
 

Environment

Release:
Component: ITPAM

Resolution

The error happens because of missing User ID and Password fields in the Run Script operator definition screen.

Provide a valid username and password for a user that can access the file structure D:\grloader\grloader as well as be able to create temporary files during the runtime of the grloader process. Once this is done, save the PAM process and test it again.

Attachments

1558698192973000109525_sktwi1f5rjvs16j8t.jpeg get_app
1558698185627000109525_sktwi1f5rjvs16j8s.jpeg get_app