Consultor Eletrônico



Kbase P15227: Can't role forward the 11th AI file using 9.1C on SUN Solaris.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   16/10/2008
Status: Unverified

FACT(s) (Environment):

Sun Solaris SPARC
Progress 9.1C

SYMPTOM(s):

Can't role forward the 11th AI file.

Can't roll forward an empty after-image extent file. (3780)

After-image dates for this after-image file: (1633)

Last AIMAGE BEGIN <date/time> (1640)

Last AIMAGE BEGIN Wed Dec 31 19:00:00 1969 (1640)

This file was last opened for output on <date/time>. (1643)

This file was last opened for output on Wed Dec 31 19:00:00 1969. (1643)

<number> notes were processed. (1634)

0 notes were processed. (1634)

in-flight transactions. (3785)

0 in-flight transactions. (3785)

<number> transactions were started. (1635)

0 transactions were started. (1635)

At the end of the .ai file, <number> transactions were still active. (1636)

At the end of the .ai file, 0 transactions were still active. (1636)

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

SYSTEM ERROR: Roll forward of file /db5/aifiles/fastmarc.a11.2002-12-03.022908
did not complete normally (1046)

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

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

CAUSE:

Progress bug# 20010821-051.

CAUSE:

The problem occurred based on the following sequence of steps:

1) An online PROBKUP was completed and a new AI extent was started, number 11.
2) A second online PROBKUP was performed a short time later and the 11th AI
extent was closed and a new one was started, number 12.

There was no activity on the database between the two PROBKUP sessions.

FIX:

1) Recover from backup again, and start the roll forward process again up to a
specific time prior to the corrupt AI file.
2) Upgrade to 9.1D to avoid this problem in the future.