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 Install the Identity Router Virtual Appliance for VMware Number of Views How to add a second SNMP Security Name (Trap User) in RSA Authentication Manager 8.x 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
Trending Articles
Connection fails to Cloud Authentication Service when connecting through a proxy server from RSA Authentication Manager to… Downloading RSA Authentication Manager license files or RSA Software token seed records Unable to login to RSA Authentication Manager Security Console as super admin RSA Authentication Manager 8.9 Release Notes (January 2026) How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device
Don't see what you're looking for?
