No connect of TP sapxpg from host database.fes.com...

Former Member · ‎12-13-2010

Dear Experts

I have three server and I had installed with HA Options as belows

Server B -> ASCS & Database

Server A -> CI

Server C -> DI

I logged in SAP through Group Logon in Logon Pad -> OK

But when i run tcode DB13 to run Action Pad : Cleanup Logs, Check and Update Optimize Statistic ....etc -> with Cancel status in tcode SM37 -> with error in tab Job Log below

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

Job started

Step 001 started (program RSDBAJOB, variant &0000000000019, user ID DDIC)

No application server found on database host - rsh/gateway will be used

Execute logical command BRCONNECT On host database

Parameters: -u / -jid STATS20101214002434 -c -f stats -t ALL

SXPG_STEP_XPG_START: is_local_host: rc = 403

SXPG_STEP_XPG_START: host = database

SXPG_STEP_XPG_START: is_local_r3_host: rc = 802

SXPG_STEP_XPG_START: RFC_TCPIP_CONNECTION_OPEN: rc = 1003

SXPG_STEP_COMMAND_START: SXPG_STEP_XPG_START returned: 1.003

SXPG_COMMAND_EXECUTE(LONG)

<timestamp> = 20101214002506

COMMANDNAME = BRCONNECT

ADDITIONAL_PARAMETERS = -u / -jid STATS20101214002434 -c -f stats -t ALL

LONG_PARAMS

OPERATINGSYSTEM = ANYOS

TARGETSYSTEM = database

DESTINATION

SY-SUBRC = 1003

SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: program_start_error: For More Information, See SYS

Job cancelled after system exception ERROR_MESSAGE

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

and then , I checked tcode SM59 -> TCP/IP Connection -> SAPXPG_DBDEST_DATABASE -> Test Connection -> not OK with error

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

Connection Error

Error when opening an RFC connection

ERROR: timeout during allocate

LOCATION: SAP-Gateway on host dialog.fes.com.vn / sapgw02

DETAIL: no connect of TP sapxpg from host database.fes.com.vn after 20 sec

COMPONENT: SAP-Gateway

COUNTER: 193

MODULE: gwr3cpic.c

LINE: 1973

RETURN CODE: 242

SUBRC: 0

RELEASE: 701

TIME: Tue Dec 14 00:31:03 2010

VERSION: 2

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

Please make sure you have mounted your /sapmnt/<SID>/exe on your database server

Extra information:

Server B -> installed ASCS & Database -> Thus, I have exported mount point of /sapmnt/<SID>/exe, /usr/sap, /home/<sid>adm on my database server (server B) and have mounted from server A and server C to /sapmnt/<sid>/exe of server B

Please help me to resolve this warning

Former Member · ‎12-26-2010

Dear Sunil

I thinhk that -> So with Message server and Enqueue server being separated from Central Instance, Central Instance is as good as any other Dialog Instance. So the Central Instance term itself becomes obsolete and there is no difference between central instance and any dialog instance

Regards

Former Member · ‎12-24-2010

Dear Mho

With three server models, I do not configure a cluster model, but i use HA System Configuration options in Sapinst to setup for three server (Because, I want to implement to share workload between server A and Server C )
I thinhk that -> So with Message server and Enqueue server being separated from Central Instance, Central Instance is as good as any other Dialog Instance. So the Central Instance term itself becomes obsolete and there is no difference between central instance and any dialog instance and so failure of any instance does not affect SAP operations if at least one of the instance is UP and running + the logon configuration is done appropriately.
ASCS (which contains Message server and Enqueue Server)
Thus, previous, When i setup a HA Options with three server as follows:
Server B -> installed ASCS + DB
Server A -> installed CI
Server C -> installed DI
-> when run Check Statistics in DB13 with error
After that, I installed a Gatewau Standalone on Server B -> still errors in DB13
anf finally, I installed a new CI on Server B as follows:
Server B -> installed ASCS + DB + Gateway + CI
Server A -> installed CI
Server C -> installed DI
-> run DB13 on all instance (CI, DI) -> successfully
but when
run Brconnect command at OS lvel on Server A and C with <sid>adm -> still fail
and run Brconnect command at OS lvel on Server B with <sid>adm -> successfully

For DB13 run successfully => So, why do we need to install a least application instance running on DB Host (Server B)

Former Member · ‎12-24-2010

Sorry , wrong post

Former Member · ‎12-20-2010

Thanks Sunil

Former Member · ‎12-20-2010

Dear experts

Please some comments

Regards

Former Member · ‎12-18-2010

Dear Sunil

With three server models, I do not configure a cluster model, but i use HA System Configuration options in Sapinst to setup for three server (Because, I want to implement to share workload between server A and Server C )

I thinhk that -> So with Message server and Enqueue server being separated from Central Instance, Central Instance is as good as any other Dialog Instance. So the Central Instance term itself becomes obsolete and there is no difference between central instance and any dialog instance and so failure of any instance does not affect SAP operations if at least one of the instance is UP and running + the logon configuration is done appropriately.

ASCS (which contains Message server and Enqueue Server)

Thus, previous, When i setup a HA Options with three server as follows:

Server B -> installed ASCS + DB

Server A -> installed CI

Server C -> installed DI

-> when run Check Statistics in DB13 with error

After that, I installed a Gatewau Standalone on Server B -> still errors in DB13

anf finally, I installed a new CI on Server A as follows:

Server B -> installed ASCS + DB + Gateway + CI

Server A -> installed CI

Server C -> installed DI

-> run DB13 on all instance (CI, DI) -> successfully

but when

run Brconnect command at OS lvel on Server A and C with <sid>adm -> still fail

and run Brconnect command at OS lvel on Server B with <sid>adm -> successfully

Can you contribute somewhat to my ?

Former Member · ‎12-17-2010

Dear Sunil

I have installed more a additional CI instance on Database Host. Thus, am using HA system landscape configuration (Not use Distributed System)

Server B -> installed ASCS + DB + CI

Server A -> installed CI

Server C -> installed DI

Regards

Former Member · ‎12-16-2010

Dear Juan

I think I have configured correctly.

I executed R3trans from the CI / DI successfully.

And I have resolved my problem when run Statistic Optimize in tcode DB13 successfully by I have installed more a additional CI instance on Database Host and not assign Gateway. But, at OS level, when run brconnect command -> not successful.

I do not know why so !

Do you know why ?

When installed more a additional CI on DB Host, when i start application via <SID>adm user on DB Host -> system will start both (CI and ASCS) on DB Host. And now, I want to start each of them, how should i install ?

Thanks for your support to Sunil and Juan

Former Member · ‎12-16-2010

Dear Experts

Please help me to analysis this problem

Former Member · ‎12-15-2010

Dear Juan

I had created as follows:

On CI server:

groupadd dba

groupadd oper

usermod -a -G sapsys tstadm

usermod -a -G dba tstadm

usermod -a -G oper tstadm

useradd -g oper oratst

And then, I adjusted /etc/passwd on CI server same with DB server manually

Then, run "brconnect -u / -c -f stats -t system_stats" command on CI Server and logs as follows :

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

BR0801I BRCONNECT 7.00 (40)

BR0252E Function fopen() failed for '/oracle/TST/102_64/dbs/initTST.sap' at location BrInitSapRead-1

BR0253E errno 2: No such file or directory

BR0159E Error reading BR*Tools profile /oracle/TST/102_64/dbs/initTST.sap

BR0280I BRCONNECT time stamp: 2010-12-16 07.06.08

BR0301E SQL error -12545 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-12545: Connect failed because target host or object does not exist

BR0310E Connect to database instance TST failed

BR0806I End of BRCONNECT processing: ceeuhkbw.log 2010-12-16 07.06.08

BR0280I BRCONNECT time stamp: 2010-12-16 07.06.08

BR0804I BRCONNECT terminated with errors

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

Thus, I have exported /oracle from DB Server and have mounted /oracle of CI Server to /oracle of DB Server and run again with new errors :

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

BR0801I BRCONNECT 7.00 (40)

BR0805I Start of BRCONNECT processing: ceeuhjzs.sta 2010-12-16 07.05.12

BR0484I BRCONNECT log file: /oracle/TST/sapcheck/ceeuhjzs.sta

BR0613E Database instance TST is shut down

BR0806I End of BRCONNECT processing: ceeuhjzs.sta 2010-12-16 07.05.12

BR0280I BRCONNECT time stamp: 2010-12-16 07.05.12

BR0804I BRCONNECT terminated with errors

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

Regards

Former Member · ‎12-15-2010

Dear Juan

Please help me to adjust this issue

Am not a Pro Linux

Regards

Former Member · ‎12-15-2010

Dear Juan

oratst:x:502

orasid does not exist in the CI /DI ? -> YES

I will post /etc/group as follows:

/etc/group on CI Server (Server A)

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

root:x:0:root

bin:x:1:root,bin,daemon

daemon:x:2:root,bin,daemon

sys:x:3:root,bin,adm

adm:x:4:root,adm,daemon

tty:x:5:

disk:x:6:root

lp:x:7:daemon,lp

mem:x:8:

kmem:x:9:

wheel:x:10:root

mail:x:12:mail

news:x:13:news

uucp:x:14:uucp

man:x:15:

games:x:20:

gopher:x:30:

dip:x:40:

ftp:x:50:

lock:x:54:

nobody:x:99:

users:x:100:

nscd:x:28:

floppy:x:19:

vcsa:x:69:

audio:x:63:gdm

utmp:x:22:

rpc:x:32:

mailnull:x:47:

smmsp:x:51:

pcap:x:77:

utempter:x:35:

slocate:x:21:

sshd:x:74:

rpcuser:x:29:

nfsnobody:x:4294967294:

dbus:x:81:

avahi:x:70:

haldaemon:x:68:

avahi-autoipd:x:101:

ntp:x:38:

xfs:x:43:

gdm:x:42:

sabayon:x:86:

oprofile:x:16:

stapdev:x:102:

stapusr:x:103:

screen:x:84:

sapfes:x:500:

sapinst:x:501:root,tstadm

sapsys:x:502:

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

/etc/group on Datbase Server (Server B)

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

root:x:0:root

bin:x:1:root,bin,daemon

daemon:x:2:root,bin,daemon

sys:x:3:root,bin,adm

adm:x:4:root,adm,daemon

tty:x:5:

disk:x:6:root

lp:x:7:daemon,lp

mem:x:8:

kmem:x:9:

wheel:x:10:root

mail:x:12:mail

news:x:13:news

uucp:x:14:uucp

man:x:15:

games:x:20:

gopher:x:30:

dip:x:40:

ftp:x:50:

lock:x:54:

nobody:x:99:

users:x:100:

nscd:x:28:

floppy:x:19:

vcsa:x:69:

audio:x:63:gdm

utmp:x:22:

rpc:x:32:

mailnull:x:47:

smmsp:x:51:

pcap:x:77:

utempter:x:35:

slocate:x:21:

sshd:x:74:

rpcuser:x:29:

nfsnobody:x:4294967294:

dbus:x:81:

avahi:x:70:

haldaemon:x:68:

avahi-autoipd:x:101:

ntp:x:38:

xfs:x:43:

gdm:x:42:

sabayon:x:86:

oprofile:x:16:

stapdev:x:102:

stapusr:x:103:

screen:x:84:

sapfes:x:500:

sapinst:x:501:root,tstadm,oratst,sgwadm

sapsys:x:502:tstadm

dba:x:503:tstadm

oper:x:504:tstadm,oratst

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

Please help me to resolve this issue

Regards

Former Member · ‎12-15-2010

Dear Juan

I do not know user ID 502, I post /etc/passwd as follows:

/etc/passwd on Database Server (Server B)

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

root:x:0:0:root:/root:/bin/bash

bin:x:1:1:bin:/bin:/sbin/nologin

daemon:x:2:2:daemon:/sbin:/sbin/nologin

adm:x:3:4:adm:/var/adm:/sbin/nologin

lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin

sync:x:5:0:sync:/sbin:/bin/sync

shutdown:x:6:0:shutdown:/sbin:/sbin/shutdown

halt:x:7:0:halt:/sbin:/sbin/halt

mail:x:8:12:mail:/var/spool/mail:/sbin/nologin

news:x:9:13:news:/etc/news:

uucp:x:10:14:uucp:/var/spool/uucp:/sbin/nologin

operator:x:11:0:operator:/root:/sbin/nologin

games:x:12:100:games:/usr/games:/sbin/nologin

gopher:x:13:30:gopher:/var/gopher:/sbin/nologin

ftp:x:14:50:FTP User:/var/ftp:/sbin/nologin

nobody:x:99:99:Nobody:/:/sbin/nologin

nscd:x:28:28:NSCD Daemon:/:/sbin/nologin

vcsa:x:69:69:virtual console memory owner:/dev:/sbin/nologin

rpc:x:32:32:Portmapper RPC user:/:/sbin/nologin

mailnull:x:47:47::/var/spool/mqueue:/sbin/nologin

smmsp:x:51:51::/var/spool/mqueue:/sbin/nologin

pcap:x:77:77::/var/arpwatch:/sbin/nologin

sshd:x:74:74:Privilege-separated SSH:/var/empty/sshd:/sbin/nologin

rpcuser:x:29:29:RPC Service User:/var/lib/nfs:/sbin/nologin

nfsnobody:x:4294967294:4294967294:Anonymous NFS User:/var/lib/nfs:/sbin/nologin

dbus:x:81:81:System message bus:/:/sbin/nologin

avahi:x:70:70:Avahi daemon:/:/sbin/nologin

haldaemon:x:68:68:HAL daemon:/:/sbin/nologin

avahi-autoipd:x:100:101:avahi-autoipd:/var/lib/avahi-autoipd:/sbin/nologin

ntp:x:38:38::/etc/ntp:/sbin/nologin

xfs:x:43:43:X Font Server:/etc/X11/fs:/sbin/nologin

gdm:x:42:42::/var/gdm:/sbin/nologin

sabayon:x:86:86:Sabayon user:/home/sabayon:/sbin/nologin

oprofile:x:16:16:Special user account to be used by OProfile:/home/oprofile:/sbin/nologin

sapfes:x:500:500::/home/sapfes:/bin/bash

tstadm:x:501:502:SAP System Administrator:/home/tstadm:/bin/csh

oratst:x:502:503:SAP Database Administrator:/oracle/TST:/bin/csh

sgwadm:x:503:502:SAP System Administrator:/home/sgwadm:/bin/csh

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

/etc/passwd on CI Server (Server A)

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

root:x:0:0:root:/root:/bin/bash

bin:x:1:1:bin:/bin:/sbin/nologin

daemon:x:2:2:daemon:/sbin:/sbin/nologin

adm:x:3:4:adm:/var/adm:/sbin/nologin

lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin

sync:x:5:0:sync:/sbin:/bin/sync

shutdown:x:6:0:shutdown:/sbin:/sbin/shutdown

halt:x:7:0:halt:/sbin:/sbin/halt

mail:x:8:12:mail:/var/spool/mail:/sbin/nologin

news:x:9:13:news:/etc/news:

uucp:x:10:14:uucp:/var/spool/uucp:/sbin/nologin

operator:x:11:0:operator:/root:/sbin/nologin

games:x:12:100:games:/usr/games:/sbin/nologin

gopher:x:13:30:gopher:/var/gopher:/sbin/nologin

ftp:x:14:50:FTP User:/var/ftp:/sbin/nologin

nobody:x:99:99:Nobody:/:/sbin/nologin

nscd:x:28:28:NSCD Daemon:/:/sbin/nologin

vcsa:x:69:69:virtual console memory owner:/dev:/sbin/nologin

rpc:x:32:32:Portmapper RPC user:/:/sbin/nologin

mailnull:x:47:47::/var/spool/mqueue:/sbin/nologin

smmsp:x:51:51::/var/spool/mqueue:/sbin/nologin

pcap:x:77:77::/var/arpwatch:/sbin/nologin

sshd:x:74:74:Privilege-separated SSH:/var/empty/sshd:/sbin/nologin

rpcuser:x:29:29:RPC Service User:/var/lib/nfs:/sbin/nologin

nfsnobody:x:4294967294:4294967294:Anonymous NFS User:/var/lib/nfs:/sbin/nologin

dbus:x:81:81:System message bus:/:/sbin/nologin

avahi:x:70:70:Avahi daemon:/:/sbin/nologin

haldaemon:x:68:68:HAL daemon:/:/sbin/nologin

avahi-autoipd:x:100:101:avahi-autoipd:/var/lib/avahi-autoipd:/sbin/nologin

ntp:x:38:38::/etc/ntp:/sbin/nologin

xfs:x:43:43:X Font Server:/etc/X11/fs:/sbin/nologin

gdm:x:42:42::/var/gdm:/sbin/nologin

sabayon:x:86:86:Sabayon user:/home/sabayon:/sbin/nologin

oprofile:x:16:16:Special user account to be used by OProfile:/home/oprofile:/sbin/nologin

sapfes:x:500:500::/home/sapfes:/bin/bash

tstadm:x:501:502:SAP System Administrator:/home/tstadm:/bin/csh

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

I tried with "brconnect -u tstadm/sapadmin1 -c -f stats -t system_stats" commans on CI server

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

BR0801I BRCONNECT 7.00 (40)

BR0251E Function getpwuid() failed at location BrEnvProcess-79

BR1247E No password entry found for user ID 502

BR0806I End of BRCONNECT processing: ceeuheod.log 2010-12-16 06.03.51

BR0280I BRCONNECT time stamp: 2010-12-16 06.03.51

BR0804I BRCONNECT terminated with errors

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

Regards

Former Member · ‎12-15-2010

Dear Juan

while standing on /sapmnt/SID/exe of Server A and Server C -> run "brconnect -u / -c -f stats -t system_stats" command failed with error :

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

BR0801I BRCONNECT 7.00 (40)

BR0152E Environment variable ORACLE_HOME is not set

BR0806I End of BRCONNECT processing: ceeuhbqb.log 2010-12-16 05.30.53

BR0280I BRCONNECT time stamp: 2010-12-16 05.30.53

BR0804I BRCONNECT terminated with errors

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

With errors above, I assigned ORACEL_HOME with command on Server A :

central:tstadm 43> setenv ORACLE_HOME /oracle/TST/102_64

and with new error :

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

BR0801I BRCONNECT 7.00 (40)

BR0251E Function getpwuid() failed at location BrEnvProcess-79

BR1247E No password entry found for user ID 502

BR0806I End of BRCONNECT processing: ceeuhcfc.log 2010-12-16 05.37.24

BR0280I BRCONNECT time stamp: 2010-12-16 05.37.24

BR0804I BRCONNECT terminated with errors

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

In the previous post, I discussed this issue, II restated as follows :

I had installed Standalone Gateway Instance on my database host (Server B) with Gateway Host is database.fes.com.vn and Gateway Service is sapgw03 -> I assigned Gateway Host and Gateway Service into Technical Setting tab of SAPXPG_DBDEST_DATABASE connection -> test connection OK

Regards

Former Member · ‎12-15-2010

Dear Juan

maybe you do not understand me. I restated as follows:

Dear Juan

I have three server and I had installed with HA Options as belows

Server B -> installed ASCS & Database

On server B => i have ora<sid> user of DB Instance and <sid>adm user of ASCS instance.

With ora<sid> when execute "brconnect -u / -c -f stats -t system_stats" command at OS level -> brconnect succussfully

With <sid>adm of ACSC, when execute "brconnect -u / -c -f stats -t system_stats" command at OS level -> brconnect succussfully

Server A -> installed CI

On server A => I have <sid>adm user of CI instance at OS level

With <sid>adm of CI, when execute "brconnect -u / -c -f stats -t system_stats" command at OS level -> brconnect failed

Server C -> installed DI

On server C => I have <sid>adm user of DI instance at OS level

With <sid>adm of DI, when execute "brconnect -u / -c -f stats -t system_stats" command at OS level -> brconnect failed

Regards

Former Member · ‎12-15-2010

Dear Juan

I think Ok, Please you see details when i run at OS Level on database host

database:ora<SID> 26> brconnect -u / -c -f stats -t system_stats

BR0801I BRCONNECT 7.00 (40)

BR0805I Start of BRCONNECT processing: ceeugsqt.sta 2010-12-16 03.49.47

BR0484I BRCONNECT log file: /oracle/TST/sapcheck/ceeugsqt.sta

BR0280I BRCONNECT time stamp: 2010-12-16 03.49.48

BR0807I Name of database instance: TST

BR0808I BRCONNECT action ID: ceeugsqt

BR0809I BRCONNECT function ID: sta

BR0810I BRCONNECT function: stats

BR0812I Database objects for processing: SYSTEM_STATS

BR0997I System statistics will be collected with 'NOWORKLOAD' option

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRCONNECT time stamp: 2010-12-16 03.49.48

BR0992I Starting collection of system statistics...

BR0280I BRCONNECT time stamp: 2010-12-16 03.52.41

BR0993I Collection of system statistics completed

BR0806I End of BRCONNECT processing: ceeugsqt.sta 2010-12-16 03.52.41

BR0280I BRCONNECT time stamp: 2010-12-16 03.52.41

BR0802I BRCONNECT completed successfully

Extra information :

database:<SID>adm 34> brconnect -u / -c -f stats -t system_stats (on database host at OS level) -> successfully too

Regards

Former Member · ‎12-15-2010

Dear Juan

I have three server and I had installed with HA Options as belows

Server B -> ASCS & Database

Server A -> CI

Server C -> DI

Extra information:

Server B -> installed ASCS & Database -> Thus, I have exported a mount point (includes: /sapmnt/<SID>/exe, /usr/sap, /home) on my database server (server B) and have mounted from server A and server C to (/sapmnt/<sid>/exe,/usr/sap,/home) of server B => the same kernel on all systems

This problem occurred on both (CI and DI)

Thanks and regards

Former Member · ‎12-15-2010

Dear

please help me to resolve

Former Member · ‎12-15-2010

Dear experts

Please help me

Former Member · ‎12-14-2010

Dear experts

logs of dev_cp

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

Trace file of control program (trace level 3)

< Function: BtcTrcInit> Function: main SAPXPG 720

2010-12-15--16-41-32 : Before BtcXpgDetach

> Function: BtcXpgDetach Can't detach from process group (already leader)

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

2010-12-15--16-41-32 : Before RfcAccept

2010-12-15--16-41-32 : RfcAccept returned OK

Begin of check_if_security_list

security check switched OFF

End of check_if_security_list

Begin of check_trace_option

End of check_trace_option

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

2010-12-15--16-41-32 : Before first call of RFCDispatch

Security: rfcexec_logon_check

rfcexec_logon_check: logon_user = BASIS01

sapxpg_logon_check: rfc_attr.user = BASIS01

rfcexec_logon_check: client = 001

> Function: BtcXpgStartXpgLong

2010-12-15--16-41-32 : 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 = <0>

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

tracecntl = : 0

Program argument string: -u / -jid STATS20101215164132 -c -f stats -t ALL

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

parameter number 2:

Scanned parameter: /

parameter number 3:

Scanned parameter: -jid

parameter number 4:

Scanned parameter: STATS20101215164132

parameter number 5:

Scanned parameter: -c

parameter number 6:

Scanned parameter: -f

parameter number 7:

Scanned parameter: stats

parameter number 8:

Scanned parameter: -t

parameter number 9:

Scanned parameter: ALL

Total number of arguments scanned: 9

Argument argv[0]: brconnect

< 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 > Function: BtcTrcInit Process id: 9723

Parent process id: 779

< Function: BtcXpgStart Start status of external program: external program successfully started

Id of external process: 0000009724

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

2010-12-15--16-41-32 : End of BtcXpgStartXpgLong

< Function: BtcXpgStartXpgLong

2010-12-15--16-41-32 : After first call of RFCDispatch

Wait for RFC call SAPXPG_END_XPG

2010-12-15--16-41-32 : Before second call of RFCDispatch

Security: rfcexec_logon_check

rfcexec_logon_check: logon_user =

sapxpg_logon_check: rfc_attr.user = BASIS01

rfcexec_logon_check: client =

> Function: BtcXpgEndXpg

2010-12-15--16-41-32 : 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 > Function: BtcXpgLog

Log message (80 byte): > Function: BtcXpgPanicCan't exec external program (No such file or directory)

< Function: BtcXpgLog

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

2010-12-15--16-41-32 : End of BtcXpgEndXpg

< Function: BtcXpgEndXpg

2010-12-15--16-41-32 : After second call of RFCDispatch

2010-12-15--16-41-32 : After call of RfcClose (wait)

< Function: main

2010-12-15--16-41-32 : End of SAPXPG: main

Former Member · ‎12-14-2010

Dear

Please help me to resolve this issue

Former Member · ‎12-13-2010

Dear Sunil

When SM59 not successful -> DB13 with errors :

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

SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: program_start_error:For More Information, See SYS

Job cancelled after system exception ERROR_MESSAGE

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

But when SM59 successful -> DB13 with erros :

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

> Function: BtcXpgPanicCan't exec external program (No such file or

directory)

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

I think we do not resolve this problems successully

Thanks

Former Member · ‎12-13-2010

Dear Sunil

I found sapxpg file in /sapmnt/<SID>/exe at OS Level and i provided full path in SM59 as /sapmnt/SID/exe/sapxpg

Permission of sapspg at OS Level

-rwxr-xr-x 1 tstadm sapsys 4878792 Dec 14 05:03 sapxpg

P/S : You can view this thrad ->

But errors remains

Edited by: myfriend280985 on Dec 13, 2010 5:18 PM

Former Member · ‎12-13-2010

Dear Sunil

I did as your advice and error remains

Former Member · ‎12-13-2010

Dear Sunil

I have upgraded Kernel to lastest and adjusted in SM59 as /sapmnt/SID/exe/sapxpg

But not resolve this problem

sad ... very sad

can you a new solution for this problem ?

Thanks and best regards

Former Member · ‎12-13-2010

Dear Sunil

I connected to DB Hosts with ora<sid> and type "brtools" with options

BR0651I BRTOOLS 7.00 (40)

BR0280I BRTOOLS time stamp: 2010-12-14 04.46.26

BR0656I Choice menu 1 - please make a selection

-

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

I think brtools tool -> OK

I trying to update Kernel to lastest ...and then, I will feedback to you

Edited by: myfriend280985 on Dec 13, 2010 3:49 PM

Former Member · ‎12-13-2010

Dear Sunil

I have checked your note

Like i did, i tried to install Sap Gateway On database host and test Dentination Connection SAPXPG_DBDEST_DATABASE in SM59 -> successfully

and when run DB13 with error :

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

Job started

Step 001 started (program RSDBAJOB, variant &0000000000020, user ID DDIC)

No application server found on database host - rsh/gateway will be used

Execute logical command BRCONNECT On host database

Parameters: -u / -jid STATS20101214023439 -c -f stats -t ALL

> Function: BtcXpgPanicCan't exec external program (No such file or directory)

External program terminated with exit code 1

BRCONNECT returned error status E

Job finished

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

Not like old errors before

Former Member · ‎12-13-2010

Dear Sunil

Yes, Destination Connection RFC TCP SAPXPG_DBDEST_DATABASE was created automatically and i just assign gateway host and gateway service in Technical Setting tab of this RFC (I do not change anythings)

Former Member · ‎12-13-2010

Dear Sunil

What must I do with this warning?

P/S : I do the above steps correct ? etc .... install a Gateway

Please guide me

Former Member · ‎12-13-2010

Dear Sunil

My OS : Redhat 5.4 64bit

I have checked Note 446171 and found sapxpg file in /sapmnt/<SID>/exe --> Not resolve

Do I need to install Gateway on my database host ? And then, I tried to install Gateway Instance on my database host with Gateway Host is database.fes.com.vn and Gateway Service is sapgw03 -> I assigned Gateway Host and Gateway Service into Technical Setting tab of SAPXPG_DBDEST_DATABASE connection -> test connection OK

But in tcode DB13 -> display new error as below :

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

Job started

Step 001 started (program RSDBAJOB, variant &0000000000020, user ID DDIC)

No application server found on database host - rsh/gateway will be used

Execute logical command BRCONNECT On host database

Parameters: -u / -jid STATS20101214023439 -c -f stats -t ALL

> Function: BtcXpgPanicCan't exec external program (No such file or directory)

External program terminated with exit code 1

BRCONNECT returned error status E

Job finished

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

logs of dev_xpg on database host :

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

Trace file of external program (trace level 3)

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

Process id: 19082

Parent process id: 19081

Rearrange StdErr to be collected in memory

Rearrange StdOut to be collected in memory

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

logs of dev_rd on database host :

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

-

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

-

Tue Dec 14 00:46:26 2010

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

systemid 390 (AMD/Intel x86_64 with Linux)

relno 7010

patchlevel 0

patchno 32

intno 20020600

make: single threaded, Unicode, 64 bit, optimized

pid 13741

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

gateway (version=701.2009.01.21)

gw/local_addr : 0.0.0.0

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: Initalizing shared memory of size 60000000 for monitoring segment.

CCMS: Checking Downtime Configuration of Monitoring Segment.

Bind service sapgw01 (socket) to port 3301

GwPrintMyHostAddr: my host addresses are :

1 : [10.86.82.251] central.fes.com.vn (HOSTNAME)

2 : [127.0.0.1] localhost.localdomain (LOCALHOST)

Full qualified hostname = central.fes.com.vn

DpSysAdmExtCreate: ABAP is active

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

Tue Dec 14 00:46:36 2010

DpShMCreate: sizeof(wp_adm) 28032 (1752)

DpShMCreate: sizeof(tm_adm) 6009216 (29896)

DpShMCreate: sizeof(wp_ca_adm) 28800 (96)

DpShMCreate: sizeof(appc_ca_adm) 9600 (96)

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 (2008)

DpShMCreate: sizeof(wall_adm) (40056/36728/80/192)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 0x2b4136b45000, size: 6709824)

DpShMCreate: allocated sys_adm at 0x2b4136b45000

DpShMCreate: allocated wp_adm at 0x2b4136b47308

DpShMCreate: allocated tm_adm_list at 0x2b4136b4e088

DpShMCreate: allocated tm_adm at 0x2b4136b4e0e8

DpShMCreate: allocated appc_ca_adm at 0x2b41371102e8

DpShMCreate: allocated comm_adm at 0x2b4137112868

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 0x2b4137198548

DpShMCreate: allocated gw_adm at 0x2b41371985c8

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 0x2b41371985f8

MtxInit: -2 0 0

Tue Dec 14 00:46:37 2010

GwDpInit: attached to gw_adm at 0x2b41371985c8

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

Please help me to resolve

Edited by: myfriend280985 on Dec 13, 2010 1:36 PM

No connect of TP sapxpg from host database.fes.com.vn after 20 sec

Accepted Solutions (0)

Answers (32)

Answers (32)

Análise Combinatória de dados de bancos diferentes

Re: generating qrcode using image url in crystal r...

SOAMANAGER - Field Cardinality - Min Occurence - W...

Re: SWPSTEPLOG table partitioning

SWPSTEPLOG table partitioning