Uploaded image for project: '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
    • Status: Closed
    • Priority: 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
    • 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
      
      

        Attachments

          Issue Links

            Activity

            Hide
            jcoltrin Jessica Coltrin (Inactive) added a comment -

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

            Show
            jcoltrin Jessica Coltrin (Inactive) added a comment - Assigning to Peter to review to see if it's critical for 2.3.
            Hide
            gilesp 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
            gilesp 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
            eghm-kuali-m Erik Meade added a comment -

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

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

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: