SXPG_COMMAND_EXECUTE failed... (DB13)

[Former Member]

Hello,

This is a SAP distributed system with one SAP dialog instance.

We are facing some problems when we add/run an activity (job) in DB13 tcode.

When we run a Check and update optimizer statistics activity in DB13, it show the following error (the same for other type of activity, like CheckDB):

Job started
Step 001 started (program RSDBAJOB, variant &0000000000006, user ID ADMINSAP)
Execução do comando lógico BRCONNECT No host liszgpora001
Parâmetros: -jid STATS20130320200000 -u / -c -f stats -t ALL
SXPG_STEP_XPG_START: is_local_host: rc = 403
SXPG_STEP_XPG_START: host = liszgpora001
SXPG_STEP_XPG_START: is_local_r3_host: rc = 802
SXPG_STEP_XPG_START: RFC_TCPIP_CONNECTION_OPEN: rc = 1003
SXPG_STEP_COMMAND_START: SXPG_STEP_XPG_START returned: 1.003
SXPG_COMMAND_EXECUTE(LONG)
<timestamp> = 20131009200121
COMMANDNAME = BRCONNECT
ADDITIONAL_PARAMETERS = -jid STATS20130320200000 -u / -c -f stats -t ALL
LONG_PARAMS
OPERATINGSYSTEM = ANYOS
TARGETSYSTEM = liszgpora001
DESTINATION
SY-SUBRC = 1003
SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: program_start_error: For More Information, See SYS

I checked the SM37 for DB job (DBA:UPDATESTATS_____@121311/5000) and I see in there an error... the same error.

I searched for a solution and I found the following SAP notes:
1914589 - SXPG_COMMAND_EXECUTE failed when start job from DB13/DBACOCKPIT

446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13

I read them, but sincerely I didn't understand some of the instructions/information described in that sap notes. I also found some threads in SDN forums:
http://scn.sap.com/thread/2155624
http://scn.sap.com/thread/2129398

For instance: I see in central instance if there exist the RFC --> SAPXPG_DBDEST_<SAPDBHOST> - and yes, there is the RFC SAPXPG_DBDEST_LISZGPORA001, I made a conection test and everything is OK! I also checked the same RFC but in dialog instance, there is the same RFC - SAPXPG_DBDEST_LISZGPORA001 but when I done a connection test it show me an error:

Connection Error

Error when opening an RFC connection (CPIC-CALL: 'ThSAPOCMINIT' : cmRc=27 thRc=2

ERROR: timeout during allocate

LOCATION: SAP-Gateway on host liszgpsap003.zagope.pt / sapgw01

DETAIL: no connect of TP /usr/sap/AZP/DVEBMGS00/exe/sapxpg from host liszgpsap

COMPONENT: SAP-Gateway

COUNTER: 18059

MODULE: gwr3cpic.c

LINE: 2025

RETURN CODE: 242

SUBRC: 0

RELEASE: 720

TIME: Fri Oct 11 15:32:37 2013

VERSION: 2

I don´t know if this is the cause for this error... and if this RFC in dialog instance is suppose to be work for this can run the jobs for DB!
I don´t know...

Please, can you help me!?

Kind regards,
samid

[Former Member]

Hi,

Have you checked this SAP Note 446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13. It seems your RFC is not working.

And also, check sxpg rfc  is pointing towards phyical host instead of virtual host.

BR,

Prabhakar