[Building Sakai] Error on Delegated Access Tool

[Bryan Holladay]

Peter,

Also, I would recommend running Hierarchy's trunk branch instead of the
1.2.6 tag.  I have just written a patch for this error
https://jira.sakaiproject.org/browse/DAC-52

Aaron Z is planning on cleaning up the patch and applying it to trunk, so
you shouldn't have to branch.

-Bryan


On Wed, Jun 19, 2013 at 2:16 PM, Bryan Holladay <holladay at longsight.com>wrote:

> 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/20130620/ab8d2c08/attachment.html