Thank you very much Guillaume,
I was able to re-create the application with another name (good luck there was a def file exported a while ago) and re-point all links to it. So for the moment we will not touch the database as we seem to get rid of timeouts. Thanks again for your time and advice. 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> ________________________________ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Guillaume Rheault Sent: Friday, March 30, 2012 6:02 PM To: arslist@ARSLIST.ORG Subject: Re: Application not accessible through BMC Remedy Administrator 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"_ _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"