Support Article
DatabaseException when importing data from Data Import wizard
SA-95387
Summary
DatabaseException occurs when importing data from the Data Import wizard.
Error Messages
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.
Root Cause
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.
Resolution
As a local-change, create the PostGIS extension later.
Published December 2, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.