itmicus/cmdbuild_docker

ERROR: relation "Gis_Building_Position" does not exist

Opened this issue · 1 comments

In my OpenMaint installation I always have this error when creating a FLOOR card. I have imported the demo.dump into db.
What would be your suggestion? Thanks.

org.cmdbuild.dao.DaoException: error executing insert for entry = CardImpl{id=null, code=VIA10, type=Floor}, caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "Gis_Building_Position" does not exist Where: PL/pgSQL function _cm3_trigger_card_enforce_foreign_key_for_target() line 4 during statement block local variable initialization SQL statement "UPDATE "Building" SET "TotFloors" = new_subsites_current, "User" = NEW."User" WHERE "Id" = new_site_id" PL/pgSQL function tt_site_to_parent_data() line 50 at SQL statement, caused by: org.postgresql.util.PSQLException: ERROR: relation "Gis_Building_Position" does not exist Where: PL/pgSQL function _cm3_trigger_card_enforce_foreign_key_for_target() line 4 during statement block local variable initialization SQL statement "UPDATE "Building" SET "TotFloors" = new_subsites_current, "User" = NEW."User" WHERE "Id" = new_site_id" PL/pgSQL function tt_site_to_parent_data() line 50 at SQL statement

Sorry, I think it is developer bug, please check now

CMDbuild openMAINT 2.0

docker run --name openmaint_db -p 5432:5432 -d itmicus/cmdbuild:db-3.0
docker run --name openmaint_app --restart unless-stopped -e CMDBUILD_DUMP="demo.dump.xz" --link openmaint_db  -p 8090:8080 -d itmicus/cmdbuild:om-2.0-3.2