SXPG_COMMAND_EXECUTE error

[Former Member]

Hi All,

Jobs in db13 are failing with below error.

04.08.2010 05:00:46 Job started

04.08.2010 05:00:47 Step 001 started (program RSDBAJOB, variant &0000000000059, user ID xxxxx)

04.08.2010 05:00:47 Execute logical command BRCONNECT On host dbSID

04.08.2010 05:00:47 Parameters: -u / -jid STATS20100609000000 -c -f stats -t ALL

04.08.2010 05:01:27 External communication error at program start (see system log)

04.08.2010 05:01:27 SAPXPG_START_XPG_LONG: sy-subrc ne 0

04.08.2010 05:01:27 destination = SAPXPG_DBDEST_DBSID

04.08.2010 05:01:28 SXPG_STEP_XPG_START: execute_sapxpg: rc = 1.003

04.08.2010 05:01:28 SXPG_STEP_COMMAND_START: SXPG_STEP_XPG_START returned: 1.003

04.08.2010 05:01:28 SXPG_COMMAND_EXECUTE(LONG)

04.08.2010 05:01:28 COMMANDNAME = BRCONNECT

04.08.2010 05:01:28 OPERATINGSYSTEM = ANYOS

04.08.2010 05:01:28 TARGETSYSTEM = dbSID

04.08.2010 05:01:28 DESTINATION = SAPXPG_DBDEST_DBSID

04.08.2010 05:01:28 SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: program_start_error: For More Information, See SYS

04.08.2010 05:01:28 Job cancelled after system exception ERROR_MESSAGE

And SAPXPG_DBDEST_DBSID rtc connection failed with timeout error.

Logon Connection Error

Error Details Error when opening an RFC connection

Error Details ERROR: timeout during allocate

Error Details LOCATION: SAP-Gateway on host ciSID.ncsbe.eu.jnj.com / sapgw52

Error Details DETAIL: no connect of TP sapxpg from host dbSID.ncsbe.eu.jnj.com after 20 sec

Error Details COMPONENT: SAP-Gateway

Error Details COUNTER: 98

Error Details MODULE: gwr3cpic.c

Error Details LINE: 2030

Error Details RETURN CODE: 242

Error Details SUBRC: 0

Error Details RELEASE: 701

Error Details TIME: Wed Aug 4 13:41:27 2010

Error Details VERSION: 2

System log is showing " Error1005 when executing external command brtools on SAPXPG_DBDEST_DBSID (in=R,out=M,err=M,trc=0,trm=C. strtstat=,xpgid=0,convid=. msg :Error when openi)".

When i check detail logs also it is throwing error " SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: program_start_error: For More Information, See SYS ".

DB and CI are on different hosts.

SAP : SAP EHP 1 for SAP NetWeaver 7.0

DB : Oracle 10.2.0.4.0

OS : HP-UX

Gateway is running, I see gateway profiles exist at OS level in /usr/sap/SID/SYS/profile.

But gateway profiles haven't been created in RZ10.

Is this causing the issue. Can you please help me out here.

Thanks in advance.

Edited by: SAP Basis on Aug 4, 2010 7:59 AM

[Former Member]

Hi

See below note i faced same problem

solution

SAP Note 446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13

bye

Surendra Jain

[nelis]

Error Details Error when opening an RFC connection
Error Details ERROR: timeout during allocate
Error Details LOCATION: SAP-Gateway on host ciSID.ncsbe.eu.jnj.com / sapgw52

It's using RFC to connect so check SM59 -> TCP/IP Connections -> SAPXPG_DBDEST_<SID>

Make sure the Technical Settings are correct and you can do a successful "Connection Test".

Nelis

[Former Member]

Hi Nelis,

Technical settings are correct.

Program sapxpg

Target Host dbSID.ncsbe.eu.jnj.com

Gateway Host dbSID.ncsbe.eu.jnj.com

Gateway service sapgw52

do we need to create gateway profiles in RZ10 also?

Is that causing this issue?

Please let me know.

[Former Member]

Hi ,

Instead of scheduling DB13 and try to take immediate backup from DB13 ...

it should work

[Former Member]

Hi

pls check s. note #1025707 for details

[Former Member]

from BRtools I am able to run.

But in db13 i m getting this error and when i check detail log it is throwing error.

[nelis]

do we need to create gateway profiles in RZ10 also?

Not sure what you mean by that but if there are no specific gateway parameters in your profile then it will use the system defaults which should be fine.

Is that causing this issue?

You can check Note 581509 - Reasons for "timeout during allocate" for more information.

Nelis

[Former Member]

When I run below command as per note 446172 it is giving connection refused.

sidadm> remsh dbSID.ncsbe.eu.jnj.com -l sidadm sapxpg

dbSID.ncsbe.eu.jnj.com: Connection refused

rcmd_af: connect: dbSID.ncsbe.eu.jnj.com: Connection refused

[peter_dzurov]

Do you have separate server for CI and DB?

[nelis]

sidadm> remsh dbSID.ncsbe.eu.jnj.com -l sidadm sapxpg
dbSID.ncsbe.eu.jnj.com: Connection refused
rcmd_af: connect: dbSID.ncsbe.eu.jnj.com: Connection refused

remshd needs to be enabled on the server(and inetd running). Check /etc/inetd.conf and 'man remshd' for further information. Also, if you are using inetd.sec then make sure your host has access.

Nelis