[Deploying Sakai] Advise on upgrading errors - 2.5.4 to 2.6.1

Leon Kolchinsky lkolchin at gmail.com
Mon Feb 1 02:51:00 PST 2010


Hello All,

Sorry for asking again but I really need some advise.

Those 2 issues currently bothering me:

1) Finished running those 2 conversion scripts on 2.5.4 version:
sakai-2-6-0-oracle-conversion.sql
sakai_2_6_0-2_6_1_oracle_conversion.sql

I've got some errors after running first script (full log attached):

INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM
where REALM_ID = '!site.template.course'), (select ROLE_KEY from
SAKAI_REALM_ROLE where ROLE_NAME = 'Instructor'), (select FUNCTION_KEY from
SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'site.viewRoster'))
*
ERROR at line 1:
ORA-00001: unique constraint (SAKAI.SYS_C003862) violated


INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM
where REALM_ID = '!group.template.course'), (select ROLE_KEY from
SAKAI_REALM_ROLE where ROLE_NAME = 'Instructor'), (select FUNCTION_KEY from
SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'site.viewRoster'))
*
ERROR at line 1:
ORA-00001: unique constraint (SAKAI.SYS_C003862) violated


INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM
where REALM_ID = '/site/mercury'), (select ROLE_KEY from SAKAI_REALM_ROLE
where ROLE_NAME = 'maintain'), (select FUNCTION_KEY from
SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'site.viewRoster'))
*
ERROR at line 1:
ORA-01400: cannot insert NULL into ("SAKAI"."SAKAI_REALM_RL_FN"."REALM_KEY")



Any advice on how to fix those?
Any highlights on these errors?

2) Another strange error I get after upgrading.
When I go to check any site in Sakai admin backend, I get:

2010-02-01 12:32:15,875 WARN [BaseSiteService] isCourseSite(): no site with
id:
2010-02-01 12:32:15,878 INFO [none] ResourceManager : found chef_header.vm
with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:15,878 INFO [none] ResourceManager : found
vm/editor/FCKeditor/sakai_header.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:15,879 ERROR [none] Left side ($formItem) of '==' operation
has null value. If a reference, it may not be in the context. Operation not
possible. /vm/adminsites/chef_sites_list.vm [line 23, column 73]
2010-02-01 12:32:16,003 INFO [none] ResourceManager : found chef_footer.vm
with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:20,728 INFO [none] ResourceManager : found chef_header.vm
with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:20,729 INFO [none] ResourceManager : found
vm/editor/FCKeditor/sakai_header.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:20,729 ERROR [none] Left side ($formItem) of '==' operation
has null value. If a reference, it may not be in the context. Operation not
possible. /vm/adminsites/chef_sites_edit.vm [line 23, column 73]
2010-02-01 12:32:20,732 INFO [none] ResourceManager : found
vm/editor/FCKeditor/sakai_body.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:20,747 WARN [none] Warning! The reference $paramNames is an
Iterator in the #foreach() loop at [204,33] in template
/vm/adminsites/chef_sites_edit.vm. Because it's not resetable, if used in
more than once, this may lead to unexpected results.
2010-02-01 12:32:20,748 INFO [none] ResourceManager : found chef_footer.vm
with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:30,787 INFO [none] ResourceManager : found chef_header.vm
with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:30,793 INFO [none] ResourceManager : found
vm/editor/FCKeditor/sakai_header.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:30,800 INFO [none] ResourceManager : found
/vm/admin/chef_aliases_list.vm with loader
org.apache.velocity.runtime.resource.loader.FileResourceLoader
2010-02-01 12:32:30,883 ERROR [none] Left side ($formItem) of '==' operation
has null value. If a reference, it may not be in the context. Operation not
possible. /vm/admin/chef_aliases_list.vm [line 23, column 73]
2010-02-01 12:32:30,904 INFO [none] ResourceManager : found chef_footer.vm
with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:31,897 INFO [none] ResourceManager : found chef_header.vm
with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:31,898 INFO [none] ResourceManager : found
vm/editor/FCKeditor/sakai_header.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:31,899 ERROR [none] Left side ($formItem) of '==' operation
has null value. If a reference, it may not be in the context. Operation not
possible. /vm/adminsites/chef_sites_edit.vm [line 23, column 73]
2010-02-01 12:32:31,901 INFO [none] ResourceManager : found
vm/editor/FCKeditor/sakai_body.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:31,921 WARN [none] Warning! The reference $paramNames is an
Iterator in the #foreach() loop at [204,33] in template
/vm/adminsites/chef_sites_edit.vm. Because it's not resetable, if used in
more than once, this may lead to unexpected results.
2010-02-01 12:32:31,923 INFO [none] ResourceManager : found chef_footer.vm
with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:37,109 WARN [BaseSiteService] isCourseSite(): no site with
id:
2010-02-01 12:32:37,112 INFO [none] ResourceManager : found chef_header.vm
with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:37,112 INFO [none] ResourceManager : found
vm/editor/FCKeditor/sakai_header.vm with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader
2010-02-01 12:32:37,113 ERROR [none] Left side ($formItem) of '==' operation
has null value. If a reference, it may not be in the context. Operation not
possible. /vm/adminsites/chef_sites_list.vm [line 23, column 73]
2010-02-01 12:32:37,241 INFO [none] ResourceManager : found chef_footer.vm
with loader
org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader


Any resolution to this?
Appreciate any help with this and conversion errors too.

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20100201/32dbbce4/attachment.html 


More information about the production mailing list