An export of the View form and then a import corrected the issue. Dave
________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Gutierrez, Alejandro (HITS) Sent: Wednesday, March 25, 2009 10:53 AM To: arslist@ARSLIST.ORG Subject: Re: View Forms ** Hi Lisa, Have you checked the underlying DB Tables for any changes? This happened to me in the past and the reason was that someone changed the length of the fields on the DB tables. Alex. ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Wednesday, March 25, 2009 8:49 AM To: arslist@ARSLIST.ORG 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 lisa.ke...@tycoelectronics.com __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __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"
