ITADB484S DB process X Exceeded user type EPVUser time policy (running Y seconds).

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

PAM Self-Hosted Articles
3 min read
L0 Member
No ratings

Question

What does the following message in the Vault's italog.log indicate?

ITADB484S DB process X Exceeded user type EPVUser time policy (running Y seconds).
 

Answer

ITADB484S is a system code from the Cyber-Ark Database Manager.  This code (ITADB484S) means that there was a request from a user that took longer than expected to execute. There are no actions required unless the system becomes unresponsive, in which case the offending process may be killed by running CAVaultManager TerminateDBTransaction <process id>, where process ID is what was reported by the message.

Steps to Terminate a Transaction:

1.  Make note of the long-running transaction’s unique ID.  For example, the following alert in the italog file refers to a transaction whose unique ID is 67.

ITADB484S DB process 67 Exceeded user type EPVUser time policy (running 6153 seconds).

2. Run from the Vault the 'CAVaultManager.exe TerminateDBTransaction' command. If you do not specify the transaction’s unique ID in the command, you will be prompted for it, as shown below.

CAVaultManager.exe TerminateDBTransaction
Database Transaction ID [mandatory] ==> 67


3. This command will identify the transaction and terminate the transaction, then display the following confirmation:
CAVLT212I Transaction was killed successfully.

How to identify which transaction is hung:
1. Go to the vault installation folder (default 'C:\Program Files (x86)\PrivateArk\Server') and start an Administrator CMD prompt
2. Run the following command to generate a DB report and export it to a text file:
CAVaultmanager.exe DiagnoseDBReport > dbr.txt
3. Open the file dbr.txt in notepad and find the section titled Output for SHOW FULL PROCESSLIST;":

This section will contain a table with transactions ID's, the time they have been running for (in seconds), and their current state.
Locate the transaction that is in "Executing" state and has a large value in the time column. This is most likely the one that needs to be terminated.

Note:
Frequent occurrence of this message may be a symptom of a larger performance problems with the vault. 
 

Q:
What does the following message in the Vault's italog.log indicate?

 
ITADB484S DB process X Exceeded user type EPVUser time policy (running Y seconds).

A:
ITADB484S is a system code from the Cyber-Ark Database Manager.  This code (ITADB484S) means that there was a request from a user that took longer than expected to execute. There are no actions required unless the system becomes unresponsive, in which case the offending process may be killed by running CAVaultManager TerminateDBTransaction <process id>, where process ID is what was reported by the message.

Steps to Terminate a Transaction ::


1.  Make note of the long-running transaction’s unique ID.  For example, the following alert in the italog file refers to a transaction whose unique ID is 67.
"ITADB484S DB process 67 Exceeded user type EPVUser time policy (running 6153 seconds)."

2. Run from the Vault the CAVaultManager.exe TerminateDBTransaction command. If you do not specify the transaction’s unique ID in the command, you will be prompted for it, as shown below.

 
CAVaultManager.exe TerminateDBTransaction Database Transaction ID [mandatory] ==> 67

3. This command will identify the transaction and terminate the transaction, then display the following confirmation:
CAVLT212I Transaction was killed successfully.

Note:
Frequent occurrence of this message may be a symptom of a larger performance problems with the vault. 
Rate this article:
  • 11524 Views
  • 0 comments
  • 0 Likes
Article Dashboard
Version history
Last Updated:
‎08-06-2024 10:26 AM
Updated by: