itmicus / itmicus/cmdbuild_docker
ERROR: relation "Gis_Building_Position" does not exist
- Dominant language
- Dockerfile
- Stars
- 123
- Forks
- 76
- PR merge metrics
- No merged PRs in 30d
Description
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
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.