SQL integrity issue

Support
#1

Hey,

I have a class called daily census which has only two attributes
1.census date
2.patient assignment
Also I have classes like doctor daily census and nurse daily census which has daily census as the parent class
Now the doctor daily census and nurse daily census has 1 attribute in common
Patient with not null patient id
Because the daily census is the parent class to both of these classes whenever I save data I encounter this issue

java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: NOT NULL check constraint; SYS_CT_12485 table: HREMS_DAILY_CENSUS column: PATIENT_ID
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

how can I remove this .?
I will attach screenshots for better understanding
RegardsDaily_censusnurse%20daily%20censusScreenshot%20(330)
Screenshot%20(331)

#2

Hi,

Most probably it’s the same issue as described here.

In order to fix it, upgrade your project to the platform version 6.9.4 and add the following property to app.properties file of the core module:

cuba.hasMultipleTableConstraintDependency = true
#3

Thank you so much for the reply :slight_smile: