Are there any Entry ID's that are NULL???? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of arthurj Sent: Monday, June 25, 2007 1:32 PM To: arslist@ARSLIST.ORG Subject: Re: View Form
Yup, checked that too. The only index on that table at the Oracle level is the Primary Key Index on Entry_ID column. Kaiser Norm E CIV USAF 96 CS/SCCE wrote: > > I assume you've checked with the Oracle DBA (if that's not you) to see > if there are indexes on Oracle table itself? > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of arthurj > Sent: Monday, June 25, 2007 12:23 PM > To: arslist@ARSLIST.ORG > Subject: View Form > > I have a view form that looks at an Oracle table. This table has an Oracle > unique index on ENTRY_ID column. When an escalation runs thru the records in > this view form and sets the value of a column named TABLENAME_STATUS, for > every record, I seem to get the following error: > > Filter operation in escalation failed, errno=382 > On looking at the errror it seems to complain of violating a unique index. > But I don't have a unique index other than the Entry_ID column. > > Can someone help with this error? > > Thanks No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.9.7/868 - Release Date: 6/25/2007 12:20 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"