"not data found" error in replication

Hello All!

My environment is a Multi-Master Replication in 7.3.4 on Solaris 2.6. We do not need error resolution methods because the application only works on one of the DB´s. Configured with High Availability Software.
Everything works fine so far but:
Sometimes (not to reproduce) we get an error "no data found" in the deferror view in the standby DB. Only the standby DB!!

Frank Naudé said in his FAQ that you should not update the primary key.
OK, he might be right and the PowerBuilder Application is really very stupid. Powerbuilder creates only full update statements like. update <tablename> set <PK>='SAME' others=''... where <PK>='SAME'...

My questions: Can I reproduce this behaviour? Why does that error not occur everytime? Why is it only a problem in the standby DB and NOT in the productive DB the user is connected to?

Any help?

Thorsten Received on Sat Nov 13 1999 - 02:18:17 CST