Former Member

Feb 05, 2009 at 02:09 PM

Starting external progran SAPXPG failed (SM69)

2813 Views

System Information:

ECC 6, Oracle 10.2, AIX 5.3, Kernel Patch level 147

Hi all,

We were encountered problems when try to scheduled actions in DB13.

We had install CI & DB on separate server and the rfc SAPXPG_DBDEST_<Destination> is not working.

We tried to use RSH in SM49/SM69 to start external program SAPXPG in target host remotely, however, it return External program terminated with exit code 1 when we executed it.

*External command we used

Rsh

Target host u2013l <sid>adm sapxpg

____________________________________________________________________________________

Logs of dev_cp:

Trace file of control program (trace level 3)

< Function: BtcTrcInit> Function: main SAPXPG 700

2009-02-05--21-18-10 : Before BtcXpgDetach

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

2009-02-05--21-18-10 : Before RfcAccept

2009-02-05--21-18-10 : 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-02-05--21-18-10 : Before first call of RFCDispatch

> Function: BtcXpgStartXpgLong

2009-02-05--21-18-10 : Beginning of BtcXpgStartXpgLong

> Function: BtcXpgStartXpgImportLong > Function: BtcXpgParam < Function: BtcXpgParam > Function: BtcXpgParam < Function: BtcXpgParam > Function: BtcXpgParam < Function: BtcXpgParam > Function: BtcXpgParam < Function: BtcXpgParam > Function: BtcXpgParam < Function: BtcXpgParam > Function: BtcXpgParam < Function: BtcXpgParam > Function: BtcXpgParam < Function: BtcXpgParam > Function: BtcXpgParam < Function: BtcXpgParam > Function: BtcXpgTable < Function: BtcXpgTable < Function: BtcXpgStartXpgImportLong

BtcXpgStartXpgLong: special_trace_flag = <3>

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

Line Text

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: rsh

tracecntl = : 3

Program argument string: bir-hrerpdb -l prdadm sappxpg

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

parameter number 1:

Scanned parameter: bir-hrerpdb

parameter number 2:

Scanned parameter: -l

parameter number 3:

Scanned parameter: prdadm

parameter number 4:

Scanned parameter: sappxpg

Total number of arguments scanned: 4

Argument argv[0]: rsh

< Function: BtcXpgArgv < Function: BtcXpgCheck > Function: BtcXpgSigInst set signal handler for SIGCHLD to SIG_DFL

old signal handler for SIGCHLD: SIG_DFL

< Function: BtcXpgSigInst > Function: BtcXpgStart Process id: 172232

Parent process id: 352710

> Function: BtcTrcIni Start status of external program: external program successfully started

Id of external process: 0000323746

StdOut/StdErr collected in memory

Line Text

< Function: BtcXpgStartXpgInt > Function: BtcXpgStartXpgExport > Function: BtcXpgParam < Function: BtcXpgParam > Function: BtcXpgParam < Function: BtcXpgParam > Function: BtcXpgParam < Function: BtcXpgParam < Function: BtcXpgStartXpgExport

2009-02-05--21-18-10 : End of BtcXpgStartXpgLong

< Function: BtcXpgStartXpgLong

2009-02-05--21-18-10 : After first call of RFCDispatch

Wait for RFC call SAPXPG_END_XPG

2009-02-05--21-18-10 : Before second call of RFCDispatch

> Function: BtcXpgEndXpg

2009-02-05--21-18-10 : Beginning of BtcXpgEndXpg

> Function: BtcXpgStartXpgExport > Function: BtcXpgTable < Function: BtcXpgTable < Function: BtcXpgEndXpgImport > Function: BtcXpgEndXpgInt > Function: BtcXpgItTransfer Content of source log table:

Line Text

Target log table is not identical to source

ItGetLine terminated with NULL

< Function: BtcXpgItTransfer > Function: BtcXpgReadChild Process executing external program has terminated

< Function: BtcXpgReadChild > Function: BtcXpgEnd > Function: BtcXpgLog

Log message (44 byte): External program terminated with exit code 1

< Function: BtcXpgLog

< Function: BtcXpgEnd Termination status of external program: program terminated with error code 1

StdOut/StdErr collected in memory

< Function: BtcXpgEndXpgInt > Function: BtcXpgEndXpgExport > Function: BtcXpgParam < Function: BtcXpgParam > Function: BtcXpgParam < Function: BtcXpgParam < Function: BtcXpgEndXpgExport

2009-02-05--21-18-10 : End of BtcXpgEndXpg

< Function: BtcXpgEndXpg

2009-02-05--21-18-10 : After second call of RFCDispatch

2009-02-05--21-18-10 : After call of RfcClose (wait)

< Function: main

2009-02-05--21-18-10 : End of SAPXPG: main

____________________________________________________________________________________

We couldnu2019t located any clear error indication that might help us in troubleshooting.

We already configured settings in .rhosts file & we had resolve the permission problem

We executed the following commands as user <sid>adm:

In DB host, we executed rsh <CI host> date & it works.

But in DB hosts, its doesn't work when we executed rsh <DB host> date

Is this issue should be isolated as AIX OS issue?

We couldn't execute any activities from DB13 as the DB rfc destination is not working.

Is that alternative way that we can execute sapxpg on DB host?

Or we have to install standalone gateway as solution? It's that any impact if we installing standalone gateway at DB host now (It's production system)?

Thanks.

BR,

Terry