Fellow ARSListers I have an interesting problem that I would like to get some advice on. I had to do an installation of Approval Server on the second server that is part of a Server Group. The installation went through without any errors, but appears to have screwed up the APW:Approval Central form. The installation reloaded several fields that had been previously deleted as this form was customized to our current environment. Normally, I would just re-delete these fields since all the other fields were untouched, but this is where the problem comes in.
In Remedy User (v 6.03), the form loads with both customized and newly added fields displaying. There are 27 errant fields in total. In Remedy Admin (v 6.03), these errant fields do not show up, and I cannot locate any reference to them in any view. As far as Remedy Admin is concerned, these 27 fields do not appear to exist. I did an export of the form, and confirmed that these errant fields do not show up in the DEF file. Based on a conversation and recommendation from Remedy Support, I deleted all fields from the Approval Central form that I could see in Remedy Admin. I then went into the SQL database (Microsoft SQL Server), and deleted references in the field and related field tables pointing to the errant fields for this Approval Central form. When I open the form in Remedy Admin, the Display-Only form has no fields within. When I open the form in Remedy User, all the 27 errant fields display without any problem. According to the SQL database, there are no fields associated to this schema under the field table. In an attempt to start from scratch, I tried to delete the APW:Approval Central form and workflow so I could just re-import from a backup DEF file that I have. During the deletion process I got error message "8804 Specified container does not exist." When I attempted to re-import the form and workflow with the replace objects option checked, I received the same error message. When I went back to look at the form in Remedy Admin, I could only find 3 Active Link objects related to the form. When I checked the SQL database, I showed 39 Active Link objects related to the form. Rather than make this problem worse, I figured it would be best to stop and get a second opinion from the Remedy Community rather than speaking with Remedy Support again. I would appreciate any advice anyone can provide on this issue. Thank you for your time. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
