Skip to Content

SQL Error: -9111

Hi,

we are using MaxDB 7.8.01.18 on SuSe Linux Enterprise Server 10 SP2 in a Java environment

with JBoss 6.

Now I have a problem updating a row in a table.

I get the following error:

SQL Error: -9111, SQLState S9111

[-9111]: y           0226 (Input Position 2)

I already had this problem in the past with some other tables and the following workaround solved the Problem

Export catalog and data of the table

drop the table

Import catalog and data

But is there an other solution for this problem ?

Because for tables with many rows, the Export and Import lasts very Long.

Thanks!

Regards

Reinhard

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 05, 2013 at 09:15 AM

    Hi Reinhard,

    7.8.01. is a very old MaxDb version. We did a lot of bug fixes in the next release 7.8.02. I recommend to upgrade your database to 7.8.02 newst patch avaialble.

    Regards, Christiane

    Add comment
    10|10000 characters needed characters exceeded