on 02-05-2009 2:09 PM
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
Hi,
Install standalone gateway on DB server. this will resolve your DB13 problem.
Regards,
Sachin Rane.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Appreciate for all supporting statement.
I was able to solve the problem through rsh connection
Thanks.
BR,
Terry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hai,
Is the RFC connection containing the gateway details, such as gateway host and port number?
Regards,
Yoganand.V
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.