Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error -9407 while updating row.

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

Former Member
Not what you were looking for? View more on this topic or Ask a question