I'm having issues writing a nested, multiple cdt to my database (MS SQL). (O

I'm having issues writing a nested, multiple cdt to my database (MS SQL). (One) type!SF1449() (to Many) type!LineItems().
Everything works fine in process.
type!SF1449 will write to the db if I don't add any line items. But as soon as I include one or more line items the write to ds node breaks.

xsd's and sql attached. Alert/Error message below. Any help would be greatly appreciated!

Error message recieved: Details: An error occurred while trying to write to the entity “SAP_sf1449” [id=a59fec12-14e8-40e3-8873-784e24e6758e@10890, type=SAP_sf1449 (id=2862)] (data store: SAP_STANDARD_FORMS). Details: org.hibernate.exception.SQLGrammarException: could not insert collection: [SAPSf1449DT183042.lineItems#1003]: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot update identity column 'ITEM_ID'. Data: TypedValue[it=2862,v={ /* all the sf1449 var names & values */,{ /* one line item ->*/ {<null>,1,1,1,1,1.0,1.0}}}]

Troubleshoot CDT _ SQL.zip

OriginalPostID-145977

OriginalPostID-145977