Kbase P10316: Error code returned from fdfnd. (1410) shows evidence of database corruption
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/6/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
WebSpeed 3.1x
SYMPTOM(s):
Error 1410 occurs when performing a query
Error 1410 generated when running WebSpeed against a specific database
Error code <number> returned from fdfnd. (1410)
Error code -4281960 returned from fdfnd. (1410)
Error code -20011 returned from fnfnd (1410)
Error code -1220 returned from fdfnd. (1410)
Error occurred on specific tables.
CAUSE:
Index level or record level corruption exists on the tables queried caused by duplicate records on a unique index or index corruption exists.
FIX:
1. Determine if index corruption exists in the database or against the table(s) used in the query. Use one of the below utilities to scan the indexes:
To use Idxcheck the database must be shutdown. Idxfix can be run while the database is online.
Idxcheck command syntax: proutil dbname -C idxcheck
Idxfix command syntax: proutil dbname -C idxfix
It may be more desirable to scan only the indexes associated with the table(s) that are encountering the problem. If the index names associated with a table are not known " proutil dbname -C Idxanalys " will output all the indexes associated with all the tables in a database. This information is also displayed in the Data Dictionary tool on Windows.
If the output of the idxfix or idxcheck reports duplicate entries perform one of the following options:
1. Dump and Reload the affected table.
1. Backup the database.
2. Dump the tables definition and data from Data Administration.
3. Delete the table from Data Dictionary.
4. Reload the table.
5. Rerun the idxfix or idxcheck to ensure the problem has been removed.
2. Use idxfix to remove each duplicate entry listed in the idxfix or idxcheck utility. See Solution ID: 12760 for further information.
2. If the corruption does not exist at the index level run the dbrpr tool to determine if there is corruption at the database record and block level. See Solution ID 2077 for information on the dbrpr tool.