Starting external progran SAPXPG failed (SM69)

[Former Member]

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

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

<No StdOut/StdErr output reported>

< 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

<No StdOut/StdErr output reported>

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

[Former Member · Accepted solution]

Hi,

Install standalone gateway on DB server. this will resolve your DB13 problem.

Regards,

Sachin Rane.

[Former Member]

Hi All,

Appreciate for all supporting statement.

I was able to solve the problem through rsh connection

Thanks.

BR,

Terry

[Former Member]

Hi Terry , we have the similar issue.. how did u resolveed it. Please share

[Former Member]

Hi,

Goto SM69, create a external OS command and insert the following:

Command name: Zxxx

Operating system command: rsh

Parameters for OS command: rsh <DB Host> | <sid>adm sapxpg

Then SAVE and EXECUTE.

If you could execute successfully, proceed to SM59 and test connection for rfc destination: SAPXPG_DBDEST_<DB_host>

If this being tested successfully, means connection had been setup

Good luck.

BR,

Terry

[Former Member]

I did that but i get connection refused error from both OS level and sm69. spoke to unix team to enable it but they are against using RSH as its not safe. I have them enabled RSH for trouble shooting purpose but now when execute rsh <DBHOST> -l bd0adm sapxpg it still connection refused error.

any idea? thanks in advance.

[Former Member]

Hi,

This problems comes when you execute any action from DB13 in CI where your CI & DB are installed on different host.

Go SM59-->TCP/IP Connections & select SAPXPG_DBDEST_<DBHOST>. Here maintain below details & do a connection test.

maintain Program=sapxpg

Target Host= <DBHOSTNAME>

Gateway Host = <DBHOSTNAME>

Gateway service sapgw## were ## is System number

Also see below SAP notes.

Note 446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13

Note 583759 - R/3 error when you start jobs from DB13.

Hope it helps.

Thanks,

Sushil

[Former Member]

Hi Guru,

When we tried to execute the following command from host DB:

rsh <Host CI> date

it was return results.

However, if we tried to execute from host CI:

rsh <Host DB> data

it was return no results.

That's means we could'nt remotely start any of external command at DB host from CI host.

Start external program error was isolated within operating system level.

Any luck on this?

Thanks.

BR,

Terry

[Former Member]

Hai,

Is the RFC connection containing the gateway details, such as gateway host and port number?

Regards,

Yoganand.V

[Former Member]

There's no sap gateway application because application server is not installed on DB host.

Thus we used rsh to connect instead of GW.

Shall we need to install a standalone gateway on DB host? Or there's alternative workaround?

Thanks.

BR,

Terry