Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] loader exception - where to find ActivePITMember with sourceId= ?

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] loader exception - where to find ActivePITMember with sourceId= ?

Chronological Thread 
  • From: Shilen Patel <>
  • To: Baron Fujimoto <>
  • Cc: Grouper Users <>
  • Subject: Re: [grouper-users] loader exception - where to find ActivePITMember with sourceId= ?
  • Date: Sat, 26 Jan 2019 02:07:14 +0000
  • Accept-language: en-US
  • Ironport-phdr: 9a23:2JG93RZ6sgNNDh8nf1/m9Ib/LSx+4OfEezUN459isYplN5qZr8S7bnLW6fgltlLVR4KTs6sC17KG9fi4EUU7or+5+EgYd5JNUxJXwe43pCcHRPC/NEvgMfTxZDY7FskRHHVs/nW8LFQHUJ2mPw6arXK99yMdFQviPgRpOOv1BpTSj8Oq3Oyu5pHfeQpFiCa+bL9oMBm6sRjau9ULj4dlNqs/0AbCrGFSe+RRy2NoJFaTkAj568yt4pNt8Dletuw4+cJYXqr0Y6o3TbpDDDQ7KG81/9HktQPCTQSU+HQRVHgdnwdSDAjE6BH6WYrxsjf/u+Fg1iSWIdH6QLYpUjm58axlVAHnhzsGNz4h8WHYlMpwjL5AoBm8oxBz2pPYbJ2JOPZ7eK7WYNEUSndbXstJVyJPHJ6yb5cBAeQCM+ZXrYfyp1oSohWxCgahH//vxSRNhnPqwaE3yeYsHAfb1wIgBdIOt3HUoc3oOqcSUOC1yLfHzTPeZP1Mwzj99JbHchQ8qvyLRrJwccvRyU0xGAPDlViftJHlPzCL2egXrWeU8vdgWPuphmU6pQ9xpT2vyd0tionPno8V0krE9SJ+wIY7Pd24T097Ydi4EJdKqy6aMI52T8U/SG9roCY30qAKtJ6lcCQQxpkr3QPTZv+DfoSS/B7uW/udLS9liH9nZr6znRS//Ee6xuHhSsW4zExGojdLn9XRrnwN2QLc58ubRvZ4+0qs1iqA2g7c5+xBIk04i7bUJpwkz7M0i5UfrUXOEyr1lUnrkaCbdkMp8fWy5ev9eLXpvJqcOpd0ig7gNqQundSyAeEiPQgPW2iX4Ou81bP68UHkQLhGlPo2kqjFsJzAOMsbu625DBFP3ok99hm/Ei+q0NUenXYZMFJIYA+Lgoj3N13ULv30F+qzjleonTtx2fzLMaDtDo3ILnfZkbfhebh961RbyAo21d1f/JJUCrAFIP3tXE/8r8HXDgI6MwOq2eroFshy1p4GVWKVHqCZKL/SsUOP5u83LOmMfogVuCvlK/c7/f7ilGI5mUQDcqmzxpsac3S4HvV9I0WFenrgmNYBEWEWvgUgVuzqjkONUSJNa3qoQa0z+yw7W8qaCtLpT5qqhvSvwSW6G5pKYSgSAFmWFnHAd4ybUvYNLi+eP5kyvCYDUO2aS44l2BfmjAbmxr4vevHU+ykVs7rvydt4oeDfiEdhpnRPE82B3jTVHClPlWQSSmpzhfgnrA==

Try removing the ‘BEQUEATH DEFINER’ from that statement?


- Shilen

On 1/25/19, 7:46 PM, "Baron Fujimoto" <> wrote:

Thanks, this looks promising. I got as far as running
edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables(), but
encountered syntax errors[*] trying to create GROUPER_CHANGE_LOG_TEMP_V...
possibly due to our older version of MySQL. I'll see if I can sort them out
and find workarounds to continue.

[*] E.g.:

ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right syntax
SELECT gcle.created_on,
gclt.change_log_categor' at line 33

On Fri, Jan 25, 2019 at 08:16:10PM +0000, Shilen Patel wrote:
>Does it seem like this issue?

>If so, it was fixed in a 2.3 patch. But the wiki tells you how to
update the timestamp in the temp changelog to get past it if you don’t have
the patch.
>- Shilen
>On 1/25/19, 2:57 PM, " on behalf of
Baron Fujimoto" < on behalf of
> wrote:
> Every so often when running
loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog") from gsh, we encounter
errors aprently due to table/entry inconsistencies that I have to manually
try to hunt down and clean up (I don't know what the root cause of these
inconsistencies might be).
> Today, the current exception is:
> // Error: unable to evaluate command: Sourced file: inline
evaluation of: ``loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog");'' :
Error invoking compiled command: : Error in compiled command:
java.lang.RuntimeException: java.lang.RuntimeException: Active PITMember with
sourceId=4d799e6a04594a128af363db89478f3b not found,
> Problem in HibernateSession: HibernateSession (4087f108): new,
notReadonly, READ_WRITE_NEW, notActiveTransaction, session (1e769d81)
> I'm not sure where to find this offending entry though. I've
attempted to search the grouper_pit_* tables for a source_id column with that
value without success, but perhaps/probably it's in some other table under
different column that is being used as the source_id? Any tips tracking this

Baron Fujimoto <> :: UH Information Technology Services
minutas cantorum, minutas balorum, minutas carboratum desendus pantorum

Archive powered by MHonArc 2.6.19.

Top of Page