Grouper Users - Open Discussion List

[Kumi Hagimoto <>]

Hi,

We got the following error message in the log over the weekend trying to add
membership via a sql loader job.  It's only happened this one time in the past
week, so I don't know if there's a pattern yet.  I did look at the loader
source table to make sure we had unique set of data.  Has anyone encountered
this error?  Any pointers are appreciated.

Thanks,
Kumi

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique
constraint (GROUPER.MEMBERSHIP_UNIQ_IDX) violated

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:459)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:999)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:539)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:235)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:543)
        at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:239)
        at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.ja
va:1448)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePre
paredStatement.java:17722)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatemen
t.java:17849)
        at
oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.
java:785)
        at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPrepar
edStatement.java:2544)
        at
org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(Batchi
ngBatch.java:110)
        at
org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(Batching
Batch.java:97)
        at
org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBat
chImpl.java:147)
        at
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordi
natorImpl.java:214)
        at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:589)
        at
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434)
        at
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(A
bstractFlushingEventListener.java:337)
        at
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEve
ntListener.java:39)
        at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1224)
        at
edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:221)
        at
edu.internet2.middleware.grouper.hibernate.ByObjectStatic$7.callback(ByObjectS
tatic.java:494)
        at
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateS
ession(HibernateSession.java:700)
        at
edu.internet2.middleware.grouper.hibernate.ByObjectStatic.save(ByObjectStatic.
java:481)
        at
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.save(Hib3
MembershipDAO.java:2077)
        at
edu.internet2.middleware.grouper.Membership.fixComposites(Membership.java:2272
)
        at
edu.internet2.middleware.grouper.Membership.processPostMembershipSaveOrUpdate(
Membership.java:2173)
        at
edu.internet2.middleware.grouper.Membership.onPostSave(Membership.java:1997)
        at
edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:224)
        at
edu.internet2.middleware.grouper.hibernate.ByObjectStatic$7.callback(ByObjectS
tatic.java:494)
        at
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateS
ession(HibernateSession.java:700)
        at
edu.internet2.middleware.grouper.hibernate.ByObjectStatic.save(ByObjectStatic.
java:481)
        at
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.save(Hib3
MembershipDAO.java:2077)
        at
edu.internet2.middleware.grouper.Membership.internal_addImmediateMembership(Me
mbership.java:1246)
        at edu.internet2.middleware.grouper.Group$4.callback(Group.java:1392)
        at
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateS
ession(HibernateSession.java:700)
        at
edu.internet2.middleware.grouper.Group.internal_addMember(Group.java:1364)
        at edu.internet2.middleware.grouper.Group.addMember(Group.java:938)
        at edu.internet2.middleware.grouper.Group.addMember(Group.java:857)
        at
edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncOneMemberAdd
MemberLogic(GrouperLoaderType.java:4159)
        at
edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.access$400(Group
erLoaderType.java:118)
        at
edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$12$2.callLogic(G
rouperLoaderType.java:2647)
        at
edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$12$2.callLogic(G
rouperLoaderType.java:2643)
        at
edu.internet2.middleware.grouper.util.GrouperCallable$1.callback(GrouperCallab
le.java:164)
        at
edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(Grouper
Session.java:974)
        at
edu.internet2.middleware.grouper.util.GrouperCallable.callLogicWithSessionIfEx
ists(GrouperCallable.java:161)
        at
edu.internet2.middleware.grouper.util.GrouperCallable.call(GrouperCallable.jav
a:132)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145
)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615
)
        at java.lang.Thread.run(Thread.java:745)