MaxDB-Trouble

[Former Member]

Hello Everybody,

I'm having a huge Problems with the MaxDB Database for my ERP-System.

*ERR*
*-24988,ERR_SQL: SQL error*
*-902,I/O error*

The bad news, I have no Backup of the Database, because there's no sufficient space for it.

The second bad news, I updated my windows server 2003 while the SAP-System was running and a message appeared telling me you should use the original CD to restore the previous configuration version of Win2003 because the system is not stable.

The last bad news is that our Network Administration performed updates and has shutdown all the systems, the thing is that our system is running on top of VM-Ware machine.

After, the reboot has been performed and the system is running, I wanted to start the SAP-System but I got this massive Problem which I think will let me reinstall everything, what a thing.

What is the Problem with the File System and what's this so called the DevSpace, is it related to the VM-Ware ?

Ps. one another thing that I'm using the MaxDb-Manager v. 7.6.03 and my database is on v.7.6.02

Edited by: Kais El Kara on Aug 14, 2009 12:32 PM

[Former Member · Accepted solution]

I'm getting the following error : (I already checked knldiag.err)

2009-08-08 03:18:43 0x81C ERR 18431 MESSAGES Could not write to event log, rc = 5

2009-08-08 14:28:20 --- Starting GMT 2009-08-08 12:28:20 7.6.02 Build 012-123-151-053

2009-08-08 14:28:29 0x4F8 ERR 18177 VOLUMEIO No volume on compressed file 'c:\sapdb\XXX\sapdata\DISKD0001'

2009-08-08 14:28:29 0x3DC ERR 20027 IOMan Attach error on data volume 1: no volumes on compressed file

2009-08-08 14:28:29 0x3DC ERR 3 Admin Database state: OFFLINE

2009-08-08 14:28:29 0x3DC ERR 6 KernelCo + Internal errorcode, Errorcode 9050 "disk_not_accessible"

2009-08-08 14:28:29 0x3DC ERR 20017 Admin + RestartFilesystem failed with 'I/O error'

2009-08-08 14:28:29 0x37C ERR 7 Messages Begin of dump of registered messages

2009-08-08 14:28:29 0x37C ERR 10 Messages abort dump of registered messages

2009-08-08 14:28:29 0x37C ERR 8 Messages End of the message list registry dump

2009-08-08 14:28:31 ___ Stopping GMT 2009-08-08 12:28:31 7.6.02 Build 012-123-151-053

2009-08-08 15:35:19 --- Starting GMT 2009-08-08 13:35:19 7.6.02 Build 012-123-151-053

2009-08-08 15:35:26 0xA2C ERR 18177 VOLUMEIO No volume on compressed file 'c:\sapdb\XXX\sapdata\DISKD0001'

2009-08-08 15:35:26 0xA84 ERR 20027 IOMan Attach error on data volume 1: no volumes on compressed file

2009-08-08 15:35:26 0xA84 ERR 3 Admin Database state: OFFLINE

2009-08-08 15:35:26 0xA84 ERR 6 KernelCo + Internal errorcode, Errorcode 9050 "disk_not_accessible"

2009-08-08 15:35:26 0xA84 ERR 20017 Admin + RestartFilesystem failed with 'I/O error'

2009-08-08 15:35:26 0xA04 ERR 7 Messages Begin of dump of registered messages

2009-08-08 15:35:26 0xA04 ERR 10 Messages abort dump of registered messages

2009-08-08 15:35:26 0xA04 ERR 8 Messages End of the message list registry dump

2009-08-08 15:35:27 ___ Stopping GMT 2009-08-08 13:35:27 7.6.02 Build 012-123-151-053

2009-08-08 15:35:32 --- Starting GMT 2009-08-08 13:35:32 7.6.02 Build 012-123-151-053

2009-08-08 15:35:35 0xAC0 ERR 18177 VOLUMEIO No volume on compressed file 'c:\sapdb\XXX\sapdata\DISKD0001'

2009-08-08 15:35:35 0xB18 ERR 20027 IOMan Attach error on data volume 1: no volumes on compressed file

2009-08-08 15:35:35 0xB18 ERR 3 Admin Database state: OFFLINE

2009-08-08 15:35:35 0xB18 ERR 6 KernelCo + Internal errorcode, Errorcode 9050 "disk_not_accessible"

2009-08-08 15:35:35 0xB18 ERR 20017 Admin + RestartFilesystem failed with 'I/O error'

2009-08-08 15:35:35 0xAAC ERR 7 Messages Begin of dump of registered messages

2009-08-08 15:35:35 0xAAC ERR 10 Messages abort dump of registered messages

[markus_doehr2 · Accepted solution]

> 2009-08-08 14:28:29 0x4F8 ERR 18177 VOLUMEIO No volume on compressed file 'c:\sapdb\XXX\sapdata\DISKD0001'

> 2009-08-08 14:28:29 0x3DC ERR 20027 IOMan Attach error on data volume 1: no volumes on compressed file

Just saw that you posted the output already.

Uncompress the DATA foldes, database files should NEVER be compressed.

Markus

[Former Member · Accepted solution]

Hi Markus

Thanks for replying.

What's actually a compressed file, I didn't do anything to compress them.

They still have 9GB.

I think also that the Driver "C" is not a compressed Driver.

I can only denote that they have attributes i.e. AC

ps. Here is an important thing, I deleted the compressed files using the Disk clean up, there was 30GB of compressed file.

By should I reboot, actually it hasn't worked jet.

Regards,

Kais

Edited by: Kais El Kara on Aug 14, 2009 12:48 PM

[markus_doehr2 · Accepted solution]

> What's actually a compressed file, I didn't do anything to compress them.

Windows explorer -right click - properties - compress.

> They still have 9GB.

Yes - but they are compressed - which doesn't work for database files.

> I think also that the Driver "C" is not a compressed Driver.

Check it! The database wouldn't tell that the file is compress if it wouldn't be. Also check if maybe just the subdirectory is compressed. You can enable in explorer that compressed files are displayed in a different color (please check with your Windows admin).

> ps. Here is an important thing, I deleted the compressed files using the Disk clean up, there was 30GB of compressed file.

> By should I reboot, actually it hasn't worked jet.

??

Markus

[Former Member · Accepted solution]

Oh, I understand now.

So, the only thing to do, is to change this option.

I'll report back, if it has worked after changing the properties of all the 10 files.

Problem, has been resolved.

Thanks A Lot.

Best Regards,

Kais

Edited by: Kais El Kara on Aug 14, 2009 2:21 PM

[markus_doehr2]

> I'm having a huge Problems with the MaxDB Database for my ERP-System.

>

>

> *ERR*
> *-24988,ERR_SQL: SQL error*
> *-902,I/O error*
> 

Please check the files "knldiag" and "knldiag.err" for the real error message.

> After, the reboot has been performed and the system is running, I wanted to start the SAP-System but I got this massive Problem which I think will let me reinstall everything, what a thing.

Not necessarily...

> What is the Problem with the File System and what's this so called the DevSpace, is it related to the VM-Ware ?

Please check above logs

Markus