Thanks, Nicky. I ran this query earlier. It does find and return the correct record. But Remedy still can't find it. I have had our dba validate the correct owner of the tables. So that does not appear to be the problem. I am currently reviewing the arerror.log file to see what I can find. We are also opening a ticket to BMC on this issue. Fortunately, this does not affect anyone but us admins so it's not a high priority issue.
Jenni Wacholz 480-445-2517 WFH Tuesdays 602-606-7484 ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Thursday, June 04, 2009 11:09 AM To: arslist@ARSLIST.ORG Subject: Re: Lost form reference ** Jenni, In toad run select * from arschema where schema_id=107; arschema is the top layer where form inforrmation starts, if you dont have a record there, you won't see it. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com ----- Original Message ----- From: Wacholz, Jeanette (Jenni) <mailto:jwach...@cvty.com> Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, June 04, 2009 12:46 PM Subject: Lost form reference ** Hi Listers, ARS V6.3 P020 ITSM 6 Oracle V10g AIX 5.3 We have lost the ability to access one form via the User or the Admin tool. The form is SHRCFG:ConfigPeople. If I look in TOAD, I can see the view of the form. I can also see the t107, h107 and b107 tables there. But the form is not visible or available from inside Remedy. I believe I've seen issues similar to this on the list but I haven't been successful finding them in the archives. The issue began last night after our dba's installed Guardium on the db server. (ARSystem was shutdown correctly before the dba's started their install and brought back up after the install was completed.) Any help you can offer would be appreciated! Jenni Wacholz Coventry Health Care Inc Scottsdale AZ 480-445-2517 Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"