Problem:

Release 4.0:

After rebuilding a file with duplicate keys the run time error 9/077 appeared when deleting the duplicate.

Resolution:

It is related to the large number of duplicate key values (20354) in alternate key 1 in that case.

It is falling foul of some incorrect error checking in the filehandler whilst processing a delete operation (which in the end is causing the file to be corrupted). This code was corrected as the result of rpi no: 1053279 which is fixed in Micro Focus Studio 5.

Workaround:

In this case the problem can also be worked around by increasing the nodesize of the file to 4K using rebuild (ie create an extfh.cfg with NODESIZE=4096 and rebuild the file). This will increase the number of alternate keys that can be held in a node so that the total number of nodes needed to store the maximum number of alternate keys (65535) cannot trigger the incorrect error checking code.

With the file containing the duplicates it does and the nodesize set as it is, unfortunately unless some action is taken this is something that is going to be hit repeatedly.