I have a portal configurated with SQLServer as 'WPS50' db.
In my portlets, if I try to call PropertyBrokerService.unregisterActions I o
btain the exception:

<I>java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC
][SQLServer]DELETE statement conflicted with COLUMN REFERENCE constraint
 'FK910B'. The conflict occurred in database 'wps50', table 'PORT_PARM', col
umn 'PORT_PROP_OID'.</I>

The constraint FK910B is setted on WPSDBUSR.PORT_PARM table:
CONSTRAINT [FK910B] FOREIGN KEY ([PORT_PROP_OID]) REFERENCES [WP
SDBUSR].[PORT_PROP] ([OID])

This is without 'on delete cascade' directive so I think this is the problem
. In fact, other db (cloudscape or db2) have it.

I try to drop and recreate the constraint by hand but SQLServer cannot sets 
'delete cascade' on FK910B because, it says, may causes cyclic paths.

Any idea?

Ciao, Diego

[ Post a follow-up to this message ]