Thanks so much Joe. We just exported the form and imported it again and everything is working, so you were on the money when you said that something was corrupted.
Thanks again! Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe DeSouza Sent: Wednesday, March 25, 2009 10:56 AM To: [email protected] Subject: Re: View Forms ** Lisa, Delselect the primary key again from the view form definition, and choose an alternate one.. save the form, then remove that alternate one, and readd the original primary key and then save the form.. There might be some sort of a corruption in the data dictionary maybe because you might have altered the structure of the original table, causing the ARS to loose its definition.. Thats my wild wild assumption but its not gonna hurt you to try since your view form is already hurting you in its current state.. It can't get worse if you try my suggestion.. Cheers Joe ________________________________ From: "Kemes, Lisa" <[email protected]> To: [email protected] Sent: Wednesday, March 25, 2009 10:48:52 AM Subject: View Forms ** We are suddenly getting the error when we do a query on our view form: ARERR [482] This View Form contains Request IDs that are null. Ensure that the key field is set to a non-null, unique column to avoid data corruption We checked the table and there are no fields that are null and the field has no dupes (therefore is unique). Anything else we might need to check? This was working just fine a couple of days ago and has been working flawlessly for years. ARS 7.0 P5 Windows Server 2003 Oracle 10i Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [email protected] __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
