My thoughts exactly!! -----Original Message----- From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Greg Reese Sent: 07 May 2005 04:20 To: thin@xxxxxxxxxxxxx Subject: [THIN] Re: kb: CTX106440 - Unable To Delete Published Applications From the Data Store so much for "Don't ever direcly modify the datastore" Greg On 5/7/05, Jim Kenzig Kenzig.com <jkenzig@xxxxxxxxx> wrote: > CTX106440 - Unable To Delete Published Applications From the Data > Store > > > This document was published at: > http://support.citrix.com/kb/entry.jspa?externalID=CTX106440 > > > > Document ID: CTX106440, Created on: May 6, 2005, Updated: May 6, 2005 > > Products: Citrix MetaFrame XP 1.0 for Microsoft Windows 2000, Citrix > MetaFrame XP 1.0 for Microsoft Windows 2003 > > > > > Symptoms > > After a MetaFrame Presentation Server 3.0 or later server is added to > an existing MetaFrame XP farm and then removed, the following symptoms > are > experienced: > > > â Unable to delete published applications from the MetaFrame data store. > > â No error is returned when trying to delete the published application. > > â Modifications to the published application are successful. > > Resolution > > To resolve this issue, use the following steps. > > Note: Consult your DBA before making any modifications to the tables > in the database. > > 1. Open the SQL Enterprise Manager and select the MetaFrame Data store > database. > > 2. Expand the database and select tables. > > 3. In the right pane, select the KEYTABLE item. > > 4. Right-click KEYTABLE and then select DESIGN TABLE. > > 5. Click the TRIGGERS icon on the toolbar (mouse over the icons to > display the name). > > 6. In the TRIGGERS properties dialog box, select the drop down tab. > > 7. If the trigger OnKeyTableDelete exists, from the bottom of the > properties dialog box, select the trigger and click DELETE. (One may > disable the trigger. Use the discretion of the Database > Administrator.) > > 8. It prompts you for verification, select yes and click OK to exit > the dialog box. > > 9. Attempt to delete the published application. > > Note: You may need to recreate the Local Host Cache before you are > able to delete the published applications.* > > > > NÂYÃÂÂ*hÅÃ+NÂ>ÂÂÂiâÃ0jÃÂâÂÃy8^ÂÃ/zÂ"ÂzkÅ{DÅÂ{ÂÂÅÃRHÂÂrÂÂÂ*'jw\zÂb~'ÂÃÅ ÂâÃÃâÃiÃÃ0ÃÃbÅÅÃÅÃ(âK~ÃSâ)Ãâ'ÂÂ*&ÂÃbÅÃÅKÂÃÂj)ZnWÅÂmÂÃÃâ)ÃzÃÃÅy,qÃââ)ÃÅH ÅÂiÂÅ+râW BIÃÂrÅÂÂÃâ+bzÃmÂÅÃà -â)ÃÅHÅÂah Ãâ+ÃÂÃÅÃâÂÃÃmÃÂnÃ+âÂÂÂÃÂ(ÂÃ+UÂÂ*'Åâ^ÂÃÂâÃÃâÅ%Åy!ÂÃÃÃbÅwÂÃÃÂÂ,eÅÃ\