Kbase P125741: 10.1B Index rebuild fails with an error 11476 Unable to open sort file
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/07/2008 |
|
Status: Verified
SYMPTOM(s):
Index rebuild fails with an error 11476 Unable to open sort file in directory
Unable to open sort file in directory scgaXXXXX, errno is 13. (11476)
Unable to open sort file in directory sbpaXXXXX, errno is 2. (11476)
idxbuild does not fail consistently
FileMon shows _dbutil is trying to open a temp sort file which has been previously closed
FileMon shows _dbutil failing to create a temp sort file
Disabling Antivirus on the machine does not resolve the issue
Enough space on all discs
No user directory restrictions
FACT(s) (Environment):
OpenEdge 10.1B02
OpenEdge 10.1B0201
OpenEdge 10.1B0106
Windows
CAUSE:
If a Windows API returns an error, the program will retry it. With threading enabled, some of these functions were failing to initiate the retry so that the program can continue after retrying. This is a Windows issue which we suspect is caused by the way Windows creates the temp files.
CAUSE:
Bug# OE00157245
FIX:
Upgrade to OpenEdge 10.1C where this issue has been addressed by replacing functions with Window specific APIs.
If using the -T definition in the index build, specify the fully qualified path.
If Upgrading is not possible, the following workaround's are suggested:
1.) Place temporary files in different directory from where the database resides using -T specifying the full path to the directory.
2.) Disable threading on idxbuild with -thread 0 parameter:
$ proutil dbname -C idxbuild -thread 0 [+ parameters]