@@ -20,3 +20,12 @@ You tried to delete data in a view where you do not have the permission to do so
...
@@ -20,3 +20,12 @@ You tried to delete data in a view where you do not have the permission to do so
## Solution
## Solution
To edit or delete data, please always use the views with suffix __import_ or __qa_rejected_.
To edit or delete data, please always use the views with suffix __import_ or __qa_rejected_.
# Import problem with DBeaver: "Can't init data transfer"
"Reason: Can't create or update tagret table: ALTER View surfw.meas_import ADD ..."
## Cause
Instead of importing data via the import view DBeaver tries do change the view by adding columns to it. The right query for import would be a "INSERT INTO surfw.meas_import VALUES ... ".
## Solution
Make sure the mapping of columns from the data source to the database table in the DBeaver import wizzard is everywhere showing "existing" and no "create".