Question Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS in Technology Q&A

SXPG_COMMAND_EXECUTE failed for BRTOOLS

Former Member — Tue, 09 Sep 2014 11:03:35 GMT

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,

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

divyanshu_srivastava3 — Tue, 09 Sep 2014 11:42:40 GMT

Hi Victor,

Is your system configured correctly for Distributed setup ?

Are the GID and UID same for users on both hosts ?

Refer - 980266 - RFC destination SAPXPG_DBDEST_<DB-HOST> does not work

Regards,

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

Reagan — Tue, 09 Sep 2014 11:50:36 GMT

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

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

narukurti — Tue, 09 Sep 2014 11:53:57 GMT

1) Please be sure whether the executable sapxpg is located at /sapmnt/SID/exe/sapxpg or not?

2) check SAPXPG_DBDEST_HOSTDB from the application server, from which you are invoking BRTOOLS.

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

divyanshu_srivastava3 — Tue, 09 Sep 2014 12:03:04 GMT

Also, have a look at 1891781 - error occurs when you execute an external command

Regards,

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

Former Member — Tue, 09 Sep 2014 12:21:02 GMT

Yes, the system is configured correctly, more than 5 years working without problems; except the db13.

Users have the same GID and UID.

The RFC SAPXPG_DBDEST_<DB-HOST> works fine

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

Former Member — Tue, 09 Sep 2014 12:22:11 GMT

1) yes

2) works fine

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

Former Member — Tue, 09 Sep 2014 12:22:43 GMT

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

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

alwina_enns — Tue, 09 Sep 2014 12:33:45 GMT

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

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

Former Member — Tue, 09 Sep 2014 13:35:10 GMT

Hi,

The command work is:

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

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

alwina_enns — Tue, 09 Sep 2014 13:45:10 GMT

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

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

Former Member — Tue, 09 Sep 2014 13:51:06 GMT

The parameter is /bin/rsh

It is ok...

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

alwina_enns — Tue, 09 Sep 2014 13:52:15 GMT

and to which value gw/rem_start is set?

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

alwina_enns — Tue, 09 Sep 2014 13:53:34 GMT

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

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

Former Member — Tue, 09 Sep 2014 13:53:45 GMT

My system is Solaris; and it is there

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

Former Member — Tue, 09 Sep 2014 13:53:53 GMT

REMOTE_SHELL

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

alwina_enns — Tue, 09 Sep 2014 14:00:54 GMT

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?

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

Former Member — Tue, 09 Sep 2014 14:03:19 GMT

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.

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

alwina_enns — Tue, 09 Sep 2014 14:49:05 GMT

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?

Re: SXPG_COMMAND_EXECUTE failed for BRTOOLS

Former Member — Tue, 09 Sep 2014 15:33:30 GMT

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,