In the first table I have the machines and in the second one the currently logged on persons. In the EMPLOYEES table I'm using a PK of two columns (PERSONALID / MACHINEID). I'm not using ID. When a person logs off, it is not deleted from EMPLOYEES table when using .store(obj). The object contains the reduced collection of employees.
In the database, is the column "EMPLOYEE.PERSONALID" a foreign key or reference to another table? If you a dropping people from this table the sequence of things in the transaction could be important.
If the removal aware collection is trying to delete EMPLOYEE when personalId is either 0/null or references a deleted tuple, I guess you will run into problems.
There is also no object-level cache consistency in the PB API, so it could simply be that you are reading the object back from cache when testing?
Use P6Spy to check what SQL statements are beeing sent to the database.
Regards, Martin
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
