After starting tomcat i am able to get the login page . i have use manual installation for version 3.0. after seeing the log while on screen i have manually created user cmdbuild and also created manually database as cmdbuild_30.
After lunching tomcat first page it prompt for applied patch. and when i ama applying the patch it prompt for error on bottom screen a
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
Previously Mr Hitesh Taunk wrote:
After starting tomcat i am able to get the login page . i have use manual installation for version 3.0. after seeing the log while on screen i have manually created user cmdbuild and also created manually database as cmdbuild_30.
After lunching tomcat first page it prompt for applied patch. and when i ama applying the patch it prompt for error on bottom screen a
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
i have the same error . you resolved this ?
If you are creating a database from scratch make sure you are setting it up correctly with the required tables and relations, it is suggested to start from one of the provided databases like the demo database included in the installation files to properly understand the structure of it.
CMDBuild Team.