Hi I am facing errors in assigning Geo Attributes to building cards. Using the combination of openmaint-2.0-.3.1.1, PostgreSQL 10.1 and PostGIS 3.0 on Windows 10 system. Reference to similar posts in this Forum, I have followed below procedure to make GIS feature work but failed.
Step 1 - Install PostGIS 3.0
Step 2 - Execute the commands in Pg Admin
- CREATE DATABASE [database_name]
- CREATE SCHEMA gis;
- SET SEARCH_PATH TO gis, public;
- Run SQL code of postgis.sql file [ located in $ROOT DIR=\PostgreSQL\10\share\contrib\postgis-3.0]
- Run SQL code of spatial_ref_sys.sql file [ located in $ROOT DIR =\PostgreSQL\10\share\contrib\postgis-3.0 ]
- Run SQL code of legacy.sql file [ located in $ROOT DIR =\PostgreSQL\10\share\contrib\postgis-3.0 ]
- ALTER DATABASE [database_name] SET search_path="$user", public, gis;
Step 3 - Restore the demo dump “openmaint_empty_gis.dump” into new database created
Step 4 - Start Tomcat
In Admin Module, when I activate the GIS navigation, I get this error:
In Management Module, when I save a card in building class, I get this error
Could you please point out which step I am missing ? Thanks