Has anyone had the following problem (and a solution!):
We are using the JDBC adapter to extract data from a SQL Server 2000 database. We are using the data to create the document in ES. The column we are extracting is null but webMethods defaults the value to the initial value for the data type of the document field (in this case integer). So we get a 0 instead of a null field. The value is set to zero as soon as we do the select statement (viewed it in debug mode).
In your integration component, go to the properties tab and check ‘Allow unset fields’.