Skip to content

Can't save new data sources #63

@markanthony97

Description

@markanthony97

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions