Follow

Error: Failed to load records error message is displayed when trying to view events

Symptom:

When trying to view events for an object, the message "Timeout expired. The timeout period elapsed prior to completion of the operation or server is not responding." is displayed:

2013-10-08_0358_001.png

This could be due to the high number of events present in the Venafi Encryption Director database.

To check the number of events run the below query

MSSQL:

SELECT COUNT(*) FROM log

Oracle:

SELECT COUNT(*) FROM [VED_USERNAME].log;

Replace [VED_USERNAME] by the username used to access the Oracle database

Resolution:

A short term measure is to delete events from the database

(See How to: Delete events from the log table without creating a huge transaction file)

There are way to prevent this to happen:

  • Setting up log expiration - This will permanently delete events older than a set date on a regular basis (See Info: Set Up Log Expiration)
  • Creating a Filter Channel - This will reduce the numbers of events logged as per the define filter (See Director Administration Guide)

 

If log retention is an issue, a second SQL channel where all events are logged can be defined and the above recommendation be used for the day-to-day administration. (See Director Administration Guide)

 

Also See:

Info: Set Up Log Expiration

How to: Delete events from the log table without creating a huge transaction file

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk