giovedì 3 maggio 2012

Error while inserting NULL value to Oracle database table using BizTalk 2010

The scenario:
 Consume Adapter Service to generate the schema structure. The Schema elements have Nillable = True, Min Occurs =0. error:

When there is no value to a particular element, Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: The value for field "XXX ELEMENT" is invalid. or Microsoft.ServiceModel.Channels.Common.XmlReaderParsingException: The value for field "XXX ELEMENT" is invalid.System.ArgumentNullException: Value cannot be null. Parameter name: numStr

 environment is BizTalk Server 2010 with cu 4 and cu 2 for adapter!

  the solution: When make the map for instance the message , for each element NILLABLE add to map the functoid NIL VALUE (in advanced funtoids) and set the input parameter and the output parameter.









With this funtoid, the Oracle Database adapter interprets a null value in a record to mean that the column should be excluded from the Insert/update operation

Nessun commento: