SXPG_COMMAND_EXECUTE failed for BRBACKUP

[Former Member]

Dear All,

OS : AIX, DB :Oracle , SAP ECC6.0

i got an error and online backup has scheduled in DB13 ( Production Server)

when its reach the backup time its showins error

Status : not Available

JOB LOG:

30.11.2009 17:26:56 Job started

30.11.2009 17:26:56 Step 001 started (program RSDBAJOB, variant &0000000000672, user ID BASIS)

30.11.2009 17:26:56 No application server found on database host - rsh/gateway will be used

30.11.2009 17:26:56 Execute logical command BRBACKUP On host PRODORADB

30.11.2009 17:26:56 Parameters:-u / -jid ALLOG20091130172655 -c force -t online -m all -p initIRPoffsite.sap -a -c force -p initIRP

30.11.2009 17:26:56 offsite.sap -cds

30.11.2009 17:27:28 SXPG_STEP_XPG_START: is_local_host: rc = 403

30.11.2009 17:27:28 SXPG_STEP_XPG_START: host = PRODORADB

30.11.2009 17:27:28 SXPG_STEP_XPG_START: is_local_r3_host: rc = 802

30.11.2009 17:27:28 SXPG_STEP_XPG_START: RFC_TCPIP_CONNECTION_OPEN: rc = 1003

30.11.2009 17:27:28 SXPG_STEP_COMMAND_START: SXPG_STEP_XPG_START returned: 1.003

30.11.2009 17:27:28 SXPG_COMMAND_EXECUTE(LONG)

30.11.2009 17:27:28 <timestamp> = 20091130172728

30.11.2009 17:27:28 COMMANDNAME = BRBACKUP

30.11.2009 17:27:28 ADDITIONAL_PARAMETERS =

30.11.2009 17:27:28 -u / -jid ALLOG20091130172655 -c force -t online -

30.11.2009 17:27:28 m all -p initIRPoffsite.sap -a -c force -p initIRP

30.11.2009 17:27:28 offsite.sap -cds

30.11.2009 17:27:28 LONG_PARAMS

30.11.2009 17:27:28 OPERATINGSYSTEM = ANYOS

30.11.2009 17:27:28 TARGETSYSTEM = PRODORADB

30.11.2009 17:27:28 DESTINATION

30.11.2009 17:27:28 SY-SUBRC = 1003

30.11.2009 17:27:28 SXPG_COMMAND_EXECUTE failed for BRBACKUP - Reason: program_start_error: For More Information, See SYS

30.11.2009 17:27:28 Job cancelled after system exception ERROR_MESSAGE

pls give suggestion to solve this issue

regards

satheesh

[JPReyes · Accepted solution]

check the errors on dev_cp and dev_xpg and post them here.

Regards

Juan

[Former Member · Accepted solution]

Hi JUAN,

please check the errors on dev_cp and dev_xpg .

PRODORADB:irpadm 3> cat dev_xpg

Trace file of external program (trace level 3)

< Function: BtcTrcInit> Function: BtcXpgStart External program: brtools

Process id: 590042

Parent process id: 270598

Rearrange StdErr to be collected in memory

Rearrange StdOut to be collected in memory

PRODORADB:irpadm 4>

pls give me any suggestion

regards

[Former Member · Accepted solution]

HI Michael,

please check the dev_rd trace file

RSTR0006: Display Developer Traces

trc file: "dev_rd", trc level: 1, release: "700"

Sun Dec 27 17:03:37 2009

***LOG S00=> GwInitReader, gateway started ( 282838) [gwxxrd.c 1757]

systemid 324 (IBM RS/6000 with AIX)

relno 7000

patchlevel 0

patchno 167

intno 20050900

pid 282838

gateway runs with dp version 240000(ext=110000) (@(#) DPLIB-INT-VERSION-240000-UC)

gateway (version=700.2008.06.23)

gw/local_addr : 0.0.0.0

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

Bind service sapgw00 (socket) to port 3300

GwPrintMyHostAddr: my host addresses are :

1 : [10.54.145.33] PRDAPP1 (HOSTNAME)

2 : [127.0.0.1] loopback (LOCALHOST)

Full qualified hostname = PRDAPP1

DpSysAdmExtCreate: ABAP is active

DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

DpShMCreate: sizeof(wp_adm)##15624#(1736)

DpShMCreate: sizeof(tm_adm)##5941632#(29560)

DpShMCreate: sizeof(wp_ca_adm)##24064#(80)

DpShMCreate: sizeof(appc_ca_adm)#8000#(80)

DpCommTableSize: max/headSize/ftSize/tableSize=500/8/548056/548064

DpShMCreate: sizeof(comm_adm)##548064#(1088)

DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

DpShMCreate: sizeof(slock_adm)##0#(104)

DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

DpShMCreate: sizeof(file_adm)##0#(72)

DpShMCreate: sizeof(vmc_adm)##0#(1864)

DpShMCreate: sizeof(wall_adm)##(40056/36728/64/192)

DpShMCreate: sizeof(gw_adm)#48

DpShMCreate: SHM_DP_ADM_KEY##(addr: 0x700000000121000, size: 6623112)

DpShMCreate: allocated sys_adm at 0x700000000121000

DpShMCreate: allocated wp_adm at 0x700000000123198

DpShMCreate: allocated tm_adm_list at 0x700000000126ea0

DpShMCreate: allocated tm_adm at 0x700000000126f00

DpShMCreate: allocated appc_ca_adm at 0x7000000006d7680

DpShMCreate: allocated comm_adm at 0x7000000006d95c0

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 0x70000000075f2a0

DpShMCreate: allocated gw_adm at 0x70000000075f320

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 0x70000000075f350

MtxInit: -2 0 0

Sun Dec 27 17:03:39 2009

GwDpInit: attached to gw_adm at 0x70000000075f320

Mon Dec 28 01:48:09 2009

• ERROR => NiIRead: invalid data (len=-2139094781;0x80800103;mode=0;hdl 12;peer=10.54.145.11:2684) [nixxi.cpp 4245]

*****************************************************************************

*

• LOCATION SAP-Gateway on host PRDAPP1 / sapgw00

• ERROR internal error

*

• TIME Mon Dec 28 01:48:09 2009

• RELEASE 700

• COMPONENT NI (network interface)

• VERSION 38

• RC -1

• MODULE nixxi.cpp

• LINE 4240

• DETAIL NiIRead: invalid data (len=-2139094781); probably RAW_IO

• COUNTER 505

*

*****************************************************************************

please give any suggestion

Regards

[Former Member · Accepted solution]

Hello,

the timestamp in dev_rd does not correspond to the previously failed brbackup run. Can you please check whether the stderr files in the work directory of the SAP instance contain any error relevant to this point in time?

Best Regards,

Michael

[Former Member · Accepted solution]

Hi,

I am facing the same issue but couldn't able to resolve it, I have checked sapnote 446172 but still not able to find the solution. Please help.

Regards,

Mridul

[Former Member · Accepted solution]

Mridul ,

I believe your Database host and CI are installed in a distributed configuration.For sapxpg utility to be able to execute brtools jobs on database host ,the easiest way is to install a SAP Standalone Gateway on the database host with the user SIDADM.

Otherwise you can configure ssh or rsh between these two hosts ,which might be cumbersome.So just install a standalone gateway and you should be good with it.

Rgds

Amit

Edited by: Amit Bangotra on Jul 4, 2011 5:25 PM

[anindya_bose]

Hi

Most probably this is due to failure in RFC connection from where you have different DB and App server. If you run backup from db13, it executes the command on DB instance through an RFC connection SAPXPG_DBDEST_<dbhostname>. Check if the RFC is working properly.

For this connection to work properly you need two entries in the service file of the app server. sapgw30 3330 and sapdb30 3230. This is a automatically generated RFC.

Inmportant Note: 446172- (SXPG_COMMAND_EXECUTE (program_start_error) in DB13

Regards

anindya

Edited by: Anindya Bose on Dec 29, 2009 6:24 PM

[Former Member]

Hi Anindya,

we have 1 CI & 2 App. Instance

Application Instance 1

i have Checked RFC Destination SAPXPG_DBDEST_PRODORADB through SM59.

when i give connection Test , its pinging . below result

Logon 185 msec

Transfer of 0 KB 198 msec

Transfer of 10 KB 200 msec

Transfer of 20 KB 200 msec

Transfer of 30 KB 201 msec

Application Instance 2

i have Checked RFC Destination SAPXPG_DBDEST_PRODORADB through SM59.

when i give connection Test , its not pinging

Logon Connection Error

Error Details Error when opening an RFC connection

Error Details ERROR: timeout during allocate

Error Details LOCATION: SAP-Gateway on host PRDAPP2 / sapgw00

Error Details DETAIL: no connect of TP sapxpg from host PRODORADB after 20 sec

Error Details COMPONENT: SAP-Gateway

Error Details COUNTER: 3012

Error Details MODULE: gwr3cpic.c

Error Details LINE: 1973

Error Details RETURN CODE: 242

Error Details SUBRC: 0

Error Details RELEASE: 700

Error Details TIME: Tue Dec 29 20:30:06 2009

Error Details VERSION: 2

Central Instaence (CI):

i have Checked RFC Destination SAPXPG_DBDEST_PRODORADB through SM59.

when i give connection Test , its pinging . below result

Logon 185 msec

Transfer of 0 KB 198 msec

Transfer of 10 KB 200 msec

Transfer of 20 KB 200 msec

Transfer of 30 KB 201 msec

pls advise me , the above error is related to Backup

pls suggest me to resolve the issue

[anindya_bose]

Hi Satheesh

When you schedule a backup from DB13, it actually schedule a job in the system. All those database related job names start with DBA.

In SM37, check the cancelled jobs which start with DBA ( Search with DBA*) and then check the executing server of that cancelled job. If the server is same as your application instace 2 , that means DB13 backup is faining due to problem in that RFC.

Check the HOST and SERVICES file of your App instance 2 and compare with those of other 2 instances. Also compare SM59 screen of all the servers. There may be problem in SAPXPG executable in that server. You have to try every option one by one.

[peter_dzurov]

can you start other db13 jobs?

maybe you will have to generate ssh keys for both hosts where your DB and CI is running.

[Former Member]

HI,

thanks for your advance reply

i cannot start other db13 jobs?

could you tell how to generate ssh keys for both hosts where your DB and CI is running.

kindly advice me

regards

[Former Member]

Hi

In Windows we can find Host & services from C:\WINDOWS\system32\drivers\etc

we are using AIX for all servers

below detail for reference

===================================================

ROOT@PRDCIXI:/#ls

.TTauthority bosinst.data perfdata

.Xauthority cdrom proc

.dt clverify_daemon.log sapcd

.dtprofile configassist.log sapcdd

.java dead.letter sapmnt

.mh_profile dev sbin

.profile esa sdtstart.err

.rhosts etc smit.log

.rhosts.previous home smit.script

.sdtgui image.data smit.transaction

.sh_history lib ss.txt

.vi_history lost+found tftpboot

.wmrc lpp tk

CSD mksysb tmp

IRPEXE mnt u

Mail mount.a1253462 unix

TT_DB opt usr

audit oracle var

backup pay websm.script

bin pay1

ROOT@PRDCIXI:/#cat .rhosts

PRODORADB_boot1

PRODORADB_boot2

PRODORADB_svc

PRODORADB_ps

PRDCIXI_boot1

PRDCIXI_boot2

PRDCIXI_svc

PRDCIXI_ps

===================================================

This is APP2 Instanece

ROOT@PRDAPP2:/#ls

.TTauthority TT_DB lpp smit.log

.Xauthority audit mksysb smit.script

.dt bin mnt smit.transaction

.dtprofile bosinst.data nmon tftpboot

.java cdrom opt tk

.profile configassist.log oracle tmp

.rhosts dev pay u

.rhosts.previous esa proc unix

.sdtgui etc sapcd usr

.sh_history home sapcdd var

.ssh image.data sapmnt websm.script

.vi_history lib sbin

.wmrc lost+found sdtstart.err

ROOT@PRDAPP2:/#cat .rhosts

SAP-DEV-QAS root

ROOT@PRDAPP2:/#cat .rhosts.previous

SAP-DEV-QAS root

ROOT@PRDAPP2:/#

========================================

This is APP1 Instanece

ROOT@PRDAPP1:/#ls

.TTauthority TT_DB lpp smit.log

.Xauthority audit mksysb smit.script

.dt bin mnt smit.transaction

.dtprofile bosinst.data nmon tftpboot

.java cdrom opt tk

.profile configassist.log oracle tmp

.rhosts dev pay u

.rhosts.previous esa proc unix

.sdtgui etc sapcd usr

.sh_history home sapcdd var

.ssh image.data sapmnt websm.script

.vi_history lib sbin

.wmrc lost+found sdtstart.err

ROOT@PRDAPP1:/#cat .rhosts

SAP-DEV-QAS root

ROOT@PRDAPP1:/#

You have mail in /usr/spool/mail/root

ROOT@PRDAPP1:/#

ROOT@PRDAPP1:/#cat .rhosts

SAP-DEV-QAS root

ROOT@PRDAPP1:/#cat .rhosts.previous

SAP-DEV-QAS root

ROOT@PRDAPP1:/#

============================================================

kindly advise me i didnt get any hint from host file

[peter_dzurov]

Please generate key pairs so you will be able to access through ssh as sidadm from ci host to db host.

Check http://w3.pppl.gov/cppg/seminars/papers/linux_talk/node11.html

In summary:

At first check if profile parameter is set to gw/remsh = /usr/bin/ssh

- then

/home/sidadm> ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/home/sidadm/.ssh/id_dsa):[Enter]
Enter passphrase (empty for no passphrase):<Enter>
Enter same passphrase again:<Enter>
Your identification has been saved in /home/sidadm/.ssh/id_dsa.
Your public key has been saved in /home/sidadm/.ssh/id_dsa.pub.
The key fingerprint is:
9b:bb:76:61:e7:ef:c2:cd:3c:1d:16:02:c0:a4:ed:ds sidadm@host
/home/sidadm> cd .ssh
sidadm/.ssh> ls -al id*
-rw-------  1 sidadm sapsys 668 2009-07-15 13:00 id_dsa
-rw-ru2014r--  1 sidadm sapsys 605 2009-07-15 13:00 id_dsa.pub

Public key id_dsa.pub has to be appended to the file authorized_keys of the user sidadm on dbhost. Login as sidadm on dbhost, copy public key from ci host and append it (in this example is id_dsa.pub renamed to sidadm.pub on dbhost):

dbhost:sidadm 53> pwd
/home/sidadm/.ssh/
dbhost:sidadm 53> cat sidadm.pub >> authorized_keys

Then please try to logon from ci host to db host with ssh:

ssh sidadm@dbhost
type yes and hit <Enter>

That should be everything. Now try to execute jobs from DB13.

[Former Member]

HI,

thanks for your advance reply

from DB13 Backups are running when Execute immediately .

but Scheduled backup jobs are cancelled ... STATUS shows scheduled failed

JOB LOG :

30.12.2009 17:00:11 Job started

30.12.2009 17:00:11 Step 001 started (program RSDBAJOB, variant &0000000000733, user ID S2K_BASIS)

30.12.2009 17:00:11 No application server found on database host - rsh/gateway will be used

30.12.2009 17:00:11 Execute logical command BRBACKUP On host PRODORADB

30.12.2009 17:00:11 Parameters:-u / -jid ALLOG20091220170000 -c force -t online -m all -p initIRPoffsite.sap -a -c force -p initIRP

30.12.2009 17:00:11 offsite.sap -cds

30.12.2009 17:00:38 SXPG_STEP_XPG_START: is_local_host: rc = 403

30.12.2009 17:00:38 SXPG_STEP_XPG_START: host = PRODORADB

30.12.2009 17:00:38 SXPG_STEP_XPG_START: is_local_r3_host: rc = 802

30.12.2009 17:00:38 SXPG_STEP_XPG_START: RFC_TCPIP_CONNECTION_OPEN: rc = 1003

30.12.2009 17:00:38 SXPG_STEP_COMMAND_START: SXPG_STEP_XPG_START returned: 1.003

30.12.2009 17:00:38 SXPG_COMMAND_EXECUTE(LONG)

30.12.2009 17:00:38 <timestamp> = 20091230170038

30.12.2009 17:00:38 COMMANDNAME = BRBACKUP

30.12.2009 17:00:38 ADDITIONAL_PARAMETERS =

30.12.2009 17:00:38 -u / -jid ALLOG20091220170000 -c force -t online -

30.12.2009 17:00:38 m all -p initIRPoffsite.sap -a -c force -p initIRP

30.12.2009 17:00:38 offsite.sap -cds

30.12.2009 17:00:38 LONG_PARAMS

30.12.2009 17:00:38 OPERATINGSYSTEM = ANYOS

30.12.2009 17:00:38 TARGETSYSTEM = PRODORADB

30.12.2009 17:00:38 DESTINATION

30.12.2009 17:00:38 SY-SUBRC = 1003

30.12.2009 17:00:38 SXPG_COMMAND_EXECUTE failed for BRBACKUP - Reason: program_start_error: For More Information, See SYS

30.12.2009 17:00:38 Job cancelled after system exception ERROR_MESSAGE

regards

[Former Member]

Hello,

as mentioned in one of the previous replies, the problem is most likely caused by the configuration of rsh/ssh. If this is the case, you should find an entry in the file dev_rd file around the time of the failing backup. Can you please check this and post the relevant part of dev_rd?

Best Regards,

Michael

[Former Member]

unanswer

[Former Member]

answered

[Former Member]

Hi Juan ,

pls check the DEV_XPG , DEV_CP log

DEV_XPG Error Log file :

RSTR0006: Display Developer Traces

Trace file of external program (trace level 3)

< Function: BtcTrcInit> Function: BtcXpgStart External program: env

Process id: 1290304

Parent process id: 1548360

Rearrange StdErr to be collected in memory

Rearrange StdOut to be collected in memory

DEV_XPG Error Log file :

RSTR0006: Display Developer Traces 1

Trace file of control program (trace level 3)

< Function: BtcTrcInit> Function: main SAPXPG 700

2009-12-10 19-01-36 : Before BtcXpgDetach

> Function: BtcXpgDetach < Function: BtcXpgDetach Accept RFC connection from R/3 system

2009-12-10 19-01-36 : Before RfcAccept

2009-12-10 19-01-36 : RfcAccept returned OK

security check switched OFF

Install RFC call SAPXPG_START_XPG

Install RFC call SAPXPG_START_XPG_LONG

Install RFC call SAPXPG_END_XPG

Wait for RFC call SAPXPG_START_XPG or SAPXPG_START_XPG_LONG

2009-12-10 19-01-36 : Before first call of RFCDispatch

> Function: BtcXpgStartXpgLong

2009-12-10 19-01-36 : Beginning of BtcXpgStartXpgLong

> Function: BtcXpgStartXpgImportLong > Function: BtcXpgParam < Function: BtcXpgParam > Function: BtcXpgParam < Functio

BtcXpgStartXpgLong: special_trace_flag = <0>

> Function: BtcXpgStartXpgInt > Function: BtcXpgItTransfer Content of source log table:

Line Text

<No StdOut/StdErr output reported>

Target log table is not identical to source

ItGetLine terminated with NULL

< Function: BtcXpgItTransfer > Function: BtcTrcReset < Function: BtcTrcReset Call mode: VIA RFC

Input arguments of BtcXpgStartXpg:

External program: env

tracecntl = : 0

Program argument string:

Contents of control flags:

StdIn control flag: redirect StdIn

StdOut control flag: store StdOut output in memory

StdErr control flag: store StdErr output in memory

Trace control flag: unknown contents

Termination control flag: control program will wait for termination

> Function: BtcXpgCheck > Function: BtcXpgArgv

Total number of arguments scanned: 0

Argument argv[0]: env

Reggards

[Former Member]

Hi,

Also sm21 system log

Mark

[Former Member]

Hello,

I see you are running on a UNIX platform (AIX).

In your log file I see clearly the command BRBACKUP in uppercase.

Commands in UNIX are case sensitive, BRBACKUP does not exist.

Try to change the command BRBACKUP by brbackup and tell us the results.

Success.

Wim