Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

error openmaint-2.0-3.2.1 #15

Open
MANTENIMIENTOSENA opened this issue Jun 15, 2020 · 0 comments
Open

error openmaint-2.0-3.2.1 #15

MANTENIMIENTOSENA opened this issue Jun 15, 2020 · 0 comments

Comments

@MANTENIMIENTOSENA
Copy link

Help me, I have this error.

image

org.cmdbuild.dao.DaoException: error processing patch = Patch{version=3.3.0-02_etl_gate_upgrade, category=core, applied=false}, caused by: org.cmdbuild.dao.DaoException: error processing patch = core-3.3.0-02_etl_gate_upgrade (etl gate tables upgrade), 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-3.3.0-02_etl_gate_upgrade'; END $$ LANGUAGE PLPGSQL; -- etl gate tables upgrade SELECT _cm3_attribute_create('OWNER: _EtlGate|NAME: Handlers|TYPE: jsonb|DEFAULT: ''[]''::jsonb'); DO $$ DECLARE _record record; _handlers jsonb; _templates varchar; BEGIN PERFORM _cm3_class_triggers_disable('"_EtlGate"'); FOR _record IN SELECT * FROM "_EtlGate" LOOP _handlers = '[]'::jsonb; SELECT string_agg(_template, ',') FROM unnest(_record."Templates") _template INTO _templates; IF _cm3_utils_is_not_blank(_record."Script") THEN _handlers = _handlers || jsonb_build_object('type', 'script', 'script', _record."Script", 'templates', _templates); END IF; IF _record."Handler" = 'default' THEN IF _cm3_utils_is_not_blank(_templates) THEN _handlers = _handlers || jsonb_build_object('type', 'template', 'templates', _templates); END IF; ELSE _handlers = _handlers || jsonb_build_object('type', _record."Handler", 'templates', _templates); END IF; UPDATE "_EtlGate" SET "Handlers" = _handlers WHERE "Id" = _record."Id"; END LOOP; PERFORM _cm3_class_triggers_enable('"_EtlGate"'); END $$ LANGUAGE PLPGSQL; ALTER TABLE "_EtlGate" DROP COLUMN "Script"; ALTER TABLE "_EtlGate" DROP COLUMN "Templates"; ALTER TABLE "_EtlGate" DROP COLUMN "Handler"; ALTER TABLE "_EtlGate" ADD CONSTRAINT "_cm3_Handlers_check" CHECK ( "Status" <> 'A' OR _cm3_etl_handlers_check("Handlers") ); DO $$ BEGIN RAISE NOTICE 'applied cmdbuild patch %', 'core-3.3.0-02_etl_gate_upgrade'; END $$ LANGUAGE PLPGSQL; ]; nested exception is org.postgresql.util.PSQLException: ERROR: no existe la columna pg_attrdef.adsrc Where: función SQL «_cm3_attribute_default_get», durante expansión en línea sentencia SQL: «SELECT _cm3_attribute_default_get(_class, _attr)» función PL/pgSQL _cm3_attribute_default_set(regclass,character varying,character varying,boolean) en la línea 11 en asignación sentencia SQL: «SELECT _cm3_attribute_default_set(_class, _attr, _default, TRUE)» función PL/pgSQL _cm3_attribute_create(regclass,character varying,character varying,jsonb) en la línea 33 en PERFORM sentencia SQL: «SELECT _cm3_attribute_create(_class, _attr, _features->>'TYPE', _features - 'TYPE')» función PL/pgSQL _cm3_attribute_create(regclass,character varying,jsonb) en la línea 2 en PERFORM sentencia SQL: «SELECT _cm3_attribute_create(_cm3_utils_name_to_regclass(_features->>'OWNER'), _features->>'NAME', _features - 'OWNER' - 'NAME')» función PL/pgSQL _cm3_attribute_create(jsonb) en la línea 2 en PERFORM sentencia SQL: «SELECT _cm3_attribute_create(_cm3_comment_to_jsonb(_features))» función PL/pgSQL _cm3_attribute_create(character varying) en la línea 2 en PERFORM, caused by: org.postgresql.util.PSQLException: ERROR: no existe la columna pg_attrdef.adsrc Where: función SQL «_cm3_attribute_default_get», durante expansión en línea sentencia SQL: «SELECT _cm3_attribute_default_get(_class, _attr)» función PL/pgSQL _cm3_attribute_default_set(regclass,character varying,character varying,boolean) en la línea 11 en asignación sentencia SQL: «SELECT _cm3_attribute_default_set(_class, _attr, _default, TRUE)» función PL/pgSQL _cm3_attribute_create(regclass,character varying,character varying,jsonb) en la línea 33 en PERFORM sentencia SQL: «SELECT _cm3_attribute_create(_class, _attr, _features->>'TYPE', _features - 'TYPE')» función PL/pgSQL _cm3_attribute_create(regclass,character varying,jsonb) en la línea 2 en PERFORM sentencia SQL: «SELECT _cm3_attribute_create(_cm3_utils_name_to_regclass(_features->>'OWNER'), _features->>'NAME', _features - 'OWNER' - 'NAME')» función PL/pgSQL _cm3_attribute_create(jsonb) en la línea 2 en PERFORM sentencia SQL: «SELECT _cm3_attribute_create(_cm3_comment_to_jsonb(_features))» función PL/pgSQL _cm3_attribute_create(character varying) en la línea 2 en PERFORM

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant