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

Can't create new Role, get exception incident page

    Details

    • 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:
      None
    • 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:
      KIM

      Description

      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.

        Activity

        Hide
        Peter Giles (Inactive) added a comment -

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

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

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Structure Helper Panel