Knowage-Server-Docker icon indicating copy to clipboard operation
Knowage-Server-Docker copied to clipboard

Can't save new data sources

Open markanthony97 opened this issue 1 year ago • 0 comments

Situation

I have set up a postgresql database from which I retrieve data. I could add the data source but when it came to adding the dataset I couldn't do anything on the 8.2-SNAPSHOT version of the knowage-server-docker image because the type section was completely empty, so I switched to :latest in the docker compose that used a different kind of GUI. It seemed to work.

Problem

Now the Type section shows up, with the problem however being that I can't save on the database whe, because I get this error: Cannot add or update a child row: a foreign key constraint fails ('knowagedb'.'SBI_DATA_SET', CONSTRAINT 'FK_DATA_SET_CATEGORY' FOREIGN KEY ('CATEGORY_ID') REFERENCES 'SBI_CATEGORY' ('ID'))

Does this that the "Default Data Category" depends on a constraint that I have to modify manually?

Next, if I try instead to not add any data category, I run into this other error Unknown column 'IS_VOLATILE' in 'where clause'

Notes

I may not go back to the 8.2-SNAPSHOT version of the container because the type section for adding a new dataset is bugged and doesn't show anything. If this is not the proper place, should I move this issue to the central repository here? But the problem seems to be with the database writing, so if there is a fix for this or you need more details let me know, thank you.

markanthony97 avatar Mar 22 '23 12:03 markanthony97