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 Configuring a Checkpoint firewall to work with SecurID Number of Views Migration to RSA Authentication Manager 8.1 with the option to retain system settings fails with an error about duplicate … Number of Views Running out of disk space when using RMAN in RSA Identity Governance & Lifecycle Number of Views How to add a second SNMP Security Name (Trap User) in RSA Authentication Manager 8.x Number of Views
Trending Articles
How to factory reset an RSA Authentication Manager 8.x hardware appliance without a factory reset button from the Operatio… RSA Authentication Manager 8.9 Release Notes (January 2026) Microsoft Office 365 - SAML Relying Party Configuration - RSA Ready Implementation Guide RSA Release Notes for RSA Authentication Manager 8.8 RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
