Kbase P11083: PROUTIL -C IDXFIX Option 6 errors when Storage Area Name is entered
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/5/2007 |
|
Status: Verified
SYMPTOM(s):
PROUTIL -C IDXFIX Option 6 errors when Storage Area Name is entered
SYSTEM ERROR: Could not lock the record with recid <recid>. (5188)
Record <recid> has been deleted from the database. (5190)
SYSTEM ERROR: The specified area 0 does not exist. (9873)
CAUSE:
When running idxfix (6) = Delete one record and it's index entries
At the prompt "Type the area for the recid(s)"
The Area NAME is entered instead of the instead of AREA NUMBER which results in the above error messages and the recid is NOT deleted despite confirmation messages to the contrary.
FIX:
Enter the Area NUMBER not the Area NAME at the idxfix prompt.
To find the related Area NUMBER:
Method 1:
FOR EACH _area WHERE _area._area-num > 5 NO-LOCK:
DISPLAY _area._area-name _area._area-num EXP(2,_area._area-recbits).
END.
Method 2:
$ PROUTIL [ dbname ] -C tabanalys > tab.txt
Find the Storage Area that houses the table in question
Reference the Storage Area number in the header section
For example, the "Feedback" table in the sports2000 database is in Storage Area 12:
RECORD BLOCK SUMMARY FOR AREA "Misc" : 12
-----------------------------------------
Table
PUB.Feedback 8 1.0K 10