Hi Georgi, first I would not do a change like this in a production system. I would try it in dev environment, but only after getting the feedback from BMC Support. If you cannot get a knowledgeable tech support guy, escalate until you get somebody that knows this well
The other table that you need to take a look at is arreference, that links the application with the forms. take a look at it. Still even if you are able to figure out all this, I would not try it first in a production system, I would try it in a cloned system that you can mess up and blow-away at will. Also, when you try whatever fix BMC Support gives you, before you make any change to production, make sure you have a reliable database backup. Guillaume ________________________________ From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Remedy-Administrator (ISI) [remedy-administra...@idealstandard.com] Sent: Friday, March 30, 2012 8:49 AM To: arslist@ARSLIST.ORG Subject: Application not accessible through BMC Remedy Administrator ** Hi Folks, Hope someone can help me in this issue. First I want to inform you that we are on a very old release. Our env. is: AR-Server: 7.0.01 patch 2 OS: HP-UX B.11.11 DB: Oracle 10.2.0.5.0 64bit MidTier: Version 7.0.01 Patch 002 200703132023 OS: Windows 2003 Server Now to describe the issue. Since 2 weeks we’ve got a couple timeout errors in Midtier. After enabling SQL/API logs we have found that the problem should be in one of our applications. But when I try to open the application in BMC Remedy Administrator it says “Application does not exists”. If I try to right click on it (to delete it), Remedy Administrator closes automatically. So it seems that I need to remove it on DB level but have not enough knowledge about DB structure. There are all custom applications. No ITSM. I have found the name of the application in table “arcontainer” but I am not sure if I delete the record from there will not destroy the DB consistency. Unfortunately I have no test environment where I can try this. We are only with a production one and need to be very careful in all these changes. Thanks in advance for everyone spending a time for me. Kind Regards, Georgi Paunov Remedy Administration Tel.: +359 675 30200 E-mail: Remedy-Administrator<mailto:remedy-administra...@idealstandard.com>@IdealStandard.com<mailto:n...@idealstandard.com> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
