none
Column cannot be set to null because it is a not null column error in Biztalk 2016 RRS feed

  • Question

  • Hi Team,

    Recently we have migrated Biztalk interfaces from 2013R2 to Biztalk 2016.

    As part of testing we are updating DB2 databases using DB2 adapter. I am facing the below error when we are updating DB2 database.

    Error Description:

    A message sent to adapter "DB2" on send port "XXXX" with URI "XXXXXX" is suspended. 
     Error details: System.Exception: There was an error in the Send port with URI: XXXXXX. Internal message: There was an error in the Send port with URI: XXXXXXX. Internal message: Column XX cannot be set to null because it is a not null column. 
     MessageId:  {3A023CE0-220A-4511-8DD9-25EBE2191260}
     InstanceID: {C14E0961-CB02-43BD-9EAE-7838DF9BEC19}

    The same input file is working as expected in 2013R2 environment.

    Any suggestion will be appreciated.



    kiran Valluru


    Thursday, August 23, 2018 2:07 PM

All replies

  • Hi,

    Are you using the same DB2 database table from the BizTalk2016 environment?

    Please check that the column you're trying to null really supports null in the DB2 database.

    Br,

    Leo


    Did my post help? Please use "Vote As Helpful", "Mark as answer" or "Propose as answer". Thank you!

    Friday, August 24, 2018 6:59 AM
  • Hi Leo. Thanks for the response.

    Yes. We are connecting to the same database and tables in both 2013R2 and 2016 environments. Data we are sending through DB2 adapter is same but it's working in 2013R2 but not 2016.

    Please let us know if there are any issues with Db2 adapter connectivity in 2016.


    kiran Valluru

    Friday, August 24, 2018 8:53 AM