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: Baron Fujimoto <>
  • To: Shilen Patel <>
  • Cc: Grouper Users <>
  • Subject: Re: [grouper-users] loader exception - where to find ActivePITMember with sourceId= ?
  • Date: Fri, 25 Jan 2019 14:46:23 -1000
  • Ironport-phdr: 9a23:dbSFPRLtNWrMCN5LWtmcpTZWNBhigK39O0sv0rFitYgeLPnxwZ3uMQTl6Ol3ixeRBMOHs6IC07KempujcFRI2YyGvnEGfc4EfD4+ouJSoTYdBtWYA1bwNv/gYn9yNs1DUFh44yPzahANS47xaFLIv3K98yMZFAnhOgppPOT1HZPZg9iq2+yo9JDffwZFiCChbb9uMR67sRjfus4KjIV4N60/0AHJonxGe+RXwWNnO1eelAvi68mz4ZBu7T1et+ou+MBcX6r6eb84TaFDAzQ9L281/szrugLdQgaJ+3ART38ZkhtMAwjC8RH6QpL8uTb0u+ZhxCWXO9D9QKsqUjq+8ahkVB7oiD8GNzEn9mHXltdwh79frB64uhBz35LYbISTOfFjfK3SYMkaSHJPUMhRSSJPH4Cyb4UAAOUdIOlWoIvyqFUVoBuiBgShHv/jxiNSi3L026AxzuQvERvB3AwlB98DrW7brM/yNKcUTOu7zLTIzTfCb/NT3jf99I/IeQ0mrP6XR71wa83RyU80GgPFlFqRp5bqPzKU1ugXrWeU8vdgWPuphmU6pQ9xpT2vyd0tionPno8Vy1bE9Tlnz4YvI923VlJ7bcC+HJROqi6aKo17Sd4hTWFwoCs21LwLtYK5cSUPxpQqxAXQZ+CCfoWH4R/uVemcLDJmiH55fb+yghe//Eagx+HkS8W4zlVHojBYntTOq3wBzQHf5tKZRvZ740yvwyyA1xrJ5eFBOU00lbTUK5omwrMok5ocq0XDHivvlEXuiK+aa1wo++ep5unpYrjqvJCcN4hzigHxNqQhhNazDvg/MggLR2Sb+OK826P//UDhXrlHj+E6n6vcvZDUJskUvbK1Dgpa34sg6huyADKr3MoEkXQCKV9IeRyKgojxN1HLOv/4DPO/g1q2kDdswvDLJqbuDY/XLnjElrfsZrZ95FRSyQUpzNBf5ohYBa8cL/LuQkPxrsDXDgclMwyoxObqENp91pkZWWKSGq+WLrnSvUaV5uI0PeaMfpQVtS35K/gk/P7ukWQ5lUUcfamvwZsYdmq4HvJ4LEWFf3bgmMkOHnoXvll2cOu/s12DVTNVL067Q684rmUgCIOiAIHrSp2ujfqM0DrtTbNMYWUTIFmWFnGgWZiGWvILdCXadsVoiDsCfbioVIYg1FejuBKsmOkvFfbd5iBN7cGr79Ny/eCG0EhqrTE=

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 to
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
>- 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 down?

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

Archive powered by MHonArc 2.6.19.

Top of Page