Hello Folks,
I am getting this error while write to Data store entity.:"An error occurred while trying to write to the data store. No values have been written. Details: org.hibernate.PropertyValueException: not-null property references a null or transient value :"
Can anyone help me on this? Actually I want one column in a table is non nullable that is also behave as a foreign key.
Thanks
Discussion posts and replies are publicly visible
You have columns in database which are defined as Non-Nullable. Which means it cannot be empty and looks like you have no value being saved, hence the error. Please share the DB structure and the PV data if possible.
hi manjit.1486 I think you have some not null columns in your database, columns in your database might be missing default value, May be you would be passing some null value from Appian to database
You are trying to insert a null value in a column that does not accept null or empty values..
Hi,
You can look at this Log tomcat-stdOut.log for more info like which one of the columns in this table is configured as Not Null.
Do check how the value for your primary key of the cdt value is being saved. It might be the root cause or as the others mentioned, do check for the remaining fields you have marked not-null
Please see db structure:
Valuationid is not null field as it should not be empty or null.
As a prior reply already noted, your tomcat-stdout.log file should contain an explanation as to what the actual missing column is.
Did you check your failed process instance data to ensure that the CDT value is properly populated? Could you post a screenshot of it here?
this valuationid column is a foriegn key. Value is not populated but the parent table value properly entered into a table.
manjit.1486 said: Value is not populated but the parent table value properly entered into a table.
Where do you mapping the valuationId ?? Only when using Records (With relationships) FK Values gonna map automatically . But you are using CDT's , So you need to map it and then write it through datastore
Okay, let me try.