Skip to Content.
Sympa Menu

grouper-users - [grouper-users] SQLIntegrityConstraintViolationException from one of the loader jobs

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] SQLIntegrityConstraintViolationException from one of the loader jobs


Chronological Thread 
  • From: Kumi Hagimoto <>
  • To:
  • Subject: [grouper-users] SQLIntegrityConstraintViolationException from one of the loader jobs
  • Date: Tue, 17 Jan 2017 20:56:35 +0000 (UTC)
  • Ironport-phdr: 9a23:qHF+lh90M06BpP9uRHKM819IXTAuvvDOBiVQ1KB+0+4QIJqq85mqBkHD//Il1AaPBtSHrakbwLON4ujJYi8p2d65qncMcZhBBVcuqP49uEgeOvODElDxN/XwbiY3T4xoXV5h+GynYwAOQJ6tL1LdrWev4jEMBx7xKRR6JvjvGo7Vks+7y/2+94fdbghMizexe71/IRe5oQnMuMQbhZZpJ7osxBfOvnZGYfldy3lyJVKUkRb858Ow84Bm/i9Npf8v9NNOXLvjcaggQrNWEDopM2Yu5M32rhbDVheA5mEdUmoNjBVFBRXO4QzgUZfwtiv6sfd92DWfMMbrQ704RSiu4qF2QxDvlCoKOTw0/W/OhsBska5QvRatqhN7zoLRZoyeKfhwcb7Hfd4CW2RPXttfWC5CDIyzc4QBAO0PM+hDoonhulUDtweyCBOwCO/xzDJDm3/43bc90+QkCQzI2REgH9cPsH/Jrtv6LqgSUeGwzKnP0TXDaO5d1DD+6IjVdxAhoOuAXbJqfsreyEkvEgTFjkmXqYH+ODOVzPoCs2ec7+pmTuKvl3Qoqx1vrTS12Mgjl5TJi5sTx1vZ+yt5x4M1Kse5SE59edOrC5tRtyaBOIt0XMwtX31ouD0myrIcpZ67fTQFxI48xxHFdfyIbZCE4h35VOaWPDd4nGxqeKilixmo6Uig0vXwVtW00FZQsCVKiMTDumoX1xzO7MiLUvt9/ka61juB0gDc9ORELlsqmqrBMJ4hwr8wloIOvkvZGS/6gl72g7WIdko64uSo5P7nYrL7pp+EKYB0kB3xPb4qmsy7G+s3KQwOUHaB9eugzrLj+Un5TK1Rgfw2lanWq5LaKtoHqa6lGQNVyZws6wihADu+3tQYgGUHLE9feB2Zk4jmIUrOIPPiAfelnlSsljFmzO3FML35GpjBMGTPnbX7cbt/60NQ0hc/wNFQ6p5OFL0NPu//V0nsv9LCFBA5KRa7w+P/BdV9yIweXWWPD7edMKPTql+I+vkvL/eWaI8Uvjb9N+Yq5+TojXAnhV8RY7Ol0oUKZ3ClBvhmIkOZbmTwgtoZD2sGoggzQPbohVCCSzJfene/Uq0m6j0lFo6qEJ/PRoW3j7yA2Ce7EIdWZmdDCl2UCXfoap6LW+wMaSKXOs9uiCcJVbmnS489yx6urgn6xKR7LubK4CEXq4/s1MVt6+3JiR4y7SB0D9ia02yVQGF0hGQIRyIu3K9hu0xx00qD0bNmjPxCDtxe/PdJUgYhNZ7A1Ox2Fcr+WgPHfteVVlmmWNOmDi8tTt4v2dMBfVtyG8jxxizEiiWwBKINmqbOGYc56Ln03n7tKtx7xmqckqQtkgoIWMxKYE67g6831wHcBovOj0LRw6W3cKVa3CfC9WKE0W2mu1tVXwl2SrnMQX1Za0fL+4eqrnjeRqOjXOx0ejBKztSPf/cbZw==

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)



Archive powered by MHonArc 2.6.19.

Top of Page