---Data Insertion failing using Nested CDT---

Roshan Rokade over 7 years ago

Hello,

Currently we are facing issues to insert data in Oracle database.
We are using nested CDT with OneTo Many relationship. While inserting data in the database, data get inserted in both the tables parent and child but child table has got null value in the foreign key column.
We are able to insert data with same approach in mysql database.
Any help is appreciated.

Discussion posts and replies are publicly visible

0 Mike Cichy
Appian Employee
over 7 years ago

Are you getting any errors? Can you check the app server log?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Chris over 7 years ago

I ran into this issue in MS SQL and the resolution was to remove the child FK column from the CDT definition, then the values were updated correctly.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aloks0189
Certified Lead Developer
over 7 years ago

@roshanr First of All, As per the best practices, we should not use Nested CDT rather than that we can have a column of type int and can store the generated Primary key of Parent into Child as Foreign key. Coming to your Concern, it will be easy to trace out the issue if you could share the screenshot of ri!cdt filed with data along with XSD configuration, and also the Screenshot of how actually you have stored the data using Smart Service. And Also please check the Server Log to get more details about the issue, However if you can share the screenshots, it will be easy to debug this problem statement. If you talk about MySQL, this supports AUTO_INCREMENT strategy for Primary key Generation where as Oracle do not
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Roshan Rokade over 7 years ago

we have removed nested CDT and using separate CDT for parent and child tables.Its working fine. Thanks All.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel