Re: Oracle exception USER.INDEX_QUERY violated

From: tricky <tricky_at_poczta.onet.pl>
Date: Thu, 9 Oct 2008 12:07:08 +0200
Message-ID: <gcklfc$aga$1@mx1.internetia.pl>

i'm using toplink and the full exception is

[TopLink Warning]: 2008.10.09 11:58:32.695--UnitOfWork(127474599)--Exception
[TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build b58g-fcs
(09/07/2007))): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: java.sql.SQLException: ORA-00001: unique constraint (IBS_O.INDEX_QUERY) violated

Error Code: 1
Call: INSERT INTO VFDEEVENTS (ID, NUMMINFREJ, CLOSESTRES, QUERYIMAGENAME, CLOSESTMINF, ANSMODELNUM, RESIDUAL, CLIIDINT, GROUPID, CUSTOMID, TS, UN, SEL, DIST, SENDER, PROB, KEYWORD, DEFGS, MMSRELAYSERVERID, DEFMAXRESIDUAL, MMSTEXT, DEFFEATSTRENGTH, TRANSID, DETNOM, ANSWERTYPE, NUMRESREJ, ANSWERTEXT, NOM, ANSWERACK, CLIIDSTR, PROCTIMEWS, DT, PROCTIME, DEFMINNUMF, SERVERID, DEFFEATQUAL, DISPDT, DETNUMF, ANSWERDT, ANSMODELLABEL, IMGWIDTH, NUMF, IMGHEIGHT, DEFDETTHRESHOLD, IMGSIZE, ERRCODE, WITHINMIQTIMESTAMP, WITHINIBSTHREADTIMESTAMP, DEFUPS, WITHINSOQTIMESTAMP) VALUES (?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
        bind => [20, null, null, 1223546312524, null, null, 12.551, 0, 0, 0, 

2008-10-09 11:58:32.687, 1223546312524, 0, 1.04013, 4242, 1.0, BILD, null, ,

null, null, 0.7, null, null, null, null, null, null, null, +49555555558, 
null, 2008-10-09 11:58:32.524, null, 7, 1, 0.7, null, 2083, null, null, 
null, 17, null, 0.999, null, null, null, 2008-10-09 11:58:32.524, 0, 

2008-10-09 11:58:32.686]
Query:
InsertObjectQuery(otello.ibs.rel1.prj047_02.common.pul.dwh.VfdeeventsModel[id=20]) 09 Oct 2008 11:58:32,697 ERROR [BCORE] ( otello.ibs.rel1.prj047_02.common.pul.dwh.DwhApi cVfdeevents:1255 )
[GUMobileToken|nosession] Cannot persist the VfdeeventsModel:
javax.persistence.RollbackException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: java.sql.SQLException: ORA-00001: unique constraint (IBS_O.INDEX_QUERY) violated Received on Thu Oct 09 2008 - 05:07:08 CDT