CA Service Management

Expand all | Collapse all

Executing GRLoader from a remote system

  • 1.  Executing GRLoader from a remote system

    Posted 11-03-2014 07:17 AM

    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>



  • 2.  Re: Executing GRLoader from a remote system

    Posted 11-03-2014 07:43 PM

    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



  • 3.  Re: Executing GRLoader from a remote system

    Posted 02-23-2015 04:18 PM

    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?



  • 4.  Re: Executing GRLoader from a remote system

    Posted 02-24-2015 11:55 PM

    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



  • 5.  Re: Executing GRLoader from a remote system

    Posted 04-14-2015 12:10 AM

    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



  • 6.  Re: Executing GRLoader from a remote system

    Posted 04-14-2015 12:12 AM

    Hi Gizmo1969,

     

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

     

    Thanks,

    Naveen



  • 7.  Re: Executing GRLoader from a remote system

    Posted 04-14-2015 04:29 PM

    Hi Naveen,

     

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

     

    Regards



  • 8.  Re: Executing GRLoader from a remote system

    Posted 04-14-2015 08:50 PM

    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



  • 9.  Re: Executing GRLoader from a remote system

    Posted 04-15-2015 01:45 AM

    Check the Access Type you are using. In the Role tab check that you have a role with sufficient privileges in both 

     



  • 10.  Re: Executing GRLoader from a remote system

    Posted 04-15-2015 05:23 PM

    Hi Gordon,

     

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

     

    Regards,

    Gizmo



  • 11.  Re: Executing GRLoader from a remote system

    Posted 04-15-2015 05:55 AM

    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



  • 12.  Re: Executing GRLoader from a remote system

    Posted 04-15-2015 05:24 PM

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



  • 13.  Re: Executing GRLoader from a remote system

    Posted 04-19-2015 05:05 PM

    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.



  • 14.  Re: Executing GRLoader from a remote system

    Posted 04-19-2015 11:37 PM

    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?