Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

32 Answers

  • avatar image
    Former Member
    Dec 13, 2010 at 11:53 AM

    Hi,

    Please check the Note 446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13

    Check and revert.

    Regards,

    Sharath

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 13, 2010 at 11:56 AM

    You sure that you can find the sapxpg file on your database server undr /sapmnt/<SID>/exe

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 13, 2010 at 12:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 13, 2010 at 01:02 PM

    Dear Sunil

    What must I do with this warning?

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

    Please guide me

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      what are the automatically create RFC destination in you systems for SAPXPG_DBDEST_<x> RFC destination?

      You sure that the SAPXPG_DBDEST_<server_B> destination has correct details?

  • avatar image
    Former Member
    Dec 13, 2010 at 01:34 PM

    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)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 13, 2010 at 02:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Can you please go to DB server and execute brtools command. Looks like you have not extracted the brtools tool.

  • avatar image
    Former Member
    Dec 13, 2010 at 02:47 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I don't thnk so your problem will resolve after kernel upgrade as you are getting below error:

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

      Can you give the full path of your program in SM59 as /sapmnt/<SID>/exe/sapxpg and try.

  • avatar image
    Former Member
    Dec 13, 2010 at 03:48 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      The same I mentioned in my previous reply, can you also try the alternative which I have given earlier as

      provide the full path of your program in SM59 as /sapmnt/<SID>/exe/sapxpg and try.

  • avatar image
    Former Member
    Dec 13, 2010 at 04:06 PM

    Dear Sunil

    I did as your advice and error remains

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hm! mean the sapxpg file is not under /sapmnt/<SID>/exe please check and confim on your database server.

      /sapmnt/<SID>/exe/sapxpg

      Also what are the permission for this file?

  • avatar image
    Former Member
    Dec 13, 2010 at 04:17 PM

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

    db13-does-not-work-with-cluster-in-different-node

    But errors remains

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      The other thread you mentioned is for permission denied issue.

      As you mentioned your SM59 connection is successful then you DB13 jobs should work.