Grouper Users - Open Discussion List

[Scott Koranda <>]

On Mon, Jun 2, 2014 at 7:03 AM, Scott Koranda 
<>
 wrote:
> Hello,
>
> I am using Grouper version 2.1.5.
>
> A routine loader job that had run many time successfully before caused
> this error to be written to the log file:
>
> 2014-05-30 18:25:03,602: [DefaultQuartzScheduler_Worker-2] ERROR
> JDBCExceptionReporter.logExceptions(234) -  - ORA-00001: unique
> constraint (GROUPER.STEM_NAME_IDX) violated
>
> The loader job later ran without exception.
>
> Any ideas on why this type of error would be thrown?
>
> I can send the entry from the log file with the full stack trace if
> that would be helpful.
>
> Thanks,
>
> Scott

Hello,

The loader job logged another error last night of the same type. Below
is the full stack trace.

Any thoughts?

Thanks,

Scott


2014-06-11 20:40:04,322: [DefaultQuartzScheduler_Worker-6] ERROR
GrouperLoaderJob.execute(318) -  - Error running up job
edu.internet2.middleware.grouper.exception.StemAddException: cannot
create child stem: Problem in HibernateSession: HibernateSession:
isNew: false, isReadonly: false, grouperTransactionType:
READ_WRITE_NEW,
Exception in save: edu.internet2.middleware.grouper.Stem,
ByObjectStatic, query: ', cacheable: null, cacheRegion: null,
entityName: null, tx type: null,
Problem creating child stem:
edu.internet2.middleware.grouper.Stem$8@5f2ce977,
 extn: CSS, dExtn:
CSS, uuid: null, Problem in HibernateSession: HibernateSession: isNew:
false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,
Exception in save: edu.internet2.middleware.grouper.Stem,
ByObjectStatic, query: ', cacheable: null, cacheRegion: null,
entityName: null, tx type: null,
Problem in HibernateSession: HibernateSession: isNew: false,
isReadonly: false, grouperTransactionType: READ_WRITE_NEW,
Problem in HibernateSession: HibernateSession: isNew: true,
isReadonly: false, grouperTransactionType: READ_WRITE_NEW
    at edu.internet2.middleware.grouper.Stem$8.callback(Stem.java:2402)
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)
    at 
edu.internet2.middleware.grouper.Stem.internal_addChildStem(Stem.java:2324)
    at 
edu.internet2.middleware.grouper.Stem.internal_addChildStem(Stem.java:2304)
    at edu.internet2.middleware.grouper.Stem.addChildStem(Stem.java:522)
    at 
edu.internet2.middleware.grouper.Stem._createStemAndParentStemsIfNotExist(Stem.java:3333)
    at 
edu.internet2.middleware.grouper.GroupSave$1$1.callback(GroupSave.java:337)
    at 
edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:803)
    at 
edu.internet2.middleware.grouper.GroupSave$1.callback(GroupSave.java:274)
    at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1.callback(Hib3TransactionDAO.java:66)
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)
    at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.transactionCallback(Hib3TransactionDAO.java:56)
    at 
edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:87)
    at 
edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:106)
    at edu.internet2.middleware.grouper.GroupSave.save(GroupSave.java:267)
    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.lookupSubject(GrouperLoaderType.java:1566)
    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$3.runJob(GrouperLoaderType.java:454)
    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:413)
    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:315)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
    at 
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException:
Problem in HibernateSession: HibernateSession: isNew: false,
isReadonly: false, grouperTransactionType: READ_WRITE_NEW,
Exception in save: edu.internet2.middleware.grouper.Stem,
ByObjectStatic, query: ', cacheable: null, cacheRegion: null,
entityName: null, tx type: null,
Problem creating child stem:
edu.internet2.middleware.grouper.Stem$8@5f2ce977,
 extn: CSS, dExtn:
CSS, uuid: null, Problem in HibernateSession: HibernateSession: isNew:
false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,
Exception in save: edu.internet2.middleware.grouper.Stem,
ByObjectStatic, query: ', cacheable: null, cacheRegion: null,
entityName: null, tx type: null
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:495)
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:581)
    at 
edu.internet2.middleware.grouper.hibernate.ByObjectStatic.save(ByObjectStatic.java:468)
    at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO.createChildStem(Hib3StemDAO.java:225)
    at edu.internet2.middleware.grouper.Stem$8.callback(Stem.java:2367)
    ... 20 more
Caused by: org.hibernate.exception.ConstraintViolationException: Could
not execute JDBC batch update,
Exception in save: edu.internet2.middleware.grouper.Stem,
edu.internet2.middleware.grouper.hibernate.ByObject@6839e6b4
    at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
    at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at 
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
    at 
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
    at 
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
    at 
edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:214)
    at 
edu.internet2.middleware.grouper.hibernate.ByObjectStatic$7.callback(ByObjectStatic.java:481)
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:571)
    ... 23 more
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint
(GROUPER.STEM_NAME_IDX) violated

    at 
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
    at 
oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
    at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
    at 
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
    at 
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
    ... 31 more