Can't Create Warehouse , error in integration monitor "Can not insert null value " in InvWareHouse

Can't Create Warehouse , error in integration monitor "Can not insert null value " in InvWareHouse

Problem Statement

Customer created the warehouse in SAP and it will show an error in integration monitor "Can not insert null value "


Solution

We compared the InvWareHouse  table schema and found that it was a different schema from the iVend standard InvWareHouse . 


We have checked below points on the InvWareHouse table to solve the issue.

1) We found Extended Property with sp_addextendedproperty was created.

2) We have taken database backup .

3) We have dropped the extended property .

4) We created a default iVend standard constraint.

5) Restart the integration service.


When we retry it gets integrated.