on 01-25-2012 2:06 PM
Dear All,
In our production system, we are unable to execute database jobs successfully in TCode DB13.
System Landscape :
SAP NetWeaver 7.01
SAP Application server host OS : Solaris
SAP Database Server host OS : HP-unix
Database : Oracle 10.2
We are using distributed model where SAP Application instance running on different server and database instance running on different server.
Database jobs " Check Database" and "Update Static" scheduled via DB13 are getting failed. I found that background jobs scheduled by DB13 are getting failed.
Error : 1005 when executing external command brconnect on SAPXPG_DBDEST_<DB Host> (xpgid=0,convid=.)
I found that RFC SAPXPG_DBDEST_<DB Host> is not working as this RFC execute the BRTOOL function on Database host.
Error in RFC :
Logon Connection Error
Error Details Error when opening an RFC connection
Error Details ERROR: SAP gateway connection failed. Is SAP gateway started?
Error Details LOCATION: SAP-Server <SAP Application host>_<SID>_20 on host <SAP Application host> (wp 0)
Error Details COMPONENT: CPIC
Error Details COUNTER: 61
Error Details MODULE:
Error Details LINE:
Error Details RETURN CODE: 236
Error Details SUBRC: 0
Error Details RELEASE: 701
Error Details TIME: Wed Jan 25 08:39:08 2012
Error Details VERSION:
On SAP Application host following Gateway service is running:
bwpadm 4581 4577 0 Jan 22 ? 0:59 gwrd -dp pf=/usr/sap/BWP/SYS/profile/BWP_DVEBMGS20_psapp08
But there is no Gateway service is running on database host.
Do we need to have SAP Gateway service on Database host as well.
Please analyze this problem and help me.
Thanks
Abhishek
Hi Abhishek
This is a very common issue of HA or distributed systems. A basis search in the forum could have helped you by now.
Refer to this link
http://wiki.sdn.sap.com/wiki/display/Basis/InstallationofSAPgatewayservicesinMSCS+cluster
though it is for MSCS, you can get the general idea on how to do this on Unix.
Cheers!
Javed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Deepak and Javed,
We encounter with this error after OS patching of our Database server. Before OS patching, this functionality was working fine i.e. RFC was working fine.
Means SAP Gateway service already installed on DB server , only we need to activate the service.
On DB server , gwrd executable file is available in path : /usr/sap/BWD/SYS/exe/run
Could you please let me know the command to activate it.
Thanks,
Abhishek
Thanks Rajesh,
But after executing command I got error :
-
hpdbo03:orabwp 7> gwrd -dp pf=/usr/sap/BWP/SYS/profile/BWP_DVEBMGS20_PHSDBO03
rename (dev_rd -> dev_rd.old) failed: errno = 13
ERROR => CTrcOpen: fopen dev_rd
-
trc file: "dev_rd", trc level: 1, release: "701"
-
Fri Jan 27 05:34:16 2012
ERROR => GwInitPrf failed 104 [gwxxrd.c 1635]
***LOG S00=> GwInitReader, gateway started ( 25829) [gwxxrd.c 1759]
sapcscsa: SCSA defined. sapscsaId == 327687 == 00050007
sapcscsa: SCSA attached at address c0000000004ad000
sapcscsa: SCSA initialized.
rslgwr1(21): Searching for overlap point in pre-existing SysLog file...
/usr/sap/BWP/DVEBMGS20/log/SLOG20: Permission denied
rslgwr1(11): rstrbopen cannot open SysLog file.
SysLog:iE1020120127053416002583200000sapts/0 orabwp
: sapmscsa 0000
:SCSA 4096
/usr/sap/BWP/SYS/exe/run/sapmscsa: finished.
/usr/sap/BWP/DVEBMGS20/log/SLOG20: Permission denied
rslgwr1(11): rstrbopen cannot open SysLog file.
SysLog:mS0020120127053416002582900000RD
: 0
: 25829 GwInitRgatewaygwxxrd.c1759
systemid 274 (HP (IA-64) with HP-UX)
relno 7010
patchlevel 0
patchno 127
intno 20020600
make: single threaded, ASCII, 64 bit, optimized
pid 25829
gateway runs with dp version 245(ext=110) (@(#) DPLIB-INT-VERSION-245)
gateway (version=701.2010.11.29)
gw/reg_no_conn_info = 0
gw/local_addr : 0.0.0.0
Profile configuration error detected, use temporary corrected setup
Shared Pool 10: ipc/shm_psize_10 = 19880000 (too small)
Shared Pool 10: (smaller than min requirement 104190616)
Shared Pool 10: (estimated size assumed 108000000)
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
CCMS: Initalizing shared memory of size 40000000 for monitoring segment.
CCMS: Checking Downtime Configuration of Monitoring Segment.
Fri Jan 27 05:34:17 2012
Bind service sapgw20 (socket) to port 3320
GwIRegInitRegInfo: reg_info file /usr/sap/BWP/DVEBMGS20/data/reginfo not found
ERROR => failed to open gw_log-2012-01-27 (Permission denied) [gwxxlog.c 800]
GwPrintMyHostAddr: my host addresses are :
1 : [10.142.196.19] phsdbo03.pld.aig.com (HOSTNAME)
2 : [127.0.0.1] localhost (LOCALHOST)
3 : [10.142.182.212] phpdbo03-hb.pld.aig.com (NILIST)
4 : [10.142.197.18] phpdbo03-bkp.pld.aig.com (NILIST)
5 : [10.142.196.18] phpdbo03.pld.aig.com (NILIST)
6 : [10.142.197.19] phsdbo03-bkp.pld.aig.com (NILIST)
Full qualified hostname = phsdbo03.pld.aig.com
ERROR => DpSysAdmExtCreate: ShmCreate (ATTACH) failed (3) [dpxxtool2.c 652]
ERROR => DpIPCInit2: DpSysAdmExtCreate [dpxxtool2.c 369]
ERROR => CCMS: MsDownload: could not open file /usr/sap/BWP/DVEBMGS20/log/ALMTTREE for write. [alxxload.c 3746]
***LOG S0V=> GwStopGateway, gateway stopped () [gwxxrd.c 15082]
SysLog:mS0V20120127053417002582900000RD
: 0
: GwStopGgatewaygwxxrd.c1508
-
I need your analysis on this error log.
Please help me.
Thanks,
Abhishek
I nee
Dear All,
After login with <SID>adm I try to start Gateway service with following command :
gwrd -dp pf=/usr/sap/BWD/SYS/profile/BWD_DVEBMGS20_DHSDBO03
But no luck
when I checked the trace file dev_rd , I found the following
-
trc file: "dev_rd", trc level: 1, release: "701"
-
Fri Feb 3 00:16:07 2012
ERROR => GwInitPrf failed 104 [gwxxrd.c ; 1635]
***LOG S00=> GwInitReader, gateway started ( 27350) [gwxxrd.c ; 1759]
systemid 274 (HP (IA-64) with HP-UX)
relno 7010
patchlevel 0
patchno 117
intno 20020600
make: single threaded, ASCII, 64 bit, optimized
pid 27350
gateway runs with dp version 244(ext=110) (@(#) DPLIB-INT-VERSION-244)
gateway (version=701.2010.10.27)
gw/reg_no_conn_info = 0
gw/local_addr : 0.0.0.0
Profile configuration error detected, use temporary corrected setup
Shared Pool 10: ipc/shm_psize_10 = 19880000 (too small)
Shared Pool 10: (smaller than min requirement 104190616)
Shared Pool 10: (estimated size assumed 108000000)
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
Bind service sapgw20 (socket) to port 3320
GwIRegInitRegInfo: reg_info file /usr/sap/BWD/DVEBMGS20/data/reginfo not found
GwPrintMyHostAddr: my host addresses are :
1 : [10.142.196.49] dhsdbo03.pld.aig.com (HOSTNAME)
2 : [127.0.0.1] localhost (LOCALHOST)
3 : [10.142.182.213] dhpdbo03-hb.pld.aig.com (NILIST)
4 : [10.142.197.48] dhpdbo03-bkp.pld.aig.com (NILIST)
5 : [10.142.196.48] dhpdbo03.pld.aig.com (NILIST)
6 : [10.142.197.49] dhsdbo03-bkp.pld.aig.com (NILIST)
Full qualified hostname = dhsdbo03.pld.aig.com
ERROR => DpSysAdmExtCreate: ShmCreate (ATTACH) failed (3) [dpxxtool2.c ; 652]
ERROR => DpIPCInit2: DpSysAdmExtCreate [dpxxtool2.c ; 369]
***LOG S0V=> GwStopGateway, gateway stopped () [gwxxrd.c ; 15080]
-
Please analyze and give your suggestion.
Thanks,
Abhishek
Hi,
You need to install the standalone gateway to get connected between the two system for doing the db13 activities. Related notes available in support site.
Regards
D.Mukunthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear All,
Thanks to all.
My issue got resolved in Development server. I was able to start gateway service with command 'gwrd -force pf=<> & '.
But with same command I am unable to start gateway service in Production box.
when I checked the log in dev_rd file :
-
-
trc file: "dev_rd", trc level: 1, release: "701"
-
Fri Feb 17 00:52:21 2012
***LOG S00=> GwInitReader, gateway started ( 4768) [gwxxrd.c 1759]
systemid 274 (HP (IA-64) with HP-UX)
relno 7010
patchlevel 0
patchno 127
intno 20020600
make: single threaded, ASCII, 64 bit, optimized
pid 4768
gateway runs with dp version 245(ext=110) (@(#) DPLIB-INT-VERSION-245)
gateway (version=701.2010.11.29)
gw/reg_no_conn_info = 0
gw/local_addr : 0.0.0.0
switch off alert monitoring
Bind service sapgw20 (socket) to port 3320
ERROR => e=13 semctl(2015259,0,SETVAL,(1..)) (13: Permission denied) [semux.c 1611]
***LOG S06=> GwInitShTbl, SemInit ( 01) [gwxxtool.c 1692]
***LOG S07=> GwInitReader, GwInitShTbl () [gwxxrd.c 2034]
ERROR => try "gwrd -a" to attach to existing segments [gwxxrd.c 2040]
-
Please help me.
Thanks,
Abhishek
Hi Abhishek,
You need to have SAP gateway installed on the DB host for DB13 jobs to run successfully in a distributed environment.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.