Cannot insert the value NULL into column FieldDefID Kdolib Error 4006 when importing Batch Class

Question / Problem:

Why do I receive an error:

“-2147217498 - [4006] KdoLib: Error executing SQL command. Cannot insert the value NULL into column 'FieldDefID', table 'ACSystem.dbo.UserFldDef'; column does not allow nulls. INSERT fails. (515)”

when trying to import a Batch Class?

Answer / Solution:

You may receive an error:

‘-2147217498 - [4006] KdoLib: Error executing SQL command. Cannot insert the value NULL into column 'FieldDefID', table 'ACSystem.dbo.UserFldDef'; column does not allow nulls. INSERT fails. (515)”

when importing a Batch Class if something within the Batch Class has become corrupted.

It may be necessary to recreate the Batch Class or aspects thereof:

1. In the Administration module, create a test Batch Class that uses the same workflow as the Batch Class in error.
2. Right-click on the test Batch Class and select ‘Insert Document Class’.
3. Insert the Document Class from the Batch Class in error.
4. Publish the test Batch Class and export it.
5. Try to import the new test Batch Class.
6. The new Batch Class may generate errors. Begin deleting aspects of the test Batch Class (Form Types, Release Scripts, zones, etc.), repeating steps 3 - 5 in an effort to locate the corruption.

Applies to: