Database update issue

Hi sunil ,

1)can you please verify the CDT is same as a table. For example, all column properties need to same.
2)Plus save the output in CDT again and see the value is saving back in CDT or not.
3)Verify primary key is properly Define in CDT structure.

Thanks

Hello Sunilc,

How is your configuration on the datasource? Which server are you using? Are you cloud or on-premise?

One thought I had when reading the post is the parameter autocommit = false,
<xa-datasource>(Can have autcommit = false) this is used in Appian.

Take a look at the configuration
docs.appian.com/.../Configuring_Relational_Databases.html

Can you check the log files? is there something there ?

Hope this helps

Jose

Hi sunilc,

1)Check whether CDT name and table is same.
2) Ensure the primary key is defined properly in CDT
Follow the below link to have a clear understanding:
docs.appian.com/.../Configuring_Relational_Databases.html,

Also check the log files to to have a better picture .

Hi Sunil,
Verify if the xsd mappings are correct. i.e the cdt is pointing to the same table or not. Also verify the entity that you are using is the correct entity. This should help you identify the issue.

Hi,
Please check the inputs, Entity and the respective data should be properly mapped to the table you want to write in,
and save that data in outputs so that you will get to know is it writing to DB or not.

Are you able to query from the data source?

I agree with shwetad are you mapping the inputs properly?

What do you get on the output? Does is return the cdt with the primary key generated?

Jose

Thank you all for your responses. Another table was created through the DDL script when i created manually in APPIAN schema with different column types. I dropped that table and created the table with correct mappings. It worked fine now.. I'm able to insert the record. Thank you all for your valuable suggestions!