on 12-03-2013 7:52 AM
Hi All,
I have installed IDES in my system with NW 7.0 a long back.When i start the server through SAP MMC ,the left side tree was hidden.After reading some threads in forum , i got to know that SAP service is stopped.Installed the service using the command sapstartsrv.exe.To install the service i have given following details in the popup .
SID = ECC
NR = 00
profile path = chosen from profile folder
uname = ./SAPservice<SID>/<Myusername>
Pword = <logon password>
Now am able to see tree left side.But when i start the server ,all tree items turn Yellow but not able to see WP Table entries right side.
Being not a basis guy,i could not identify what was the issue.Am i giving correct values for creating service?please help me out regarding this.
Thanks
Naresh Bammidi
Hi Naresh,
Please paste the dev_w0 logs from /usr/sap/SID/DVEBMGS00/work
regards
kartik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Karthikeyan,
There is nothing in the dev_w0 file.It is empty.when i install the service with out giving uname and password,i could see some log in Dev_w0.
Below is the dev_disp trace
---------------------------------------------------
trc file: "dev_disp", trc level: 1, release: "700"
---------------------------------------------------
sysno 00
sid ECC
systemid 560 (PC with Windows NT)
relno 7000
patchlevel 0
patchno 75
intno 20050900
make: multithreaded, Unicode, optimized
pid 452
Sun Dec 01 17:38:17 2013
kernel runs with dp version 217000(ext=109000) (@(#) DPLIB-INT-VERSION-217000-UC)
length of sys_adm_ext is 572 bytes
*** SWITCH TRC-HIDE on ***
***LOG Q00=> DpSapEnvInit, DPStart (00 452) [dpxxdisp.c 1237]
shared lib "dw_xml.dll" version 75 successfully loaded
shared lib "dw_xtc.dll" version 75 successfully loaded
shared lib "dw_stl.dll" version 75 successfully loaded
shared lib "dw_gui.dll" version 75 successfully loaded
shared lib "dw_mdm.dll" version 75 successfully loaded
rdisp/softcancel_sequence : -> 0,5,-1
use internal message server connection to port 3900
Sun Dec 01 17:38:23 2013
*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds
***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 5273]
MtxInit: 30000 0 0
DpSysAdmExtInit: ABAP is active
DpSysAdmExtInit: VMC (JAVA VM in WP) is not active
DpIPCInit2: start server >gcecc62_ECC_00 <
DpShMCreate: sizeof(wp_adm) 18304 (1408)
DpShMCreate: sizeof(tm_adm) 3994272 (19872)
DpShMCreate: sizeof(wp_ca_adm) 24000 (80)
DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064
DpShMCreate: sizeof(comm_adm) 528064 (1048)
DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
DpShMCreate: sizeof(file_adm) 0 (72)
DpShMCreate: sizeof(vmc_adm) 0 (1440)
DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)
DpShMCreate: sizeof(gw_adm) 48
DpShMCreate: SHM_DP_ADM_KEY (addr: 067E0040, size: 4653368)
DpShMCreate: allocated sys_adm at 067E0040
DpShMCreate: allocated wp_adm at 067E1E40
DpShMCreate: allocated tm_adm_list at 067E65C0
DpShMCreate: allocated tm_adm at 067E65F0
DpShMCreate: allocated wp_ca_adm at 06BB5890
DpShMCreate: allocated appc_ca_adm at 06BBB650
DpShMCreate: allocated comm_adm at 06BBD590
DpShMCreate: system runs without file table
DpShMCreate: allocated vmc_adm_list at 06C3E450
DpShMCreate: allocated gw_adm at 06C3E490
DpShMCreate: system runs without vmc_adm
DpShMCreate: allocated ca_info at 06C3E4C0
DpShMCreate: allocated wall_adm at 06C3E4C8
MBUF state OFF
DpCommInitTable: init table for 500 entries
EmInit: MmSetImplementation( 2 ).
MM global diagnostic options set: 0
<ES> client 0 initializing ....
<ES> InitFreeList
<ES> block size is 1024 kByte.
Using implementation flat
<EsNT> Memory Reset disabled as NT default
<ES> 511 blocks reserved for free list.
ES initialized.
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c 1623]
Sun Dec 01 17:38:24 2013
***LOG Q0K=> DpMsAttach, mscon ( gcecc62) [dpxxdisp.c 11586]
DpStartStopMsg: send start message (myname is >gcecc62_ECC_00 <)
DpStartStopMsg: start msg sent
CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.
CCMS: Initalizing shared memory of size 60000000 for monitoring segment.
Thanks
Naresh Bammidi
Hi Naresh
1. Just restart the windows system and then check the SAP system.
2. You can find the two files in \usr\sap\SID\devebmgsxx\exe\SAPSTARTSRV.*. before that stop the SAPSIDXX service in windows services
rename the sapstartsrv.exe to old_sapstartsrv.exe
rename the sapstartsrv.exe.new to sapstartsrv.exe
3. You kernel level are low better you can upgrade the kernel at the latest
Regards
Sriram
Karthikeyan,
last line in the dev_disp i could see is
CCMS: Initalizing shared memory of size 60000000 for monitoring segment.
i am pretty sure that i did not miss even a single line from the log file .
while installing service through the sapstartsrv.exe command,what to give as user name ? I have given user name as ./SAPservice<SID>/<Myusername>
Is this the right user name?
Thanks
Naresh Bammidi
Sriram,
The ID which is showing in log on tab is what i gave while installing the service.I gave the uname as ./SAPservice<SID>/<Myusername>.Is this the correct Uname? Karthikeyan suggesting the different way that where i need to include domain name as domain\SAPService<SID>.Which domain name i have to include there?How to find it out?Is giving User ID mandatory?
Thanks
Naresh Bammidi
Thank you all for your valuable inputs,
Server is not getting started because i passed wrong user name to install the SAP service.But i really don't know what to give as user name.When i start the server through SAP MMC one pop up is coming to enter password.Uname (ECECC62/<SID>adm) is getting populated automatically.I took the username from console and installed the service again then my problem got resolve.
Thanks
Naresh Bammidi
Message was edited by: Naresh Bammidi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Naresh,
Did you put the correct parameters when you used the command sapstartsrv.exe?
There could be a possibility that the parameters are a mismatch.
Then restart the SAP services.
Thanks,
Sameer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi sameer,
below are the parameters which i have given.Please tell me any thing is wrong here.I am doubting username which i have given.Please let me know your inputs
SID = ECC
NR = 00
profile path = chosen from profile folder
uname = ./SAPservice<SID>/<Myusername>
Pword = <logon password>
Thanks
Naresh Bammidi
Hi Naresh,
Kindly post developer logs so that we can help you further.
Also login to the OS level using the <SID>ADM user and check whether the database is running, use the following command in the command prompt and paste the output.
r3trans -d
Cheers!
Abhishek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abhishek,
"Also login to the OS level using the <SID>ADM user and check whether the database is running,"
How can i check that whether the data base is running or not? do you mean to say Oracle service in services.msc?
If so all Oracle services and SAPECC_00 are running fine.
I have executed the r3trans -d command,below is the result.
Enter user-name: sapuser as sysdba
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> r3trans -d
SP2-0103: Nothing in SQL buffer to run.
SQL>
Thanks
Naresh
Message was edited by: Naresh Bammidi
Hi Himanshu,
Yes am using windows,Do i need to switch to sqlplus directory to execute the command?
I opened command prompt and executed the command with out switching to the sqlplus directory.
C:\Documents and Settings\eccadm>R3trans -d
This is R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).
unicode enabled version
R3trans finished (0000).
C:\Documents and Settings\eccadm>
I found the trans.log file in c:\Documents and Settings\<SID>adm directory.
4 ETW000 R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 03.12.2013 - 21:20:39
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Tue Dec 03 21:20:41 2013 1018 0.001018
4 ETW000 [dev trc ,00000] db_con_init called 44 0.001062
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 63 0.001125
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 53 0.001178
4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 54900 0.056078
4 ETW000 [dev trc ,00000] using "D:\usr\sap\ECC\SYS\exe\uc\NTI386\dboraslib.dll"
4 ETW000 56 0.056134
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 23 0.056157
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 39 0.056196
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.73)
4 ETW000 24509 0.080705
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 44 0.080749
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 57 0.080806
4 ETW000 [dev trc ,00000] New connection 0 created 39 0.080845
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 51 0.080896
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 29 0.080925
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 33 0.080958
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO
4 ETW000 43 0.081001
4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or
4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.
4 ETW000 assuming using instant client with unspecified location.
4 ETW000 7048 0.088049
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 79038 0.167087
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 46 0.167133
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 3312 0.170445
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 43 0.170488
4 ETW000 [dev trc ,00000] Connecting as /@ECC on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
4 ETW000 47 0.170535
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 448 0.170983
4 ETW000 [dev trc ,00000] 0 UTF8 1 022CB010 02C539D4 02C5325C
4 ETW000 133 0.171116
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 2027 0.173143
4 ETW000 [dev trc ,00000] Allocating server context handle 52 0.173195
4 ETW000 [dev trc ,00000] Attaching to DB Server ECC (con_hdl=0,svchp=02C531A8,svrhp=02C6465C)
4 ETW000 74 0.173269
4 ETW000 [dev trc ,00000] Assigning server context 02C6465C to service context 02C531A8
4 ETW000 69954 0.243223
4 ETW000 [dev trc ,00000] Allocating user session handle 37 0.243260
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=02C531A8,srvhp=02C6465C,usrhp=02C9FC28)
4 ETW000 59 0.243319
4 ETW000 [dev trc ,00000] Tue Dec 03 21:20:42 2013 154149 0.397468
4 ETW000 [dev trc ,00000] Assigning user session 02C9FC28 to service context 02C531A8
4 ETW000 50 0.397518
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;
4 ETW000 93 0.397611
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;
4 ETW000 123 0.397734
4 ETW000 [dev trc ,00000] Now '/@ECC' is connected (con_hdl 0, nls_hdl 0).
4 ETW000 123283 0.521017
4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY
4 ETW000 56 0.521073
4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)
4 ETW000 1217 0.522290
4 ETW000 [dev trc ,00000] Got SAPSR3's password from OPS$-user 86600 0.608890
4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 41 0.608931
4 ETW000 [dev trc ,00000] Rolling back transaction ... 29 0.608960
4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=02C531A8,usrhp=02C9FC28)
4 ETW000 484 0.609444
4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 770 0.610214
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@ECC on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
4 ETW000 46 0.610260
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 42 0.610302
4 ETW000 [dev trc ,00000] 0 UTF8 1 022CB010 02C539D4 02C5325C
4 ETW000 41 0.610343
4 ETW000 [dev trc ,00000] Assigning username to user session 02C9FC28 24 0.610367
4 ETW000 [dev trc ,00000] Assigning password to user session 02C9FC28 35 0.610402
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=02C531A8,srvhp=02C6465C,usrhp=02C9FC28)
4 ETW000 52 0.610454
4 ETW000 [dev trc ,00000] Assigning user session 02C9FC28 to service context 02C531A8
4 ETW000 15022 0.625476
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;
4 ETW000 64 0.625540
4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;
4 ETW000 88 0.625628
4 ETW000 [dev trc ,00000] Now 'SAPSR3/<pwd>@ECC' is connected (con_hdl 0, nls_hdl 0).
4 ETW000 12944 0.638572
4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY
4 ETW000 55 0.638627
4 ETW000 [dev trc ,00000] SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER IN ('NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET') ORDER BY PARAM
4 ETW000 914 0.639541
4 ETW000 [dev trc ,00000] ETER
4 ETW000 41 0.639582
4 ETW000 [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.UTF8 94981 0.734563
4 ETW000 [dev trc ,00000] SELECT UPPER(INSTANCE_NAME), HOST_NAME, VERSION, TO_CHAR (STARTUP_TIME, 'YYYYMMDD') FROM V$INSTANCE
4 ETW000 12007 0.746570
4 ETW000 [dev trc ,00000] Database instance ECC is running on GCECC62 with ORACLE version 10.2.0.2.0 since 20131203
4 ETW000 7821 0.754391
4 ETW000 [dev trc ,00000] SELECT SUBSTR(NAME, 1, 3), TO_CHAR (CREATED, 'YYYYMMDDHHMMSS') FROM V$DATABASE
4 ETW000 54 0.754445
4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 35687 0.790132
4 ETW000 [dev trc ,00000] SELECT VERSION FROM SVERS
4 ETW000 23243 0.813375
4 ETW000 [dev trc ,00000] SELECT COMPCNT FROM "DDNTT"
4 ETW000 201933 1.015308
4 ETW000 [dev trc ,00000] Tue Dec 03 21:20:43 2013 1283322 2.298630
4 ETW000 [dev trc ,00000] NTAB: Structure of NTAB on DB is VERS_B 46 2.298676
4 ETW000 [dev trc ,00000] Tue Dec 03 21:20:44 2013 21144 2.319820
4 ETW000 [dev trc ,00000] NTAB: standalone processing 43 2.319863
4 ETW000 [dev trc ,00000] NTAB: read profile 25 2.319888
4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/entrycount 1000. 24 2.319912
4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/ftabsize 500. 21 2.319933
4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/irbdsize 100. 21 2.319954
4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/sntabsize 100. 29 2.319983
4 ETW000 [dev trc ,00000] NTAB: compute_hash_card: 2003. 35 2.320018
4 ETW000 [dev trc ,00000] NTAB: maxcnt 1000. 39 2.320057
4 ETW000 [dev trc ,00000] NTAB: hfactor 2003. 20 2.320077
4 ETW000 [dev trc ,00000] NTAB: mem_protocol_size 104 21 2.320098
4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_offset 0 20 2.320118
4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_size 0 21 2.320139
4 ETW000 [dev trc ,00000] NTAB: FTAB: header_size 44. 21 2.320160
4 ETW000 [dev trc ,00000] NTAB: FTAB: item_size 36. 21 2.320181
4 ETW000 [dev trc ,00000] NTAB: FTAB: item_cnt 1000. 21 2.320202
4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_size 4 21 2.320223
4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_cnt 128000. 22 2.320245
4 ETW000 [dev trc ,00000] NTAB: FTAB: data_size 512000. 21 2.320266
4 ETW000 [dev trc ,00000] NTAB: IREC: header_size 44. 21 2.320287
4 ETW000 [dev trc ,00000] NTAB: IREC: item_size 36. 22 2.320309
4 ETW000 [dev trc ,00000] NTAB: IREC: item_cnt 250. 20 2.320329
4 ETW000 [dev trc ,00000] NTAB: IREC: unit_size 8 21 2.320350
4 ETW000 [dev trc ,00000] NTAB: IREC: unit_cnt 12800. 21 2.320371
4 ETW000 [dev trc ,00000] NTAB: IREC: data_size 102400. 23 2.320394
4 ETW000 [dev trc ,00000] NTAB: STAB: header_size 44. 21 2.320415
4 ETW000 [dev trc ,00000] NTAB: STAB: item_size 36. 21 2.320436
4 ETW000 [dev trc ,00000] NTAB: STAB: item_cnt 250. 21 2.320457
4 ETW000 [dev trc ,00000] NTAB: STAB: unit_size 4 21 2.320478
4 ETW000 [dev trc ,00000] NTAB: STAB: unit_cnt 25600. 21 2.320499
4 ETW000 [dev trc ,00000] NTAB: STAB: data_size 102400. 22 2.320521
4 ETW000 [dev trc ,00000] NTAB: TTAB: header_size 148. 21 2.320542
4 ETW000 [dev trc ,00000] NTAB: TTAB: item_size 24. 21 2.320563
4 ETW000 [dev trc ,00000] NTAB: TTAB: item_cnt 1000. 21 2.320584
4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_size 256 21 2.320605
4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_cnt 1000. 21 2.320626
4 ETW000 [dev trc ,00000] NTAB: TTAB: data_size 256000. 22 2.320648
4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 2c7c9a0, hh_len 44 802 2.321450
4 ETW000 [dev trc ,00000] NTAB: FTAB: aa_p 2c784e0, aa_len 8012 33 2.321483
4 ETW000 [dev trc ,00000] NTAB: FTAB: ia_p 2fd0778, ia_len 36000 24 2.321507
4 ETW000 [dev trc ,00000] NTAB: FTAB: dat_p 2fdb008, dat_len 512000 23 2.321530
4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 2c72ac0, hh_len 44 23 2.321553
4 ETW000 [dev trc ,00000] NTAB: IREC: aa_p 3058010, aa_len 8012 23 2.321576
4 ETW000 [dev trc ,00000] NTAB: IREC: ia_p 3059f68, ia_len 9000 23 2.321599
4 ETW000 [dev trc ,00000] NTAB: IREC: dat_p 305c298, dat_len 102400 23 2.321622
4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 2c72bf0, hh_len 44 23 2.321645
4 ETW000 [dev trc ,00000] NTAB: STAB: aa_p 30752a0, aa_len 8012 23 2.321668
4 ETW000 [dev trc ,00000] NTAB: STAB: ia_p 30771f8, ia_len 9000 124 2.321792
4 ETW000 [dev trc ,00000] NTAB: STAB: dat_p 3079528, dat_len 102400 26 2.321818
4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 22c4680, hh_len 148 24 2.321842
4 ETW000 [dev trc ,00000] NTAB: TTAB: aa_p 3092530, aa_len 8012 23 2.321865
4 ETW000 [dev trc ,00000] NTAB: TTAB: ia_p 3094488, ia_len 24000 23 2.321888
4 ETW000 [dev trc ,00000] NTAB: TTAB: dat_p 309a250, dat_len 256000 24 2.321912
4 ETW000 [dev trc ,00000] NTAB: ntab_mem_protocol 22c4680, ntab_mp_p 22c4680, ntab_proc_id 0
4 ETW000 41 2.321953
4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 2c7c9a0, ha_list 2c784e0, hi_list 2fd0778, buffer 2fdb008
4 ETW000 84 2.322037
4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 2c72ac0, ha_list 3058010, hi_list 3059f68, buffer 305c298
4 ETW000 35 2.322072
4 ETW000 [dev trc ,00000] NTAB: STAB: hh_p 2c72bf0, ha_list 30752a0, hi_list 30771f8, buffer 3079528
4 ETW000 36 2.322108
4 ETW000 [dev trc ,00000] NTAB: TTAB: hh_p 22c46e8, ha_list 3092530, hi_list 3094488, buffer 309a250
4 ETW000 34 2.322142
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 0
4 ETW000 44 2.322186
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 1
4 ETW000 48 2.322234
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2
4 ETW000 46 2.322280
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3
4 ETW000 44 2.322324
4 ETW000 [dev trc ,00000] SELECT TABNAME, BLOCKNR, FIELDSLG, FIELDS FROM "DDNTF" WHERE TABNAME = :A0 ORDER BY TABNAME, BLOCKNR
4 ETW000 119 2.322443
4 ETW000 [twdydbacc.c ,00612] i:0 1736752 4.059195
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: PGMID 49 4.059244
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 1 37 4.059281
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 0 20 4.059301
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 4 19 4.059320
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:4 20 4.059340
4 ETW000 [twdydbacc.c ,00612] i:1 41 4.059381
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: OBJECT 20 4.059401
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 1 19 4.059420
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 4 18 4.059438
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 4 112 4.059550
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:4 20 4.059570
4 ETW000 [twdydbacc.c ,00612] i:2 36 4.059606
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: OBJ_NAME 19 4.059625
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 1 26 4.059651
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 8 19 4.059670
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 40 18 4.059688
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:40 18 4.059706
4 ETW000 [twdydbacc.c ,00612] i:3 35 4.059741
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: KORRNUM 19 4.059760
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 19 4.059779
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 48 18 4.059797
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 10 18 4.059815
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:10 18 4.059833
4 ETW000 [twdydbacc.c ,00612] i:4 34 4.059867
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: SRCSYSTEM 19 4.059886
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 19 4.059905
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 58 19 4.059924
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 10 18 4.059942
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:10 18 4.059960
4 ETW000 [twdydbacc.c ,00612] i:5 34 4.059994
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: AUTHOR 18 4.060012
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 19 4.060031
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 68 18 4.060049
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 12 18 4.060067
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:12 18 4.060085
4 ETW000 [twdydbacc.c ,00612] i:6 34 4.060119
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: SRCDEP 19 4.060138
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 18 4.060156
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 80 18 4.060174
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 1 91 4.060265
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:1 22 4.060287
4 ETW000 [twdydbacc.c ,00612] i:7 35 4.060322
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: DEVCLASS 19 4.060341
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 18 4.060359
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 81 18 4.060377
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 30 18 4.060395
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:30 19 4.060414
4 ETW000 [twdydbacc.c ,00612] i:8 34 4.060448
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: GENFLAG 19 4.060467
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 18 4.060485
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 111 18 4.060503
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 1 18 4.060521
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:1 19 4.060540
4 ETW000 [twdydbacc.c ,00612] i:9 34 4.060574
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: EDTFLAG 23 4.060597
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 19 4.060616
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 112 18 4.060634
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 1 19 4.060653
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:1 19 4.060672
4 ETW000 [twdydbacc.c ,00612] i:10 35 4.060707
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: CPROJECT 19 4.060726
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 18 4.060744
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 113 18 4.060762
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 8 18 4.060780
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:8 18 4.060798
4 ETW000 [twdydbacc.c ,00612] i:11 100 4.060898
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: MASTERLANG 22 4.060920
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 19 4.060939
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 121 18 4.060957
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 1 18 4.060975
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:1 18 4.060993
4 ETW000 [twdydbacc.c ,00612] i:12 35 4.061028
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: VERSID 18 4.061046
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 18 4.061064
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 122 19 4.061083
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 20 18 4.061101
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:20 18 4.061119
4 ETW000 [twdydbacc.c ,00612] i:13 35 4.061154
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: PAKNOCHECK 19 4.061173
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 18 4.061191
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 142 29 4.061220
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 1 18 4.061238
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:1 19 4.061257
4 ETW000 [twdydbacc.c ,00612] i:14 34 4.061291
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: OBJSTABLTY 19 4.061310
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 19 4.061329
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 143 19 4.061348
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 1 18 4.061366
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:1 18 4.061384
4 ETW000 [twdydbacc.c ,00612] i:15 35 4.061419
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: COMPONENT 19 4.061438
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 84 4.061522
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 144 19 4.061541
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 30 20 4.061561
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:30 18 4.061579
4 ETW000 [twdydbacc.c ,00612] i:16 39 4.061618
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: CRELEASE 19 4.061637
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 18 4.061655
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 174 19 4.061674
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 10 18 4.061692
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:10 18 4.061710
4 ETW000 [twdydbacc.c ,00612] i:17 35 4.061745
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: DELFLAG 18 4.061763
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 19 4.061782
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 184 18 4.061800
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 1 18 4.061818
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:1 18 4.061836
4 ETW000 [twdydbacc.c ,00612] i:18 35 4.061871
4 ETW000 [twdydbacc.c ,00613] db_fd_p[i].fname: TRANSLTTXT 19 4.061890
4 ETW000 [twdydbacc.c ,00614] db_fd_p[i].is_key: 0 18 4.061908
4 ETW000 [twdydbacc.c ,00615] db_fd_p[i].offset: 185 19 4.061927
4 ETW000 [twdydbacc.c ,00616] db_fd_p[i].db_length: 1 17 4.061944
4 ETW000 [twdydbacc.c ,00617] db_fd_p[i].fixed_length:1 18 4.061962
4 ETW000 [dev trc ,00000] Tue Dec 03 21:20:45 2013 80 4.062042
4 ETW000 [dev trc ,00000] SELECT VERSION, UUID, CRTIMESTMP, ABTIMESTMP, DYTIMESTMP, FLDCNT, TABLENGTH, KEYCNT, KEYLENGTH, CLIENTPOS, TABTYPE, TABFOR
4 ETW000 33 4.062075
4 ETW000 [dev trc ,00000] M, REFNAME, HFLAG, BUFSTATE, BUFPARM, ALIGN, POINTERLG, UNICODELG, COMPCNT, LEAFCNT FROM "DDNTT" WHERE TABNAME = :A0
4 ETW000 40 4.062115
4 ETW000 [twdydbacc.c ,00760] buffer:'ŸȬŸȬ' 65364 4.127479
4 ETW000 [twdydbacc.c ,00765] i:0 45 4.127524
4 ETW000 [twdydbacc.c ,00766] tw_fd_p[i].offset:0 22 4.127546
4 ETW000 [twdydbacc.c ,00765] i:1 18 4.127564
4 ETW000 [twdydbacc.c ,00766] tw_fd_p[i].offset:4 19 4.127583
4 ETW000 [twdydbacc.c ,00765] i:2 18 4.127601
4 ETW000 [twdydbacc.c ,00766] tw_fd_p[i].offset:8 18 4.127619
4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_READ_ONLY', tname = 'TADIR' ) {twdbcall.c:643}
4 ETW000 61 4.127680
4 ETW000 [dev trc ,00000] SELECT * FROM "TADIR" WHERE "PGMID" = :A0 AND "OBJECT" = :A1 AND "OBJ_NAME" = :A2
4 ETW000 36976 4.164656
4 ETW000 [dev trc ,00000] Tue Dec 03 21:20:46 2013 147357 4.312013
4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_READ_ONLY', retcode = 0 )
4 ETW000 50 4.312063
4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'ECC' --- SYSTEM = 'ECC'.
4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1245}
4 ETW000 29356 4.341419
4 ETW000 [dev trc ,00000] INSERT INTO "PATCHHIST" VALUES( :A0 , :A1 , :A2 , :A3 , :A4 , :A5 , :A6 , :A7 )
4 ETW000 93403 4.434822
4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_INSERT', retcode = 0 ) 88190 4.523012
4 ETW000 [dev trc ,00000] dsql_open (con_da=(0,R/3),stmt="SELECT EXECUTABLE,SAPRELEASE,H ...",#binds=0,name=UNKNOWN,#input=0)
4 ETW000 20780 4.543792
4 ETW000 [dev trc ,00000] SELECT EXECUTABLE,SAPRELEASE,HOSTNAME,PLATFORM,DBVENDOR,TIMESTAMP,PATCHNO,DBSLPATCHN FROM PATCHHIST WHERE EXECUTABLE = 'R3
4 ETW000 111 4.543903
4 ETW000 [dev trc ,00000] trans' AND TIMESTAMP = (SELECT MAX(TIMESTAMP) FROM PATCHHIST WHERE EXECUTABLE = 'R3trans' AND SAPRELEASE = '700' AND HOSTN
4 ETW000 41 4.543944
4 ETW000 [dev trc ,00000] AME = 'GCECC62' AND PLATFORM = 'NT' AND DBVENDOR = 'ORA')
4 ETW000 40 4.543984
4 ETW000 [dev trc ,00000] dsql_fetch (con_da=(0,R/3),cu_id=0,#output=8) 133 4.544117
4 ETW000 [dev trc ,00000] dsql_close (con_da=(0,R/3),cu_id=0) 27767 4.571884
4 ETW000 [dev trc ,00000] { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1353}
4 ETW000 60 4.571944
4 ETW000 [dev trc ,00000] DELETE FROM "PATCHHIST" WHERE "EXECUTABLE" = :A0 AND "SAPRELEASE" = :A1 AND "HOSTNAME" = :A2 AND "PLATFORM" = :A3 AND "DBV
4 ETW000 85 4.572029
4 ETW000 [dev trc ,00000] ENDOR" = :A4 AND "TIMESTAMP" = :A5
4 ETW000 48 4.572077
4 ETW000 [dev trc ,00000] } db_rtab( fcode = 'RT_DELETE', retcode = 0 ) 10068 4.582145
4 ETW690 "0" "0"
4 ETW000 [dev trc ,00000] db_con_commit (con_da={R/3,0,0},th_commit=1,tx=1,hold_cursor=0)
4 ETW000 110 4.582255
4 ETW000 COMMIT (0).
4 ETW000 trace to file pointer closed
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000
4 ETW000 ================== STEP 1 =====================
4 ETW000 date&time : 03.12.2013 - 21:20:46
4 ETW000 function : CONNECT
4 ETW000 buffersync : YES
4 ETW000 clients : default
4 ETW000 l.s.m. : VECTOR
4 ETW000 commit : 100000
4 ETW000 table cache : dynamic
4 ETW000
4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 15966 0.015966
4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 37 0.016003
4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=02C531A8,usrhp=02C9FC28)
4 ETW000 645 0.016648
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=02C531A8,srvhp=02C6465C)
4 ETW000 805 0.017453
4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 604 0.018057
4 ETW000 [dev trc ,00000] Disconnected from connection 0 35 0.018092
4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1)
4 ETW000 35 0.018127
4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)
4 ETW000 41 0.018168
4 ETW000 Disconnected from database.
4 ETW000 End of Transport (0000).
4 ETW000 date&time: 03.12.2013 - 21:20:46
Thanks
Naresh Bammidi
dev_w0 log file is empty and dev_disp log is already posted in this thread,please find the log in Karthikeyan's reply as the thread will become clumsy if i post the log again.
After starting the server in console process list status is as below
ABAP WP tables showing nothing
Thanks
Naresh Bammidi
Message was edited by: Naresh Bammidi
I see the below error:-
1 possible network problems detected - check tracefile and adjust the DNS settings
OSS Notes 1136330 and 1022502 both have information regarding an error that you are seeing related to a bad version of the sapstartsrv.
Also i would suggest to go with the complete reboot of the system and then start the DB and SAP.
Regards,
Himanshu
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
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.