Skip to Content
avatar image
Former Member

Error in MVNTAB_TOOL

Hello,

We are trying to upgrade an old SAP R/3 4.5B system. We copied it into a virtual machine with Windows 2003 64bit and Oracle 10.2.0.2 (this is supported for upgrade purposes according to SAP note 976979). The used source kernel is 4.5B_EXT patch level 898.

We are currently blocked in PREPARE phase MVNTAB_TOOL.

Our SAPSID is DEI, and our DBSID is P09.

In TP.ECO, we see the following with tp 4.5B (latest known):

EXECUTING E:\usr\sap\DEI\SYS\exe\run\tp.exe pf=E:\usr\sap\put\bin\MVNTTOOL.TPP mvntabs DEI

Environment: dbs_ora_schema=SAPR3

Environment: dbs_ora_tnsname=P09

Environment: NLS_LANG=AMERICAN_AMERICA.WE8DEC

Environment: ORACLE_HOME=E:\oracle\P09\102

Environment: ORACLE_SID=P09

This is E:\usr\sap\DEI\SYS\exe\run\tp.exe version 305.12.65 (release 46D) for ANY database

Warning: unknown parameter WITH_TACOB in parameter file (line 19).

Warning: unknown parameter WITH_TACOB in parameter file (line 19).

TRACE-INFO: 1: [developertrace,0] Fri Feb 03 18:00:56 2012 0.000000

TRACE-INFO: 2: [developertrace,0] db_con_init called 0.000000

TRACE-INFO: 3: [developertrace,0] load shared library (dboraslib.dll), hdl 0

TRACE-INFO: 4: 812 0.000812

TRACE-INFO: 5: [developertrace,0] function DbSlExpFuns loaded from library dboraslib.dll

TRACE-INFO: 6: 7 0.000819

TRACE-INFO: 7: [developertrace,0] function dsql_db_init loaded from library dboraslib.dll

TRACE-INFO: 8: 111 0.000930

TRACE-INFO: 9: [developertrace,0] function dbdd_exp_funs loaded from library dboraslib.dll

TRACE-INFO: 10: 9 0.000939

TRACE-INFO: 11: [developertrace,0] db_con_connect (con_name=R/3) 19 0.000958

TRACE-INFO: 12: [developertrace,0] find_con found the following connection for reuse:

TRACE-INFO: 13: 4 0.000962

TRACE-INFO: 14: [developertrace,0] Got ORACLE_HOME=E:\oracle\P09\102 from environment

TRACE-INFO: 15: 150 0.001112

TRACE-INFO: 16: [developertrace,0] -->oci_initialize 7 0.001119

TRACE-INFO: 17: [developertrace,0] Got TNS_ADMIN=
pwlusa52\SAPMNT\DEI\sys\profile\oracle from environment

TRACE-INFO: 18: 32 0.001151

TRACE-INFO: 19: [developertrace,0] Got ORACLE_SID=P09 from environment 5 0.001156

TRACE-INFO: 20: [developertrace,0] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

TRACE-INFO: 21: 6 0.001162

TRACE-INFO: 22: [developertrace,0] Logon as OPS$-user to get SAPR3's password

TRACE-INFO: 23: 4 0.001166

TRACE-INFO: 24: [developertrace,0] Connecting as /@P09 on connection 0 ...

TRACE-INFO: 25: 3 0.001169

TRACE-INFO: 26: [developertrace,0] -->oci_logon(con_hdl=0, user='', dbname='P09')

TRACE-INFO: 27: 8 0.001177

TRACE-INFO: 28: [developertrace,0] Now I'm connected to ORACLE 64851 0.066028

TRACE-INFO: 29: [developertrace,0] Got SAPR3's password from table SAPUSER

TRACE-INFO: 30: 901 0.066929

TRACE-INFO: 31: [developertrace,0] Disconnecting from connection 0 ... 4 0.066933

TRACE-INFO: 32: [developertrace,0] -->oci_logoff(con_hdl=0) 4 0.066937

TRACE-INFO: 33: [developertrace,0] Now I'm disconnected from ORACLE 1314 0.068251

TRACE-INFO: 34: [developertrace,0] Try to connect with the password I got from OPS$-user

TRACE-INFO: 35: 6 0.068257

TRACE-INFO: 36: [developertrace,0] Connecting as SAPR3/<pwd>@P09 on connection 0 ...

TRACE-INFO: 37: 5 0.068262

TRACE-INFO: 38: [developertrace,0] -->oci_logon(con_hdl=0, user='SAPR3', dbname='P09')

TRACE-INFO: 39: 4 0.068266

TRACE-INFO: 40: [developertrace,0] Now I'm connected to ORACLE 24844 0.093110

TRACE-INFO: 41: [developertrace,0] Database instance p09 is running on PWLUSA52 with ORACLE version 10.2.0.2.0 since 20120202

TRACE-INFO: 42: 11773 0.104883

TRACE-INFO: 43: [developertrace,0] NTAB: Structure of NTAB on DB is VERS_A

TRACE-INFO: 44: 5481 0.110364

TRACE-INFO: 45: [developertrace,0] NTAB: standalone processing 15 0.110379

TRACE-INFO: 46: [developertrace,0] NTAB: read profile 3 0.110382

TRACE-INFO: 47: [developertrace,0] NTAB: rsdb/ntab/entrycount 150 3 0.110385

TRACE-INFO: 48: [developertrace,0] NTAB: rsdb/ntab/ftabsize 200 3 0.110388

TRACE-INFO: 49: [developertrace,0] NTAB: rsdb/ntab/irbdsize 100 3 0.110391

TRACE-INFO: 50: [developertrace,0] NTAB: rsdb/ntab/sntabsize 100 3 0.110394

TRACE-INFO: 51: [developertrace,0] NTAB: maxcnt 150 3 0.110397

TRACE-INFO: 52: [developertrace,0] NTAB: adm_initial 4080 3 0.110400

TRACE-INFO: 53: [developertrace,0] NTAB: hfactor 1009 2 0.110402

TRACE-INFO: 54: [developertrace,0] NTAB: mem_protocol_size 104 3 0.110405

TRACE-INFO: 55: [developertrace,0] NTAB: FTAB: total 51200, adm_size 14920, data_size 204800

TRACE-INFO: 56: 5 0.110410

TRACE-INFO: 57: [developertrace,0] NTAB: IREC: total 12800, adm_size 14920, data_size 102400

TRACE-INFO: 58: 4 0.110414

TRACE-INFO: 59: [developertrace,0] NTAB: STAB: total 25600, adm_size 14920, data_size 102400

TRACE-INFO: 60: 4 0.110418

TRACE-INFO: 61: [developertrace,0] NTAB: TTAB: total 150, adm_size 7784, data_size 21000

TRACE-INFO: 62: 4 0.110422

TRACE-INFO: 63: [developertrace,0] NTAB: FTAB: adm_adr 2a358c8, adm_len 14920, dat_adr 2a39310, dat_len 204800

TRACE-INFO: 64: 217 0.110639

TRACE-INFO: 65: [developertrace,0] NTAB: IREC: adm_adr 2a6b338, adm_len 14920, dat_adr 2a6ed80, dat_len 102400

TRACE-INFO: 66: 5 0.110644

TRACE-INFO: 67: [developertrace,0] NTAB: STAB: adm_adr 2a87da8, adm_len 14920, dat_adr 2a8b7f0, dat_len 102400

TRACE-INFO: 68: 6 0.110650

TRACE-INFO: 69: [developertrace,0] NTAB: TTAB: adm_adr 2aa4818, adm_len 7784, dat_adr 2aa6680, dat_len 21000

TRACE-INFO: 70: 5 0.110655

TRACE-INFO: 71: [developertrace,0] NTAB: mem_protocol 2aa4818, mp_p 2aa4818, proc_id 0

TRACE-INFO: 72: 6 0.110661

TRACE-INFO: 73: [developertrace,0] NTAB: FTAB: hh_p 2a358c8, ha_list 2a358f4, hi_list 2a368b8, buffer 2a39310

TRACE-INFO: 74: 21 0.110682

TRACE-INFO: 75: [developertrace,0] NTAB: IREC: hh_p 2a6b338, ha_list 2a6b364, hi_list 2a6c328, buffer 2a6ed80

TRACE-INFO: 76: 5 0.110687

TRACE-INFO: 77: [developertrace,0] NTAB: STAB: hh_p 2a87da8, ha_list 2a87dd4, hi_list 2a88d98, buffer 2a8b7f0

TRACE-INFO: 78: 5 0.110692

TRACE-INFO: 79: [developertrace,0] NTAB: TTAB: hh_p 2aa4880, ha_list 2aa48ac, hi_list 2aa5870, buffer 2aa6680

TRACE-INFO: 80: 5 0.110697

TRACE-INFO: 81: [developertrace,0] NTAB: mem_handler: alloc for 500 elems, task 0, art 0

TRACE-INFO: 82: 9 0.110706

TRACE-INFO: 83: [developertrace,0] NTAB: mem_handler: alloc for 500 elems, task 0, art 1

TRACE-INFO: 84: 13 0.110719

TRACE-INFO: 85: [developertrace,0] NTAB: mem_handler: alloc for 500 elems, task 0, art 2

TRACE-INFO: 86: 20 0.110739

TRACE-INFO: 87: [developertrace,0] NTAB: mem_handler: alloc for 500 elems, task 0, art 3

TRACE-INFO: 88: 10 0.110749

TRACE-INFO: 89: [developertrace,0] Fri Feb 03 18:00:57 2012 545034 0.655783

TRACE-INFO: 90: [dbsloci.,0] *** ERROR => ORA-904 occured; SQL statement is ==>

TRACE-INFO: 91: 5 0.655788

TRACE-INFO: 92: [developertrace,0] SELECT "SQLX" , "EDTX" , "DBNA" , "CLAS" , "TYPE" , "OCCURS" , "SUBC" , "APPL" , "SECU" , "CNAM" , "\

TRACE-INFO: 93: 8 0.655796

TRACE-INFO: 94: [developertrace,0] CDAT" , "VERN" , "LEVL" , "RSTAT" , "RMAND" , "RLOAD" , "R3RELEASE" , "R3MODIFY" , "UNAM" , "UDAT" ,\

TRACE-INFO: 95: 5 0.655801

TRACE-INFO: 96: [developertrace,0] "UTIME" , "DATALG" , "VARCL" , "DBAPL" , "FIXPT" , "SSET" , "SDATE" , "STIME" , "IDATE" , "ITIME" ,\

TRACE-INFO: 97: 4 0.655805

TRACE-INFO: 98: [developertrace,0] "LDBNAME" , "UCCHECK" FROM "D010SINF" WHERE "PROG" = :A0 AND "R3STATE" = :A1 FOR UPDATE OF R3RELEAS\

TRACE-INFO: 99: 4 0.655809

TRACE-INFO: 100: [developertrace,0] E; 2 0.655811

TRACE-INFO: 101: [dbrepo ,3351] ***LOG BY4=>sql error 904 performing SEL on table D010SINF

TRACE-INFO: 102: 19 0.655830

TRACE-INFO: 103: [dbrepo ,3351] ***LOG BY0=>ORA-00904: "UCCHECK": invalid identifier

TRACE-INFO: 104: 5 0.655835

TRACE-INFO: 105: [dbeh.c ,0] *** ERROR => missing return code handler 10 0.655845

TRACE-INFO: 106: caller does not handle code 1 from dbrepo.c[1814]

TRACE-INFO: 107: ==> calling sap_dext to abort transaction

HALT 20120203180057

tp returncode summary:

TOOLS: Highest return code of single steps was: 16

ERRORS: Highest tp internal error was: 0234

tp finished with return code: 234

meaning:

uncaught error -> function err_exit called

904 sap_dext called with msgnr 951.

ec: 10; msgid: 00; retf: 0.

ERROR: uncaught internal error: ORA-00904: "UCCHECK": invalid identifier

ERROR: EXIT(16) -> process ID is: 728

Process with ID 728 terminated with status 234

We tried to replace this version 4.5B by the version provided in the tools directory of \usr\sap\put, but in this case the phase MVNTAB_TOOL hangs and the content of TP.ECO is:

R3up> Starting subprocess tp.exe with id 380 at 20120203183222

EXECUTING E:\usr\sap\DEI\SYS\exe\run\tp.exe pf=E:\usr\sap\put\bin\MVNTTOOL.TPP mvntabs DEI

Environment: dbs_ora_schema=SAPR3

Environment: dbs_ora_tnsname=P09

Environment: NLS_LANG=AMERICAN_AMERICA.WE8DEC

Environment: ORACLE_HOME=E:\oracle\P09\102

Environment: ORACLE_SID=P09

This is E:\usr\sap\DEI\SYS\exe\run\tp.exe version 305.12.65 (release 46D) for ANY database

Warning: unknown parameter WITH_TACOB in parameter file (line 19).

Warning: unknown parameter WITH_TACOB in parameter file (line 19).

... and nothing else.

Any idea is welcome !

Kind regards,

Christophe

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 03, 2012 at 08:27 PM

    Hello,

    We are trying to upgrade an old SAP R/3 4.5B system. We copied it into a virtual machine with Windows 2003 64bit and Oracle 10.2.0.2 (this is supported for upgrade purposes according to SAP note 976979). The used source kernel is 4.5B_EXT patch level 898.

    > In TP.ECO, we see the following with tp 4.5B (latest known):

    > This is E:\usr\sap\DEI\SYS\exe\run\tp.exe version 305.12.65 (release 46D) for ANY database

    > TRACE-INFO: 20: [developertrace,0] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

    > TRACE-INFO: 103: [dbrepo ,3351] ***LOG BY0=>ORA-00904: "UCCHECK": invalid identifier

    Hi,

    your saying, you use 4.5B_EXT Kernel, but the tp identifies itself as 4.6D.

    My be you did a release mismatch when patching?

    Looks like the 4.6D tp is expecting A UCCHECK Filed in the table D010SINF that is not existing, so your TP might be too high ?

    Volker

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 06, 2012 at 08:43 AM

    Hi,

    That's correct, I'm using a 4.5B_EXT kernel, because this kernel works with Oracle 10.2.0.2.

    I made a first attempt with tp and R3trans provided with corresponding SAPEXE and SAPEXEDB files, but R3up stopped at step DBCHECK_PRE (latest step of Parameter Input at PREPARE) with 'SEVERE ERROR: Could not determine SAP and DB version'. When checking DBINFO.LOG file, I saw that tp made a mistake in determining DBSID: it took SAPSID instead, despite the fact that DBSID is correctly set in tnsnames.ora file.

    That's why I exchanged tp.exe and dboraslib.dll from \usr\sap\put\tools to \usr\sap\DEI\sys\exe\run, according to tools.txt file. This exchange solved the problem at DBCHECK_PRE, but generated the problem described above.

    Another interesting thing: I made another test in parallel with Oracle 9.2.0.7. This test stopped exactly at the same steps.

    Kind regards,

    Christophe

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2012 at 02:05 PM

    Hi,

    The problem is caused by giving a different value to SAPSID and BDSID.

    I reinstalled the source system with SAPSID=DBSID, and now I can upgrade without the above error.

    Thanks,

    Christophe

    Add comment
    10|10000 characters needed characters exceeded