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. And see here for current known issues.

New Member

Purge problem Logger

Hi

One of my loggers has stopped purging some of the tables in particular the TCD and RCD tables. looking at the history I find the following error.

"

RegOpenKeyEx() returned error 2, 'The system cannot find the file specified.'

Msg 22001, Level 1, State 1

(0 row(s) affected)"

Any ideas?

Victor

2 REPLIES

Purge problem Logger

Where there any reacent changes to the logger?  Seems like it might be an issue with SQL.  Can you log in locally and bring up MS SQL and run a simple query?

david

New Member

Purge problem Logger

Hello David

Thanks for the reply. These loggers are separated by a WAN connection that went down simultaneosly fro both public and private networks. Initially I tried sincronising the loggers using ICMDBA but for some reason with no success so I hado to copy the LoggerA database and restore on the LoggerB side. What was causing the problem with the purge is that the stored procedure in SQL was pointing to LoggerA registry setting. Modifying it to LoggerB solved the problem. Curiously only some of the tables were not being purged while others were.

Thanks all the same.

Victor

359
Views
0
Helpful
2
Replies
CreatePlease login to create content