passing null values to adapter connection

HI everyone,

I cannot pass null value(i have hardcoded this fields to $null in pipeline) to adapter service, iam getting the following error while tracing: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service TPCM_LDWInterface.adapters.ExPRSStaging:saveExPRSSettlementStaging_DBAdapter.
[ADA.1.314] Cannot set data for the input field “XXXXXXX”
For input string: "$null.

i really appreciate your help.



The field in the table might have been configured not to allow nulls. Please check that and ask your DBA to remove that constraint or do not pass nulls.

use regular expressions to filter out the nulls or empty strings by using /[^ ]/ on the branch sequence and set evaluate labels to ‘false’