Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
5 subscribers
Views
1706 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
I'm having issues writing a nested, multiple cdt to my database (MS SQL). (O
charlesa115
over 9 years ago
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
Discussion posts and replies are publicly visible
Parents
0
Eduardo Fuentes
Appian Employee
over 9 years ago
Can you reproduce the issue and attach the entire application-server.log to see the full stack trace?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Eduardo Fuentes
Appian Employee
over 9 years ago
Can you reproduce the issue and attach the entire application-server.log to see the full stack trace?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data