Batch step failing with: java.sql.SQLException: ORA-01460: unimplemented or unreasona

[geira]

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.

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)

[Dave Syer]

If you enable TRACE level debugging on Spring JDBC you will see the parameter values for the query that is failing. I can't see any reason why it would fail, but maybe there is a clue there?