db_deletevolume gives err 9407 unexpected error

[Former Member]

Dear Gentlemans,

I tried to free up some datafiles:

db_deletevolume DATA 12

it was successful, so I continued

db_deletevolume DATA 11

it failed: (then it failed again later too)

2009-03-20 18:23:39 10826 ERR 51080 SYSERROR -9407 unexpected error

2009-03-20 18:23:39 10826 ERR 20076 IOMan Drop data volume failed - volume 11 still contains 6 pages

(database fill level is at 50%, so lack of space is not the error)

I made a chack data (extended is the default)

db_execute CHECK DATA

gives the error:

2009-03-21 09:02:19 10827 ERR 51080 SYSERROR -9046 BD No converter entry

The version is MAX DB 7.6.04.15

Please advice if we need to restore the database?

Thanks in advance!

Tibor Meszaros

[lbreddemann · Accepted solution]

> db_deletevolume DATA 11

> it failed: (then it failed again later too)

> 2009-03-20 18:23:39 10826 ERR 51080 SYSERROR -9407 unexpected error

> 2009-03-20 18:23:39 10826 ERR 20076 IOMan Drop data volume failed - volume 11 still contains 6 pages

> (database fill level is at 50%, so lack of space is not the error)

Hmm... without further inspection of the problem I would guess that you hit [PTS 1151963|http://maxdb.sap.com/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1151963].

>

> I made a chack data (extended is the default)

> db_execute CHECK DATA

> gives the error:

> 2009-03-21 09:02:19 10827 ERR 51080 SYSERROR -9046 BD No converter entry

>

>

> The version is MAX DB 7.6.04.15

>

> Please advice if we need to restore the database?

Try a CHECK DATA WITH UPDATE in ADMIN mode first.

This rebuilds the converter.

After that, you may install the current 7.6.06 patch.

regards,

Lars

[Former Member · Accepted solution]

Thank you!

Is it possible to upgrade first to required level and then to finish the check (first check with update doesn't finished yet, but it is running since 26 hours) and delete the volumes?

Kind Regards,

Tibor

Edited by: Tibor Meszaros on Mar 22, 2009 11:52 AM

Edited by: Tibor Meszaros on Mar 22, 2009 11:58 AM

[Former Member · Accepted solution]

Dear Lars,

Some other news:

2009-03-22 01:14:41 49C582F10001 0000 VER CHECK DATA WITH UPDATE

2009-03-22 12:00:43 49C61A5B0002 0000 REQ CHECK DATA EXCEPT INDEX

2009-03-22 12:00:43 49C61A5B0002 0001 RET RETURNCODE -9232;CHECK DATA EXCEPT INDEX ;

Database is in admin mode.

Kind Regards,

Tibor Meszaros