Updating batch_job_execution_context table : Error

[PriyaRaj]

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.

[michael.lange]

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

?

[PriyaRaj]

Hi thanks michael for your reply?

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

[michael.lange]

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

all answers sound like "get all patches for your oracle db"