[cisco-voip] RTMT DB error - resolved

[Mike Armstrong]

Problem went away following upgrade to OS 2000.2.7SR2 and 4.1(2)SR1.  There 
may have been a SQL problem that wasn't obvious during normal operations. 
During the 4.1(2)SR1 upgrade, the install failed on the first attempt:

11:33:28: Critical Error - Replication is in a failure status.  Current
Reported Status is: At least one agent-implementing job has failed to
execute successfully

I deleted the Subscriber subscription and recreated it, following the [new?] 
rules presented by the SQL Enterprise Manager.  Then SR1 liked it,

11:47:29: Pre-Upgrade Database Check Successful*****

and the SR1 installation ran to completion.  Enterprise Manager complained 
about 2 things when I recreated the subscription:

1) It wouldn't allow sa authentication (our (upgraded from 3.3) Publisher
used sa), so I switched to Microsoft.
2) Both the Publisher and Subscriber referred to themselves as (local) in
the SQL Enterprise Manager, but when I tried to re-establish the 
subscription
and replication, the Enterprise Manager insisted that the servers' names be 
used.

Comments welcome...

mike

>>>
>>> Mike Armstrong wrote:
>>>
>>>> Should have mentioned this earlier -- works OK.  I can run perfmon on 
>>>> the Pub and monitor both Pub and Sub counters.
>>>>
>>>> mike
>>>>
>>>> ----- Original Message ----- From: "Wes Sisk" <wsisk at cisco.com>
>>>> To: "Mike Armstrong" <mfa at crec.ifas.ufl.edu>
>>>> Cc: <cisco-voip at puck.nether.net>
>>>> Sent: Wednesday, March 16, 2005 5:07 PM
>>>> Subject: Re: [cisco-voip] RTMT DB error
>>>>
>>>>
>>>>> Can you bounce Remote Registry on the offending subscriber and then 
>>>>> check? It provides access to the counters.
>>>>>
>>>>> To verify - run perfmon on the pub.
>>>>> add counter
>>>>> point to the sub
>>>>> then try to add cpu.
>>>>>
>>>>>
>>>>> /Wes
>>>>>
>>>>> Mike Armstrong wrote:
>>>>>
>>>>>> Nope.  If I use the Windows Performance Monitor and select the 
>>>>>> RegisteredHardwarePhones counter in the Cisco CallManager performance 
>>>>>> object, I get the correct number of phones registered; similarly, 
>>>>>> %CPU, Memory, and Calls Active show reasonable values.  RTMT shows 
>>>>>> 100% memory, 0% CPU, 0 phones registered, and 0 calls in progress. 
>>>>>> Remote Registry and Cisco RIS Data Collector services are showing as 
>>>>>> Automatic, Started.
>>>>>>
>>>>>> mike
>>>>>> ----- Original Message ----- From: "Wes Sisk" <wsisk at cisco.com>
>>>>>> To: "Mike Armstrong" <mfa at crec.ifas.ufl.edu>
>>>>>> Cc: <cisco-voip at puck.nether.net>
>>>>>> Sent: Wednesday, March 16, 2005 3:15 PM
>>>>>> Subject: Re: [cisco-voip] RTMT DB error
>>>>>>
>>>>>>
>>>>>>> Seen this happen before when:
>>>>>>>
>>>>>>> The Process performance object has become disabled in the system, 
>>>>>>> and did not show up in
>>>>>>> Perfmon. After following the fix in Microsoft KB article 248993, 
>>>>>>> restarting the Remote
>>>>>>> Registry service, and restarting Cisco RIS Data Collector service, 
>>>>>>> the information showed
>>>>>>> up as expected in RTMT.
>>>>>>>
>>>>>>> /Wes
>>>>>>>
>>>>>>> Mike Armstrong wrote:
>>>>>>>
>>>>>>>> Tried that.  Now I no longer get the DB error message, but...  Data 
>>>>>>>> for the Publisher (addressed by IP) seems reasonable, but the 
>>>>>>>> Subscriber (addressed by name) shows 0 registered phones (should be 
>>>>>>>> over 200), 100% memory, 0% CPU, 0 calls in progress.  I get the 
>>>>>>>> same result no matter how I start RTMT -- via Publisher name or IP, 
>>>>>>>> or Subscriber name or IP.
>>>>>>>>
>>>>>>>> mike
>>>>>>>>
>>>>>>>> ----- Original Message ----- From: "Wes Sisk" <wsisk at cisco.com>
>>>>>>>> To: "Mike Armstrong" <mfa at crec.ifas.ufl.edu>
>>>>>>>> Cc: <cisco-voip at puck.nether.net>
>>>>>>>> Sent: Wednesday, March 16, 2005 9:00 AM
>>>>>>>> Subject: Re: [cisco-voip] RTMT DB error
>>>>>>>>
>>>>>>>>
>>>>>>>>> Mike,
>>>>>>>>>
>>>>>>>>> This used to happen when a CM server was removed from the cluster. 
>>>>>>>>> We had to delete the default profile in RTMT, close out, and let 
>>>>>>>>> it re-populate. Same applies when a CM subscriber IP changed.
>>>>>>>>>
>>>>>>>>> /Wes
>>>>>>>>>
>>>>>>>>> Mike Armstrong wrote:
>>>>>>>>>
>>>>>>>>>> RTMT does not appear to be able to find my Subscriber.  When RTMT 
>>>>>>>>>> starts, it displays an error: "Unable to restore configuration! 
>>>>>>>>>> Host name in the configuration is not defined in DB!".  I assume 
>>>>>>>>>> the host name it's talking about is the Subscriber, since it 
>>>>>>>>>> reports essentially nothing relative to the Subscriber, but what 
>>>>>>>>>> "DB" are they talking about?  The Subscriber is defined in the 
>>>>>>>>>> CallManager Publisher database, and I can't find any 
>>>>>>>>>> RTMT-specific database anywhere.  CCM 4.1(2).
>>>>>>>>>>
>>>>>>>>>> Mike Armstrong
>>>>>>>>>> UF/IFAS CREC
>>>>>>>>>> Lake Alfred, FL
>>>>>>>>>> _______________________________________________
>>>>>>>>>> cisco-voip mailing list
>>>>>>>>>> cisco-voip at puck.nether.net
>>>>>>>>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>>>>>>>>>