Cannot insert the value NULL into column FieldDefID Kdolib Error 4006 when importing Batch Class
9218
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:
- In the Administration module, create a test Batch Class that uses the same workflow as the Batch Class in error.
- Right-click on the test Batch Class and select ‘Insert Document Class’.
- Insert the Document Class from the Batch Class in error.
- Publish the test Batch Class and export it.
- Try to import the new test Batch Class.
- 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:
Product | Version | Category |
---|---|---|
CAPTURE | 6.0 | Administration |
CAPTURE | 6.1 | Administration |
CAPTURE | 7.0 | Administration |
CAPTURE | 7.5 | Administration |
CAPTURE | 8.0 | Administration |
CAPTURE | 9.0 | Administration |