Data binding error for Org and Functional roles

Hello Community,

I have data-binded the organizational and functional roles, while importing it to another instance it shows an error.

 



Thanks in Advance

Yasaswini I

Like 0

Like

4 comments

Hello!



Every time when we want to import data with changes in SysAdminUnit we should do the following:



1. disable trigger TRSysAdminUnitRoot

2. install the package with data

3. enable trigger TRSysAdminUnitRoot



Kind regards,

Vladimir

Vladimir Sokolov,

Thank You

Vladimir Sokolov,

Hello Vladimir,

 

Where I can found this trigger?

Can someone in Creatio please improve this? Deploying certain Org Roles is essential, it makes very little sense for this to not be possible. It really causes a lot of problems. The error I get in the deployment logs before following Vladimir's suggestion is the following (as I couldn't see any pages mentioning it when searching before):

P0001: Cannot add root administering unit. Invalid unit type specified.

 

I can confirm that disabling the trigger worked for deploying for me in Postgres envs, but it's concerning this kind of workaround is needed. In our case, we used the following SQL Script set to run before package installation:

ALTER TABLE "SysAdminUnit" DISABLE TRIGGER "TRSysAdminUnitRoot";

And then the following SQL script set to run after schema data installation:

ALTER TABLE "SysAdminUnit" ENABLE TRIGGER "TRSysAdminUnitRoot";
Show all comments