API tools faq
paste
Advertisement
mugs

ORA-01722: invalid number on available balances

mugs
Jun 8th, 2015
339
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 12.17 KB | None | 0 0
raw download clone embed print report
  1. * SQLException during execution of sql-statement:
  2. * sql statement was 'SELECT A0.UNIV_FISCAL_YR,A0.FIN_COA_CD,A0.ACCOUNT_NBR,A0.FIN_OBJECT_CD,A1.FIN_OBJ_TYP_CD,sum(A0.CURR_BDLN_BAL_AMT),sum(A0.ACLN_ACTLS_BAL_AMT),sum(A0.ACLN_ENCUM_BAL_AMT) FROM GL_ACCT_BALANCES_T A0 INNER JOIN CA_OBJECT_CODE_T A1 ON A0.UNIV_FISCAL_YR=A1.UNIV_FISCAL_YR AND A0.FIN_COA_CD=A1.FIN_COA_CD AND A0.FIN_OBJECT_CD=A1.FIN_OBJECT_CD WHERE ((A0.FIN_COA_CD LIKE ?) AND A0.UNIV_FISCAL_YR = ?) AND A0.ACCOUNT_NBR = ? GROUP BY A0.UNIV_FISCAL_YR,A0.FIN_COA_CD,A0.ACCOUNT_NBR,A0.FIN_OBJECT_CD,A1.FIN_OBJ_TYP_CD'
  3. * Exception message is [ORA-01722: invalid number
  4. ]
  5. * Vendor error code [1722]
  6. * SQL state code [42000]
  7. * The root stack trace is -->
  8. * java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
  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.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4692)
  21.     at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:10458)
  22.     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3582)
  23.     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
  24.     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
  25.     at org.enhydra.jdbc.core.CorePreparedStatement.executeQuery(CorePreparedStatement.java:92)
  26.     at sun.reflect.GeneratedMethodAccessor389.invoke(Unknown Source)
  27.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  28.     at java.lang.reflect.Method.invoke(Method.java:597)
  29.     at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:393)
  30.     at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:175)
  31.     at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:277)
  32.     at com.sun.proxy.$Proxy383.executeQuery(Unknown Source)
  33.     at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown Source)
  34.     at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source)
  35.     at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source)
  36.     at org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.<init>(Unknown Source)
  37.     at org.apache.ojb.broker.core.ReportRsIteratorFactoryImpl.createRsIterator(Unknown Source)
  38.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown Source)
  39.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIteratorFromQuery(Unknown Source)
  40.     at org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIteratorByQuery(Unknown Source)
  41.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getReportQueryIteratorByQuery(Unknown Source)
  42.     at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getReportQueryIteratorByQuery(Unknown Source)
  43.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate$5.doInPersistenceBroker(PersistenceBrokerTemplate.java:211)
  44.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141)
  45.     at org.springmodules.orm.ojb.PersistenceBrokerTemplate.getReportQueryIteratorByQuery(PersistenceBrokerTemplate.java:209)
  46.     at za.org.kuali.kfs.gl.dataaccess.impl.AccountBalanceDaoOjb.findConsolidatedAvailableAccountBalance(AccountBalanceDaoOjb.java:59)
  47.     at org.kuali.kfs.gl.service.impl.AccountBalanceServiceImpl.findConsolidatedAvailableAccountBalance(AccountBalanceServiceImpl.java:62)
  48.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  49.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  50.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  51.     at java.lang.reflect.Method.invoke(Method.java:597)
  52.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  53.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  54.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  55.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  56.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  57.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  58.     at com.sun.proxy.$Proxy263.findConsolidatedAvailableAccountBalance(Unknown Source)
  59.     at org.kuali.kfs.gl.businessobject.lookup.AccountBalanceLookupableHelperServiceImpl.getSearchResults(AccountBalanceLookupableHelperServiceImpl.java:97)
  60.     at za.org.kuali.kfs.gl.businessobject.lookup.AccountBalanceLookupableHelperServiceImpl.getSearchResults(AccountBalanceLookupableHelperServiceImpl.java:36)
  61.     at org.kuali.rice.kns.lookup.AbstractLookupableHelperServiceImpl.performLookup(AbstractLookupableHelperServiceImpl.java:1104)
  62.     at org.kuali.kfs.gl.businessobject.lookup.AbstractGeneralLedgerLookupableHelperServiceImpl.performLookup(AbstractGeneralLedgerLookupableHelperServiceImpl.java:199)
  63.     at org.kuali.rice.kns.lookup.KualiLookupableImpl.performLookup(KualiLookupableImpl.java:307)
  64.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  65.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  66.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  67.     at java.lang.reflect.Method.invoke(Method.java:597)
  68.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  69.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  70.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  71.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  72.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  73.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  74.     at com.sun.proxy.$Proxy92.performLookup(Unknown Source)
  75.     at org.kuali.kfs.gl.web.struts.BalanceInquiryAction.search(BalanceInquiryAction.java:151)
  76.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  77.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  78.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  79.     at java.lang.reflect.Method.invoke(Method.java:597)
  80.     at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
  81.     at org.kuali.rice.kns.web.struts.action.KualiAction.dispatchMethod(KualiAction.java:171)
  82.     at org.kuali.rice.kns.web.struts.action.KualiAction.execute(KualiAction.java:129)
  83.     at org.kuali.kfs.gl.web.struts.BalanceInquiryAction.execute(BalanceInquiryAction.java:377)
  84.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor$1.doInTransaction(KualiRequestProcessor.java:494)
  85.     at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
  86.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processActionPerform(KualiRequestProcessor.java:490)
  87.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processFormActionAndForward(KualiRequestProcessor.java:219)
  88.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.strutsProcess(KualiRequestProcessor.java:206)
  89.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.process(KualiRequestProcessor.java:95)
  90.     at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
  91.     at org.kuali.rice.kns.web.struts.action.KualiActionServlet.process(KualiActionServlet.java:198)
  92.     at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
  93.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
  94.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
  95.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  96.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  97.     at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:78)
  98.     at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:62)
  99.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  100.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  101.     at org.kuali.rice.kew.web.UserLoginFilter.doFilter(UserLoginFilter.java:89)
  102.     at org.kuali.rice.kew.web.UserLoginFilter.doFilter(UserLoginFilter.java:77)
  103.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  104.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  105.     at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:277)
  106.     at org.kuali.rice.kew.web.DummyLoginFilter.doFilter(DummyLoginFilter.java:96)
  107.     at org.kuali.rice.kew.web.DummyLoginFilter.doFilter(DummyLoginFilter.java:55)
  108.     at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:270)
  109.     at org.kuali.rice.kew.web.BootstrapFilter.doFilter(BootstrapFilter.java:168)
  110.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  111.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  112.     at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  113.     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  114.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  115.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  116.     at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:185)
  117.     at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:159)
  118.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  119.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  120.     at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
  121.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  122.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  123.     at org.kuali.rice.krad.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:69)
  124.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  125.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  126.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  127.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  128.     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
  129.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  130.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  131.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  132.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
  133.     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
  134.     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
  135.     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  136.     at java.lang.Thread.run(Thread.java:662)
  137.  
  138. **
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!