Announcement Announcement Module
Collapse
No announcement yet.
BATCH_STEP_EXECUTION_SEQ insert issue Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • BATCH_STEP_EXECUTION_SEQ insert issue

    Hello,
    When I try to launch my job through the SpringSchedulerLauncher class, I got the following error in my EXIT_MESSAGEcolumn of BATCH_JOB_EXECUTION table. I was wondering what it is about and why SpringBatch is trying to insert Null in the ID column.

    Thanks,
    Asal

    org.springframework.batch.core.JobExecutionExcepti on: Flow execution ended unexpectedly at org.springframework.batch.core.job.flow.FlowJob.do Execute(FlowJob.java:141) at org.springframework.batch.core.job.AbstractJob.exe cute(AbstractJob.java:281)
    .
    .
    5 more Caused by: org.springframework.dao.DataAccessResourceFailureE xception: Could not increment identity; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'ID', table 'MShopper.dbo.BATCH_STEP_EXECUTION_SEQ'; column does not allow nulls. INSERT fails. at org.springframework.jdbc.support.incrementer.SqlSe rverMaxValueIncrementer.getNextKey(SqlServerMaxVal ueIncrementer.java:108) .......

  • #2
    I figured that out. It was a problem with creating the batch tables.

    Comment

    Working...
    X