Results 1 to 2 of 2

Thread: BATCH_STEP_EXECUTION_SEQ insert issue

  1. #1
    Join Date
    Oct 2011
    Posts
    8

    Default 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. #2
    Join Date
    Oct 2011
    Posts
    8

    Default

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •