API tools faq
paste
Advertisement
mugs

SQLSyntaxErrorException: ORA-01722: invalid number

mugs
Mar 8th, 2019
151
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 8.67 KB | None | 0 0
raw download clone embed print report
  1. rg.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [SELECT P.KBUSINESSENTITYID, P.PARTYTYPE, P.LOCKSTAMP FROM PARTY P WHERE P.KBUSINESSENTITYID = ? ]; ORA-01722: invalid number
  2. ; nested exception is java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
  3.  
  4.     at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
  5.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  6.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
  7.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)
  8.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
  9.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
  10.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
  11.     at org.kuali.rice.par.impl.identity.repository.PartyRepositoryImpl.getEntities(PartyRepositoryImpl.java:897)
  12.     at org.kuali.rice.par.impl.identity.repository.PartyRepositoryImpl.getEntity(PartyRepositoryImpl.java:438)
  13.     at za.org.kuali.kim.identity.impl.PartyRepositoryDelegateImpl.getEntity(PartyRepositoryDelegateImpl.java:49)
  14.     at org.kuali.rice.par.impl.identity.EmbeddedIdentityServiceImpl.getEntity(EmbeddedIdentityServiceImpl.java:244)
  15.     at za.org.kuali.kim.identity.impl.CustomerServiceDelegateImpl.update(CustomerServiceDelegateImpl.java:17)
  16.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  17.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  18.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  19.     at java.lang.reflect.Method.invoke(Method.java:606)
  20.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  21.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
  22.     at com.sun.proxy.$Proxy146.update(Unknown Source)
  23.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  24.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  25.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  26.     at java.lang.reflect.Method.invoke(Method.java:606)
  27.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  28.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
  29.     at com.sun.proxy.$Proxy147.update(Unknown Source)
  30.     at za.org.kuali.kfs.module.ar.document.CustomerMaintenableImpl.doRouteStatusChange(CustomerMaintenableImpl.java:178)
  31.     at org.kuali.rice.krad.maintenance.MaintenanceDocumentBase.doRouteStatusChange(MaintenanceDocumentBase.java:526)
  32.     at org.kuali.kfs.sys.document.FinancialSystemMaintenanceDocument.doRouteStatusChange(FinancialSystemMaintenanceDocument.java:112)
  33.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl$1.call(PostProcessorServiceImpl.java:81)
  34.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl$1.call(PostProcessorServiceImpl.java:61)
  35.     at org.kuali.rice.krad.util.GlobalVariables.doInNewGlobalVariables(GlobalVariables.java:191)
  36.     at org.kuali.rice.krad.service.impl.PostProcessorServiceImpl.doRouteStatusChange(PostProcessorServiceImpl.java:60)
  37.     at sun.reflect.GeneratedMethodAccessor1224.invoke(Unknown Source)
  38.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  39.     at java.lang.reflect.Method.invoke(Method.java:606)
  40.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  41.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  42.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  43.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  44.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  45.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  46.     at com.sun.proxy.$Proxy88.doRouteStatusChange(Unknown Source)
  47.     at sun.reflect.GeneratedMethodAccessor1224.invoke(Unknown Source)
  48.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  49.     at java.lang.reflect.Method.invoke(Method.java:606)
  50.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  51.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  52.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  53.     at org.kuali.rice.core.framework.persistence.jpa.NoResultExceptionInterceptor.invoke(NoResultExceptionInterceptor.java:33)
  54.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  55.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  56.     at com.sun.proxy.$Proxy89.doRouteStatusChange(Unknown Source)
  57.     at org.kuali.kfs.sys.document.workflow.PostProcessor.doRouteStatusChange(PostProcessor.java:53)
  58.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.notifyPostProcessor(StandardWorkflowEngine.java:513)
  59.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.nodePostProcess(StandardWorkflowEngine.java:423)
  60.     at org.kuali.rice.kew.engine.StandardWorkflowEngine.process(StandardWorkflowEngine.java:151)
  61.     at org.kuali.rice.kew.impl.document.DocumentProcessingQueueImpl.processWithOptions(DocumentProcessingQueueImpl.java:66)
  62.     at sun.reflect.GeneratedMethodAccessor1380.invoke(Unknown Source)
  63.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  64.     at java.lang.reflect.Method.invoke(Method.java:606)
  65.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
  66.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  67.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  68.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  69.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  70.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  71.     at com.sun.proxy.$Proxy175.processWithOptions(Unknown Source)
  72.     at sun.reflect.GeneratedMethodAccessor1376.invoke(Unknown Source)
  73.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  74.     at java.lang.reflect.Method.invoke(Method.java:606)
  75.     at org.kuali.rice.ksb.messaging.MessageServiceInvoker.invokeService(MessageServiceInvoker.java:157)
  76.     at org.kuali.rice.ksb.messaging.MessageServiceInvoker$1.doInTransaction(MessageServiceInvoker.java:72)
  77.     at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
  78.     at org.kuali.rice.ksb.messaging.MessageServiceInvoker.run(MessageServiceInvoker.java:67)
  79.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  80.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  81.     at java.lang.Thread.run(Thread.java:744)
  82. Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
  83.  
  84.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  85.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  86.     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  87.     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  88.     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  89.     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  90.     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
  91.     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
  92.     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
  93.     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
  94.     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
  95.     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
  96.     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
  97.     at org.enhydra.jdbc.core.CorePreparedStatement.executeQuery(CorePreparedStatement.java:92)
  98.     at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:644)
  99.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)
  100.     ... 75 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!