Hi,
I get an error when I am trying to save a Building card in Openmaint 1-1 2.4.2
The installation includes PostGIS and Opensource BIM and Geoserver as well.
The error:
Error: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [UPDATE "Building"
SET "ZIP" = ?, "Group" = ?, "Description" = ?, "Address" = ?, "GlazedArea" = ?, "Name" = ?, "Complex" = ?, "TotalGrossArea" = ?,
"CleanableArea" = ?, "TotalHeatedVolume" = ?, "IsInUnit" = ?, "Notes" = ?, "Floors" = ?, "Criticality" = ?, "Availability" = ?,
"Condition" = ?, "IsInRoom" = ?, "LastCheckDate" = ?, "City" = ?, "Code" = ?, "ClimaticZone" = ?, "MainUse" = ?, "IsInFloor" = ?,
"Units" = ?, "TotalNetArea" = ?, "Rooms" = ?, "IsInBuilding" = ?, "CoveredArea" = ?, "IsInComplex" = ?, "Country" = ?,
"TotalVolume" = ?, "User" = ? WHERE "Id" = ?]; nested exception is org.postgresql.util.PSQLException: ERROR: relation
"Detail_Building_Position" does not exist
Where: PL/pgSQL function _cm_trigger_restrict() line 5 during statement block local variable initialization
Caused by: org.postgresql.util.PSQLException: ERROR: relation "Detail_Building_Position" does not exist
Restoring the database, did you use the instructions described in the CMDBuild 2.4 Technical Manual on page 8 ?
CMDBuild Team
It
would appear that you have not performed the operations described in
the CMDBuild Technical Manual on page 8 regarding Postgis.
CMDBuild Team
Previously Tecnoteca wrote:
Restoring the database, did you use the instructions described in the CMDBuild 2.4 Technical Manual on page 8 ?
CMDBuild Team
Thanks. It seems to work after that.
/Jesper
Previously Jesper wrote:
Previously Tecnoteca wrote:
Restoring the database, did you use the instructions described in the CMDBuild 2.4 Technical Manual on page 8 ?
CMDBuild Team
Thanks. It seems to work after that.
/Jesper
Ok. It seems that there still is some issue. Now I get this error when I try to save a position on a card:
ERROR: column "Geometry" is of type gis.geometry but expression is of type geometry
Ok. It seems that there still is some issue. Now I get this error when I try to save a position on a card:
ERROR: column "Geometry" is of type gis.geometry but expression is of type geometry
/Jesper
There seems to be something wrong with database restore and in particular with the GIS schema.
When the restore is done correctly the GIS data types are in the GIS schema (see attachment), in your case where are they?
It may be that you need to change the options in the File menu to see the data types in pgAdmin.
CMDBuild Team
gisschema-jpg (36.2 KB)
Previously Tecnoteca wrote:
There seems to be something wrong with database restore and in particular with the GIS schema.
When the restore is done correctly the GIS data types are in the GIS schema (see attachment), in your case where are they?
It may be that you need to change the options in the File menu to see the data types in pgAdmin.
CMDBuild Team
Ok. The datatypes is in the public schema. How is that possible?
I restored the openmaint-1.1-demo.backup file included in the download.
/Jesper
