on 11-06-2007 2:59 AM
Hi,
Please help on our problem with SAP-BW. The disp+work stops a few minutes after starting the system. the msg_server.exe and igswd.exe are still running. This system was copied (db copy) from our bw production using backup restore.
We are on win2003, ECC5 & Oracle 9i
You can see below the log taken from the work directory.
-
trc file: "dev_w0", trc level: 1, release: "640"
-
*
ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, M
*
B
B Tue Nov 06 12:48:35 2007
B create_con (con_name=R/3)
B Loading DB library 'D:\usr\sap\AQB\SYS\exe\run\dboraslib.dll' ...
B Library 'D:\usr\sap\AQB\SYS\exe\run\dboraslib.dll' loaded
B Version of 'D:\usr\sap\AQB\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.172)
B New connection 0 created
M sysno 00
M sid AQB
M systemid 561 (PC with Windows NT)
M relno 6400
M patchlevel 0
M patchno 203
M intno 20020600
M make: multithreaded, Unicode, 64 bit
M pid 3804
M
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3804) [dpxxdisp.c 1162]
I MtxInit: -2 0 0
M DpSysAdmExtCreate: ABAP is active
M DpShMCreate: sizeof(wp_adm) 35648 (1320)
M DpShMCreate: sizeof(tm_adm) 3609968 (17960)
M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)
M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
M DpShMCreate: sizeof(comm_adm) 312000 (624)
M DpShMCreate: sizeof(vmc_adm) 0 (512)
M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
M DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000006FF0050, size: 4075376)
M DpShMCreate: allocated sys_adm at 0000000006FF0050
M DpShMCreate: allocated wp_adm at 0000000006FF1C30
M DpShMCreate: allocated tm_adm_list at 0000000006FFA770
M DpShMCreate: allocated tm_adm at 0000000006FFA7A0
M DpShMCreate: allocated wp_ca_adm at 000000000736BD10
M DpShMCreate: allocated appc_ca_adm at 0000000007371AD0
M DpShMCreate: allocated comm_adm_list at 0000000007373A10
M DpShMCreate: allocated comm_adm at 0000000007373A30
M DpShMCreate: allocated vmc_adm_list at 00000000073BFCF0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 00000000073BFD20
M DpShMCreate: allocated wall_adm at 00000000073BFD30
M ThTaskStatus: rdisp/reset_online_during_debug 0
X EmInit: MmSetImplementation( 2 ).
X <ES> client 0 initializing ....
X Using implementation flat
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M
M Tue Nov 06 12:48:36 2007
M calling db_connect ...
C Prepending D:\oracle\AQB\920 to Path.
C got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment
C Client NLS settings: AMERICAN_AMERICA.UTF8
C Logon as OPS$-user to get SAPAQB's password
C Connecting as /@AQB on connection 0 (nls_hdl 0) ... (dbsl 640 010307)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 000006FBF9E82CC0 000006FBF9E8AB50 000006FBF9E8A488
C Attaching to DB Server AQB (con_hdl=0,svchp=000006FBF9E8A358,srvhp=000006FBD1616B88)
C Starting user session (con_hdl=0,svchp=000006FBF9E8A358,srvhp=000006FBD1616B88,usrhp=000006FBD161F618)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
[dboci.c 4502]
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 11332]
C Try to connect with default password
C Connecting as SAPAQB/<pwd>@AQB on connection 0 (nls_hdl 0) ... (dbsl 640 010307)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 000006FBF9E82CC0 000006FBF9E8AB50 000006FBF9E8A488
C Starting user session (con_hdl=0,svchp=000006FBF9E8A358,srvhp=000006FBD1616B88,usrhp=000006FBD161F618)
C Now 'SAPAQB/<pwd>@AQB' is connected (con_hdl 0, nls_hdl 0).
C Database NLS settings: AMERICAN_AMERICA.UTF8
C DB instance AQB is running on S11Q001B with ORACLE version 9.2.0.5.1 since NOV 05, 2007, 15:19:09
B Connection 0 opened (DBSL handle 0)
B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost
B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20071106 124836 S11Q001B
B ***LOG BZA=> table SVERS does not exist on database [dblink#3 @ 1280] [dblink 1280 ]
M ***LOG R19=> tskh_init, db_connect ( DB-Connect 004096) [thxxhead.c 1280]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9621]
M
M Info for wp 0
M
M stat = 4
M reqtype = 1
M act_reqtype = -1
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source = 255
M last_tid = 0
M last_mode = 0
M int_checked_resource(RFC) = 0
M ext_checked_resource(RFC) = 0
M int_checked_resource(HTTP) = 0
M ext_checked_resource(HTTP) = 0
M report = > <
M action = 0
M tab_name = > <
M
M *****************************************************************************
M *
M * LOCATION SAP-Server BWQA_QAS_00 on host BWQA (wp 0)
M * ERROR tskh_init: db_connect
M *
M * TIME Tue Nov 06 12:48:36 2007
M * RELEASE 640
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 9806
M * COUNTER 1
M *
M *****************************************************************************
M
M PfStatDisconnect: disconnect statistics
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 255]
M Entering ThSetStatError
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3804) [dpnttool.c 357]
Got it. The problem was due to the environment variable DBS_ORA_SCHEMA.
The system is now running.
Points will still be awarded for your effort.
kbas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks for your reply.
Actually, the first problem was on this lines.
Logon as OPS$-user to get SAPAQB's password
C Connecting as /@AQB on connection 0 (nls_hdl 0) ... (dbsl 640 010307)
It originally was an error until I manually created the user SAPAQB in oracle. I was not sure if it is the right action for the error.
The system was a copy from system id APB. the target system was AQB.
rgds,
kbas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
OPS$ problem can be ignored for the time bieng coz it is able to connect with default password.
"Now 'SAPAQB/<pwd>@AQB' is connected"
Main problem looks like its here,
Table SVERS does not exist on database!
Please check env variable dbs_ora_schema. Has it been set correctly? - Note 534765
Also see Note 530392
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bas,
looks like some problem with ops$ usr
check notes 400241 and 361641
Thanks
Prince Jose
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.