Announcement Announcement Module
Collapse
No announcement yet.
Updating batch_job_execution_context table : Error Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Updating batch_job_execution_context table : Error

    Hi ,

    Somebody help me out of this problem.

    I have a job which contains 4 steps,after completion of each step and before start of next step the framework updates the batch_job_execution_context table.In very rare scenario some times I'm facing the below error

    Caused by: org.springframework.jdbc.UncategorizedSQLException : PreparedStatementCallback; uncategorized SQLException for SQL [UPDATE BATCH_JOB_EXECUTION_CONTEXT SET SHORT_CONTEXT = ?, SERIALIZED_CONTEXT = ? WHERE JOB_EXECUTION_ID = ?]; SQL state [63000]; error code [3120]; ORA-03120: two-task conversion routine: integer overflow
    ; nested exception is java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow

    at org.springframework.jdbc.support.AbstractFallbackS QLExceptionTranslator.translate(AbstractFallbackSQ LExceptionTranslator.java:83)
    at org.springframework.jdbc.support.AbstractFallbackS QLExceptionTranslator.translate(AbstractFallbackSQ LExceptionTranslator.java:80)
    at org.springframework.jdbc.support.AbstractFallbackS QLExceptionTranslator.translate(AbstractFallbackSQ LExceptionTranslator.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:602)
    at org.springframework.jdbc.core.JdbcTemplate.update( JdbcTemplate.java:786)
    at org.springframework.jdbc.core.JdbcTemplate.update( JdbcTemplate.java:842)
    at org.springframework.batch.core.repository.dao.Jdbc ExecutionContextDao.persistSerializedContext(JdbcE xecutionContextDao.java:193)
    at org.springframework.batch.core.repository.dao.Jdbc ExecutionContextDao.updateExecutionContext(JdbcExe cutionContextDao.java:124)
    at org.springframework.batch.core.repository.support. SimpleJobRepository.updateExecutionContext(SimpleJ obRepository.java:182)
    at sun.reflect.GeneratedMethodAccessor891.invoke(Unkn own Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)


    When i reschedule the job it works fine.

    Table description

    JOB_EXECUTION_ID NOT NULL NUMBER(19)
    SHORT_CONTEXT NOT NULL VARCHAR2(2500 CHAR)
    SERIALIZED_CONTEXT CLOB()



    Note: the problem is in the SHORT_CONTEXT column then next time also the job should fail but sometimes it works and some time it fails.

  • #2
    Did you check the numerous google references to ORA-03120: two-task conversion routine: integer overflow? Especially the
    apply all patches
    or
    client version differs from host version
    ?

    Comment


    • #3
      Hi thanks michael for your reply?

      But what kind of patch should apply?.Do you have any idea

      Comment


      • #4
        Originally posted by PriyaRaj View Post
        But what kind of patch should apply?.Do you have any idea
        all answers sound like "get all patches for your oracle db"

        Comment

        Working...
        X