This has been done by checking out the source for slide corresponding to the
running version (2.1) and looking at stack trace of error.
statement = connection.prepareStatement("delete from URI where
URI_STRING = ?");
statement.setString(1, uri.toString());
statement.executeUpdate();
This is the sql query leading to problem. About all users were already removed
from the system, except for root which does not belong to the concerned
group.
I have located the DIRECTION.SYS_C0035428 constraint in table permissions
foreign key (SUBJECT_ID) references DIRECTION.URI(URI_ID)
Looks like we had an ace on a collection referencing that role.
Shouldn't slide automatically removes aces referencing that role when the role
is deleted??
In our case, we had ace /roles/PublicationManager /actions/write allow
on /files/published
Regards,
--
David Delbecq
Royal Meteorological Institute of Belgium
Le Lundi 18 Avril 2005 10:03, Martin Kal�n a �crit :
> delbd wrote:
> > We have got a problem here to remove a role using a webdav client.
> > When we select any role and ask for deletion, we get this in console:
> >
> > 18 Apr 2005 07:15:12 -
> > org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR - SQL
> > error 2292 on /roles/PublicationManager: ORA-02292: integrity constraint
> > (DIRECTION.SYS_C0035428) violated - child record found
>
> Either debug Slide or, for better overview on the SQL level, use P6Spy [1]
> to get a trace of the SQL statements being issued.
>
> The last SQL statement in the P6Spy log should tell you exactly the SQL
> that fails. If you know this, it might be easier to figure out what
> constraint you are trying to violate.
>
> I would first look for users belonging to the role or permissions entries
> for this role, since both would have "child records" from the role entry in
> DB.
>
> Regards,
> Martin
>
> [1] http://www.p6spy.org/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
