Cmdbuild ready2use-2.0-3.3 sql issue

[boblee4839]

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: ERROR: relation "Role" does not exist, caused by: org.postgresql.util.PSQLException: ERROR: relation "Role" does not exist

[afcarvalho1991]

This is most likely a CMDBuild issue more than it is a Dockerfile or docker-compose issue.

[Iizuki]

Did you figure out a workaround?