Question Re: SXPG_COMMAND_EXECUTE failed... (DB13) in Technology Q&A

SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Fri, 11 Oct 2013 14:32:58 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Fri, 11 Oct 2013 14:52:16 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Fri, 11 Oct 2013 15:10:15 GMT

Hello Mudasir,

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

Any tips?!

Thank you,

samid

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Fri, 11 Oct 2013 15:29:59 GMT

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.

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Fri, 11 Oct 2013 16:23:18 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Fri, 11 Oct 2013 16:49:35 GMT

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.

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Fri, 11 Oct 2013 17:10:46 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Fri, 11 Oct 2013 17:31:38 GMT

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.

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Fri, 11 Oct 2013 17:37:06 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Sat, 12 Oct 2013 01:30:08 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Sat, 12 Oct 2013 08:13:24 GMT

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?frameset=/en/47/1cc68241f64403e10000000a1553f6/frameset.htm

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Reagan — Sat, 12 Oct 2013 20:49:04 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Sun, 13 Oct 2013 12:45:00 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Sun, 13 Oct 2013 13:16:01 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Reagan — Sun, 13 Oct 2013 13:20:23 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Sun, 13 Oct 2013 13:43:13 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Reagan — Sun, 13 Oct 2013 13:59:59 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Sun, 13 Oct 2013 14:36:29 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Reagan — Sun, 13 Oct 2013 14:49:24 GMT

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

Re: SXPG_COMMAND_EXECUTE failed... (DB13)

Former Member — Sun, 13 Oct 2013 15:59:20 GMT

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