cancel
Showing results for 
Search instead for 
Did you mean: 

SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Reagan
Advisor
Advisor
0 Kudos

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
0 Kudos

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
Advisor
Advisor
0 Kudos

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
0 Kudos

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
Advisor
Advisor
0 Kudos

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
0 Kudos

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
Advisor
Advisor
0 Kudos

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
0 Kudos

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
Advisor
Advisor
0 Kudos

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

ashish_vikas
Active Contributor
Former Member
0 Kudos

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
0 Kudos

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
Advisor
Advisor
0 Kudos

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
0 Kudos

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
0 Kudos

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

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

Thank you,

samid

Former Member
0 Kudos

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

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

Thank you,

samid

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello,

In  dialog instance, please check the hosts & Services  file at Operating system level and make sure that entries of the target server are maintained as same as in Central instance.

Regards,

Mudasir H Syed

Former Member
0 Kudos

Hello Mudasir,

I checked both files (/etc/hosts and /etc/services) and they have the same entries!

Any tips?!

Thank you,

samid

Former Member
0 Kudos

Hello,

Check the note 980266 and change the settings of your RFC as it has been mentioned in the note.

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


Another crude work around is ( Temporary ) ,

As you are able to access the RFC from Central instance then try to run the job on Central instance only. You can remove the Dialog instance from the 'background processing group' ( SM61 ) and then execute the job. It will run on central instance only.

Regards,

Mudasir H Syed.

Former Member
0 Kudos

Hello,

I´m reading that sap note 980266.

Tell me one thing, and correct me please if I am wrong...

As I said before this is a distributed SAP system with a dialog instance, so we have three servers, the server A (central instance), server B (dialog instance) and server C (database instance/host).

Regarding that RFC SAPXPG_DBDEST__<SAPDBHOST>, in central instance the settings of this RFC has the program field with server A host.

In dialog instance the settings of this RFC has the program field with server A host.

So... my question is, the value of that Program the value of thisfieldshould not be for both RFC´s (in central and dialog instance) the server C host, this is, the database host? I think so, but can you tell me if I am right, please?

Kind regards,

samid


former_member186066
Participant
0 Kudos

Try this once:

In RFC SAPXPG_DBDEST__<SAPDBHOST, enter gateway host and service of the Central instance.

Then  try running DB13 from any of the dialog instance.

Former Member
0 Kudos

Hello Ankit Mishra,

I did what you suggested and yes, it corrects the RFC SAPXPG_DBDEST__<SAPDBHOST> in dialog instance.

I run again in DB13 the activity Check and update optimizer statistics and again it stops with an error... not the initial error, it´s a new error!

Job started
Step 001 started (program RSDBAJOB, variant &0000000000023, user ID ADMINSAP)
Execute logical command BRCONNECT On host liszgpora001
Parameters: -jid CHECK20131011180519 -u / -c -f check
BR0801I BRCONNECT 7.20 (1)
BR0252E Function fopen() failed for './dbs/initAZP.sap' at location BrInitSapRead-1
BR0253E errno 2: No such file or directory
BR0159E Error reading BR*Tools profile ./dbs/initAZP.sap
BR0280I BRCONNECT time stamp: 2013-10-11 18.05.20
BR0301E SQL error -12545 at location db_connect-2, SQL statement:
'CONNECT /'
Error while trying to retrieve text for error ORA-12545
BR0310E Connect to database instance AZP failed

BR0806I End of BRCONNECT processing: cemhednc.log2013-10-11 18.05.20
BR0280I BRCONNECT time stamp: 2013-10-11 18.05.20
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
Job finished

Can you help me please?!

Thanks,

samid

former_member186066
Participant
0 Kudos

do the following:

1. Grant 777 or 775 perimission to conn<SID>.log created under /oracle/<SID>/sapcheck

run and let me know the result.

former_member186066
Participant
0 Kudos

Also, check

/oracle/AZP/11203/dbs has the following permission

drwxr-xr-x  2 oraazp dba  4096 Oct 11 12:00 dbs

Second,

files under dbs i.e initAZP.sap has the below perimission and ownership

-rw-r-xr-x 1 oraazp dba     27414 Sep 20 12:52 initAZP.sap

Former Member
0 Kudos

Hello Ankit,

1. Grant 777 or 775 perimission to conn<SID>.log created under /oracle/<SID>/sapcheck

I didn´t found any sapcheck directory under /oracle/<SID>

All this checks is to be done in Database host or in central instance, dialog instance hosts?


I also check the permissions in /oracle/AZP/11202/dbs (in Database host) and also in the files under dbs and everything is OK, like you recommended


What I don´t understand is... when I read the sap note 980266 (RFC destination SAPXPG_DBDEST_<DB-HOST> does not work) I thought that RFC´s (in central instance and dialog instance) should has in the 'Program' field the path of sapxpg program in database instance/host and not to the central instance (gateway host and service of the Central instance)! What you think about that?

regards,

samid

ashish_vikas
Active Contributor
0 Kudos

Do you have Database host and central instance host different ?

- If this is same, in RFC you just need to update Gateway host & Gateway Service of Central Instance.

- If database host has no sap instance installed : you need a Gateway installed on this host.

BR0801I BRCONNECT 7.20 (1)

BR0252E Function fopen() failed for './dbs/initAZP.sap' at location BrInitSapRead-1

BR0253E errno 2: No such file or directory

BR0159E Error reading BR*Tools profile ./dbs/initAZP.sap

>> what is your ORACLE_HOME for sidadm & orasid on database host ?

Also verify permissions of brtools with  Note 113747 - Owners and authorizations for BR*Tools

/oracle/SID/sapcheck is a standard default directory on database host for storing BRCONNECT logs. If it is not there, please create it. Permission can be 775 for orasid:dba

http://help.sap.com/saphelp_nwpi71/helpdata/en/47/05f87ce74266c0e10000000a1553f7/content.htm?framese...

make sure you have permissions for dbs & initSID.sap like below :

dbs > drwxr-xr-x oraSID:dba

initSID.sap > -rw-r--r-- oraSID:dba

best regards

ashish

Former Member
0 Kudos

Hello ashish,

Do you have Database host and central instance host different ?

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

>> what is your ORACLE_HOME for sidadm & orasid on database host ?

For azpadm and oraazp the ORACLE_HOME is the same: /oracle/AZP/112_64

/oracle/SID/sapcheck is a standard default directory on database host for storing BRCONNECT logs. If it is not there, please create it. Permission can be 775 for orasid:dba

The location of sapcheck directory is not, in my case, in /oracle/<SID>/sapcheck, instead it is in the following directory: /oracle/AZP/sapdata/sapcheck

It has the following permissions:

drwxr-xr-x   2 oraazp   dba           12 Aug 12 13:13 sapcheck

make sure you have permissions for dbs & initSID.sap like below :

dbs > drwxr-xr-x oraSID:dba

initSID.sap > -rw-r--r-- oraSID:dba

I checked the permissions in /oracle/AZP/11202/dbs and also in the files under dbs and everything is OK, like you recommended:

drwxr-xr-x   2 oraazp   dba           27 Oct 13 02:47 dbs

-rwxr-xr-x   1 oraazp   dba         6996 Feb 25  2013 initAZP.sap

Any tips?

Kind regards,

samid

ashish_vikas
Active Contributor
0 Kudos

you are right.. you should installed a standalone gateway on database host.

Nicholas Chang has explained it very well in http://scn.sap.com/thread/1937412

So just follow all steps and let us know in case of further problems.

best regards

ashish