Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

Sporadic 1046 and 1048 errors when rolling forward the next available After Image file from a pool of transferred AI files.

Last AI extent fails with errors 1046 and 1048

File offset shown within error 1048 does not match the original AI Extent size.

SYSTEM ERROR: Roll forward of file <filename> did not complete normally (1046)

SYSTEM ERROR: End of last note read is at file offset <offset> (1048)

FACT(s) (Environment):

Rolling forward all available After Image (AI) extents
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
OpenEdge Database Category: Maintenance

CAUSE:

The ai file being applied to the HOT spare was not complete.

This can happen when scripts periodically apply the ai files to the HOT SPARE without checking that the file transfer has completed before applying the file to the HOT SPARE.

The amount of time it takes to transfer the ai file can vary for a number of reasons such as load on the network, size of the file being transferred and settings on the nick card. In this case the settings on the Nic card had been changed causing the time to transfer the files across the network to increase.

ie: Some Nic cards have a setting for Speed and Duplex mode which when set to an incorrect setting can slow down the transfer of files across the network. When the Speed and Duplex setting was set to 1 the file transfer from time to time was not complete prior to the script applying the AI file to the HOT SPARE. Changing the setting to 0 corrected the problem for now.

Example,
set to 1 = 10 Mbps speed, half-duplex operation
set to 0 = Auto ( picks to best setting for the card and network )


FIX:

Do not start the roll forward until the file transfer has completed.

This is expected behavior if the AI file transfer has not completed prior to applying the AI file to the HOT SPARE.