CMDBuild Forum

Issues deleting demo data

Old Versions
#1

Hello,

When using CMDBuild 2.3.1 (openMAINT 1.0) when deleting some entries of the demo data I got this error in PostgreSQL log and the entry is not deleted, even though the http request for the deletion returns success:

<pre>ERROR:  schema "bim" does not exist

CONTEXT:  PL/pgSQL function _cm_trigger_restrict() line 5 during statement block local variable initialization

SQL statement "UPDATE "FireExtinguisher" SET "Status" = 'N' WHERE "Id" = 212794"

PL/pgSQL function cm_delete_card(integer,oid) line 11 at EXECUTE statement

STATEMENT:  select * from cm_delete_card($1, $2) as result

ERROR:  schema "bim" does not exist

CONTEXT:  PL/pgSQL function _cm_trigger_restrict() line 5 during statement block local variable initialization

SQL statement "UPDATE "FireExtinguisher" SET "Status" = 'N' WHERE "Id" = 212794"

PL/pgSQL function cm_delete_card(integer,oid) line 11 at EXECUTE statement

STATEMENT:  select * from cm_delete_card($1, $2) as result</pre>

In fact schema bim does not exist, but I didn't find any instructions on how to set this up.

Any help will be appreciated.

#2
Any hints on how to overcome this?
 
Previously Ruben Silva wrote:

Hello,

When using CMDBuild 2.3.1 (openMAINT 1.0) when deleting some entries of the demo data I got this error in PostgreSQL log and the entry is not deleted, even though the http request for the deletion returns success:

<pre>ERROR:  schema "bim" does not exist

CONTEXT:  PL/pgSQL function _cm_trigger_restrict() line 5 during statement block local variable initialization

SQL statement "UPDATE "FireExtinguisher" SET "Status" = 'N' WHERE "Id" = 212794"

PL/pgSQL function cm_delete_card(integer,oid) line 11 at EXECUTE statement

STATEMENT:  select * from cm_delete_card($1, $2) as result

ERROR:  schema "bim" does not exist

CONTEXT:  PL/pgSQL function _cm_trigger_restrict() line 5 during statement block local variable initialization

SQL statement "UPDATE "FireExtinguisher" SET "Status" = 'N' WHERE "Id" = 212794"

PL/pgSQL function cm_delete_card(integer,oid) line 11 at EXECUTE statement

STATEMENT:  select * from cm_delete_card($1, $2) as result</pre>

In fact schema bim does not exist, but I didn't find any instructions on how to set this up.

Any help will be appreciated.

 

#3

Hello,

try to execute this command:

DROP TRIGGER "_Constr_FireExtinguisher_Master" ON public."FireExtinguisher";

 

replacing FireExtinguisher with the name of the classes on which you are facing the problem.

 

Best regards

CMDBuild Team