We are trying to create a simple process to correct some data via process start form and write to data store entity.
In the writing activity, I received an error message as follows:
Problem: An error occurred in executing an Activity Class.
Details: org.hibernate.PropertyValueException: not-null property references a null or transient value: ESPCustomerDT1234.discountrate Data:~
Actually, I didn't set any value on discountrate.
However, I turned off null constraint of dicountrate.
My CDT is configured like this and my data store has verified succesfully.
Discussion posts and replies are publicly visible
Did you also set the field to be nullable in the database?
Can you download CDT's XSD and check if nullable constraint is removed from here as well?
One thing that seems surprising - it doesn't look like you have defined a primary key for that CDT (the little Key icon on the right only displays if a primary key has not already been set). Can you define a primary key? Tables that don't have a primary key can have other issues, so it may resolve this issue if a primary key is defined.
ID column is necessary in Appian. It means your CDT needs to have a primary Key if you want to write it to the DB.
© 2021 Appian. All rights reserved.