Question:
I've got ORA-00942 Error during the IDES Installation 4.6D on Windows 2000 with Oracle Database 8,1.7 wiht all SPs.
Following are in the dev_dbsl:
DbSl Trace: dbsloci.c 7515 ORA-1403 when accessing table SAPUSER
This appears in the trans.log after try r3trans -d
4 ETW000 r3trans version 6.05 (release 46D - 09.08.01 - 15:20:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: r3trans -d
4 ETW000 date&time : 12.12.2005 - 11:14:19
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [developertrace,0] Mon Dec 12 11:14:20 2005 7684 0.007684
4 ETW000 [developertrace,0] db_con_init called 43 0.007727
4 ETW000 [developertrace,0] create_con (con_name=R/3) 52 0.007779
4 ETW000 [developertrace,0] Loading DB library 'dboraslib.dll' ...
4 ETW000 70 0.007849
4 ETW000 [developertrace,0] load shared library (dboraslib.dll), hdl 0
4 ETW000 15938 0.023787
4 ETW000 [developertrace,0] Library 'dboraslib.dll' loaded
4 ETW000 31 0.023818
4 ETW000 [developertrace,0] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 35 0.023853
4 ETW000 [developertrace,0] Version of library 'dboraslib.dll' is "46D.00", patchlevel (0.575)
4 ETW000 11425 0.035278
4 ETW000 [developertrace,0] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 36 0.035314
4 ETW000 [developertrace,0] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 54 0.035368
4 ETW000 [developertrace,0] New connection 0 created 86 0.035454
4 ETW000 [developertrace,0] db_con_connect (con_name=R/3) 42 0.035496
4 ETW000 [developertrace,0] find_con found the following connection for reuse:
4 ETW000 27 0.035523
4 ETW000 [developertrace,0] Got ORACLE_HOME=C:\oracle\c11817 from environment
4 ETW000 2883 0.038406
4 ETW000 [developertrace,0] -->oci_initialize 590 0.038996
4 ETW000 [developertrace,0] Got ORACLE_SID=C11 from environment
4 ETW000 1355 0.040351
4 ETW000 [developertrace,0] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment
4 ETW000 33 0.040384
4 ETW000 [developertrace,0] Logon as OPS$-user to get SAPR3's password
4 ETW000 27 0.040411
4 ETW000 [developertrace,0] Connecting as /@C11 on connection 0 ...
4 ETW000 27 0.040438
4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='', dbname='C11')
4 ETW000 53 0.040491
4 ETW000 [developertrace,0] Mon Dec 12 11:14:22 2005 2479756 2.520247
4 ETW000 [developertrace,0] Now I'm connected to ORACLE 46 2.520293
4 ETW000 [dbsloci.,0] *** ERROR => ORA-1403 when accessing table SAPUSER
4 ETW000 1416 2.521709
4 ETW000 [developertrace,0] Disconnecting from connection 0 ...
4 ETW000 31 2.521740
4 ETW000 [developertrace,0] -->oci_logoff(con_hdl=0) 19 2.521759
4 ETW000 [developertrace,0] Now I'm disconnected from ORACLE
4 ETW000 9617 2.531376
4 ETW000 [developertrace,0] Try to connect with default password
4 ETW000 31 2.531407
4 ETW000 [developertrace,0] Connecting as SAPR3/<pwd>@C11 on connection 0 ...
4 ETW000 29 2.531436
4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='SAPR3', dbname='C11')
4 ETW000 27 2.531463
4 ETW000 [developertrace,0] Now I'm connected to ORACLE 131868 2.663331
4 ETW000 [developertrace,0] Database instance c11 is running on SAPGATE with ORACLE version 8.1.7.4.1 since 20051212
4 ETW000 15780 2.679111
4 ETW000 [developertrace,0] Connection 0 opened 23606 2.702717
4 ETW000 [dblink ,2056] ***LOG BZA=>table SVERS doesn't exist on database
4 ETW000 113947 2.816664
4 ETW000 [developertrace,0] NTAB: SELECT VERSION FROM DDNTT FAILED
4 ETW000 5338 2.822002
4 ETW000 [dbntab.c,0] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED
4 ETW000 975 2.822977
4 ETW000 [dbntab ,1009] ***LOG BZY=>unexpected return code 107 on NTAB -call
4 ETW000 60 2.823037
4 ETW000 [developertrace,0] Mon Dec 12 11:14:27 2005 5007242 7.830279
4 ETW000 [developertrace,0] NTAB: SELECT VERSION FROM DDNTT FAILED
4 ETW000 59 7.830338
4 ETW000 [dbntab.c,0] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED
4 ETW000 804 7.831142
4 ETW000 [dbntab ,1009] ***LOG BZY=>unexpected return code 107 on NTAB -call
4 ETW000 35 7.831177
4 ETW000 [developertrace,0] Mon Dec 12 11:14:32 2005 4998309 12.829486
4 ETW000 [developertrace,0] NTAB: SELECT VERSION FROM DDNTT FAILED
4 ETW000 53 12.829539
4 ETW000 [dbntab.c,0] *** ERROR => NTAB: SELECT VERSION/DBASE FROM DDNTT FAILED
4 ETW000 881 12.830420
4 ETW000 [dbntab ,1009] ***LOG BZY=>unexpected return code 107 on NTAB -call
4 ETW000 36 12.830456
4 ETW000 [developertrace,0] Mon Dec 12 11:14:37 2005 4997808 17.828264
4 ETW000 [developertrace,0] NTAB: standalone processing 43 17.828307
4 ETW000 [developertrace,0] NTAB: read profile 22 17.828329
4 ETW000 [developertrace,0] NTAB: rsdb/ntab/entrycount 150
4 ETW000 28 17.828357
4 ETW000 [developertrace,0] NTAB: rsdb/ntab/ftabsize 200 17 17.828374
4 ETW000 [developertrace,0] NTAB: rsdb/ntab/irbdsize 100 18 17.828392
4 ETW000 [developertrace,0] NTAB: rsdb/ntab/sntabsize 100 17 17.828409
4 ETW000 [developertrace,0] NTAB: maxcnt 150 17 17.828426
4 ETW000 [developertrace,0] NTAB: adm_initial 4080 17 17.828443
4 ETW000 [developertrace,0] NTAB: hfactor 1009 17 17.828460
4 ETW000 [developertrace,0] NTAB: mem_protocol_size 104 18 17.828478
4 ETW000 [developertrace,0] NTAB: FTAB: total 51200, adm_size 14920, data_size 204800
4 ETW000 30 17.828508
4 ETW000 [developertrace,0] NTAB: IREC: total 12800, adm_size 14920, data_size 102400
4 ETW000 28 17.828536
4 ETW000 [developertrace,0] NTAB: STAB: total 25600, adm_size 14920, data_size 102400
4 ETW000 29 17.828565
4 ETW000 [developertrace,0] NTAB: TTAB: total 150, adm_size 7784, data_size 21000
4 ETW000 28 17.828593
4 ETW000 [developertrace,0] NTAB: FTAB: adm_adr 2cf2218, adm_len 14920, dat_adr 2cf5c60, dat_len 204800
4 ETW000 3492 17.832085
4 ETW000 [developertrace,0] NTAB: IREC: adm_adr 2d27c70, adm_len 14920, dat_adr 2d2b6b8, dat_len 102400
4 ETW000 31 17.832116
4 ETW000 [developertrace,0] NTAB: STAB: adm_adr 3250048, adm_len 14920, dat_adr 3253a90, dat_len 102400
4 ETW000 106 17.832222
4 ETW000 [developertrace,0] NTAB: TTAB: adm_adr 326caa0, adm_len 7784, dat_adr 326e908, dat_len 21000
4 ETW000 29 17.832251
4 ETW000 [developertrace,0] NTAB: mem_protocol 326caa0, mp_p 326caa0, proc_id 0
4 ETW000 46 17.832297
4 ETW000 [developertrace,0] NTAB: FTAB: hh_p 2cf2218, ha_list 2cf2244, hi_list 2cf3208, buffer 2cf5c60
4 ETW000 71 17.832368
4 ETW000 [developertrace,0] NTAB: IREC: hh_p 2d27c70, ha_list 2d27c9c, hi_list 2d28c60, buffer 2d2b6b8
4 ETW000 31 17.832399
4 ETW000 [developertrace,0] NTAB: STAB: hh_p 3250048, ha_list 3250074, hi_list 3251038, buffer 3253a90
4 ETW000 31 17.832430
4 ETW000 [developertrace,0] NTAB: TTAB: hh_p 326cb08, ha_list 326cb34, hi_list 326daf8, buffer 326e908
4 ETW000 31 17.832461
4 ETW000 [developertrace,0] NTAB: mem_handler: alloc for 500 elems, task 0, art 0
4 ETW000 56 17.832517
4 ETW000 [developertrace,0] NTAB: mem_handler: alloc for 500 elems, task 0, art 1
4 ETW000 178 17.832695
4 ETW000 [developertrace,0] NTAB: mem_handler: alloc for 500 elems, task 0, art 2
4 ETW000 89 17.832784
4 ETW000 [developertrace,0] NTAB: mem_handler: alloc for 500 elems, task 0, art 3
4 ETW000 139 17.832923
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 2331 17.835254
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 3175 17.838429
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 918 17.839347
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 911 17.840258
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 831 17.841089
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 860 17.841949
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 870 17.842819
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 1011 17.843830
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 907 17.844737
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 910 17.845647
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 878 17.846525
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 915 17.847440
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 910 17.848350
4 ETW000 [dbntab ,6933] ***LOG BZY=>unexpected return code 107 on DbSlExeRd -call
4 ETW000 878 17.849228
4 ETW000 [dbntab ,6663] ***LOG BZY=>unexpected return code 107 on DbSlRead -call
4 ETW000 2008 17.851236
2EETW150 sap_dext called with msgnr "2":
2EETW000 DBE_EXTERNALERROR
4 ETW000
2EETW000 ---- db call info ----
2EETW000 function: db_ntab
2EETW000 fcode: NT_RDTDESCR
2EETW000 keylen: 0
2EETW000 key:
2EETW000 retcode: 2
4 ETW000
4 ETW000 [developertrace,0] db_con_rollback (con_da={R/3,0,0},th_rollback=1,forced=1,tx=0)
4 ETW000 14418 17.865654
4 ETW000 ROLLBACK (0).
Did anyone know how I solved this issue?
Answer:
try with a more recent program from sapnet