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

[Reagan · Accepted solution]

As you have distributed set up then read this SAP note

Note 1025707 - DBA Cockpit: Planning calendar and remote Oracle databases

Either you set up a standalone gateway on the DB node or with the help of remote shell.

You can easily fix this problem with the help of these threads.

http://scn.sap.com/thread/3323179

https://scn.sap.com/thread/1642168

http://scn.sap.com/thread/1937412

http://scn.sap.com/thread/2101286

Also check this SAP note

Note 34219 - DB13: CPIC error CM_RESOURCE_FAILURE_RETRY

Good Luck

RB

[Former Member · Accepted solution]

Hello Reagan,

Thank you for the information.

But can you read my last answer to Ashish Vikas, please? I put in there more information about my scenario.

Can you help me to find the solution for this?

regards,

samid

[Reagan · Accepted solution]

They are in different hosts! So, in this case, I need a Gateway installed on this databse host, am I right?

I will only consider this as a valid point in the whole post as the rest are irrelevant.

I already answered your question in my first reply. Here it is once more.

Either you set up a standalone gateway on the DB node or with the help of remote shell.

Regards

RB

[Former Member · Accepted solution]

Hi Reagan,

Yes... sorry!

Let me to put here some information about the RFC SAPXPG_DBDEST__<SAPDBHOST>

In central and dialog instance, in SM59, I change the settings of that RFC, I put the information about database host (liszgpora001😞

The connection test show me the following error:

Connection Error

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

ERROR: Estruturação conexão à porta conv.SAP fracassou (porta conv.SAP inciad

LOCATION: SAP-Server liszgpsap003_AZP_00 on host liszgpsap003 (wp 3)

COMPONENT: CPIC

COUNTER: 615

MODULE:

LINE:

RETURN CODE: 236

SUBRC: 0

RELEASE: 720

TIME: Sun Oct 13 14:34:48 2013

VERSION:

regards,

samid

[Reagan · Accepted solution]

Hello

LOCATION: SAP-Server liszgpsap003_AZP_00 on host liszgpsap003 (wp 3)

Let me clarify this.

liszgpsap003 = CI host with system number 00

liszgpora001 = Oracle DB host

Right ?

I see you are providing gateway host as liszgpora001 and gateway service as sapgw00

Is there a gateway running on host liszgpora001 ?

Regards

RB

[Former Member · Accepted solution]

Hello Reagan,

Let me clarify this.
liszgpsap003 = CI host with system number 00
liszgpora001 = Oracle DB host

Yes, you are right!

I see you are providing gateway host as liszgpora001 and gateway service as sapgw00
Is there a gateway running on host liszgpora001 ?

That´s the point here! 🙂

I believe that I must follow the instructions in sap note 1025707 (DBA Cockpit: Planning calendar and remote Oracle databases) the section "3. Connection through SAP gateway", am I right?

And also check the information in sap note 980266 (RFC destination SAPXPG_DBDEST_<DB-HOST> does not work), right?

Thank you Reagan for your patience 🙂

regards,

samid

[Reagan · Accepted solution]

I believe that I must follow the instructions in sap note 1025707 (DBA Cockpit: Planning calendar and remote Oracle databases) the section "3. Connection through SAP gateway", am I right?
And also check the information in sap note 980266 (RFC destination SAPXPG_DBDEST_<DB-HOST> does not work), right?

You are in the right track now.

Good Luck

RB

[Former Member · Accepted solution]

Hello,

For this, first I need to install a standalone gateway on DB host server. For this activity, I´m reading the following installation guide:

-> service.sap.com/instguides

-> SAP NetWeaver

-> SAP NetWeaver 7.4

-> Installation

-> 3 - Installation - Standalone Engines

-> Installing Gateway for SAP NetWeaver 7.1 or Higher

But now I´m with a doubt regarding which version of SAP Software Provisioning Manager I need to download/run for this installation. My ERP systems are in release ERP 6.0 EHP5 (with NW EHP2 - which means that SAP_BASIS and SAP_ABA components are in 7.02 version).

This is important, because for instance, as you know I need to download the software provisioning manager 1.0 (http://service.sap.com/sltoolset -> Software Logistics Toolset 1.0 -> Software Provisioning Manager) here there are two SWPM  types:

SWPM10SP02_4-20009707.SAR Software Provisioning Manager1.0 SP2 for

NW higher than 7.0x 4 Info 267126 12.07.2013

SAR SWPM10SP03_7-20009707.SAR SW Prov. Mgr. 1.0 SP03 for systems based

on NW7.1x or higher

Which you think is the indicated file for my case? I guess it is the first (SWPM10SP02_4-20009707.SAR) because it says that is for NW higher that 7.0x and as I said before our NW release in our ERP systems is 7.02!

Can you clarify me please this point?

regards,

samid

[Reagan · Accepted solution]

Which you think is the indicated file for my case?

Read this article

http://scn.sap.com/community/netweaver-administrator/blog/2013/08/21/swpm-variants-70swpm-or-swpm

Regards

RB

[Former Member · Accepted solution]

yes, you are correct.

Note 1680045 - Release Note for Software Provisioning Manager 1.0

[Former Member · Accepted solution]

Ok, thank you for the link and the information... but even so

As I said, my system is a SAP ERP 6.0 EHP5 with SAP NW EHP2 (SAP_BASIS and SAP_ABA components are 7.02 version)

Therefore I believe the installation guide that I need to follow is not that I mentioned ("Installing Gateway for SAP NetWeaver 7.1 or Higher"), I think the installation guide that fits my release is the "Installing Gateway for SAP NetWeaver 7.0 / 7.0 EHPs":

-> service.sap.com/instguides
-> SAP NetWeaver
-> SAP NetWeaver 7.0 (2004s)
-> Installation
-> 3 - Installation - Standalone Engines
-> Installing Gateway for SAP NetWeaver 7.0 / 7.0 EHPs

Please, can you confirm if this is the correct thought!
Am I correct or not?

___

I have one more question...
Regarding the following options:

-> service.sap.com/instguides
-> SAP NetWeaver
-> SAP NetWeaver Gateway 2.0

What´s this? Is the sap product that SAP Gateway that I need to install?

Kind regards,
samid

[Former Member · Accepted solution]

Hello,

I installed a SAP Gateway in DB host and now the RFC SAPXPG_DBDEST_LISZGPORA001 (SAPXPG_DBDEST_<DB-HOST>) is work but when I schedule in DB13, for instance, the "Check and update optimizer statistics" it show the following information:

Job started

Step 001 started (program RSDBAJOB, variant &0000000000024, user ID ADMINSAP)

Execução do comando lógico BRCONNECT No host liszgpora001

Parâmetros: -jid STATS20131020181756 -u / -c -f stats -t ALL

Can't exec external program (No such file or directory)

External program terminated with exit code 1

BRCONNECT returned error status E

Job finished

The RFC SAPXPG_DBDEST_LISZGPORA001 in Central instance (liszgpsap003) and also in Dialog instance (liszgpsap004) is configured like this (the LISZGPORA001 is the DB host) and like I said above, now the connection is good:

Any tips? Can you help me to understand what is the problem now?!

Best regards,

samid

[Reagan · Accepted solution]

Can't exec external program (No such file or directory)

The system cannot execute the sapxpg program.

Is the sapxpg file present in this location.

ls -la /usr/sap/AZP/SYS/exe/uc/sun_64/sapxpg

Check the environment variables for the oraazp and azpadm users.

Regards

RB

[Former Member · Accepted solution]

Dear Samid,

1.Please check the  "sapxpg" executable is present in kernel dir  or not

2. if yes,check the permission

3. Please run sapdba_role.sql and try again

Regards

sashi

[Former Member · Accepted solution]

I created a specific thread for this new issue in the following url:

http://scn.sap.com/thread/3441054

Thank you,

samid

[Former Member · Accepted solution]

I created a specific thread for this new issue in the following url:

http://scn.sap.com/thread/3441054

Thank you,

samid