[Building Sakai] Error on Delegated Access Tool

[Bryan Holladay]

Are you running Oracle? :)

So far I've only seen this on one Oracle instance.  I'm actually going to
start looking into this error this week and will hopefully have a fix for
it.  In the mean time, you can fix the job by doing the following:

1) Make sure all the null titles/descriptions are removed:


Update HIERARCHY_NODE hn

right join (select ID from HIERARCHY_NODE_META where TITLE is null or
description is null) a on hn.childIds like concat('%:', concat(a.ID, ':%'))

set hn.childIds = replace(hn.childIds, concat(':', concat(a.ID, ':')), ":");



Update HIERARCHY_NODE hn

right join (select ID from HIERARCHY_NODE_META where TITLE is null or
description is null) a on hn.directchildIds like concat('%:', concat(a.ID,
':%'))

set hn.directchildIds = replace(hn.directchildIds, concat(':', concat(a.ID,
':')), ":");



*Run both of the updates until you see "0 record(s) affected".  Once all
updates are complete, then you can run the delete queries below


Delete From HIERARCHY_PERMS where nodeId in (select ID from
HIERARCHY_NODE_META where title is null or description is null);

Delete from HIERARCHY_NODE where id in (select ID from HIERARCHY_NODE_META
where title is null or description is null);

Delete From HIERARCHY_NODE_META where title is null or description is null;



2) Update the job last ran flag to a time before you saw this error:


Select * FROM HIERARCHY_PERMS where permission like
'siteHierarchyJobLastRunDate%'

(update this record)


3)  Make sure the Indexes are in sync


There are 3 indexes:


HIERARCHY_NODE

HIERARCHY_NODE_META

HIERARCHY_PERMS


Make sure all those indexes are larger than the max ID for each table.
 Very Important:  Make sure HIERARCHY_NODE and HIERARCHY_NODE_META
indexes's nextval are the same value.


If you have any information on why you think this happened, let me know
(definitely let me know if it's Oracle or not).  I will be debugging the
quartz job and anything will help.


Thanks,

Bryan


On Wed, Jun 19, 2013 at 12:30 PM, Liu, Peter <peter.liu at yale.edu> wrote:

>  Hi,****
>
> ** **
>
> I try to build and update the site-hirarchy by running the job: ‘Delegaed
> Access Site Hierarchy Job’  for Fall 2013 (New one).  It gives me the
> following errors shown below.****
>
> ** **
>
> Has anyone seen it or have any idea?  What will be the solution? ****
>
> ** **
>
> Thanks a lot!****
>
> Peter****
>
> ** **
>
> - - - - - - - ****
>
> java.lang.IllegalArgumentException: Invalid node id, cannot find node with
> id: 27673****
>
>         at
> org.sakaiproject.hierarchy.impl.HierarchyServiceImpl.saveNodeMetaData(HierarchyServiceImpl.java:338)
> ****
>
>         at
> org.sakaiproject.delegatedaccess.jobs.DelegatedAccessSiteHierarchyJob.checkAndAddNode(DelegatedAccessSiteHierarchyJob.java:235)
> ****
>
>         at
> org.sakaiproject.delegatedaccess.jobs.DelegatedAccessSiteHierarchyJob.execute(DelegatedAccessSiteHierarchyJob.java:144)
> ****
>
>         at
> org.sakaiproject.component.app.scheduler.jobs.SpringJobBeanWrapper.execute(SpringJobBeanWrapper.java:70)
> ****
>
>         at org.quartz.core.JobRunShell.run(JobRunShell.java:202)****
>
>         at
> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:534)
> ****
>
> mgt40203_f13: Invalid node id, cannot find node with id: 27674****
>
> ** **
>
> java.lang.IllegalArgumentException: Invalid node id, cannot find node with
> id: 27674****
>
>         at
> org.sakaiproject.hierarchy.impl.HierarchyServiceImpl.saveNodeMetaData(HierarchyServiceImpl.java:338)
> ****
>
>         at
> org.sakaiproject.delegatedaccess.jobs.DelegatedAccessSiteHierarchyJob.checkAndAddNode(DelegatedAccessSiteHierarchyJob.java:235)
> ****
>
>         at
> org.sakaiproject.delegatedaccess.jobs.DelegatedAccessSiteHierarchyJob.execute(DelegatedAccessSiteHierarchyJob.java:144)
> ****
>
>         at
> org.sakaiproject.component.app.scheduler.jobs.SpringJobBeanWrapper.execute(SpringJobBeanWrapper.java:70)
> ****
>
>         at org.quartz.core.JobRunShell.run(JobRunShell.java:202)****
>
>         at
> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:534)
> ****
>
> mgt40202_f13: Invalid node id, cannot find node with id: 27675****
>
> ** **
>
> java.lang.IllegalArgumentException: Invalid node id, cannot find node with
> id: 27675****
>
>         at
> org.sakaiproject.hierarchy.impl.HierarchyServiceImpl.saveNodeMetaData(HierarchyServiceImpl.java:338)
> ****
>
>         at
> org.sakaiproject.delegatedaccess.jobs.DelegatedAccessSiteHierarchyJob.checkAndAddNode(DelegatedAccessSiteHierarchyJob.java:235)
> ****
>
>         at
> org.sakaiproject.delegatedaccess.jobs.DelegatedAccessSiteHierarchyJob.execute(DelegatedAccessSiteHierarchyJob.java:144)
> ****
>
>         at
> org.sakaiproject.component.app.scheduler.jobs.SpringJobBeanWrapper.execute(SpringJobBeanWrapper.java:70)
> ****
>
>         at org.quartz.core.JobRunShell.run(JobRunShell.java:202)****
>
>         at
> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:534)
> ****
>
> mgt402_f13: Invalid node id, cannot find node with id: 27676****
>
> ** **
>
> java.lang.IllegalArgumentException: Invalid node id, cannot find node with
> id: 27676****
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130619/c022bfd3/attachment.html