Rick:
Maybe you don't understand the functionality of the change id program. I don't think it updates the nextid field for the form.
However, I would not try changing an id from 536870915 to 536870916 but rather try this method. Change 536870915 to 536871000 and see what happens.
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick
Sent: Monday, August 07, 2006 7:18 AM
To: [email protected]
Subject: Re: archgid failure...
5.1.2
ora 9i
Windows 2000 AS
Michiel, the logs are really large, can't include them here.
If I attempt to add another new char field to the test form, it won't save, complaining of a unique index being violated. If I increment the nextid in Oracle, the new field then saves.
So, I attempt to change xxxxxxxx5 to xxxxxxxx6, but it fails (after the failure, nextid in oracle still shows xxxxxxxx6).
But, if I attempt to add a new field to the form, that fails.
If I increment nextid to xxxxxxxx7, the new field then saves.
Regardless, archgid fails. I always get the error "...**** Field does not exist on current form (ARERR 314)...", but at the end of the process "...Successful update of data dictionary..."
Fred, I'm using the prompt-driven method on 5.1 archgid.
One thing that just came to mind: I inherited this app, and a peculiarity is that multiple ARS servers (there are 3) are stored as different schemas in Oracle, not different instances. Could that be affecting archgid?
Rick
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
