Oct 26th, 2011, 10:51 AM
BATCH_STEP_EXECUTION_SEQ insert issue
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.
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) .......
Oct 26th, 2011, 03:13 PM
I figured that out. It was a problem with creating the batch tables.