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

KRAD Demo Travel Account Authorization Traveler Lookup Search throws SQL Exception

    Details

    • Type: Bug Fix Bug Fix
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.0-rc1
    • Fix Version/s: 2.4
    • Component/s: Database, Development
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Similar issues:
      KULRICE-10045KRAD Sample App: Traveler Authorization Request Page. Lookups throw BadSqlGrammerException
      KULRICE-11593KRAD Demo Travel links Search, Clear, Cancel buttons JS Cannot read property 'length' of undefined
      KULRICE-12713 Validation exception on Editing a Travel Account
      KULRICE-11403Error adding Sub Account to KRAD Demo Travel Account
      KULRICE-12752Travel Account Lookup: Comma appears in lookup criteria on search
      KULRICE-11716Fill AFT Per-Screen Item Gap: KRAD Demo: Travel Account Type Lookup
      KULRICE-13275Runtime Exception in Demo Account Lookup Auto Search
      KULRICE-12434Create Travel Account Lookup with advanced features
      KULRICE-12227Creat new PeopleFlow Summary - Travel Account Number lookup throws exception
      KULRICE-12113Fill AFT Per-Screen Item Gap: KRAD Demo: Travel Account Lookup
    • Rice Module:
      KRAD
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required
    • Code Review Status:
      Not Required

      Description

      KRAD Demo Travel Authentication, Traveler Lookup search throws SQL Exception

      
      
      Stacktrace (only in dev mode)
       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.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
      at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107)
      at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89)
      at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144)
      at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCount(PersistenceBrokerTemplate.java:217)
      at org.kuali.rice.krad.dao.impl.LookupDaoOjb.executeSearch(LookupDaoOjb.java:193)
      at org.kuali.rice.krad.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:95)
      at org.kuali.rice.krad.dao.proxy.LookupDaoProxy.findCollectionBySearchHelper(LookupDaoProxy.java:137)
      at sun.reflect.GeneratedMethodAccessor1525.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:601)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
      at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      at com.sun.proxy.$Proxy100.findCollectionBySearchHelper(Unknown Source)
      at org.kuali.rice.krad.service.impl.LookupServiceImpl.findCollectionBySearchHelper(LookupServiceImpl.java:71)
      at sun.reflect.GeneratedMethodAccessor1524.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:601)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at net.bull.javamelody.MonitoringSpringInterceptor.invoke(MonitoringSpringInterceptor.java:74)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      at com.sun.proxy.$Proxy101.findCollectionBySearchHelper(Unknown Source)
      at org.kuali.rice.krad.lookup.LookupableImpl.getSearchResults(LookupableImpl.java:185)
      at org.kuali.rice.krad.lookup.LookupableImpl.performSearch(LookupableImpl.java:125)
      at org.kuali.rice.krad.web.controller.LookupController.search(LookupController.java:196)
      at org.kuali.rice.krad.web.controller.LookupController$$FastClassByCGLIB$$c32fae9b.invoke(<generated>)
      at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
      at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
      at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631)
      at org.kuali.rice.krad.web.controller.LookupController$$EnhancerByCGLIB$$e5b85a53.search(<generated>)
      at sun.reflect.GeneratedMethodAccessor1523.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:601)
      at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
      at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
      at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
      at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
      at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
      at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
      at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
      at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
      at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
      at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.kuali.rice.krad.web.filter.CharsetFilter.doFilter(CharsetFilter.java:58)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:89)
      at org.kuali.rice.krad.web.filter.UserLoginFilter.doFilter(UserLoginFilter.java:77)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.kuali.rice.krad.web.filter.BootstrapFilterChain.doFilter(BootstrapFilter.java:327)
      at org.kuali.rice.krad.web.filter.DummyLoginFilter.doFilter(DummyLoginFilter.java:83)
      at org.kuali.rice.krad.web.filter.DummyLoginFilter.doFilter(DummyLoginFilter.java:63)
      at org.kuali.rice.krad.web.filter.BootstrapFilterChain.doFilter(BootstrapFilter.java:320)
      at org.kuali.rice.krad.web.filter.BootstrapFilter.doFilter(BootstrapFilter.java:199)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.kuali.rice.krad.web.filter.UifSessionTimeoutFilter.doFilter(UifSessionTimeoutFilter.java:128)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.kuali.rice.core.web.Log4JContextClearingFilter.doFilterInternal(Log4JContextClearingFilter.java:37)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.kuali.rice.krad.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:68)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.springframework.web.filter.AbstractRequestLoggingFilter.doFilterInternal(AbstractRequestLoggingFilter.java:213)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
      at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
      at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)
      at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
      at java.lang.Thread.run(Thread.java:722)
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:452)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:884)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:471)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:199)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:535)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:238)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1196)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1444)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1662)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4364)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4445)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:6268)
      at org.enhydra.jdbc.core.CorePreparedStatement.executeQuery(CorePreparedStatement.java:92)
      at sun.reflect.GeneratedMethodAccessor138.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:601)
      at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:385)
      at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:130)
      at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:271)
      at com.sun.proxy.$Proxy70.executeQuery(Unknown Source)
      at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown Source)
      at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source)
      at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source)
      at org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.<init>(Unknown Source)
      at org.apache.ojb.broker.core.ReportRsIteratorFactoryImpl.createRsIterator(Unknown Source)
      at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown Source)
      at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIteratorFromQuery(Unknown Source)
      at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIteratorByQuery(Unknown Source)
      at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCount(Unknown Source)
      at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCount(Unknown Source)
      at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCount(Unknown Source)
      at org.springmodules.orm.ojb.PersistenceBrokerTemplate$6.doInPersistenceBroker(PersistenceBrokerTemplate.java:219)
      at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)
      ... 98 more
      
      

        Issue Links

          Activity

          Hide
          Jessica Coltrin (Inactive) added a comment -

          Assigning to Peter to review to see if it's critical for 2.3.

          Show
          Jessica Coltrin (Inactive) added a comment - Assigning to Peter to review to see if it's critical for 2.3.
          Hide
          Peter Giles (Inactive) added a comment -

          This is a ddl & data issue, there is an additional table and some data that needs to be added to the sample data set. See the scripts under /rice-middleware/sampleapp/scripts/sql/

          As discussed with Jessica, I disabled the broken lookup for the 2.3 release, and bumped the fix version on this to 2.4. When the data issue is fixed, TravelAuthorizationView.xml should be revisited to add the input field that has been commented out (search for this jira #) and remove the DataField that was added.

          This work should be done after the new database process has been unveiled.

          Show
          Peter Giles (Inactive) added a comment - This is a ddl & data issue, there is an additional table and some data that needs to be added to the sample data set. See the scripts under /rice-middleware/sampleapp/scripts/sql/ As discussed with Jessica, I disabled the broken lookup for the 2.3 release, and bumped the fix version on this to 2.4. When the data issue is fixed, TravelAuthorizationView.xml should be revisited to add the input field that has been commented out (search for this jira #) and remove the DataField that was added. This work should be done after the new database process has been unveiled.
          Hide
          Erik Meade added a comment -

          Link has been removed and Missing DB Tables have been resolved.

          Show
          Erik Meade added a comment - Link has been removed and Missing DB Tables have been resolved.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel