duplicate key detected
Markus Grossrieder
markus.grossrieder@alba-systems.com
Wed, 5 May 2004 11:35:20 +0200
This is a multi-part message in MIME format.
------=_NextPart_000_0054_01C43295.0BA9CD90
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Marc,=20
in PHDMAINT, you have some options, but I don't remember which one to =
use (if you have your manuals at hand, you should find some =
information). I would try "recover", "restore" or "reorganize" (after =
making a backup), it may correct your problem ...
HTH, Markus
----- Original Message -----=20
From: "Chris Sharman" <chris.sharman@ccagroup.co.uk>
To: "VAN DE MEERSSCHE Marc" <marc.vandemeerssche@nationalesuisse.be>
Cc: <powerh-l@lists.sowder.com>
Sent: Wednesday, May 05, 2004 9:57 AM
Subject: Re: duplicate key detected
> VAN DE MEERSSCHE Marc wrote:
> > Hello,
> >=20
> > 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)
> >=20
> > In the other dictionnaries we don't seem to have the same problem.
> >=20
> > We're using Powerhouse 7.10.G on a OpenVMS system.
> >=20
> > Can anyone help with this problem?
>=20
> Looks like a dictionary corruption of some kind.
> Since experiencing similar many years ago (V6, when we'd just started=20
> using PH), we have a batch job take a source backup every night.
>=20
> All that's necessary is:
> $ qshow
> set language pdl
> set security
> generate all
>=20
> We then automatically store the source in CMS (if changed).
> Naturally, in accordance with Murphy's Law, such a backup is only=20
> necessary if you don't have one - we've never used ours.
>=20
> We also use the FDL editor to tune the dictionary files, but that's a=20
> performance thing, not data integrity/security.
>=20
> 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=20
> corruption.
> 4. Generate the PDL again, and see whether there are differences, and=20
> whether it's better, worse, or the same. Test new record creation too.
>=20
> Further steps would include re-creating the entire dictionary from the =
> PDL, and/or cleaning up any orphaned and unused data (screen 12, =
global=20
> rename/delete).
>=20
> When you've got it cleaned up, your new record creation should work=20
> properly.
>=20
> Good luck!
> Chris
>=20
>=20
> =
-----------------------------------------------------------------------
>=20
> 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.
> =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
> Mailing list: powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to =
powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body to =
powerh-l-request@lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a =
subscriber.
>
----------------------------------------
My Inbox is protected by SPAMfighter
310 spam mails have been blocked so far.
Download free www.spamfighter.com today!
------=_NextPart_000_0054_01C43295.0BA9CD90
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Hi Marc, </FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D2>in PHDMAINT, you have some =
options, but I=20
don't remember which one to use (if you have your manuals at hand, you =
should=20
find some information). I would try "recover", "restore" or=20
"reorganize" (after making a backup), it may correct your problem=20
...</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D2>HTH, Markus</FONT></DIV></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" size=3D2>----- Original Message ----- =
</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>From: "Chris Sharman" =
<</FONT><A=20
href=3D"mailto:chris.sharman@ccagroup.co.uk"><FONT face=3D"Courier New"=20
size=3D2>chris.sharman@ccagroup.co.uk</FONT></A><FONT face=3D"Courier =
New"=20
size=3D2>></FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>To: "VAN DE MEERSSCHE Marc" =
<</FONT><A=20
href=3D"mailto:marc.vandemeerssche@nationalesuisse.be"><FONT =
face=3D"Courier New"=20
size=3D2>marc.vandemeerssche@nationalesuisse.be</FONT></A><FONT =
face=3D"Courier New"=20
size=3D2>></FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Cc: <</FONT><A=20
href=3D"mailto:powerh-l@lists.sowder.com"><FONT face=3D"Courier New"=20
size=3D2>powerh-l@lists.sowder.com</FONT></A><FONT face=3D"Courier New"=20
size=3D2>></FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Sent: Wednesday, May 05, 2004 =
9:57=20
AM</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Subject: Re: duplicate key=20
detected</FONT></DIV>
<DIV><FONT face=3D"Courier New"><BR><FONT =
size=3D2></FONT></FONT></DIV><FONT=20
face=3D"Courier New" size=3D2>> VAN DE MEERSSCHE Marc wrote:<BR>> =
>=20
Hello,<BR>> > <BR>> > When trying to create a new record in=20
powerhouse dictionnary I receive the<BR>> > following =
error:<BR>> >=20
Data access error. (O-FILE*01)<BR>> > %RMS-F-DUP, duplicate key =
detected=20
(DUP not set)<BR>> > <BR>> > In the other dictionnaries we =
don't=20
seem to have the same problem.<BR>> > <BR>> > We're using =
Powerhouse=20
7.10.G on a OpenVMS system.<BR>> > <BR>> > Can anyone help =
with this=20
problem?<BR>> <BR>> Looks like a dictionary corruption of some=20
kind.<BR>> Since experiencing similar many years ago (V6, when we'd =
just=20
started <BR>> using PH), we have a batch job take a source backup =
every=20
night.<BR>> <BR>> All that's necessary is:<BR>> $ qshow<BR>> =
set=20
language pdl<BR>> set security<BR>> generate all<BR>> <BR>> =
We then=20
automatically store the source in CMS (if changed).<BR>> Naturally, =
in=20
accordance with Murphy's Law, such a backup is only <BR>> necessary =
if you=20
don't have one - we've never used ours.<BR>> <BR>> We also use the =
FDL=20
editor to tune the dictionary files, but that's a <BR>> performance =
thing,=20
not data integrity/security.<BR>> <BR>> However, to recover after =
the fact=20
may be more difficult.<BR>> I'd recommend:<BR>> 1. Generate PDL =
(as above)=20
to a file.<BR>> 2. Inspect for anomalies.<BR>> 3. Generate FDL=20
(anal/rms/fdl) and rebuild the dictionary (conv/fdl on <BR>> each of =
files=20
1,2,3,4) (file 0 is not indexed, so won't benefit). This <BR>> will =
probably=20
rectify any RMS corruption, but not any application <BR>> =
corruption.<BR>>=20
4. Generate the PDL again, and see whether there are differences, and =
<BR>>=20
whether it's better, worse, or the same. Test new record creation =
too.<BR>>=20
<BR>> Further steps would include re-creating the entire dictionary =
from the=20
<BR>> PDL, and/or cleaning up any orphaned and unused data (screen =
12, global=20
<BR>> rename/delete).<BR>> <BR>> When you've got it cleaned up, =
your=20
new record creation should work <BR>> properly.<BR>> <BR>> Good =
luck!<BR>> Chris<BR>> <BR>> <BR>>=20
-----------------------------------------------------------------------<B=
R>>=20
<BR>> Any views expressed in this message are those of the sender and =
not<BR>> necessarily those of CCA Group. The unauthorized use,=20
disclosure,<BR>> copying or alteration of this message is =
forbidden. =20
The contents of<BR>> this message may be confidential and/or =
privileged,=20
copyright CCA Group<BR>> and are intended solely for the use of the=20
individual or entity to whom<BR>> they are addressed. Whilst =
this=20
message has been scanned, CCA Group<BR>> cannot guarantee that it is =
virus=20
free or compatible with your systems<BR>> and accepts no =
responsibility for=20
any loss or damage arising from its<BR>> use. The recipient is =
advised to run=20
their own anti-virus software. If<BR>> you receive this message in =
error=20
please contact<BR>> </FONT><A =
href=3D"mailto:postmaster@ccagroup.co.uk"><FONT=20
face=3D"Courier New" size=3D2>postmaster@ccagroup.co.uk</FONT></A><FONT=20
face=3D"Courier New" size=3D2> immediately, destroy any copies and =
delete it<BR>>=20
from your computer systems.<BR>> =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D=20
=3D =3D =3D =3D =3D =3D<BR>> Mailing list: </FONT><A=20
href=3D"mailto:powerh-l@lists.sowder.com"><FONT face=3D"Courier New"=20
size=3D2>powerh-l@lists.sowder.com</FONT></A><BR><FONT face=3D"Courier =
New"=20
size=3D2>> Subscribe: "subscribe" in message body to </FONT><A=20
href=3D"mailto:powerh-l-request@lists.sowder.com"><FONT face=3D"Courier =
New"=20
size=3D2>powerh-l-request@lists.sowder.com</FONT></A><BR><FONT =
face=3D"Courier New"=20
size=3D2>> Unsubscribe: "unsubscribe <password>" in message =
body to=20
</FONT><A href=3D"mailto:powerh-l-request@lists.sowder.com"><FONT=20
face=3D"Courier New" =
size=3D2>powerh-l-request@lists.sowder.com</FONT></A><BR><FONT=20
face=3D"Courier New" size=3D2>> </FONT><A=20
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l"><FONT=20
face=3D"Courier New"=20
size=3D2>http://lists.sowder.com/mailman/listinfo/powerh-l</FONT></A><BR>=
<FONT=20
face=3D"Courier New" size=3D2>> This list is closed, thus to post to =
the list you=20
must be a subscriber.<BR>> </FONT>
<br><hr>My Inbox is protected by SPAMfighter <br>310 spam mails have been blocked so far.<br>Download free <a href=3D"http://www.spamfighter.com/">SPAMfighter</a> today!<br>
</BODY></HTML>
------=_NextPart_000_0054_01C43295.0BA9CD90--