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,

[narukurti]

It seems it is not exactly the path problem, as your RFC is working and your DB13 is able to call the RFC. Please go through trace file dev_rd and post the exact log. it is available in

/usr/sap/<SID>/<instance>/work directory.

[Former Member]

There are any error in the file...

Only, appear error in dev_w*

M Thu Sep 11 08:53:09 2014

M

M  *****************************************************************************

M  *

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

M  *  ERROR       timeout during allocate

M  *

M  *  TIME        Thu Sep 11 08:53:09 2014

M  *  RELEASE     721

M  *  COMPONENT   SAP-Gateway

M  *  VERSION     2

M  *  RC          242

M  *  MODULE      gwr3cpic.c

M  *  LINE        2164

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

M  *  COUNTER     16712

M  *

M  *****************************************************************************

M

A  RFC 1714  CONVID 39909296

A   * CMRC=27 DATA=0 STATUS=0 SAPRC=242 ThSAPOCMINIT

A  RFC> ABAP Programm: SAPLCRFC (Transaction: )

A  RFC> User: SOTHIS (Client: 100)

A  RFC> Destination: %_TCPIP_%1 (handle: 1, DtConId: 54116C5B464863A1E1000000C0A8018E, DtConCnt: 0, ConvId: ,)

A  *** ERROR => RFC ======> CPIC-CALL: 'ThSAPOCMINIT' : cmRc=27 thRc=242

Timeout al intentar establecer una comunicación (¿ interlocutor ok ?)

[abrfcio.c    9213]

A  {root-id=80144F66D7721ED48EB007B73F235E38}_{conn-id=00000000000000000000000000000000}_0

A  *** ERROR => RFC Error RFCIO_ERROR_SYSERROR in abrfcpic.c : 1730

CPIC-CALL: 'ThSAPOCMINIT' : cmRc=27 thRc=242

Timeout al intentar establecer una comunicación (¿ interlocutor ok ?)

DEST =%_TCPIP_%1

HOST =adonisdb

PROG =sapxpg

[abrfcio.c    9213]

A  {root-id=80144F66D7721ED48EB007B73F235E38}_{conn-id=00000000000000000000000000000000}_0

L  EXTERNAL COMMAND: rc = Error 1003

L  EXTERNAL COMMAND: SAPLSSXP LSSXPF01 FORM WRITE_CALLSTACK

L  EXTERNAL COMMAND: SAPLSSXP LSSXPF01 FORM SYSLOG_COM_EXEC

L  EXTERNAL COMMAND: SAPLSSXP LSSXPU01 FUNCTION SXPG_STEP_XPG_START

L  EXTERNAL COMMAND: SAPLSSXP LSSXPU03 FUNCTION SXPG_STEP_COMMAND_START

L  EXTERNAL COMMAND: SAPLSXPT LSXPTU02 FUNCTION SXPG_COMMAND_EXECUTE_LONG

L  EXTERNAL COMMAND: SAPLSXPT LSXPTU03 FUNCTION SXPG_COMMAND_EXECUTE

L  EXTERNAL COMMAND: RSDBAJOB RSJOBF01 FORM EXEC_ACTION

L  EXTERNAL COMMAND: RSDBAJOB RSJOBE01 EVENT START-OF-SELECTION

L  SXPG_COMMAND_EXECUTE(LONG):

L  <timestamp>: 20140911085309

L  COMMANDNAME: BRCONNECT

L  ADDITIONAL_PARAMETERS: -u / -jid CHECK20140911085248 -c -f check

L  LONG_PARAMS:

L  OPERATINGSYSTEM: ANYOS

L  TARGETSYSTEM: adonisdb

L  DESTINATION:

L  SY-SUBRC: 1003

[alwina_enns]

Hello Victor,

did you check already the note:

446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13

probably also the note can be helpful:

1363610 - External commands: System log message LC2

Regards,
Alwina

[narukurti]

Dear Victor,

It seems, your problem is related to shell profile. When remote shell is used from app server,the shell profile is executed (it is .cshrc in c shell) first. Your shell profile should be like this.

# @(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ind/ind/SAPSRC.CSH#1 $ SAP

# necessary to get hostname without domain (AIX, OS/390 and NOT sun)

switch (`uname`)

   case AIX*:

       alias hostname 'hostname -s'

   breaksw

   case OS/390*:

       setenv _BPXK_AUTOCVT ON

       setenv _TAG_REDIR_IN TXT

       set    _TAG_REDIR_IN=TXT

       setenv _TAG_REDIR_OUT TXT

       set    _TAG_REDIR_OUT=TXT

       setenv _TAG_REDIR_ERR TXT

       set    _TAG_REDIR_ERR=TXT

       alias hostname 'hostname -s'

   breaksw

endsw

# SAP environment

if ( -e $HOME/.sapenv_`hostname`.csh ) then

   source $HOME/.sapenv_`hostname`.csh

else if ( -e $HOME/.sapenv.csh ) then

   source $HOME/.sapenv.csh

endif

# APO environment

if ( -e $HOME/.apoenv_`hostname`.csh ) then

   source $HOME/.apoenv_`hostname`.csh

endif

# LiveCache environment

if ( -e $HOME/.lcenv_`hostname`.csh ) then

   source $HOME/.lcenv_`hostname`.csh

else if ( -e $HOME/.lcenv.csh ) then

   source $HOME/.lcenv.csh

endif

# JAVA environment

if ( -e $HOME/.j2eeenv_`hostname`.csh ) then

   source $HOME/.j2eeenv_`hostname`.csh

else if ( -e $HOME/.j2eeenv.csh ) then

   source $HOME/.j2eeenv.csh

endif

# XI environment

if ( -e $HOME/.xienv_`hostname`.csh ) then

   source $HOME/.xienv_`hostname`.csh

else if ( -e $HOME/.xienv.csh ) then

   source $HOME/.xienv.csh

endif

# RDBMS environment

# @(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ind/ind/DBSRC.CSH#1 $ SAP

if ( -e $HOME/.dbenv_`hostname`.csh ) then

   source $HOME/.dbenv_`hostname`.csh

else if ( -e $HOME/.dbenv.csh ) then

   source $HOME/.dbenv.csh

endif

It will set the environment variables for the execution of sapxpg and brtools.

As you are telling that sapxpg and brtools are executed from anywhere in DB server,it should be the problem with shell profile, because .login profile is used when you log into the DB server directly. Shell profile is used , when you try to execute the program through remote shell. copy the .login profile to .cshrc( in case of c shell) file, of course after taking backup of shell profile file.It will solve your problem.

[Former Member]

I have the same in .login and in .cshrc

Both files are in the home of the user.

Regards,

[narukurti]

1.Are you using csh?

2. if yes, check the file content of .cshrc as mentioned above