RTMT Profiles Corrupted

From NippAero

RTMT is getting an error message Unable to Restore Configuration, Host Name in the configuration is not in the DB. Hitting a bug CSCsc20357, follow the work around of this bug.

http://tools.cisco.com/Support/BugToolKit/search/getBugDetails.do?method=fetchBugDetails&bugId=CSCsc20357

ORIGINAL

<Config Version="4.0" Name="CM-Default" Desc=""><PortStatusDialogMgr /><MainContent><MonitorFrame   Path="\\View\\Summary\\Summary"><Content Class="JSummaryPanel"><Attributes><PollingInterval Value="30" /><Status Value="RUN" /></Attributes></Content></MonitorFrame></MainContent></Config>

VERSION FROM TAC

<Config Version="4.0" Name="CM-Default" Desc="Number of registered phones and gateway status. "><PortStatusDialogMgr></PortStatusDialogMgr><MainContent><MonitorFrame Path="\\View\\Device\\Device Search" ><Content Class="JDeviceSearch" ><DeviceMonitorTabPan

Deleting Nipp's Profile

SQL does not like the apostrophe.

This is what the content looked like.

<Config Version="4.0" Name="Nipp&apos;s" Desc=""><PortStatusDialogMgr></PortStatusDialogMgr><MainContent><MonitorFrame Path="\\View\\Summary\\Summary" ><Content Class="JSummaryPanel" ><Attributes><Status Value="RUN" /></Attributes></Content></MonitorFrame>

I fixed it by running the two SQL commands below and then deleting it from the profile. I took out the apostrophe first ion SQL.

update scratch set content='<Config Version="4.0" Name="Nipps" Desc=""><PortStatusDialogMgr></PortStatusDialogMgr><MainContent><MonitorFrame Path="\\View\\Summary\\Summary" ><Content Class="JSummaryPanel" ><Attributes><Status Value="RUN" /></Attributes></Content></MonitorFrame>' where pkid = 'B06C129E-83CB-4CE3-9453-5B422E080A8B'

update scratch set Name='AppletCatalog=Nipps' where pkid = 'B06C129E-83CB-4CE3-9453-5B422E080A8B'