Hi,
When i insert a record in a progress table using jdbc, the index for this record always gets currupted. When i try to delete it, i get the error :
SYSTEM ERROR: Index cl-err-det-edi in err-det-edi for recid 143216484 could not
be deleted. (1422)
And i can't access this record using its primary key, although a find with the recid works fine. (and the data in the fields is correct).
The strange thing is that the problem only occur with this perticular table. i create other records in different tables and they are fine.
We've tried rebuilding the index. It works, but as soon as i insert another record, the index get currupted again.
Inserting a record with a sql insert statement in the progres editor works. Obviously a create/update works too.
Could this be a jdbc driver bug? but then, why can i insert into other tables without currupting the index?
anyone ran into this before?
thanks!
jean-francois dufour
When i insert a record in a progress table using jdbc, the index for this record always gets currupted. When i try to delete it, i get the error :
SYSTEM ERROR: Index cl-err-det-edi in err-det-edi for recid 143216484 could not
be deleted. (1422)
And i can't access this record using its primary key, although a find with the recid works fine. (and the data in the fields is correct).
The strange thing is that the problem only occur with this perticular table. i create other records in different tables and they are fine.
We've tried rebuilding the index. It works, but as soon as i insert another record, the index get currupted again.
Inserting a record with a sql insert statement in the progres editor works. Obviously a create/update works too.
Could this be a jdbc driver bug? but then, why can i insert into other tables without currupting the index?
anyone ran into this before?
thanks!
jean-francois dufour
