[cisco-voip] RTMT DB error - resolved

[Wes Sisk]

SQL authenticaiton is disabled in the SQL Server configuraiton for 4.1.  
Everything we do uses windows authentication now (connect to SQL using 
windows credentials)  For CM 4.0 and 4.1 the replicaiton is slightly 
changed in that all tables in the database ARE NOT repliacated.  For 
those versions, I strongly recommend using the latest version of 
DBLHelper to recreate SQL replication.  Unicast me for a copy.

/Wes

Mike Armstrong wrote:

> 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
>>>>>>>>>>>