|
| I have a portal configurated with SQLServer as 'WPS50' db.
In my portlets, if I try to call PropertyBrokerService.unregisterActions I obtain 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', column 'PORT_PROP_OID'.</I>
The constraint FK910B is setted on WPSDBUSR.PORT_PARM table:
CONSTRAINT [FK910B] FOREIGN KEY ([PORT_PROP_OID]) REFERENCES [WPSDBUSR].[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
|
|