Announcement Announcement Module
Collapse
No announcement yet.
Batch step failing with: java.sql.SQLException: ORA-01460: unimplemented or unreasona Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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)
    Last edited by geira; Aug 29th, 2009, 08:31 AM.

  • #2
    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?

    Comment

    Working...
    X