DatabaseException when importing data from Data Import wizard
DatabaseException occurs when importing data from the Data Import wizard.
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: relation "spatial_ref_sys" does not exist | SQL Code: 0 | SQL State: 42P01
Steps to Reproduce
Import data or save a case.
A defect or configuration issue in the operating environment.
PostGIS extension was dropped as part of the database upgrade process. The spatial_ref_sys is one of the PostGIS dependent objects in the database. Hence, error occurred for all those features that have data linked to spatial_ref_sys.
As a local-change, create the PostGIS extension later.
0% found this useful