Former Member

Jun 30, 2007 at 02:09 PM

Upgrade Stopped - Unable to logon to system

59 Views

Windows 2003 Server 64bit , Sql 2005, Upgrade erp2004 -> erp2005.

Upgrade has stopped in phase startsap_nbas, and although the system will start you are unable to logon due to the error "error when initialising the work area SYST".

On investigation there seems to be a problem caused by the datatype change of field syst-modno (changed from char to int4 during 640->700). The trace for w0 is

-

trc file: "dev_w0", trc level: 1, release: "700"

-

*

ACTIVE TRACE LEVEL 1
ACTIVE TRACE COMPONENTS all, MJ

*

B

B Sat Jun 30 09:46:01 2007

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\DEV\SYS\exe\run\dbmssslib.dll' ...

B Library 'E:\usr\sap\DEV\SYS\exe\run\dbmssslib.dll' loaded

B Version of 'E:\usr\sap\DEV\SYS\exe\run\dbmssslib.dll' is "700.08", patchlevel (0.109)

B New connection 0 created

M sysno 00

M sid DEV

M systemid 562 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 116

M intno 20050900

M make: multithreaded, ASCII, 64 bit, optimized

M pid 3124

M

M kernel runs with dp version 232(ext=109) (@(#) DPLIB-INT-VERSION-232)

M length of sys_adm_ext is 364 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3124) [dpxxdisp.c 1301]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 12384 (952)

M DpShMCreate: sizeof(tm_adm) 4986416 (24808)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552048/552064

M DpShMCreate: sizeof(comm_adm) 552064 (1088)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (104)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1616)

M DpShMCreate: sizeof(wall_adm) (25648/36736/64/104)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000010640050, size: 5644672)

M DpShMCreate: allocated sys_adm at 0000000010640050

M DpShMCreate: allocated wp_adm at 0000000010641BF0

M DpShMCreate: allocated tm_adm_list at 0000000010644C50

M DpShMCreate: allocated tm_adm at 0000000010644CB0

M DpShMCreate: allocated wp_ca_adm at 0000000010B062E0

M DpShMCreate: allocated appc_ca_adm at 0000000010B0A930

M DpShMCreate: allocated comm_adm at 0000000010B0C0A0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 0000000010B92D20

M DpShMCreate: allocated gw_adm at 0000000010B92DA0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 0000000010B92DD0

M DpShMCreate: allocated wall_adm at 0000000010B92DE0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Sat Jun 30 09:46:02 2007

M ThInit: running on host mk2dev

M calling db_connect ...

C Thread ID:3144

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'E:\usr\sap\DEV\SYS\exe\run\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 116

C patchcomment MSSQL: Transaction inconsistencies HOTNEWS (1067103)

C np:(local) connection used on MK2DEV

C CopyLocalParameters: dbuser is 'dev'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C Provider Release:9.00.3042.00

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C Cache sizes: header 88 bytes, 20000 names (28160000 bytes), 500 dynamic statements (2756000 bytes), total 30916088 bytes

C Using shared procedure name cache MK2DEV_DEVDEV_DEV_MEM initialized by another process.

C Connected to db server : [MK2DEV] server_used : [np:(local)], dbname: DEV, dbuser: dev

C pn_id:MK2DEV_DEVDEV_DEV

C Using MARS (on sql 9.0)

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 20070630 094602 MK2DEV

C The IRow interface is supported by this OLEDB provider

M db_connect o.k.

M ICT: exclude compression: .zip,.cs,.rar,.arj,.z,.gz,.tar,.lzh,.cab,.hqx,.ace,.jar,.ear,.war,.css,.pdf,.js,.gzip,.uue,.bz2,.iso,.sda,.sar,.gif

I

I Sat Jun 30 09:46:05 2007

I MtxInit: 0 0 0

M SHM_PRES_BUF (addr: 0000000017820050, size: 5000000)

M SHM_ROLL_AREA (addr: 000007FFE6B90050, size: 218726400)

M SHM_PAGING_AREA (addr: 0000000017CF0050, size: 95682560)

M

M Sat Jun 30 09:46:06 2007

M SHM_ROLL_ADM (addr: 000000001D840050, size: 2183680)

M SHM_PAGING_ADM (addr: 000000001DA60050, size: 525344)

M ThCreateNoBuffer allocated 324144 bytes for 1000 entries at 000000001DAF0050

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 7440 bytes (50 server) at 000000001DB40050

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X ES initialized.

B db_con_shm_ini: WP_ID = 0, WP_CNT = 13, CON_ID = -1

B Table statistics is switched off.

B dbtbxbuf: Buffer TABL (addr: 000000001FFE0160, size: 8000000, end: 0000000020781360)

B dbtbxbuf: Buffer TABLP (addr: 0000000020790160, size: 2048000, end: 0000000020984160)

B dbexpbuf: Buffer EIBUF (addr: 00000000209A0170, size: 4096000, end: 0000000020D88170)

B dbexpbuf: Buffer ESM (addr: 0000000020D90170, size: 4194304, end: 0000000021190170)

B dbexpbuf: Buffer CUA (addr: 00000000211A0170, size: 2048000, end: 0000000021394170)

B dbexpbuf: Buffer OTR (addr: 00000000213A0170, size: 4194304, end: 00000000217A0170)

M CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

S *** init spool environment

S initialize debug system

T Stack direction is downwards.

T debug control: prepare exclude for printer trace

T new memory block 0000000012E7ACA0

S spool kernel/ddic check: Ok

S using table TSP02FX for frontend printing

S 0 spool work process(es) found

S frontend print via spool service enabled

S printer list size is 150

S printer type list size is 50

S queue size (profile) = 300

S hostspool list size = 3000

S option list size is 30

S found processing queue enabled

S found spool memory service RSPO-RCLOCKS at 00000000298000C0

S doing lock recovery

S setting server cache root

S found spool memory service RSPO-SERVERCACHE at 0000000029800460

S using messages for server info

S size of spec char cache entry: 165024 bytes (timeout 100 sec)

S size of open spool request entry: 1248 bytes

S immediate print option for implicitely closed spool requests is disabled

A

A ~~-PXA~~ --

A PXA INITIALIZATION

A System page size: 4kb, total admin_size: 6968kb, dir_size: 6912kb.

A Attached to PXA (address 000007FFF3C50050, size 200000K)

A abap/pxa = shared protect gen_local

A PXA INITIALIZATION FINISHED

A ~~-PXA~~ --

A

A ABAP ShmAdm attached (addr=000007FF4F27E000 leng=20955136 end=000007FF5067A000)

A >> Shm MMADM area (addr=000007FF4F64A1A0 leng=261120 end=000007FF4F689DA0)

A >> Shm MMDAT area (addr=000007FF4F68A000 leng=16711680 end=000007FF5067A000)

A RFC Destination> destination mk2dev_DEV_00 host mk2dev system DEV systnr 0 (mk2dev_DEV_00)

A RFC Options> H=mk2dev,S=00,d=1,

B table logging switched off for all clients

A RFC FRFC> fallback activ but this is not a central instance.

A

A RFC rfc/signon_error_log = -1

A RFC rfc/dump_connection_info = 0

A RFC rfc/dump_client_info = 0

A RFC rfc/cp_convert/ignore_error = 1

A RFC rfc/cp_convert/conversion_char = 23

A RFC rfc/wan_compress/threshold = 251

A RFC rfc/recorder_pcs not set, use defaule value: 1

A RFC rfc/delta_trc_level not set, use default value: 0

A RFC rfc/no_uuid_check not set, use default value: 0

A RFC rfc/bc_ignore_thcmaccp_retcode not set, use default value: 0

A RFC Method> initialize RemObjDriver for ABAP Objects

M ThrCreateShObjects allocated 26874 bytes at 0000000029920050

N SsfSapSecin: putenv(SECUDIR=E:\usr\sap\DEV\DVEBMGS00\sec): ok

N

N =================================================

N === SSF INITIALIZATION:

N ===...SSF Security Toolkit name SAPSECULIB .

N ===...SSF trace level is 0 .

N ===...SSF library is e:\usr\sap\DEV\sys\exe\run\sapcrypto.dll .

N ===...SSF hash algorithm is SHA1 .

N ===...SSF symmetric encryption algorithm is DES-CBC .

N ===...pass SECUDIR E:\usr\sap\DEV\DVEBMGS00\sec returned 0 .

N ===...sucessfully completed.

N =================================================

M *** ERROR => SlicLikeyGetAllRecords: RS_OPEN failed rc=32 [sliclikey.c 988]

M *** ERROR => likey_init: likeyche_fill_buffer: couldn't get the list of all records from the persistence. [sliclikey.c 1269]

M *** ERROR => SlicLikeyInit: likey_init failed: 1 [sliclikey.c 261]

M *** ERROR => SAPlicense: LIKEY initialisation failed! [slicshm.c 268]

N MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from shared memory.

N MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

M JrfcVmcRegisterNativesDriver o.k.

W =================================================

W === ipl_Init() called

W ITSP ICMAN is not active: Disable Kernel Web GUI functionality

W === ipl_Init() returns 2, ITSPE_DISABLED: Service is disabled (sapparam)

W =================================================

E Replication is disabled

E EnqCcInitialize: local lock table initialization o.k.

E EnqId_SuppressIpc: local EnqId initialization o.k.

E EnqCcInitialize: local enqueue client init o.k.

A

A Sat Jun 30 09:46:26 2007

A *** ERROR => Table SYST Field MODNO : Type should be 172, but is 40. [sapicc.c 1082]

A TH VERBOSE LEVEL FULL

A ** RABAX: level LEV_RX_PXA_RELEASE_MTX entered.

A ** RABAX: level LEV_RX_PXA_RELEASE_MTX completed.

A ** RABAX: level LEV_RX_COVERAGE_ANALYSER entered.

A ** RABAX: level LEV_RX_COVERAGE_ANALYSER completed.

A ** RABAX: level LEV_RX_ROLLBACK entered.

A ** RABAX: level LEV_RX_ROLLBACK completed.

A ** RABAX: level LEV_RX_DB_ALIVE entered.

A ** RABAX: level LEV_RX_DB_ALIVE completed.

A ** RABAX: level LEV_RX_HOOKS entered.

A ** RABAX: level LEV_RX_HOOKS completed.

A ** RABAX: level LEV_RX_STANDARD entered.

A ** RABAX: level LEV_RX_STANDARD completed.

A ** RABAX: level LEV_RX_STOR_VALUES entered.

A ** RABAX: level LEV_RX_STOR_VALUES completed.

A ** RABAX: level LEV_RX_C_STACK entered.

A ** RABAX: level LEV_RX_C_STACK completed.

A ** RABAX: level LEV_RX_MEMO_CHECK entered.

A ** RABAX: level LEV_RX_MEMO_CHECK completed.

A ** RABAX: level LEV_RX_AFTER_MEMO_CHECK entered.

A ** RABAX: level LEV_RX_AFTER_MEMO_CHECK completed.

A ** RABAX: level LEV_RX_INTERFACES entered.

A ** RABAX: level LEV_RX_INTERFACES completed.

A ** RABAX: level LEV_RX_GET_MESS entered.

A ** RABAX: level LEV_RX_GET_MESS completed.

A ** RABAX: level LEV_RX_INIT_SNAP entered.

A ** RABAX: level LEV_RX_INIT_SNAP completed.

A ** RABAX: level LEV_RX_WRITE_SYSLOG entered.

A ** RABAX: level LEV_RX_WRITE_SYSLOG completed.

A ** RABAX: level LEV_RX_WRITE_SNAP entered.

A ** RABAX: level LEV_SN_END completed.

A ** RABAX: level LEV_RX_SET_ALERT entered.

A ** RABAX: level LEV_RX_SET_ALERT completed.

A ** RABAX: level LEV_RX_COMMIT entered.

A ** RABAX: level LEV_RX_COMMIT completed.

A ** RABAX: level LEV_RX_SNAP_SYSLOG entered.

A ** RABAX: level LEV_RX_SNAP_SYSLOG completed.

A ** RABAX: level LEV_RX_RESET_PROGS entered.

A ** RABAX: level LEV_RX_RESET_PROGS completed.

A ** RABAX: level LEV_RX_STDERR entered.

A Sat Jun 30 09:46:26 2007

A

A ABAP Program ????????????????????????????????????????.

A Source Line 0.

A Error Code SYSTEM_CANT_CLEAR.

A Module $Id: //bas/700_REL/src/krn/runt/abinit.c#16 $ SAP.

A Function ab_isyst Line 1406.

A ** RABAX: level LEV_RX_STDERR completed.

A ** RABAX: level LEV_RX_RFC_ERROR entered.

A ** RABAX: level LEV_RX_RFC_ERROR completed.

A ** RABAX: level LEV_RX_RFC_CLOSE entered.

A ** RABAX: level LEV_RX_RFC_CLOSE completed.

A ** RABAX: level LEV_RX_IMC_ERROR entered.

A ** RABAX: level LEV_RX_IMC_ERROR completed.

A ** RABAX: level LEV_RX_DATASET_CLOSE entered.

A ** RABAX: level LEV_RX_DATASET_CLOSE completed.

A ** RABAX: level LEV_RX_RESET_SHMLOCKS entered.

A ** RABAX: level LEV_RX_RESET_SHMLOCKS completed.

A ** RABAX: level LEV_RX_ERROR_SAVE entered.

A ** RABAX: level LEV_RX_ERROR_SAVE completed.

A ** RABAX: level LEV_RX_ERROR_TPDA entered.

A ** RABAX: level LEV_RX_ERROR_TPDA completed.

A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI entered.

A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI completed.

A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP entered.

A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP completed.

A ** RABAX: level LEV_RX_END entered.

A ** RABAX: level LEV_RX_END completed.

A ** RABAX: end no http/smtp

A ** RABAX: end RX_BTCHLOG|RX_VBLOG

A Error when initializing the work area SYST..

and then this error repeats continuously....

As this is during the 'Switch' phases I checked the table DD03L and DD03L~(shadow) and altered to live table accordingly to see if this eliminated the error. The trace describes the expectation of type 172 not 40 - but not sure which one the kernel wants - i even tried to revert the shadow table to char1.

I would appreciate any pointers that you may have.

Thanks.