Setting up permissions is using some invalid function keys

Description

Seeing this error on nightly:

WARN: Sql.dbWrite(): error code: 1400 sql: INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '!site.template.portfolio'), (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'CIG Coordinator'), (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'annc.revise.anyannc.revise.own')) binds: (2007-10-08 08:15:55,906 main_org.sakaiproject.db.impl.BasicSqlService)
java.sql.SQLException: ORA-01400: cannot insert NULL into ("SAK"."SAKAI_REALM_RL_FN"."FUNCTION_KEY")

Activity

Show:

Filter Maintainer August 8, 2008 at 6:03 AM

2.5.0 QA has been completed. Unfortunately, there were not resources available to specifically test this issue. If you find this to still be a problem in the latest release (at this point 2.5.2), please reopen the JIRA and add the latest affects version.

Megan May October 12, 2007 at 11:16 AM

in .007 tag

Christopher Maurer October 10, 2007 at 7:08 AM

I think these finally all work now.

Christopher Maurer October 8, 2007 at 1:22 PM

fixed an issue that seemed to be masking problems with the sql service and is now causing this one.

Christopher Maurer October 8, 2007 at 9:56 AM

Ok, this isn't funny...

Fixed

Details

Priority

Affects versions

Fix versions

Components

Assignee

Reporter

Created October 8, 2007 at 7:27 AM
Updated October 23, 2008 at 6:30 AM
Resolved October 10, 2007 at 7:08 AM