As long as they are using different logins to Oracle (for the different Schemas) it should be ok but you are correct in that that may be your problem.
Archgid doesn't update the NextID so changing to the next id will cause problems adding fields later. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Sent: Monday, August 07, 2006 9: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
