API tools faq
paste
Advertisement
mugs

ORA-00904: "CLOSED": invalid identifier

mugs
Jun 23rd, 2015
264
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 14.16 KB | None | 0 0
raw download clone embed print report
  1. * SQLException during execution of sql-statement:
  2. * sql statement was 'SELECT A0.FIN_COA_CD,A0.ACCOUNT_NBR,A0.ACCOUNT_NM,A0.ACCT_FSC_OFC_UID,A0.ACCT_SPVSR_UNVL_ID,A0.ACCT_MGR_UNVL_ID,A0.ORG_CD,A0.ACCT_TYP_CD,A0.ACCT_PHYS_CMP_CD,A0.SUB_FUND_GRP_CD,A0.ACCT_FRNG_BNFT_CD,A0.FIN_HGH_ED_FUNC_CD,A0.ACCT_RSTRC_STAT_CD,A0.ACCT_RSTRC_STAT_DT,A0.ACCT_CITY_NM,A0.ACCT_STATE_CD,A0.ACCT_STREET_ADDR,A0.ACCT_ZIP_CD,A0.RPTS_TO_FIN_COA_CD,A0.RPTS_TO_ACCT_NBR,A0.ACCT_CREATE_DT,A0.ACCT_EFFECT_DT,A0.ACCT_EXPIRATION_DT,A0.CONT_FIN_COA_CD,A0.CONT_ACCOUNT_NBR,A0.ENDOW_FIN_COA_CD,A0.ENDOW_ACCOUNT_NBR,A0.CONTR_CTRL_FCOA_CD,A0.CONTR_CTRLACCT_NBR,A0.INCOME_FIN_COA_CD,A0.INCOME_ACCOUNT_NBR,A0.ACCT_ICR_TYP_CD,A0.AC_CSTM_ICREXCL_CD,A0.FIN_SERIES_ID,A0.ACCT_IN_FP_CD,A0.BDGT_REC_LVL_CD,A0.ACCT_SF_CD,A0.ACCT_PND_SF_CD,A0.FIN_EXT_ENC_SF_CD,A0.FIN_INT_ENC_SF_CD,A0.FIN_PRE_ENC_SF_CD,A0.FIN_OBJ_PRSCTRL_CD,A0.CG_CFDA_NBR,A0.ACCT_OFF_CMP_IND,A0.CG_ACCT_RESP_ID,A0.ACCT_CLOSED_IND,A0.OBJ_ID,A0.VER_NBR,A0.LBR_BEN_RT_CAT_CD FROM CA_ACCOUNT_T A0 WHERE closed = ?'
  3. * Exception message is [ORA-00904: "CLOSED": invalid identifier
  4. ]
  5. * Vendor error code [904]
  6. * SQL state code [42000]
  7. * The root stack trace is -->
  8. * java.sql.SQLSyntaxErrorException: ORA-00904: "CLOSED": invalid identifier
  9.  
  10.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  11.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  12.     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  13.     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  14.     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  15.     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  16.     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
  17.     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
  18.     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
  19.     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
  20.     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
  21.     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
  22.     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
  23.     at org.enhydra.jdbc.core.CorePreparedStatement.executeQuery(CorePreparedStatement.java:92)
  24.     at sun.reflect.GeneratedMethodAccessor382.invoke(Unknown Source)
  25.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  26.     at java.lang.reflect.Method.invoke(Method.java:606)
  27.     at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:393)
  28.     at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:175)
  29.     at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:277)
  30.     at com.sun.proxy.$Proxy423.executeQuery(Unknown Source)
  31.     at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown Source)
  32.     at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source)
  33.     at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source)
  34.     at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown Source)
  35.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown Source)
  36.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknown Source)
  37.     at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
  38.     at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
  39.     at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source)
  40.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
  41.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Source)
  42.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(Unknown Source)
  43.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate$3.doInPersistenceBroker(PersistenceBrokerTemplate.java:195)
  44.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)
  45.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:162)
  46.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:193)
  47.     at za.org.kuali.rice.krad.dao.impl.LookupDaoOjbHelper.executeSearch_original(LookupDaoOjbHelper.java:83)
  48.     at za.org.kuali.rice.krad.dao.impl.LookupDaoOjbHelper.executeSearch_custom(LookupDaoOjbHelper.java:107)
  49.     at za.org.kuali.rice.krad.dao.impl.LookupDaoOjb.findCollectionBySearchHelper(LookupDaoOjb.java:40)
  50.     at org.kuali.rice.krad.dao.proxy.LookupDaoProxy.findCollectionBySearchHelper(LookupDaoProxy.java:112)
  51.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  52.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  53.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  54.     at java.lang.reflect.Method.invoke(Method.java:606)
  55.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  56.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  57.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  58.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  59.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  60.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  61.     at com.sun.proxy.$Proxy110.findCollectionBySearchHelper(Unknown Source)
  62.     at org.kuali.rice.krad.service.impl.LookupServiceImpl.findCollectionBySearchHelper(LookupServiceImpl.java:59)
  63.     at org.kuali.rice.kns.lookup.KualiLookupableHelperServiceImpl.getSearchResultsHelper(KualiLookupableHelperServiceImpl.java:364)
  64.     at org.kuali.rice.kns.lookup.KualiLookupableHelperServiceImpl.getSearchResultsUnbounded(KualiLookupableHelperServiceImpl.java:75)
  65.     at org.kuali.kfs.sec.businessobject.lookup.AccessSecurityAccountLookupableHelperServiceImpl.getSearchResultsUnbounded(AccessSecurityAccountLookupableHelperServiceImpl.java:56)
  66.     at org.kuali.rice.kns.lookup.AbstractLookupableHelperServiceImpl.performLookup(AbstractLookupableHelperServiceImpl.java:1106)
  67.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  68.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  69.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  70.     at java.lang.reflect.Method.invoke(Method.java:606)
  71.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  72.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
  73.     at com.sun.proxy.$Proxy120.performLookup(Unknown Source)
  74.     at org.kuali.rice.kns.lookup.KualiLookupableImpl.performLookup(KualiLookupableImpl.java:307)
  75.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  76.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  77.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  78.     at java.lang.reflect.Method.invoke(Method.java:606)
  79.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  80.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  81.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  82.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  83.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  84.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  85.     at com.sun.proxy.$Proxy121.performLookup(Unknown Source)
  86.     at za.org.kuali.rice.kns.web.struts.action.KualiLookupAction.getSearchResults(KualiLookupAction.java:53)
  87.     at za.org.kuali.rice.kns.web.struts.action.KualiLookupAction.viewResults(KualiLookupAction.java:36)
  88.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  89.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  90.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  91.     at java.lang.reflect.Method.invoke(Method.java:606)
  92.     at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
  93.     at org.kuali.rice.kns.web.struts.action.KualiAction.dispatchMethod(KualiAction.java:171)
  94.     at org.kuali.rice.kns.web.struts.action.KualiAction.execute(KualiAction.java:129)
  95.     at org.kuali.rice.kns.web.struts.action.KualiLookupAction.execute(KualiLookupAction.java:159)
  96.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor$1.doInTransaction(KualiRequestProcessor.java:494)
  97.     at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
  98.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processActionPerform(KualiRequestProcessor.java:490)
  99.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processFormActionAndForward(KualiRequestProcessor.java:219)
  100.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.strutsProcess(KualiRequestProcessor.java:206)
  101.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.process(KualiRequestProcessor.java:95)
  102.     at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
  103.     at org.kuali.rice.kns.web.struts.action.KualiActionServlet.process(KualiActionServlet.java:198)
  104.     at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
  105.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
  106.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
  107.     at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
  108.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)
  109.     at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:75)
  110.     at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:62)
  111.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  112.     at org.kuali.rice.kew.web.UserLoginFilter.doFilter(UserLoginFilter.java:90)
  113.     at org.kuali.rice.kew.web.UserLoginFilter.doFilter(UserLoginFilter.java:79)
  114.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  115.     at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:277)
  116.     at org.kuali.kfs.sys.web.filter.DevelopmentLoginFilter.doFilter(DevelopmentLoginFilter.java:66)
  117.     at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:270)
  118.     at org.kuali.rice.kew.web.BootstrapFilter.doFilter(BootstrapFilter.java:168)
  119.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  120.     at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:143)
  121.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  122.     at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:143)
  123.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  124.     at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  125.     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  126.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  127.     at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:185)
  128.     at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:159)
  129.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  130.     at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:140)
  131.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  132.     at org.kuali.rice.krad.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:69)
  133.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  134.     at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
  135.     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
  136.     at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)
  137.     at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
  138.     at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1072)
  139.     at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
  140.     at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
  141.     at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
  142.     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
  143.     at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255)
  144.     at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)
  145.     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
  146.     at org.eclipse.jetty.server.Server.handle(Server.java:365)
  147.     at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
  148.     at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:926)
  149.     at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:988)
  150.     at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:635)
  151.     at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
  152.     at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
  153.     at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
  154.     at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
  155.     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
  156.     at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
  157.     at java.lang.Thread.run(Thread.java:745)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!