duplicate key detected

[Chris Sharman]

VAN DE MEERSSCHE Marc wrote:
> Hello,
> 
> When trying to create a new record in powerhouse dictionnary I receive the
> following error:
> Data access error. (O-FILE*01)
> %RMS-F-DUP, duplicate key detected (DUP not set)
> 
> In the other dictionnaries we don't seem to have the same problem.
> 
> We're using Powerhouse 7.10.G on a OpenVMS system.
> 
> Can anyone help with this problem?

Looks like a dictionary corruption of some kind.
Since experiencing similar many years ago (V6, when we'd just started 
using PH), we have a batch job take a source backup every night.

All that's necessary is:
$ qshow
set language pdl
set security
generate all

We then automatically store the source in CMS (if changed).
Naturally, in accordance with Murphy's Law, such a backup is only 
necessary if you don't have one - we've never used ours.

We also use the FDL editor to tune the dictionary files, but that's a 
performance thing, not data integrity/security.

However, to recover after the fact may be more difficult.
I'd recommend:
1. Generate PDL (as above) to a file.
2. Inspect for anomalies.
3. Generate FDL (anal/rms/fdl) and rebuild the dictionary (conv/fdl on 
each of files 1,2,3,4) (file 0 is not indexed, so won't benefit). This 
will probably rectify any RMS corruption, but not any application 
corruption.
4. Generate the PDL again, and see whether there are differences, and 
whether it's better, worse, or the same. Test new record creation too.

Further steps would include re-creating the entire dictionary from the 
PDL, and/or cleaning up any orphaned and unused data (screen 12, global 
rename/delete).

When you've got it cleaned up, your new record creation should work 
properly.

Good luck!
Chris


-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.