Re: Moving Maxdb to a New Server

[Adrian Zed]

Hello,

I have the same error while I'm trying to install SAP NetWeaver 2004s SR1, The database is MAXDB 7.6.0 Build 18 and Windows 2003.

In the phase Import MAXDB statistics it's giving me the fallowing error:

ERROR 2006-11-14 09:31:08
CJS-00030 Assertion failed: ExecuteUpdateStatistics: The update statistics failed. Check logfile XCMDOUT.LOG.

In the logfile XCMDOUT.LOG everything is ok except the last part where I get an error:

> Subprocess starts at 20061114120211

Execute Command : e:\sapdb\programs\pgm\dbmcli.exe -n adita -d PRO -u control,********
Execute Session Command : sql_updatestat SAPPRO.*

> Subprocess stops at 20061114121641

ERR
-24988,ERR_SQL: Sql error
-9407,System error: unexpected error
9,Aborting statistics computation due to system error
42,Error while collecting statistics for table 00000000000029ad; error illegal_key


Now, the KNLDIAG.ERR log file is:

--------------------------------------------------------------------------------
Date Time TID(hex) Typ MsgID Label Message-Text
--------------------------------------------------------------------------------
2006-11-13 21:03:03 --- Starting GMT 2006-11-14 02:03:03 7.6.00 Build 018-123-119-055
2006-11-13 21:12:00 ___ Stopping GMT 2006-11-14 02:12:00 7.6.00 Build 018-123-119-055
2006-11-13 21:12:01 --- Starting GMT 2006-11-14 02:12:01 7.6.00 Build 018-123-119-055
2006-11-13 21:56:51 ___ Stopping GMT 2006-11-14 02:56:51 7.6.00 Build 018-123-119-055
2006-11-13 21:56:52 --- Starting GMT 2006-11-14 02:56:52 7.6.00 Build 018-123-119-055
2006-11-13 22:09:24 ___ Stopping GMT 2006-11-14 03:09:24 7.6.00 Build 018-123-119-055
2006-11-13 22:09:25 --- Starting GMT 2006-11-14 03:09:25 7.6.00 Build 018-123-119-055
2006-11-13 22:33:51 0xDFC ERR 51080 SYSERROR unexpected error
2006-11-13 22:33:51 0xDFC ERR 9 Data Data_PrimTreeStatisticsCoordinator.cpp:1449
2006-11-13 22:33:51 0xDFC ERR 9 Data 2006-11-13 22:33:50 Data Error 9
2006-11-13 22:33:51 0xDFC ERR 9 Data Aborting statistics computation due to system error
2006-11-13 22:33:51 0xDFC ERR 9 Data + SrvTasks_JobCollectTableStatistics.cpp:346
2006-11-13 22:33:51 0xDFC ERR 9 Data + 2006-11-13 22:33:50 SrvTasks Error 42
2006-11-13 22:33:51 0xDFC ERR 9 Data - Error while collecting statistics for table 00000000000029ad; error illegal_key
2006-11-14 04:25:54 0xDFC ERR 51080 SYSERROR unexpected error
2006-11-14 04:25:54 0xDFC ERR 9 Data Data_PrimTreeStatisticsCoordinator.cpp:1449
2006-11-14 04:25:54 0xDFC ERR 9 Data 2006-11-14 04:25:54 Data Error 9
2006-11-14 04:25:54 0xDFC ERR 9 Data Aborting statistics computation due to system error
2006-11-14 04:25:54 0xDFC ERR 9 Data + SrvTasks_JobCollectTableStatistics.cpp:346
2006-11-14 04:25:54 0xDFC ERR 9 Data + 2006-11-14 04:25:54 SrvTasks Error 42
2006-11-14 04:25:54 0xDFC ERR 9 Data - Error while collecting statistics for table 00000000000029ad; error illegal_key
2006-11-14 06:59:23 0x165C ERR 18431 MESSAGES Could not write to event log, rc = 1717
2006-11-14 06:59:24 ___ Stopping GMT 2006-11-14 11:59:24 7.6.00 Build 018-123-119-055
2006-11-14 09:14:13 --- Starting GMT 2006-11-14 14:14:13 7.6.00 Build 018-123-119-055
2006-11-14 09:31:08 0xF0C ERR 51080 SYSERROR unexpected error
2006-11-14 09:31:08 0xF0C ERR 9 Data Data_PrimTreeStatisticsCoordinator.cpp:1449
2006-11-14 09:31:08 0xF0C ERR 9 Data 2006-11-14 09:31:08 Data Error 9
2006-11-14 09:31:08 0xF0C ERR 9 Data Aborting statistics computation due to system error
2006-11-14 09:31:08 0xF0C ERR 9 Data + SrvTasks_JobCollectTableStatistics.cpp:346
2006-11-14 09:31:08 0xF0C ERR 9 Data + 2006-11-14 09:31:08 SrvTasks Error 42
2006-11-14 09:31:08 0xF0C ERR 9 Data - Error while collecting statistics for table 00000000000029ad; error illegal_key
2006-11-14 12:16:40 0xF0C ERR 51080 SYSERROR unexpected error
2006-11-14 12:16:40 0xF0C ERR 9 Data Data_PrimTreeStatisticsCoordinator.cpp:1449
2006-11-14 12:16:40 0xF0C ERR 9 Data 2006-11-14 12:16:40 Data Error 9
2006-11-14 12:16:40 0xF0C ERR 9 Data Aborting statistics computation due to system error
2006-11-14 12:16:40 0xF0C ERR 9 Data + SrvTasks_JobCollectTableStatistics.cpp:346
2006-11-14 12:16:40 0xF0C ERR 9 Data + 2006-11-14 12:16:40 SrvTasks Error 42
2006-11-14 12:16:40 0xF0C ERR 9 Data - Error while collecting statistics for table 00000000000029ad; error illegal_key



Thank you very much for your help.
Adrian