Error -9407 while updating row.

[thomas_huebner2]

Hello!

I'm using 7.7.6.

I'm updating a couple of rows in a table with this syntax:

create table s_entity (

ETYID FIXED(38,0) PRIMARY KEY CONSTRAINT ETYID_chk check (ETYID >= 0),

name VARCHAR(100) UNICODE NOT NULL,

ETTID FIXED(38,0) NOT NULL,

MID FIXED(38,0),

active BOOLEAN DEFAULT true NOT NULL,

status INTEGER DEFAULT 0 NOT NULL,

configuration LONG BYTE

)

But when doing this the DB instance crashes with the error in the knldiag:

Thread 0x1D0 Task 46 2011-05-11 10:57:07 ERR SYSERROR 51080: -9407 unexpected error

Thread 0x1D0 Task 46 2011-05-11 10:57:07 ERR Converter 22: Invalid file system index,PERSISTENT_TYPE=perm,PAGENO=2147483647,FILESYSTEMINDEX=89,_FILE=Converter_Converter.cpp,_LINE=3124

Any idea what I can do?

I tried a "sql_recreateindex" and the result was "OK". (Before the recreation CHECK DATA delivered an error.) Anyhow, the behaviour is the same after the recreation.

Any kind of hint is really highly appreciated,

Chris

[steffen_schildberg]

Hi Chris,

in case you are SAP customer please open a OSS message.

But anyway is it right that the problem persists after restarting the system?

Would you mind to post the call stack found in KnlMsg file - I think best would be you email the file complete (including the call stack) directly to me because the forum software garbles the input usually in a way that is unreadable.

Best regards,

Steffen