If you resort to option 3 pointed out by David do not forget to commit after you have deleted the required form and its references.. Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia.
----- Original Message ---- From: David Sanders <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, March 6, 2007 9:22:09 AM Subject: Re: how to delete an locked form So that's how Remedy reacts to missing database tables. Not nice. From this point you have 3 or 4 options, none of them nice. 1) Restore the database to a backup either before you manually deleted the tables, or before you imported the locked form. 2) Manually recreate the Txxx (and Hxxx if you deleted that too) table in the database with the same table number and structure. You do not need to worry about the rebuilding the view. If you can do either of these, you can then delete the form in the admin tool. 3) Start deleting records from the Remedy data dictionary tables. You could really mess up your system if you do this wrong. There will be an entry in the arschema table for your form which will give the table number. Then linked to this will be entries in many of the other data dictionary forms for each field, enum values, binary attachments, etc., all linked to the arschema record by the schemaId. In theory you could manually delete all these entries, but I don't recommend it. If at all possible, use options 1 or 2. David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour Sent: Tuesday, March 06, 2007 2:08 PM To: [email protected] Subject: Re: how to delete an locked form well the interesting part is that I manually deleted the tables and the view, but the form still shows up and when I want to delete the form the ARAdmin tool says: Message not in catalog -- message number = 2 (ARERR 2). Failure during SQL operation to the database : <myform> (ARERR 552). Any other help ? PS: and only my form has been locked nothing else ____________________________________________________________________________________ Sucker-punch spam with award-winning protection. Try the free Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/features_spam.html _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
