Fred is on the right track here.. For a simple sanity check, to ensure that the field you are mapping to the Request ID is indeed a unique character field: 1) Check its data type and ensure its varchar (varchar2 gets rejected) 2) Do a select count(*) on the table or view and then a select distinct count(field mapped to Request ID) on that table or view. Both should match. If the distinct count returns a lower value, you have a problem.
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Tuesday, February 05, 2013 11:35 AM To: [email protected] Subject: Re: Error on View form to an External Oracle Table The error simply states that the field you have mapped the Request ID to has some records with NULL in it. Did you map the Request ID to an integer or a character field? Turn on SQL logging to see exactly which field ARS thinks has NULL Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Olds, Kimberly M Sent: Tuesday, February 05, 2013 10:11 AM To: [email protected] Subject: Error on View form to an External Oracle Table ** Hello! I am hoping someone can provide some guidance for me to give my DBA. Environment - Oracle 11g Windows 2008 Server AR System version - 7.6.04 SP3 I am getting the following error on a view form that worked yesterday. "ARERR [482] This View Form contains empty Request IDs. Ensure that the key field is set to an unique non-blank field to avoid data corruption." My view form connects to our HR Data warehouse. The Data warehouse went down yesterday afternoon and now I get that error when i try to search on data that is valid. The DB is up and if I open my view form - I can add fields to it and save it so the link is good. I also could make a new view form to the same oracle table and it works great. I can search without the error. We have checked and there is not a blank record or an entry with a blank field ID 1 in the DB table behind the form. This form populates an employee dialog form and I have a lot of workflow tied to it so I really want to keep this form. I have logged a support issue - but I am hoping someone here can help! Thanks in advance! Kim Olds Senior User Support Specialist AACPS Help Desk Phone - 410-222-5254 Fax - 410-222-5611 ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
