grouper-users - [grouper-users] upgrade from grouper api version 2.2.0 to grouper api version 2.30 getting error in PSPNG

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] upgrade from grouper api version 2.2.0 to grouper api version 2.30 getting error in PSPNG

From: Siju Jacob <>
To: " Mailing List" <>
Cc: Omer Almatary <>, Nazeer Syed <>
Subject: [grouper-users] upgrade from grouper api version 2.2.0 to grouper api version 2.30 getting error in PSPNG
Date: Thu, 15 Feb 2018 19:47:47 +0000
Accept-language: en-US
Authentication-results: spf=none (sender IP is ) ;
Ironport-phdr: 9a23:mqyybhYFPHCSiX0jqt+4aeT/LSx+4OfEezUN459isYplN5qZrsW4bnLW6fgltlLVR4KTs6sC17KN9fi4EUU7or+5+EgYd5JNUxJXwe43pCcHRPC/NEvgMfTxZDY7FskRHHVs/nW8LFQHUJ2mPw6arXK99yMdFQviPgRpOOv1BpTSj8Oq3Oyu5pHfeQpFiCazbL9oMBm6sRjau9ULj4dlNqs/0AbCrGFSe+RRy2NoJFaTkAj568yt4pNt8Dletuw4+cJYXqr0Y6o3TbpDDDQ7KG81/9HktQPCTQSU+HQRVHgdnwdSDAjE6BH6WYrxsjf/u+Fg1iSWIdH6QLYpUjm58axlVAHnhzsGNz4h8WHYlMpwjL5AoBm8oxBz2pPYbJ2JOPZ7eK7WYNEUSndbXstJVyJPHJ6yb5cBAeQCPOZXs4byqkAUoheiGQWhHv/jxiNKi3LwwKY00/4hEQbD3AE4AtwOsXbUrMjoP6kWS++60K7Iwi7eZP5Rwjf96orFfgw/rfyXWrJwcNbRxVM1FwPYklWQppLqPymO1ugXrWeU8vdgWPuphmU6pQ9xpT2vyd0tionPno8VxUrE9SJkwIYtO9K4UlR3bsS8EJtIry2aNYx2Tdg4Q2F1viY60b0GtoC/fCgO0pgn3QPfa/qBfoOV4RzjTP6cLSlii355Zb6yggu+/VW9xuD5WMm530pGojZAn9nCqH8A2ALf582CR/Z/4kus3S6D2x3N5uxHO0w5lLDXJpAjz7Iqi5Yfr0TOEynrk0vslqCWbF8r+u2w5uTnfLrmopicOpdshAziNaoihtGzDf0lPwcMQWSX4OO826b98kHjR7VKk+E2nbLesJDHI8QUu7S1AxdP0oYk9xawESup0MgZnXkAKlJJYhWHj5X1O1HKJ/D4CvS/j06wnzdswvDKJrzhApPTIXjfiLrtY6xy51JBxAc20NxT+o9YB7QPIP/8RkP9qNnVDhEnPAG73erqDdBw24ECVW+LGqOZNbndsV6M5uIhOemMY4oVtS7mK/gn5fPikWE1lEQafamowZsbcmq4Hul6I0WWf3XsmMwBHX0UsQUjUezmkEeCXiJLZ3auQ6I84Sk2CI28DYfEW4CtmKKO3D2iEp1LfWBJFEqMEWzzeoWAWvcMcz6SItR/njAeVLihTZMh2g+0tA/81bVnMvTY9jcGup3+ydgmr9HUwFs97ztpF8mHlnyWQntvtmIOWzIs2q1j+wpwxkrL9KF5h/1eGpR35uhVGE9uOoTb0vR3EZXvQQ/bZf+ITkqrWNOrHWt3Q94slYwgeUF4Tu6jjA2L/SOhBLVdw6eJW8Ru2qXdwz7rOtpyxmzdkqQtkg91EYN0KWS6i/snpEDoDInTnhDczv7yeA==
Spamdiagnosticmetadata: NSPM
Spamdiagnosticoutput: 1:99

Hi,

After upgrading from gouper 2.2.0 to 2.3.0, while trying to use pspng we are getting following error

2018-02-15 14:37:03,537: [DefaultQuartzScheduler_Worker-8] DEBUG Provisioner.evaluateJexlExpression(382) - - Evaluating Jexl _expression_: ${utils.containedWithin(provisionerName, stemAttributes['etc:attribute:userData:provision_to'], groupAttributes['etc:attribute:userData:provision_to']) && !utils.containedWithin(provisionerName, stemAttributes['etc:attribute:userData:do_not_provision_to'], groupAttributes['etc:attribute:userData:do_not_provision_to'])}

2018-02-15 14:37:03,538: [DefaultQuartzScheduler_Worker-9] ERROR GrouperLoaderJob.runJob(485) - - Error on job: SQL_GROUP_LIST__apps:sp:sor__19b35b6f57df4e86ad24a06a0eef002f

edu.internet2.middleware.grouper.exception.GrouperStaleObjectStateException: Problem in HibernateSession: HibernateSession (4eb495a1): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (4fa3d3df),

Hook GrouperAttributeAssignValueRulesConfigHook.attributeAssignValuePostDelete id: TNY6Y0Y3,

Problem in HibernateSession: HibernateSession (23363029): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (4fa3d3df),

Problem in HibernateSession: HibernateSession (6414545): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (4fa3d3df)

at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:581)

at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:710)

at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:340)

at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3AttributeDefNameDAO.findByNameSecure(Hib3AttributeDefNameDAO.java:159)

at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3AttributeDefNameDAO.findByNameSecure(Hib3AttributeDefNameDAO.java:182)

at edu.internet2.middleware.grouper.attr.finder.AttributeDefNameFinder.findByName(AttributeDefNameFinder.java:346)

at edu.internet2.middleware.grouper.rules.RuleUtils.ruleAttributeDefName(RuleUtils.java:340)

at edu.internet2.middleware.grouper.hooks.examples.GrouperAttributeAssignValueRulesConfigHook$1.callback(GrouperAttributeAssignValueRulesConfigHook.java:118)

at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:974)

at edu.internet2.middleware.grouper.hooks.examples.GrouperAttributeAssignValueRulesConfigHook.validateRule(GrouperAttributeAssignValueRulesConfigHook.java:108)

at edu.internet2.middleware.grouper.hooks.examples.GrouperAttributeAssignValueRulesConfigHook.attributeAssignValuePostDelete(GrouperAttributeAssignValueRulesConfigHook.java:67)

at sun.reflect.GeneratedMethodAccessor574.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at edu.internet2.middleware.grouper.util.GrouperUtil.invokeMethod(GrouperUtil.java:4163)

at edu.internet2.middleware.grouper.hooks.logic.GrouperHooksUtils.executeHook(GrouperHooksUtils.java:493)

at edu.internet2.middleware.grouper.hooks.logic.GrouperHooksUtils.callHooksIfRegistered(GrouperHooksUtils.java:293)

at edu.internet2.middleware.grouper.hooks.logic.GrouperHooksUtils.callHooksIfRegistered(GrouperHooksUtils.java:232)

at edu.internet2.middleware.grouper.hooks.logic.GrouperHooksUtils.callHooksIfRegistered(GrouperHooksUtils.java:158)

at edu.internet2.middleware.grouper.attr.value.AttributeAssignValue.onPostDelete(AttributeAssignValue.java:1117)

at edu.internet2.middleware.grouper.hibernate.ByObject.delete(ByObject.java:125)

at edu.internet2.middleware.grouper.hibernate.ByObjectStatic$10.callback(ByObjectStatic.java:675)

at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:700)

at edu.internet2.middleware.grouper.hibernate.ByObjectStatic.delete(ByObjectStatic.java:662)

at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3AttributeAssignValueDAO.delete(Hib3AttributeAssignValueDAO.java:190)

at edu.internet2.middleware.grouper.attr.value.AttributeAssignValue$1.callback(AttributeAssignValue.java:501)

at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:700)

at edu.internet2.middleware.grouper.attr.value.AttributeAssignValue.saveOrUpdate(AttributeAssignValue.java:466)

at edu.internet2.middleware.grouper.attr.value.AttributeAssignValueDelegate.internal_assignValue(AttributeAssignValueDelegate.java:218)

at edu.internet2.middleware.grouper.attr.value.AttributeAssignValueDelegate.assignValue(AttributeAssignValueDelegate.java:175)

at edu.internet2.middleware.grouper.attr.value.AttributeAssignValueDelegate.assignValue(AttributeAssignValueDelegate.java:282)

at edu.internet2.middleware.grouper.attr.value.AttributeValueDelegate.assignValue(AttributeValueDelegate.java:74)

at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.updateLoaderMetadataForGroupsNoLongerInLoader(GrouperLoaderType.java:1933)

at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncGroupList(GrouperLoaderType.java:1435)

at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(GrouperLoaderType.java:634)

at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:465)

at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:345)

at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)

Caused by: org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : [edu.internet2.middleware.grouper.attr.value.AttributeAssignValue#855866d9675341e6bbe0acdc57a0dd3c]

at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:2282)

at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3199)

at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3433)

at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:98)

at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:560)

at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434)

at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)

at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)

at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1224)

at edu.internet2.middleware.grouper.hibernate.HibUtils.evict(HibUtils.java:399)

at edu.internet2.middleware.grouper.hibernate.HibUtils.evict(HibUtils.java:355)

at edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:299)

at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:349)

at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:700)

... 37 more

2018-02-15 14:37:03,544: [DefaultQuartzScheduler_Worker-9] ERROR GrouperLoaderJob.execute(348) - - Error running up job