cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Error: -9111

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (0)