Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-3585

Can't create new Role, get exception incident page


    • Type: Bug Fix Bug Fix
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Won't Fix
    • Affects Version/s: 1.0.1
    • Fix Version/s: 1.0.1
    • Component/s: Development
    • Labels:
    • Similar issues:
      KULRICE-3396can't create new Permission as user 'admin', results in Incident Report
      KULRICE-3397can't create new Responsibility as user 'admin', results in Incident Report
      KULRICE-7023Creating a new user should get the principal cache flushed
      KULRICE-12121Creating a new Role Document and changing the member type to Role causes an exception
      KULRICE-12299Unable to create new role with a permission OR create/edit a role with a responsibility
      KULRICE-4543Exception and incident handling framework improvements
      KULRICE-5846Rice Dev: Errors on Create New or Edit from Lookup on Group and Role
      KULRICE-6688member paging broken on Group & Role inquiry
      KULRICE-9214Incident Report page Cancel Button
      KULRICE-12446Exception on role document
    • Rice Module:


      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

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)

      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.


        Peter Giles (Inactive) added a comment -

        I didn't have the right impex build configuration, so I was missing that column.

        Peter Giles (Inactive) added a comment - I didn't have the right impex build configuration, so I was missing that column.


          • Assignee:
            Peter Giles (Inactive)
          • Votes:
            0 Vote for this issue
            0 Start watching this issue


            • Created:

              Structure Helper Panel