Running sdcompress; error: 'TRIGGER ERROR'
Originally Published: 2000-08-17
Article Number
Applies To
UNIX (AIX, HP-UX, Solaris)
Issue
Sdcompress is not running to completion
Error: "TRIGGER ERROR"
Compressing database and receiving trigger error
Error: "Unable to load adm role record (-1).TRIGGER ERROR-> TRIGERROR: tar_wrt.p;Inval."
Resolution
1.First you need to stop the ACE/Server and the database broker.
2. Make sure you have taken the usual backup precautions that is, you have a fresh working backup of the ace/data/ directory or a fresh sddump of the database when the ACE/Server is stopped.
On UNIX platforms:
1. From the ...ace/prog/ directory stop the ACE/Server and database brokers with:
./aceserver stop
./sdconnect stop or shutdown
2. If there are remote administration connections to the database, you need to use
./sdconnect shutdown
On NT:
1. Go to the control panel, open the ACE/Server icon, and stop the ACE/Server.
On both UNIX and NT platforms, in a command line window:
2. Move to the ace/rdbms/bin/ directory. From there run the following:
On UNIX:
./proutil ...ace/data/sdserv -C idxbuild all
On NT:
_proutil ...ace\data\sdserv -C idxbuild all
It usually takes a few minutes for this process to complete and at the very end it comes up with a long list of completed tasks.
The administrator should now be able to run sdcompress -s.
Restart the ACE/Server.
Related Articles
Error: 'Node verification failed' and 'Passcode accepted' when using RSA ACE/Agent for Netscape Number of Views Custom user attributes are not available under the table options of the Directories/Applications Account tab in RSA Identi… Number of Views Escalation Workflows randomly fail to trigger in RSA Identity Governance & Lifecycle Number of Views Review escalation workflows sometimes do not trigger in RSA Identity Governance & Lifecycle Number of Views Review escalation workflows do not trigger if review is set to Hold by an escalation workflow after due date in RSA Identi… Number of Views
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Mandatory Certificate Upgrade Required by 6th October 2025 for RSA MFA Agent for PAM, RSA MFA Agent for Apache, and Third … RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
