CMDBuild Forum

[ Error with geoserver layers ] table gis.Gis_Floor_XXX not found

Systems Engineering
#1

Hello,
In the demo of the latest version of openmaint, when I try to view the floor layer on the map, the following error appears:

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT st_extent(geometry) FROM (SELECT “Geometry”::geometry geometry FROM gis.“Gis_Floor_CPX01__TT01__F00N”) g]; nested exception is org.postgresql.util.PSQLException: ERROR: relation “gis.Gis_Floor_CPX01__TT01__F00N” does not exist Position: 76, caused by: org.postgresql.util.PSQLException: ERROR: relation “gis.Gis_Floor_CPX01__TT01__F00N” does not exist Position: 76

Any idea?
Thanks

#2

Maybe you need set again the search_path. When I restore a bak, I have to.

replace your_database in the script

-- look the search path
show search_path;

-- run in single batch
REVOKE CONNECT ON DATABASE your_database  FROM PUBLIC,  postgres;

SELECT pg_terminate_backend(pid) FROM pg_stat_activity
WHERE  
 pid <> pg_backend_pid() -- don't kill my own connection!
 AND datname = 'your_database  ' -- don't kill the connections to other databases
;
-- update the search path 
alter database your_database  set search_path = "$user", public, gis;