SXPG_COMMAND_EXECUTE failed for BRTOOLS

[Former Member]

Hi experts,

I have my SAP ECC in a distributed system (CI and DB nodes are different) on Oracle 11G/ Solaris.

When I try to execute any action in db13, appear the following error:

SXPG_COMMAND_EXECUTE failed for BRTOOLS - Reason: program_start_error: For More Information, See SYS

I follow the SAP Note:  1974030 - How to configure DB13 to work with a standalone Oracle database in Unix/Linux

but I continue with the error

The RFC SAPXPG_DBDEST_HOSTDB works fine but I check in the trace of the proccess is:

LOCATION    SAP-Gateway on host adonis.blumaq.local / sapgw00

ERROR       timeout during allocate

TIME        Tue Sep  9 12:47:24 2014

RELEASE     721

COMPONENT   SAP-Gateway

VERSION     2

RC          242

MODULE      gwr3cpic.c

LINE        2164

DETAIL      no connect of TP sapxpg from host adonisdb after 20 sec

COUNTER     6595

Any idea?

Thanks in advance,

Regards,

[Reagan]

As you have a distributed setup you need to either setup a standalone gateway in the DB node as suggested here or try the recommendation given in this thread

Additionally check the SAP notes mentioned in the second thread.

Regards

RB

[Former Member]

By this note 1974030 - How to configure DB13 to work with a standalone Oracle database in Unix/Linux  it is not necessary a gateway in Unix

[alwina_enns]

Hello Victor,

in this case are you using rsh or ssh to start sapxpg on the database host? Have you already checked, if you are able to reach sapxpg program on OS level by executing the command

rsh <database host> -l <sid>adm sapxpg


as described in this note? Could you please share a screenshot about configuration of the destination in SM59?

Regards,
Alwina

[Former Member]

Hi,

The command work is:

rsh <database host> -l <sid>adm /sapmnt/BLP/exe/sapxpg

[alwina_enns]

Hello Victor,

and how the parameter gw/remsh is set, could you please check also this section in the note "10403 - Starting external programs":

" c) If the remote shell in your computer is not called remsh

      (if you

use a Unix 5.4 system, for example),

      you must set the gateway parameter

gw/remsh to the correct name

      (which is normally "rsh" in such

cases).  You may have to use the

      complete path name.  To check whether

the remote shell is found,

      use the Unix command "which remsh" or "which

rsh" under the

      gateway identifier."

Regards,
Alwina

[Former Member]

The parameter is  /bin/rsh

It is ok...

[alwina_enns]

and to which value gw/rem_start is set?

[alwina_enns]

on our Linux server this is /usr/bin/rsh , could you please double check?

[Former Member]

My system is Solaris; and it is there

[Former Member]

REMOTE_SHELL

[alwina_enns]

and under which user you have started

rsh <database host> -l <sid>adm /sapmnt/BLP/exe/sapxpg

on OS level, is this the same user, under which gateway is running?

[Former Member]

I start with the user blpadm the same user on dbhost.

I have not installed gateway,,, in this note: 1974030 - How to configure DB13 to work with a standalone Oracle database in Unix/Linux   say it is not necessary.

[alwina_enns]

yes, it should work also without a standalone gateway on DB host. A gateway of an instance in your system will start rsh locally to execute sapxpg on the database server. In SM59 for the destination if you define gateway host and gateway service for the gateway of the instance, for which you have set gw/rem_start and gw/remsh, will it work?

[Former Member]

I think is a problem with the PATH.

If I execute:

rsh <database host> -l <sid>adm /sapmnt/BLP/exe/sapxpg

works fine

If I execute:

rsh <database host> -l <sid>adm sapxpg

does not work

How can change the path of the rsh?

Thanks in advance,

Regards,

[divyanshu_srivastava3]

add this value(full path) in your env variable PATH for sidadm and orasid.

This will work from anywhere

[alwina_enns]

but the path /sapmnt/BLP/exe/sapxpg is already defined in the destination as per your screenshot, I would try to define the gateway host and gateway service in the destination of the local instance. Usually the local gateway should be choosen automatically, but just try it

[Former Member]

I have it in both users, but If I execute

rsh adonisdb -l blpadm "/usr/bin/echo my path is \$PATH" the result is "my path is /usr/bin:"

I think the PATH have to configure in other side.

[Former Member]

I did it, and works fine the RFC but not the db13.

I think is the PATH os rsh

[alwina_enns]

do you still get the same error "timeout during allocate" or has the error changed? How many instances has the system and from which instance you call DB13?

[Former Member]

Yes, same problem...

Only 1 instance in each host