Classification: UNCLASSIFIED Caveats: NONE Hello all, I promised to tell you the outcome of this.
The problem was that a corrupted View form (actually a View form without an underlying SQL table) caused the Admin Tool to not allow our server to connect properly. With the help of Remedy Technical Support we deleted this View form using SQL and the Admin Tool came back. The SQL looks like the following: ----------------------------------- I've seen this before and sometimes it is the field count that causes the error. Theoretically, you could fix the problem by correcting the field count: select schemaId from arschema where name LIKE 'XXX:abc xyz' use the schemaId number to replace the "x's" in the rest of this... select numfields from arschema where schemaId = xxx select count(*) from field where schemaId = xxx if the output of count(*) doesn't match the output from numfields, change numfields to match the count: update arschema set numfields = nnn(the count) where schemaId = xxx Once this is done, you will need to restart the arsystem server (regardless of how you change the database directly you will need to restart the server so that it can recache the new definitions... the problem will not be resolved until after a restart). We then deleted the form when the Admin Tool came back up. -------------------------------- Thanks for everyone's help Gordon M. Frank Lockheed Martin -----Original Message----- From: Frank, Gordon M Mr NISO/Lockheed Martin Sent: Thursday, January 25, 2007 8:44 AM To: [email protected] Cc: Frank, Gordon M Mr NISO/Lockheed Martin Subject: RE: RE : Re: Admin Tool will not show an ARS Server (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Yes we were using Remedy Migrator to move several objects to another server. One of those objects was corrupted. We believe we can get rid of the object and reboot all should be well (in theory). Why this would corrupt the Admin Tool into not being able to see the entire server is a Remedy Tech Support issue (which I have opened). I will try to let everyone know the outcome of this when we resolve it. Thanks Gordon Frank Lockheed Martin -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frex Popo Sent: Thursday, January 25, 2007 7:55 AM To: [email protected] Subject: RE : Re: Admin Tool will not show an ARS Server ** have you imported some workflow to this server recently .. I was having a similar issue in the past when some of the workflow (I guess it was probably flashborad) which was imported with a different hard coded sever name. Are you using Demo to connect to the Admin tool or some other user with Admin rights? Did you say you were having problems modifying worklfow? what errors are you getting? How about the error log does it show any errors? Rick Cook <[EMAIL PROTECTED]> a écrit : ** I wonder if it is an issue with your licenses, or perhaps with the MAC address of the server, which would affect licenses. No fixed license, no Admin access. Has Support looked at that? Rick ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gordon M. Frank Sent: Thursday, January 25, 2007 2:16 AM To: [email protected] Subject: Admin Tool will not show an ARS Server ** Hello, We have a problem with seeing an ARS Server through the Admin Tool. The server can be accessed using the User Tool and via the Mid-Tier, so the data is accessible and users don't see a thing. We just can't make object modifications because the server comes up as if there is a connectivity issue. Other servers come up fine. We are installed on a SunOS/Unix box with Oracle 9i and ARS 6.3. We tried restarting the ARS Server and this made the server reappear. But we tried to make a modification to a field and the problem reoccurred. We have noticed that the CPU is running at 50% when it normally runs around 15 - 30%. We also have been running Remedy Migrator quite a bit lately and I am wondering if this is connected. Remedy Technical Support has not come up with a solution yet, so I am trying the ARSLIST to see if anybody has seen this before? Any help is appreciated Thanks up front, Gordon M. Frank Lockheed Martin __20060125_______________________This posting was submitted with HTML in it___ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.410 / Virus Database: 268.17.8/649 - Release Date: 1/23/2007 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.410 / Virus Database: 268.17.8/649 - Release Date: 1/23/2007 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ ________________________________ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses <http://fr.rd.yahoo.com/evt=42054/*http://fr.answers.yahoo.com> . __20060125_______________________This posting was submitted with HTML in it___ Classification: UNCLASSIFIED Caveats: NONE Classification: UNCLASSIFIED Caveats: NONE _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
