Executing GRLoader from a remote system

[Anon Anon]

Hi,

 

  I am trying to execute GRLoader remotely ,But i am getting the following error

 

11:56:51.578 CI and Relationship Loader for CA Service Desk Manager R12.9.000

nested exception is:

        java.net.ConnectException: Connection timed out

Unable to signon.

11:57:55.131 GRLoader ended

 

With the same credentials locally[from the server where ServiceDesk is running] its executing and updating the CI's.

 

Will this be a firewall problem,If its a firewall issue which ports all needs to be opened ?

 

The syntax i am using is

 

java -Xmx512M -cp <path>/java/lib -jar <path>/java/lib/GRLoader.jar -N <rootpath> -u <uname> -p <pwd>  -s http://<ip> -E -n -a -i <xmlfile>

[Anon Anon]

Hi Chandarvr,

 

Did you perform the below steps prior running the command:

 

1.    Verify that the Java Runtime Environment (JRE) version 6.0 or higher is installed and available.

 

2.    Copy the contents of the %NX_ROOT%\java\lib directory from the CA CMDB system to a directory on the remote system where you want to run it. This remote directory is called %ROOT%.

 

Note: In the above step, copy the contents from a SDM 12.7 machine

 

3.    Create a file called NX.ENV in the %ROOT% directory:

 

@NX_LOG=path_which_will_contain log files

 

4.    Create directory %ROOT%\site\cfg

 

5.    Create directory %ROOT%\log

 

If no, perform the above steps and run the command to see if it works.

 

Thanks,

Naveen

[Corb]

Naveen, thanks for this and I hope to try this soon.  I did have a question about the java switch "-Xmx512M ".  Is that the host name of the server connecting to?  This switch is a mystery to me.  Also, is there any documentation around the grloader for java?

[Anon Anon]

Hi Corb,

 

%ROOT% is the fully qualified path containing the files that were copied in Step 2. Below is the syntax:

java -Xmx512M -cp %ROOT% -jar %ROOT%/GRLoader.jar -N %ROOT% -u [userid] –s [server] -i [other GRLoader options] 

Thanks,

Naveen

[Simon Ellis]

Hi Guys,

 

I am also seeing this when trying to run GRLoader remotely....  I get displayed to screen....

 

16:04:23.731 CI and Relationship Loader for CA Service Desk Manager R12.7.000

nested exception is:

        java.net.ConnectException: Connection timed out: connect

Unable to signon.

16:04:45.822 GRLoader ended

 

and my log file shows....

 

04/14 16:04:23.759 INFO  GRLoader 485 ===============================================================================

04/14 16:04:23.762 INFO  GRLoader 486 GRLoader Started - load from xml file(GRLoaderServer1.xml) - to CMDB - CI Updates allowed / inserts not allowed

04/14 16:04:23.762 INFO  GRLoader 502 ===============================================================================

04/14 16:04:45.816 ERROR GRLoader 306  nested exception is:

    java.net.ConnectException: Connection timed out: connect

[Anon Anon]

Hi Gizmo1969,

 

Did you use the credentials correctly in the grloader command? Ensure that the username is case sensitive.

 

Thanks,

Naveen

[Simon Ellis]

Hi Naveen,

 

Yep did that, tried a couple of accounts and get the same error message

 

Regards

[Simon Ellis]

If i run the script from the secondary server I get the following errors....

 

04/15 12:10:15.038 INFO  GRLoader 485 ===============================================================================

04/15 12:10:15.038 INFO  GRLoader 486 GRLoader Started - load from xml file(GRLoaderServer1.xml) - to CMDB - CI Updates allowed / inserts not allowed

04/15 12:10:15.038 INFO  GRLoader 502 ===============================================================================

04/15 12:10:17.581 ERROR grDataMgr 1561 AHD03300:This operation requires Function Access for admin equal to View or Modify

.........

.........

04/15 12:12:17.795 ERROR grDataMgr 1561 AHD03300:This operation requires Function Access for admin equal to View or Modify

04/15 12:12:18.013 WARN  grDataMgr 2281 cmdb_get_cmdb_version not available, Reason:AHD03300:This operation requires Function Access for admin equal to View or Modify

04/15 12:12:18.013 ERROR GRLoader 550 Unable to determine cmdbversion.  assuming 11.0.0

04/15 12:12:18.232 WARN  grDataMgr 2341 cmdb_get_env variable NX_DISABLE_MDR_BASED_RECONCILIATION not available, Reason: AHD03300:This operation requires Function Access for admin equal to View or Modify

04/15 12:12:18.528 WARN  grDataMgr 2341 cmdb_get_env variable NX_MULTI_TENANCY not available, Reason: AHD03300:This operation requires Function Access for admin equal to View or Modify

04/15 12:12:18.528 INFO  grDataMgr 208 Multi-tenancy is enabled and set to null

04/15 12:12:19.027 INFO  grDataMgr 226 grDataMgr2000 Default tenant is set to XXXXXXXXXXXXX

04/15 12:12:19.261 INFO  grReader 188 Processing Configuration Items

04/15 12:12:19.480 WARN  grDataMgr 2341 cmdb_get_env variable NX_CMDB_MODEL_CLASS_INCONSISTENCY not available, Reason: AHD03300:This operation requires Function Access for admin equal to View or Modify

04/15 12:12:19.932 ERROR grDataMgr 773 checkCIExists WebService error while checking if CI Exists(,,VMWARE-56 4D 5F 06 5C C5 6B F9-59 D0 D8 9F 17 0E 56 07,,,,*********). Exception in checkCIexists: (no additional information available)

04/15 12:12:19.995 INFO  grReader 188 Processing Relationships

04/15 12:12:20.229 INFO  GRLoader 296  

04/15 12:12:20.229 INFO  GRLoader 296 Results:

04/15 12:12:20.229 INFO  GRLoader 296                Read   Skipped   Inserts   Updates    Errors  Warnings

04/15 12:12:20.229 INFO  GRLoader 296 CI                1         0         0         0         1         0

04/15 12:12:20.229 INFO  GRLoader 296 Relation          0         0         0         0         0         0

04/15 12:12:20.229 INFO  GRLoader 296 

04/15 12:12:20.229 INFO  GRLoader 849 ===============================================================================

04/15 12:12:20.229 INFO  GRLoader 296 GRLoader completed with errors.

04/15 12:12:20.229 INFO  GRLoader 851 ===============================================================================

 

The account has the rights to create/modify CI's

[Gordon Preston]

Check the Access Type you are using. In the Role tab check that you have a role with sufficient privileges in both  SOAP Web Service API Role  and Command Line Utility Role.

 

Regards,

Gordon.

[Simon Ellis]

Hi Gordon,

 

Checked that, i'm using the main administrator account at present and that has super access....

 

Regards,

Gizmo

[Michael Mueller]

I am wondering about the connection timeout, and my impression is, that there may be two challenges: getting connection and having correct access rights. First lets take a look at the connection:

Are you able to access the CA SDM webservice WSDL from your remote box using a browser?

Use the follwing URL:

http://<ip>:8080/axis/services/USD_R11_WebService?wsdl

If so, are there any proxy settings in your browser?

If so, does your java environment uses the same settings?

The value of -s parameter of GRLoader has to include the portnumber, which is normaly 8080.

That said, yes, port 8080 must be open!

Kind regards

...............Michael

[Simon Ellis]

Web services are working fine, a local GR Loader run from the server itself has no issue, works fine.

[Simon Ellis]

If i run the GR Loader locally on the server as my account (Admin) it works fine, the CI is update accordingly.  If i run it against the service account setup specifically to execute it I get an error.

 

?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<GRLoader>

    <ci>

        <!--ERROR: Unable to locate ID (null)-->

        <name>HLZ1IR17</name>

 

Why can't it locate the ID, the credentials the account has can login browse to the CI and manually update it.

[Simon Ellis]

The Access Type of the account i'm trying to get to work with GR Load is called CMDB Administrator.  This account has high level access to be able to do what it wants with CI's when going in through the front end.

 

If on the Access Type for the CMDB Administrator i change the Web Service and API Role on the Roles tab from Configuration Administrator to Administrator I have no problem running the GR Loader either locally or remotely from another server within the same domain.

 

Is there anything specific within the Functional Access blocking usage of GR Loader or is there black box stuff that only allows Administrator to run it?