not-null property references a null or transient value

Your database table has 'projectid' as a non-nullable value, but the data you've passed to the has this value set to null. 

Hi Stewart,

It was null before but I changed it after getting the same error as above. 

I did what you told me, to but getting the same error. 

An error occurred while trying to write to the entity "MD_PM_mdpmphases" [id=87e6bf7a-11e6-4281-a840-a48dbb5c66f3@4551, type=MD_PM_mdpmphases (id=4046)] (data store: MD_PM_Data Store). Details: org.hibernate.PropertyValueException: not-null property references a null or transient value: MDPMMdpmphasesDT3754.projectId Data: TypedValue[it=4046,v={<null>,<null>,<null>,0.89,<null>,fdgsdgdsa,terwetg,2022-03-16,2022-03-18,In Progress,PFAM,PCM,rggreghrehreh,<null>,<null>,<null>}]

My new phase interface. 

Thanks

Have you changed the corresponding CDT that you're using to map to this table? There are attributes in the CDT that instruct whether a given data item can be null or not.

Have you changed the corresponding CDT that you're using to map to this table? There are attributes in the CDT that instruct whether a given data item can be null or not.

You mean this CDT? 

That's a Record View. In your Write to Datastore node what CDT are you using? If you find that, download the XSD and open it up for editing you can see something like this: 

I copied the wrong one. Will check the XSD file. 

Thanks

Should I change it to true here? Then should I use create new version from XSD?

I haven't used this method before.

Thanks

Yes. Once you create a new version from the altered XSD that will republish the Datastore that the CDT is hosted in.

Got it. Thanks

The process model is working. Thanks for your help.