Fresh Installation

Hi there, i´m doing a fresh installation of cmdbuild 3.3 on centos 8, with tomcat 9 and postgres 12 db. when i click on installing in the webinterface i get this error…can anybody help to cover this error… i google that i shoud use a demo dump file with a given structur for the database but where can i get this file or is there a other solution?

Error Message:

org.cmdbuild.dao.DaoException: error processing patch = Patch{version=1.0.3-01, category=core, applied=false}, caused by: org.cmdbuild.dao.DaoException: error processing patch =< core-1.0.3-01 (Change Role class type from reserved to sysread) >, caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ SET SESSION cmdbuild.ignore_tenant_policies = ‘true’; SET SESSION cmdbuild.user_tenants = ‘{}’; DO $$ BEGIN RAISE NOTICE ‘apply cmdbuild patch %’, ‘core-1.0.3-01’; END $$ LANGUAGE PLPGSQL; – Change Role class type from reserved to sysread COMMENT ON TABLE “Role” IS ‘MODE: sysread|TYPE: class|DESCR: Roles|SUPERCLASS: false|MANAGER: class|STATUS: active’; DO $$ BEGIN RAISE NOTICE ‘applied cmdbuild patch %’, ‘core-1.0.3-01’; END $$ LANGUAGE PLPGSQL; ]; nested exception is org.postgresql.util.PSQLException: FEHLER: Relation »Role« existiert nicht, caused by: org.postgresql.util.PSQLException: FEHLER: Relation »Role« existiert nicht

as I remember from my install, it was a question of DB access/authendication.

Hi, the documentations says that i need an empty database with given structure, but where can i get such an database?


As I read in Technical Manual you should try with PostgreSQL 10.1, not 12