Error adding elements to dictionary

[Miller, Daniel]

Hi,

This was an interesting problem that has not occurred before, ive always
wondered what problems caused people to upgrade from 710g1 to 710g4 etc, may
this was one?

The first thing we tried was creating fdls and doing a convert which made no
difference, since the message was a duplicate key im guessing that there was
not any rms corruption just some records we didnt want.

We then tried creating a pdl from the dictionary and loading that in as a
new dictionary hoping that would clear it out, this didnt remove the problem
either.

Interestingly the pdl we generated had some errors in it when we tried to
load it the first time.  Some single + double quotes in value
captions/descriptions/help etc got muddled up.  The "gen all" also gave us 6
digit dates back with "noforcecentury" on them and that generated errors too
when we tried to load it.

If the phdmaint and recover hadnt fixed it then we would have restored the
dictionary from the previous nights backup and possibly reloaded that as
pdl.
Our entire development enviroment is backed up every night, so thats our
normal fallback if nothing else works.

Daniel Miller
Nightfreight

-----Original Message-----
From: Chris Sharman [mailto:chris.sharman@ccagroup.co.uk]
Sent: Tuesday, August 13, 2002 1:01 PM
To: Hamilton, Allison; daniel.miller@nightfreight.co.uk;
powerh-l@lists.swau.edu
Subject: RE: Error adding elements to dictionary



Just back from holiday.
Yes, as everyone's said, it's likely dictionary corruption.
Recover with PH tools, or RMS CONVERT.
We had some bad experiences right back when we started using PH (610E), and
instituted a nightly batch job to generate PDL every night, and keep it for
posterity (we store it in a CMS library). We still do, although we've never
needed it.

It seems to me to be a sensible piece of paranoia to keep source somewhere
as a guard against dictionary loss/corruption - with the pow phd tool there
is no original source.

Chris

> -----Original Message-----
> From: Hamilton, Allison [mailto:allison.hamilton@cognos.com]
> Sent: 31 July 2002 15:45
> To: daniel.miller@nightfreight.co.uk; powerh-l@lists.swau.edu
> Subject: RE: Error adding elements to dictionary
>
>
> Another option, if the dictionary doesn't recover properly, or if you just
> want to start again... Go into QSHOW, SET LANGUAGE PDL, GEN ALL
> (if you are
> using ASC's etc, make sure you SET SECURITY first, and have
> privilege to do
> so).  This will give you a PDL source for your current
> dictionary.  Then you
> can recompile it and return to POW for further updates.
>
> -----Original Message-----
> From: Hamilton, Allison [mailto:Allison.Hamilton@cognos.com]
> Sent: Wednesday, July 31, 2002 10:19 AM
> To: 'Miller, Daniel'; Powerhouse List 3 (E-mail)
> Subject: RE: Error adding elements to dictionary
>
>
> It's possible that the delete didn't delete everything it was supposed to,
> so you ended up with something left over that you shouldn't have.
>  You might
> try to use PHDMAINT to Recover your dictionary.  It should
> produce a report
> indicating where the problem is, and it may be able to fix it.
>
> -----Original Message-----
> From: Miller, Daniel [mailto:Daniel.Miller@nightfreight.co.uk]
> Sent: Wednesday, July 31, 2002 10:01 AM
> To: Powerhouse List 3 (E-mail)
> Subject: Error adding elements to dictionary
>
>
> Hi,
>
> Anyone have an idea on the cause of this error?
>
> Data access error. (O-ELEMENT*01)
> %RMS-F-DUP, duplicate key detected (DUP not set)
>
> Press RETURN to continue.
>
> When we try to add elements to a dictionary we get the above
> error on update
> (using "pow"), we can still add elements to other dictionaries ok.
>
> The elements being added definitely dont exist in the dictionary allthough
> the problem started after an element had been deleted and then
> was tried to
> be reentered.  There is definitely no one else accessing the dictionary.
>
> We use ph 710g1 on alpha vms 7.3
>
> tia,
>
> Daniel Miller
> Nightfreight
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to
> powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
>
> This message may contain privileged and/or confidential
> information.  If you
> have received this e-mail in error or are not the intended recipient, you
> may not use, copy, disseminate or distribute it; do not open any
> attachments, delete it immediately from your system and notify the sender
> promptly by e-mail that you have done so.  Thank you.
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to
> powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
>
> This message may contain privileged and/or confidential
> information.  If you
> have received this e-mail in error or are not the intended recipient, you
> may not use, copy, disseminate or distribute it; do not open any
> attachments, delete it immediately from your system and notify the sender
> promptly by e-mail that you have done so.  Thank you.
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to
> powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> ------------------------------------------------------------------
> --------------
> Date: Wed, 31 Jul 2002 10:43:08 -0400
>



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

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.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.