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

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

    Details

    • Type: Task Task
    • Status: Closed Closed
    • Priority: Major 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
    • Similar issues:
      KULRICE-11520Create Automated Functional (Smoke) Tests for KRAD Demo - Travel Application: Authorization Document
      KULRICE-13779Create Travel Authorization transactional document in KRAD
      KULRICE-11419KRAD Sample Travel App: Move unnecessary screens into their own menu section
      KULRICE-5651Create KRAD Version of Sample Travel App
      KULRICE-4777Fix workflow for Travel Request (sample travel app)
      KULRICE-6300Travel Account link in KNS sample app throwing exception
      KULRICE-12754Krad Sample App Lookup Results are missing inquiry links
      KULRICE-5652Create KRAD Version of Create New Sample Application Travel Request Document
      KULRICE-6926KRAD bookstore sample app -- the Book Order Request can't be viewed by any of the provided Rice user names
      KULRICE-11718Fill AFT Per-Screen Item Gap: KRAD Demo: Travel Authorization Request
    • 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

        Issue Links

          Activity

          Hide
          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
          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
          Erik Meade added a comment -

          SQL Exceptions on longer thrown

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

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel