Hello,
I am getting below error when i was trying to write to execute smart service write to data store entity from interface.
Few points about CDT and Table:-
Error i am getting on Interface:-
Interface Definition: Expression evaluation error: An error occurred while executing a smart service: An error occurred while trying to write to the entity “DDP_QuestionResponse” [id=3dc6d3fc-8a9e-4bcc-b781-112d22727019@1850, type=DDP_QuestionResponse (id=3860)] (data store: DDP Data Store). Details: org.hibernate.PropertyValueException: not-null property references a null or transient value:
CDT and XSD structure of Column valueMultiListValue :-
<xsd:element maxOccurs="unbounded" minOccurs="0" name="valueMultiListValue" nillable="true" type="xsd:int" />
Questions :-How do i write data to table from interface?How database write working as expected from process model?
If CDT column is transient how do i able to write it to other table from valueMultiListValue column value?
Discussion posts and replies are publicly visible
This is an expected behaviour in Appian.
This is because Nested CDTs will fail while writing to datastore entity
when the child CDT foreign key column has a NOT NULL constraint in the database
Thanks,Arun
i am facing the same issue but my foreign key is NULL CONSTRAINT IN THE DATABASE