loadnrun

[Junel Garcia]

Hi!

I'm learning about loadnrun, and I have several questions regarding it.

1. Do I have to configure all these three before I can proceed with loadNrun?
OR Server ASP .Net Client Gatekeeper2
OR Server Java Client Gatekeeper2
OR Java Client Gatekeeper3

2. How can I set II_W4GLAPPS_DIR = C:\Program Files\Actian\OpenROAD\Loadnrun62\bin? Every time I run
ingsetenv II_W4GLAPPS_DIR C:\Program Files\Actian\OpenROAD\Loadnrun62\bin
I always get this message ingsetenv: too many arguments.

3. Should I have to install loadNrun on where my OR Server is running? Or should it be only installed on the client-side?

4. For testing connection, where should I run the following, on the server-side or the client-side? And what should be the result if there's no problem with the connection?

• comtestrso MachineName/IP
• comtestrso MachineName/IP unauthenticated
• comtestrso
• comtestrso unauthenticated

Thank you!

Regards,

Junel

[Bodo Bergmann]

Hi Junel,

 

Here are some answers to your questions:

 

1. You only have to configure one of them – I recommend to use the Gatekeeper3 (within Tomcat)
2. As your directory path contains spaces you have to include it into double quotes: ingsetenv II_W4GLAPPS_DIR "C:\Program Files\Actian\OpenROAD\Loadnrun62\bin"
3. Some stuff has to be installed on the server, some on the client side.
   See https://docs.actian.com/openroad/11.2/index.html#page/ServerRef/Getting_Started_with_Loadnrun.htm#
4. Test is usually done on the server (not sure if the loadnrun client has a “comtestrso” utility, if yes you can test the connection from there as well).
   Expected output can be found: https://docs.actian.com/openroad/11.2/index.html#page/ServerRef/Set_Up_the_Loadnrun_Server.htm#ww412412
   
   

HTH.

Regards,

Bodo.

 

Bodo Bergmann
Engineering Architect
Actian | OpenROAD Engineering
www.actian.com
GESELLSCHAFTSANGABEN: Actian Germany GmbH | Sitz der Gesellschaft: Halenreie 42, 22359 Hamburg | Geschäftsführung: Stephen Padgett, Marc Monahan | Handelsregister: Amtsgericht Hamburg | HRB 135991 | USt-IdNr: DE252449897

--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/93de9378-14d6-46a1-8392-121cd5d6b49an%40googlegroups.com.

[Junel Garcia]

Hello!
I can't proceed to the next step because I'm having trouble with this.

OpenROAD JSON-RPC Request failed with Error : {"code":-32000,"message":"Server error"}

But the Gatekeeper and JsonRpcServertest work fine.


I hope you could help me with this one too. 
Thank you!

[Junel Garcia]

BTW I'm using OR 6.2 on windows 10.
Thanks...

[Bodo Bergmann]

Junel,

 

The “Server error” indicates that there was some problem with the OpenROAD server.
The Java servlets are running (in Tomcat), but they encounter an error when trying to pass on the request to the OpenROAD Server.
Either the server is not running or there is a configuration error.

 

What is the output of “comtestrso” on the server?
What is the content of the jsonrpcservertest.log file (log file for the server application)?

Do you have a jsonrpcservertest.json file in %II_SYSTEM%\ingres\files\orjsonconfig directory (or in a directory specified by the II_W4GL_JSON_CONFIG environment variable)?

 

As you are using OpenROAD 6.2 you should make sure that you are running the latest patch.

 

Regards,

Bodo.

 

From: openroa...@googlegroups.com <openroa...@googlegroups.com> On Behalf Of Junel Garcia
Sent: Thursday, April 7, 2022 8:16 PM
To: OpenROAD Users Mailing List <openroa...@googlegroups.com>
Subject: Re: [openroad-users] loadnrun

 

Hello!
I can't proceed to the next step because I'm having trouble with this.

OpenROAD JSON-RPC Request failed with Error : {"code":-32000,"message":"Server error"}

But the Gatekeeper and JsonRpcServertest work fine.

To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/b847cc86-281c-4514-829a-93b5e917ee5en%40googlegroups.com.

[Bodo Bergmann]

Another possible problem is a mismatch of Tomcat (i.e. the JVM used) and OpenROAD versions.

What exact OpenROAD version are you using?

If it is a 32-bit version you cannot connect to it from a 64-bit java process (running Tomcat),
as the servlet cannot access the OpenROAD classes (provided in the openroad.jar in connection with the 32-bit orrsojni.dll).

Check the Tomcat log files for any class loading errors.

 

Bodo.

[Junel Garcia]

I am now using OR 6.2 w/ ProductVersion : 6.2.0/15216 p15707  64-bit version and I'm still getting the same error.
Here's the output of comtestrso:

Here's the content of the jsonrpcservertest.log file

 I do have the jsonrpcservertest.json file in %II_SYSTEM%\ingres\files\orjsonconfig directory and I haven't set II_W4GL_JSON_CONFIG environment variable yet.

And which of these files should I check for the error?

[Bodo Bergmann]

The jsonrpcservertest.log file seems to be old – it is from 07-apr-2022.

Its content shows that you were running an older OpenROAD patch (15568).

 

Check the catalina.*.log, tomcat8-stderr*.log , tomcat8-stdout*.log and localhost.*.log files for errors/exceptions.

 

The comtestrso output is fine – no error there.

 

From: openroa...@googlegroups.com <openroa...@googlegroups.com> On Behalf Of Junel Garcia
Sent: Monday, April 11, 2022 9:41 AM
To: OpenROAD Users Mailing List <openroa...@googlegroups.com>
Subject: Re: [openroad-users] loadnrun

 

I am now using OR 6.2 w/ ProductVersion : 6.2.0/15216 p15707  64-bit version and I'm still getting the same error.

Here's the output of comtestrso:

 

Here's the content of the jsonrpcservertest.log file

 I do have the jsonrpcservertest.json file in %II_SYSTEM%\ingres\files\orjsonconfig directory and I haven't set II_W4GL_JSON_CONFIG environment variable yet.

And which of these files should I check for the error?

To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/8ee954bd-5c13-4c33-81b1-c41835f6774en%40googlegroups.com.

[Durwin Wright]

Hello Junel Garcia

 

Please contact durwin...@actian.com regarding this issue.

 

 

Durwin Wright

Senior Software Architect, Engineering

Actian Corporation

durwin...@actian.com

 

PHONE +1 405 844 4714

MOBILE +1 405 531 7881

OFFICE +1 650 587 5523

 

www.actian.com

 

 

 

From: openroa...@googlegroups.com <openroa...@googlegroups.com> On Behalf Of Junel Garcia
Sent: Monday, April 11, 2022 2:41 AM
To: OpenROAD Users Mailing List <openroa...@googlegroups.com>
Subject: Re: [openroad-users] loadnrun

 

I am now using OR 6.2 w/ ProductVersion : 6.2.0/15216 p15707  64-bit version and I'm still getting the same error.

Here's the output of comtestrso:

 

Here's the content of the jsonrpcservertest.log file

 I do have the jsonrpcservertest.json file in %II_SYSTEM%\ingres\files\orjsonconfig directory and I haven't set II_W4GL_JSON_CONFIG environment variable yet.

And which of these files should I check for the error?

To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/8ee954bd-5c13-4c33-81b1-c41835f6774en%40googlegroups.com.