Batch step failing with: java.sql.SQLException: ORA-01460: unimplemented or unreasona
We have experience a couple of times the batch failing with the error below.
I can't see that we have done any modifications to the code causing this.
Any tip????
We are running on Spring-batch version 1.1.4
We have an Oracle 10g db.
Code:
INFO | jvm 1 | 2009/08/29 14:04:30 | org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT STEP_EXECUTION_ID, STEP_NAME, START_TIME, END_TIME, STATUS, COMMIT_COUNT, ITEM_COUNT, CONTINUABLE, EXIT_CODE, EXIT_MESSAGE, READ_SKIP_COUNT, WRITE_SKIP_COUNT, ROLLBACK_COUNT from BATCH_STEP_EXECUTION where STEP_NAME = ? and JOB_EXECUTION_ID = ?]; SQL state [72000]; error code [1460]; ORA-014
60: unimplemented or unreasonable conversion requestedINFO | jvm 1 | 2009/08/29 14:04:30 | ; nested exception is java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested
INFO | jvm 1 | 2009/08/29 14:04:30 | INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:124)
INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.batch.core.repository.dao.JdbcStepExecutionDao.getStepExecution(JdbcStepExecutionDao.java:253)INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.batch.core.repository.support.SimpleJobRepository.getLastStepExecution(SimpleJobRepository.java:266)
INFO | jvm 1 | 2009/08/29 14:04:30 | at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)INFO | jvm 1 | 2009/08/29 14:04:30 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
INFO | jvm 1 | 2009/08/29 14:04:30 | at java.lang.reflect.Method.invoke(Method.java:585)
INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
INFO | jvm 1 | 2009/08/29 14:04:30 | at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)INFO | jvm 1 | 2009/08/29 14:04:30 | at $Proxy30.getLastStepExecution(Unknown Source)
