KnowageLabs/Knowage-Server-Docker

Can't save new data sources

markanthony97 opened this issue · 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.