grouper-users - [grouper-users] Re: 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] Re: upgrade from grouper api version 2.2.0 to grouper api version 2.30 getting error in PSPNG

From: "Bee-Lindgren, Bert" <>
To: Siju Jacob <>, " Mailing List" <>
Cc: Omer Almatary <>, Nazeer Syed <>
Subject: [grouper-users] Re: upgrade from grouper api version 2.2.0 to grouper api version 2.30 getting error in PSPNG
Date: Thu, 15 Feb 2018 20:07:10 +0000
Accept-language: en-US
Authentication-results: spf=none (sender IP is ) ;
Ironport-phdr: 9a23:GIVz0hYqBK2XsOz8gRCCnx3/LSx+4OfEezUN459isYplN5qZps64ZR7h7PlgxGXEQZ/co6odzbaO6Oa4ASQp2tWoiDg6aptCVhsI2409vjcLJ4q7M3D9N+PgdCcgHc5PBxdP9nC/NlVJSo6lPwWB6nK94iQPFRrhKAF7Ovr6GpLIj8Swyuu+54Dfbx9HiTahb75+Ngm6oRnMvcQKnIVuLbo8xAHUqXVSYeRWwm1oJVOXnxni48q74YBu/SdNtf8/7sBMSar1cbg2QrxeFzQmLns65Nb3uhnZTAuA/WUTX2MLmRdVGQfF7RX6XpDssivms+d2xSeXMdHqQb0yRD+v9LlgRgP2hygbNj456GDXhdJ2jKJHuxKquhhzz5fJbI2JKPZye6XQds4YS2VcRMZcTyxPDJ2hYYsTAeQPPuhYoIv8p1QSohSzHhOjCP/zxjJSmnP6wbA23uI8Gg/GxgwgGNcOvWzaoNjoKqgdT/m5wq/JzTXFcvxW1i3955bOchw5vPqBQKx/cdDNyUUhCgjIiU6fppL/PzOJzOgCqHaU4PR5WeKrim4nrRx+oje1xsgyjInEnYUVylHY9Sljz4Y6P8G4R1Bnbt6kCpdfqTyVN5ZvT84kXmpmtiE6yrgctp66eigH0JsnxwTYa/yaa4iH/AjjWPyLLjdgnHJpYLC/hxGp/ki61+38UNK00FZUoSpBltnArGoN1wHV6sWBV/Bz/V+h1C6R2w/J9u1IPEU5mbfGJ5I8x7MwmJUevVjfEiLzlkX5kqCbelkh9+Wt6enrfLXrqoeCO4J1lw3yLqEjltGwDOk7NwUCQmab9fii2LDm4EH0TqlGguAzn6TXrpzXKscWq6u5DgJX0osu6xOyAjik3dkXgHUKKU9JeByag4T3I13OLu73APSjj1mplTpmx+zJPrPgD5jILXXMjavtcah45kJCywc+w95S6pdQB74fPf78QUn8v8HCABAjKQy72ePnBc191owAXWKPBbeUPrvOvFGP+u4jPvCAapINtjrgMvQl4OXhgmEjlV8aYKmpwYAYaHelHvRgPkqVe2Lsgs0GEWcWoAUxUPDqiFyFUT5VfXqyWL885i0/CIKhCofDRZqhj6CG3Ce+BpFWZ2ZGBU6QEXrwaYmLQesAZD+XL8N8jzAISL2sS4Eu2B2yqAP3zrRnIfTb9yEEsJ/u0dp46/PTmB0q8Dx7FcWd02WDT2FumWMIQic707thrkxn1lePy7N3jOJGGtBK4/NJUwE6OoPTz+xgFd/yXBnMftCISFa6WNmmDis+Ts4vzNASY0ZxAcutgQ3e3yayGb8ai6SLBIAo8qLbx3XxKNx9y3Hb1Kk5kVYmWNJDNXC9hqFh7QjTHJXEk0GYl6axaaQcxzDB+H2CzWqIoEFXThRwUaPbUnADeEfat8r26V7fT+zmNbNyCQpD1IagI6BNYJW9llcZHK3LP9XCJXish2i9Hw3Oy7+ROs6iMWoH2zjFBVJBjhse522uNA4iCz2nrn6ESjFiCBrKakLo8O9x4Fe6VVN+h1WFdUp8z7evvwMOiOaHY/IVwr8evio98XN5EEvrjPzMDN/V7SBsceB4YNUx701K0yaRnQFnItboe6pvnEJYeQl6+kfv0Rl4EIhGuc8rsDUlxRZ/IqLe3V9cIWDLlavsM6HafzGhtCukbLTbjxSHiI6b
Spamdiagnosticmetadata: NSPM
Spamdiagnosticoutput: 1:99

Hello,

The debug message is from PSPNG, so just to do a quick sanity check:

Have the etc:attribute:userData:do_not_provision_to and :provision_to attribute been created? This should have happened on PSPNG's first run.

However, the Error message seems to be from a true loader job -- SQL_GROUP_LIST__apps:sp:sor...

Could it be that you have a Attribute-Related hook that is affecting the Loader's new attribute activity?

Sincerely,

Bert

From: <> on behalf of Siju Jacob <>
Sent: Thursday, February 15, 2018 2:47 PM
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

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