API tools faq
paste
Advertisement
mugs

ORA-01722: invalid number

mugs
Dec 8th, 2016
145
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 17.69 KB | None | 0 0
raw download clone embed print report
  1. org.kuali.rice.kew.api.action.InvalidActionTakenException: Failed to orchestrate the document to SuperUserApproved.
  2.     at org.kuali.rice.kew.impl.action.WorkflowDocumentActionsServiceImpl.translateException(WorkflowDocumentActionsServiceImpl.java:1342)
  3.     at org.kuali.rice.kew.impl.action.WorkflowDocumentActionsServiceImpl.executeActionInternal(WorkflowDocumentActionsServiceImpl.java:1361)
  4.     at org.kuali.rice.kew.impl.action.WorkflowDocumentActionsServiceImpl.superUserBlanketApprove(WorkflowDocumentActionsServiceImpl.java:773)
  5.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  6.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  7.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  8.     at java.lang.reflect.Method.invoke(Method.java:606)
  9.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  10.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  11.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  12.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  13.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  14.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  15.     at com.sun.proxy.$Proxy188.superUserBlanketApprove(Unknown Source)
  16.     at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.superUserApprove(KualiDocumentActionBase.java:2157)
  17.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  18.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  19.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  20.     at java.lang.reflect.Method.invoke(Method.java:606)
  21.     at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
  22.     at org.kuali.rice.kns.web.struts.action.KualiAction.dispatchMethod(KualiAction.java:171)
  23.     at org.kuali.rice.kns.web.struts.action.KualiAction.execute(KualiAction.java:129)
  24.     at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.execute(KualiDocumentActionBase.java:176)
  25.     at org.kuali.rice.kns.web.struts.action.KualiMaintenanceDocumentAction.execute(KualiMaintenanceDocumentAction.java:101)
  26.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor$1.doInTransaction(KualiRequestProcessor.java:494)
  27.     at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
  28.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processActionPerform(KualiRequestProcessor.java:490)
  29.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processFormActionAndForward(KualiRequestProcessor.java:219)
  30.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.strutsProcess(KualiRequestProcessor.java:206)
  31.     at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.process(KualiRequestProcessor.java:95)
  32.     at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
  33.     at org.kuali.rice.kns.web.struts.action.KualiActionServlet.process(KualiActionServlet.java:198)
  34.     at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
  35.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
  36.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
  37.     at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
  38.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)
  39.     at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:75)
  40.     at org.kuali.rice.kew.web.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:62)
  41.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  42.     at org.kuali.rice.kew.web.UserLoginFilter.doFilter(UserLoginFilter.java:90)
  43.     at org.kuali.rice.kew.web.UserLoginFilter.doFilter(UserLoginFilter.java:79)
  44.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  45.     at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:277)
  46.     at org.kuali.kfs.sys.web.filter.DevelopmentLoginFilter.doFilter(DevelopmentLoginFilter.java:66)
  47.     at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:270)
  48.     at org.kuali.rice.kew.web.BootstrapFilter.doFilter(BootstrapFilter.java:168)
  49.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  50.     at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:143)
  51.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  52.     at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:143)
  53.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  54.     at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  55.     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  56.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  57.     at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:185)
  58.     at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:159)
  59.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  60.     at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
  61.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  62.     at org.kuali.rice.krad.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:69)
  63.     at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
  64.     at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
  65.     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
  66.     at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)
  67.     at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
  68.     at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1072)
  69.     at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
  70.     at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
  71.     at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
  72.     at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
  73.     at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255)
  74.     at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)
  75.     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
  76.     at org.eclipse.jetty.server.Server.handle(Server.java:365)
  77.     at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
  78.     at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:937)
  79.     at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:998)
  80.     at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
  81.     at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
  82.     at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
  83.     at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
  84.     at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
  85.     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
  86.     at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
  87.     at java.lang.Thread.run(Thread.java:745)
  88. Caused by: org.kuali.rice.kew.api.exception.InvalidActionTakenException: Failed to orchestrate the document to SuperUserApproved.
  89.     at org.kuali.rice.kew.actions.SuperUserApproveEvent.recordAction(SuperUserApproveEvent.java:113)
  90.     at org.kuali.rice.kew.routeheader.service.impl.WorkflowDocumentServiceImpl.superUserApprove(WorkflowDocumentServiceImpl.java:407)
  91.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  92.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  93.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  94.     at java.lang.reflect.Method.invoke(Method.java:606)
  95.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  96.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  97.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  98.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  99.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  100.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  101.     at com.sun.proxy.$Proxy481.superUserApprove(Unknown Source)
  102.     at org.kuali.rice.kew.impl.action.WorkflowDocumentActionsServiceImpl$23.doInDocumentBo(WorkflowDocumentActionsServiceImpl.java:777)
  103.     at org.kuali.rice.kew.impl.action.WorkflowDocumentActionsServiceImpl.executeActionInternal(WorkflowDocumentActionsServiceImpl.java:1358)
  104.     ... 84 more
  105. Caused by: org.kuali.rice.kew.exception.RouteManagerException: org.kuali.rice.kew.exception.RouteManagerException: PostProcessor failed to process document:
  106.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.process(StandardWorkflowEngine.java:156)
  107.     at org.kuali.rice.kew.engine.BlanketApproveEngine.process(BlanketApproveEngine.java:139)
  108.     at org.kuali.rice.kew.actions.SuperUserApproveEvent.recordAction(SuperUserApproveEvent.java:110)
  109.     ... 98 more
  110. Caused by: org.kuali.rice.kew.exception.RouteManagerException: PostProcessor failed to process document:
  111.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.notifyPostProcessor(StandardWorkflowEngine.java:516)
  112.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.nodePostProcess(StandardWorkflowEngine.java:423)
  113.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.process(StandardWorkflowEngine.java:151)
  114.     ... 100 more
  115. Caused by: java.lang.RuntimeException: post processor caught exception while handling route status change: PreparedStatementCallback; SQL [SELECT P.KBUSINESSENTITYID, P.PARTYTYPE, P.LOCKSTAMP FROM PARTY P WHERE P.KBUSINESSENTITYID = ? ]; ORA-01722: invalid number
  116. ; nested exception is java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
  117.  
  118.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl.logAndRethrow(PostProcessorServiceImpl.java:349)
  119.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl.access$200(PostProcessorServiceImpl.java:49)
  120.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl$1.call(PostProcessorServiceImpl.java:101)
  121.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl$1.call(PostProcessorServiceImpl.java:61)
  122.     at org.kuali.rice.krad.util.GlobalVariables.doInNewGlobalVariables(GlobalVariables.java:191)
  123.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl.doRouteStatusChange(PostProcessorServiceImpl.java:60)
  124.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  125.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  126.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  127.     at java.lang.reflect.Method.invoke(Method.java:606)
  128.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  129.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  130.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  131.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  132.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  133.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  134.     at com.sun.proxy.$Proxy113.doRouteStatusChange(Unknown Source)
  135.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  136.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  137.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  138.     at java.lang.reflect.Method.invoke(Method.java:606)
  139.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  140.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  141.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  142.     at org.kuali.rice.core.framework.persistence.jpa.NoResultExceptionInterceptor.invoke(NoResultExceptionInterceptor.java:33)
  143.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  144.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  145.     at com.sun.proxy.$Proxy114.doRouteStatusChange(Unknown Source)
  146.     at org.kuali.kfs.sys.document.workflow.PostProcessor.doRouteStatusChange(PostProcessor.java:53)
  147.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.notifyPostProcessor(StandardWorkflowEngine.java:513)
  148.     ... 102 more
  149. Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [SELECT P.KBUSINESSENTITYID, P.PARTYTYPE, P.LOCKSTAMP FROM PARTY P WHERE P.KBUSINESSENTITYID = ? ]; ORA-01722: invalid number
  150. ; nested exception is java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
  151.  
  152.     at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
  153.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  154.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
  155.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
  156.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
  157.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
  158.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
  159.     at org.kuali.rice.par.impl.identity.repository.PartyRepositoryImpl.getEntities(PartyRepositoryImpl.java:897)
  160.     at org.kuali.rice.par.impl.identity.repository.PartyRepositoryImpl.getEntity(PartyRepositoryImpl.java:438)
  161.     at za.org.kuali.kim.identity.impl.PartyRepositoryDelegateImpl.getEntity(PartyRepositoryDelegateImpl.java:38)
  162.     at org.kuali.rice.par.impl.identity.EmbeddedIdentityServiceImpl.getEntity(EmbeddedIdentityServiceImpl.java:244)
  163.     at za.org.kuali.kim.identity.impl.VendorServiceDelegateImpl.update(VendorServiceDelegateImpl.java:17)
  164.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  165.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  166.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  167.     at java.lang.reflect.Method.invoke(Method.java:606)
  168.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  169.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
  170.     at com.sun.proxy.$Proxy169.update(Unknown Source)
  171.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  172.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  173.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  174.     at java.lang.reflect.Method.invoke(Method.java:606)
  175.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  176.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
  177.     at com.sun.proxy.$Proxy170.update(Unknown Source)
  178.     at za.org.kuali.kfs.vnd.document.VendorHeaderMaintainable.doRouteStatusChange(VendorHeaderMaintainable.java:164)
  179.     at org.kuali.rice.krad.maintenance.MaintenanceDocumentBase.doRouteStatusChange(MaintenanceDocumentBase.java:526)
  180.     at org.kuali.kfs.sys.document.FinancialSystemMaintenanceDocument.doRouteStatusChange(FinancialSystemMaintenanceDocument.java:112)
  181.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl$1.call(PostProcessorServiceImpl.java:81)
  182.     ... 129 more
  183. Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
  184.  
  185.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  186.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  187.     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  188.     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  189.     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  190.     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  191.     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
  192.     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
  193.     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
  194.     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
  195.     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
  196.     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
  197.     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
  198.     at org.enhydra.jdbc.core.CorePreparedStatement.executeQuery(CorePreparedStatement.java:92)
  199.     at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)
  200.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
  201.     ... 156 more
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!