NW04S SR1 installation stops in phase 26 - import MAXDB statistics

[raeijpe]

Dear Forum,

During the installation of Netweaver 2004S SR1 on a MS Windows Server 2003 64 bit environment, the installation stops in phase 26 - import MAXDB statistics.

I looked in the XCMDOUT.LOG file and tried to recreate the index.

I allready updated the database to 7.6.00.34 but this didn't help.

Please do you have any suggestions,

Robert Eijpe

XCMDOUT.LOG

-

---

Execute Command : d:\sapdb\programs\pgm\dbmcli.exe -n knowledge -d KP1 -u control,********

Execute Session Command : sql_updatestat SAPKP1.*

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 000000000000060a; error bad_datapage

Knldiag.err

-

---

2006-12-06 22:10:47 0x418 ERR 20005 Kernel Bad page - header and trailer not matching

2006-12-06 22:10:47 0x418 ERR 20006 Kernel + Header [ 65499 - data - tab - checksumData - empty ]

2006-12-06 22:10:47 0x418 ERR 20007 Kernel + Trailer[ 2097184 - data - nil - CHECKTYPE=32 - empty ]

2006-12-06 22:10:47 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21930

2006-12-06 22:10:47 0x418 ERR 20008 Data Bad page - page type 'UNDEF' is invalid

2006-12-06 22:10:47 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21924

2006-12-06 22:10:47 0x418 ERR 20008 Data Bad page - page type 'UNDEF' is invalid

2006-12-06 22:10:47 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21928

2006-12-06 22:10:48 0x418 ERR 20008 Data Bad page - page type 'nil' is invalid

2006-12-06 22:10:48 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21925

2006-12-06 22:10:48 0x418 ERR 20008 Data Bad page - page type 'UNDEF' is invalid

2006-12-06 22:10:48 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21933

2006-12-06 22:10:50 0x418 ERR 20005 Kernel Bad page - header and trailer not matching

2006-12-06 22:10:50 0x418 ERR 20006 Kernel + Header [ 65499 - data - tab - checksumData - empty ]

2006-12-06 22:10:50 0x418 ERR 20007 Kernel + Trailer[ 2097184 - data - nil - CHECKTYPE=32 - empty ]

2006-12-06 22:10:50 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21930

2006-12-06 22:10:50 0x418 ERR 20008 Data Bad page - page type 'UNDEF' is invalid

2006-12-06 22:10:50 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21924

2006-12-06 22:10:50 0x418 ERR 20008 Data Bad page - page type 'UNDEF' is invalid

2006-12-06 22:10:50 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21928

2006-12-06 22:10:50 0x418 ERR 20008 Data Bad page - page type 'nil' is invalid

2006-12-06 22:10:50 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21925

2006-12-06 22:10:51 0x418 ERR 20008 Data Bad page - page type 'UNDEF' is invalid

2006-12-06 22:10:51 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21933

2006-12-06 22:10:52 0x418 ERR 20005 Kernel Bad page - header and trailer not matching

2006-12-06 22:10:52 0x418 ERR 20006 Kernel + Header [ 65499 - data - tab - checksumData - empty ]

2006-12-06 22:10:52 0x418 ERR 20007 Kernel + Trailer[ 2097184 - data - nil - CHECKTYPE=32 - empty ]

2006-12-06 22:10:52 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21930

2006-12-06 22:10:52 0x418 ERR 20008 Data Bad page - page type 'UNDEF' is invalid

2006-12-06 22:10:52 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21924

2006-12-06 22:10:52 0x418 ERR 20008 Data Bad page - page type 'UNDEF' is invalid

2006-12-06 22:10:52 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21928

2006-12-06 22:10:52 0x418 ERR 20008 Data Bad page - page type 'nil' is invalid

2006-12-06 22:10:52 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21925

2006-12-06 22:10:53 0x418 ERR 20008 Data Bad page - page type 'UNDEF' is invalid

2006-12-06 22:10:53 0x418 ERR 20026 IOMan Bad page on data volume 1 blockno 21933

2006-12-06 22:10:54 0x418 ERR 20039 IOMan Bad data page - Requested pageno 65499 (perm) read pageno 65499

2006-12-06 22:10:54 0x418 ERR 20020 Data Bad data page 65499 belongs to root 108930 which is of filetype 'Table'

2006-12-06 22:10:54 0x418 ERR 20039 IOMan Bad data page - Requested pageno 139935 (perm) read pageno 2097184

2006-12-06 22:10:54 0x418 ERR 20020 Data Bad data page 139935 belongs to root 108930 which is of filetype 'Table'

2006-12-06 22:10:54 0x418 ERR 20039 IOMan Bad data page - Requested pageno 95280 (perm) read pageno 140

2006-12-06 22:10:54 0x418 ERR 20020 Data Bad data page 95280 belongs to root 108930 which is of filetype 'Table'

2006-12-06 22:10:54 0x418 ERR 20039 IOMan Bad data page - Requested pageno 110320 (perm) read pageno 5439489

2006-12-06 22:10:54 0x418 ERR 20020 Data Bad data page 110320 belongs to root 108930 which is of filetype 'Table'

2006-12-06 22:10:55 0x418 ERR 20039 IOMan Bad data page - Requested pageno 199662 (perm) read pageno 4522079

2006-12-06 22:10:55 0x418 ERR 20020 Data Bad data page 199662 belongs to root 108930 which is of filetype 'Table'

2006-12-06 22:10:55 0x418 ERR 53021 B*TREE Bad File: 108930 (Root)

2006-12-06 22:10:55 0x418 ERR 53021 B*TREE Bad File: 108930 (Root)

2006-12-06 22:10:55 0x418 ERR 53021 B*TREE Bad File: 108930 (Root)

2006-12-06 22:10:55 0x418 ERR 53021 B*TREE Bad File: 108930 (Root)

2006-12-06 22:10:55 0x418 ERR 53021 B*TREE Bad File: 108930 (Root)

2006-12-06 22:10:55 0xF90 ERR 42 SrvTasks Error while collecting statistics for table 000000000000060a; error bad_datapage

2006-12-06 22:10:55 0xF90 ERR 42 SrvTasks + Error while collecting statistics for table 000000000000060a; error bad_datapage

2006-12-06 22:10:55 0xF90 ERR 42 SrvTasks + Error while collecting statistics for table 000000000000060a; error bad_datapage

2006-12-06 22:10:55 0xF90 ERR 42 SrvTasks + Error while collecting statistics for table 000000000000060a; error bad_datapage

2006-12-06 22:10:55 0xF90 ERR 42 SrvTasks + Error while collecting statistics for table 000000000000060a; error bad_datapage

2006-12-06 22:10:55 0xF90 ERR 42 SrvTasks + Error while collecting statistics for table 000000000000060a; error bad_datapage

2006-12-06 22:10:55 0xF90 ERR 42 SrvTasks + Error while collecting statistics for table 000000000000060a; error bad_datapage

2006-12-06 22:10:55 0xF90 ERR 42 SrvTasks + Error while collecting statistics for table 000000000000060a; error bad_datapage

2006-12-06 22:10:55 0xF90 ERR 42 SrvTasks + Error while collecting statistics for table 000000000000060a; error bad_datapage

2006-12-06 22:10:55 0xF90 ERR 42 SrvTasks + Error while collecting statistics for table 000000000000060a; error bad_datapage

2006-12-06 22:10:55 0xF90 ERR 51080 SYSERROR -9407 unexpected error

2006-12-06 22:10:55 0xF90 ERR 9 Data Aborting statistics computation due to system error

2006-12-06 22:10:55 0xF90 ERR 42 SrvTasks + Error while collecting statistics for table 000000000000060a; error bad_datapage

2006-12-06 22:10:55 0xF90 19651 CONNECT Connection released, T99

[Former Member]

Hello Robert,

the error is that there is a bad page in the database. The general solution is to restore the last good data backup and then the subsequent log backups. You should also perform a thorough check of the system hardware.

If you are an SAP customer, please open a CSS message in component BC-DB-SDB, and open a service connection into the system.

Thanks,

Ashwath

[raeijpe]

Thanks Ashwath for your response, but because it was a new installation and I cannot restore the last good backup because i don't have one.

I remove the installation a couple of times and reinstall the central installation but I got the same problem again. So I did a distributed installation and this was working well.

with regards,

Robert