Uploaded image for project: 'Kuali Rice Development'
  1. Kuali Rice Development
  2. KULRICE-10045

KRAD Sample App: Traveler Authorization Request Page. Lookups throw BadSqlGrammerException

    Details

    • Type: Task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.0-rc1
    • Fix Version/s: 2.4
    • Component/s: Quality Assurance
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Rice Team:
      QA
    • Rice Module:
      KRAD
    • Application Requirement:
      Rice
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required
    • Code Review Status:
      Not Required

      Description

      Traver Authorization Page in KRAD Sample App Demo throws exception when attempting lookups.

      There are two Lookup icons on the page. One for Traveler Lookup, the other for Primary Destination lookup.

      When you attempt to perform a lookup in the lightbox, a BadSqlGrammer Exceptions are thrown.

      1) Traveler Lookup
      org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
      .....
      at org.kuali.rice.krad.dao.impl.LookupDaoOjb.executeSearch(LookupDaoOjb.java:193)

      2) Primary Destination Lookup
      org.springframework.jdbc.BadSqlGrammarException: OJB operation; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: "A0"."COUNTY_NM": invalid identifier

        Attachments

          Issue Links

            Activity

            Hide
            jkneal Jerry Neal (Inactive) added a comment -

            This is a sample page that has not really every been finished, so I don't think this is critical for 2.3

            Show
            jkneal Jerry Neal (Inactive) added a comment - This is a sample page that has not really every been finished, so I don't think this is critical for 2.3
            Hide
            eghm-kuali-m Erik Meade added a comment -

            SQL Exceptions on longer thrown

            Show
            eghm-kuali-m Erik Meade added a comment - SQL Exceptions on longer thrown

              People

              • Assignee:
                Unassigned
                Reporter:
                dsiebert Daniel Seibert (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: