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:
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:
How to: Delete events from the log table without creating a huge transaction file
Comments