000021849 - How to delete single corrupt record from RSA ACE/Server database

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000021849
Applies ToRSA Authentication Manager 6.0
RSA ACE/Server 5.x
Microsoft Windows 2000 SP4
IssueHow to delete single corrupt record from RSA ACE/Server database
Error: "Field 24 from cursModifyToken-A record (recid -31126) was missing from FIELDS phrase (3782) when dumping database" in RSA ACE/Server and Authentication Manager
ResolutionTo correct this issue, perform the following steps:

1. On the ACE/Server, log in as administrator who has full rights on the ACE/Server database

2. Stop the ACE/Server services from Start Menu --> Control Panel --> ACE/Server icon

3. Open the command prompt and browse to the bin directory of ACE/Server

    C:\>cd C:\ace\rdbms32\bin

4. Run the following command:

    C:\ace\rdbms32\bin>_proutil C:\ace\data\sdserv -C idxfix

Index Fix Utility

a. Scan records for missing index entries

b. Scan indexes for invalid index entries

c. Both 1 and 2 above

d. Cross-reference check of multiple indexes for a table

e. Build indexes from existing indexes

f. Delete one record and it's index entries

g. Quit

Enter selection:

6

Type the recid to delete.

31126 (this has to be the id you receive in error message when dumping the DB which can be different)

Is this correct? (y/n)
y

Record 31126 has been deleted from the database. (5190)

Index fix completed successfully.

    C:\ace\rdbms32\bin>

5. Run the dump utility from Start Menu --> Programs --> RSA ACE/Server --> Database Utilities --> Dump

6. The dump should be created without errors (if you get the the error with different recid number then repeat steps 4 to 5 
Legacy Article IDa25362

Attachments

    Outcomes