Type: Bug Fix
Resolution: Won't Fix
Affects Version/s: 1.0.1
Fix Version/s: 1.0.1
KULRICE-3396 can't create new Permission as user 'admin', results in Incident Report KULRICE-3397 can't create new Responsibility as user 'admin', results in Incident Report KULRICE-7023 Creating a new user should get the principal cache flushed KULRICE-12121 Creating a new Role Document and changing the member type to Role causes an exception KULRICE-12299 Unable to create new role with a permission OR create/edit a role with a responsibility KULRICE-4543 Exception and incident handling framework improvements KULRICE-5846 Rice Dev: Errors on Create New or Edit from Lookup on Group and Role KULRICE-6688 member paging broken on Group & Role inquiry KULRICE-9214 Incident Report page Cancel Button KULRICE-12446 Exception on role document
org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar ; nested exception is java.sql.SQLException: ORA-00904: "A0"."DESC_TXT": invalid identifier
Caused by: java.sql.SQLException: ORA-00904: "A0"."DESC_TXT": invalid identifier
I looked at OJB-repository-kim.xml and the mapping for IdentityManagementRoleDocument (to table KRIM_ROLE_DOCUMENT_T) includes a field descriptor for a desc_txt column, which doesn't exist in the database. I verified this on KR-CNV. If you try to create a new role, and enter enough info to do a "save" on the role document, you should get this if you are up to date.