petert
Member
HI List
I have run into a strange one. R42800 was updating / inserting into F4229 depending on whether it found a record or not. All of a sudden it stopped doing that and now only inserts if no record is found. If it finds a record I get an error message as follows:-
14688 Thu Feb 27 23:43:17 2003 dbperfrq384
OCI0000179 - Error - ORA-00001: unique constraint (PRODDTA.F4229_1) violated
14688 Thu Feb 27 23:43:17 2003 jdb_drvm.c887
JDB9900401 - Failed to execute db request
14688 Thu Feb 27 23:43:17 2003 jdb_exet.c2306
JDB3600011 - Failed to perform Update for F4229
I have tried everything - I have regenerated the index (both from Oracle and from JDE). We are using R42800 vanilla.
I have rebuilt and deployed an update package for R42800 as well.
I have found nothing recent on the KG.
Any other suggestions?
I have run into a strange one. R42800 was updating / inserting into F4229 depending on whether it found a record or not. All of a sudden it stopped doing that and now only inserts if no record is found. If it finds a record I get an error message as follows:-
14688 Thu Feb 27 23:43:17 2003 dbperfrq384
OCI0000179 - Error - ORA-00001: unique constraint (PRODDTA.F4229_1) violated
14688 Thu Feb 27 23:43:17 2003 jdb_drvm.c887
JDB9900401 - Failed to execute db request
14688 Thu Feb 27 23:43:17 2003 jdb_exet.c2306
JDB3600011 - Failed to perform Update for F4229
I have tried everything - I have regenerated the index (both from Oracle and from JDE). We are using R42800 vanilla.
I have rebuilt and deployed an update package for R42800 as well.
I have found nothing recent on the KG.
Any other suggestions?