Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

Green

UCCE 7.5(9) with SQL 2005 - Field Notice 63371 - you need ES9

Upgraded a big system on Saturday Oct 23. Field notice came out the previous day but I did not see it, so the bug gave me fits today.

Any config change, or getting the script lock, would cause the AW to bounce the UpdateAW process and rebuild the AW DB.

04:56:40 dis-uaw Trace: [client: scripted(upcc)] Trace: Update of central database succeeded, Message: ,  LastUpdateKey: 577441390227 

04:56:40 dis-uaw Trace: Starting incremental copy operation.

04:56:40 dis-uaw Trace: Recovery keys: 577441390219.0 (in memory), 577441390219.0 (local AWControl), 577441390227.0 (router AWControl).

04:56:40 dis-uaw Trace: Recovery keys: 577441390219.0 (in memory), 577441390219.0 (local AWControl), 577441390227.0 (router AWControl).

04:56:40 dis-uaw Trace: Central log was truncated. Must initialize local database.

04:56:41 dis-uaw Initializing Event Management System (EMS) Library.

Regards,
Geoff

2 REPLIES
New Member

Re: UCCE 7.5(9) with SQL 2005 - Field Notice 63371 - you need ES

We ran into this as well on 7.2(7).  Had to apply ES139 on all of our AWs.  I believe it was caused by one of Microsoft's recent security fixes but Cisco was still narrowing down which one was the cause.

Green

Re: UCCE 7.5(9) with SQL 2005 - Field Notice 63371 - you need ES

I see - the field notice does mention ICM 7.2(7)ES139.

Multiple occurrences of this issue have been observed since October 14, 2010 and on all Unified ICM/CCE releases. This is not a regression defect. The issue occurs when a Microsoft SQL Server query operation is performed to compare the 'lastUpdateKeys' on AW and Central Controller/Logger, during the incremental copying of configuration changes to the local AW. In addition, using the ICMDBA tool to backup and restore the database with "Truncate Config Message Log" option checked can lead to a similar issue that causes the ICM/CCE Router to reject configuration updates. No UpdateAW restart is observed in this situation.

I mistakenly thought it was caused by the SQL upgrade from 2000 to 2005.

By the way, regarding defect CSCtj65060, I NEVER check that "Truncate Config Message Log" option when exporting the config.

Regards,

Geoff

715
Views
0
Helpful
2
Replies