Hi Shazni, Better check whether those tables I have mentioned has the ON DELETE CASCADE constraint enabled.
Thanks, On Wed, Nov 23, 2016 at 2:22 PM, Shazni Nazeer <[email protected]> wrote: > Got it Maduranga. Thanks for the information. > > I've set it false in my setup and seems there's no side effect in doing > so. > > On Wed, Nov 23, 2016 at 3:48 AM, Maduranga Siriwardena <[email protected] > > wrote: > >> Hi Shazni, >> >> This property is added with a fix to [1]. With the fix we have added ON >> DELETE CASCADE constraint on UM_ROLE_PERMISSION, UM_USER_PERMISSION, >> UM_HYBRID_USER_ROLE tables in user management database. This is added with >> a kernel 4.4.x release and because we need to the database to be backward >> compatible, we have added this property. So if ON DELETE CASCADE constraint >> is not there on those tables, we need this property set to false. See the >> PR [2]. >> >> [1] https://wso2.org/jira/browse/IDENTITY-3620 >> [2] https://github.com/wso2/carbon-kernel/pull/512 >> >> Thanks, >> >> On Mon, Nov 21, 2016 at 3:20 PM, Shazni Nazeer <[email protected]> wrote: >> >>> Hi, >>> >>> I got an constraint violation while deleting an API due to cascade >>> delete. I got rid of the error by turning it off. >>> >>> Is there any functional implications in turning off >>> "isCascadeDeleteEnabled" in the API-M repository/conf/user-mgt.xml? >>> >>> regards >>> >>> -- >>> Shazni Nazeer >>> Associate Technical Lead | WSO2 >>> >>> Mob : +94 777737331 >>> LinkedIn : http://lk.linkedin.com/in/shazninazeer >>> Blog : http://shazninazeer.blogspot.com >>> >>> <http://wso2.com/signature> >>> >>> _______________________________________________ >>> Dev mailing list >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> Maduranga Siriwardena >> Software Engineer >> WSO2 Inc; http://wso2.com/ >> >> Email: [email protected] >> Mobile: +94718990591 >> Blog: http://madurangasblogs.blogspot.com/ >> <http://wso2.com/signature> >> > > > > -- > Shazni Nazeer > Associate Technical Lead | WSO2 > > Mob : +94 777737331 > LinkedIn : http://lk.linkedin.com/in/shazninazeer > Blog : http://shazninazeer.blogspot.com > > <http://wso2.com/signature> > -- Maduranga Siriwardena Software Engineer WSO2 Inc; http://wso2.com/ Email: [email protected] Mobile: +94718990591 Blog: http://madurangasblogs.blogspot.com/ <http://wso2.com/signature>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
