I know! Maybe BMC has been taking lessons from Microsoft on cryptic troubleshooting and mind reading.
Kim Phone - 410-222-5254 Fax - 410-222-5611 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Tuesday, February 05, 2013 2:17 PM To: [email protected] Subject: Re: FIXED - RE: Error on View form to an External Oracle Table That is a strange way for the application to report that indeed! I guess what its doing is that if the application cannot resolve the given table or view, it assumes it is the Request ID field, and returns that as a generic error, instead of running doing something like a DO CASE, to test several potential cases. The error should have been incorrect structure or definition or something like that. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Olds, Kimberly M Sent: Tuesday, February 05, 2013 12:38 PM To: [email protected] Subject: FIXED - RE: Error on View form to an External Oracle Table Thanks for the help. My issue is fixed. >From Support: "However, there have been reports in previous versions of Remedy (6.3), whereby this error is misleading - and that the view form was corrupted. If you enable SQL logging and reproduce the problem - it may show an API call is failing on this View form, and this failure may return the ARERR 482. A solution in the past was to export and then re-import this form." Guess it is still an issue in 7.06.04! LOL Exporting and importing my form fixed it. Thanks again for your help Kim Phone - 410-222-5254 Fax - 410-222-5611 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Tuesday, February 05, 2013 11:41 AM To: [email protected] Subject: Re: Error on View form to an External Oracle Table 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" ________________________________ Please consider the environment before printing this e-mail. ____________________________________________________________________________ ___ 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
