Salesforce

Return Code shows success when rolling forward partial ai file

« Go Back

Information

 
TitleReturn Code shows success when rolling forward partial ai file
URL NameP26329
Article Number000146878
EnvironmentProduct: Progress
Version: 8.x, 9.x
Product: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Question/Problem Description
Rolling forward AI files via a script fails with errors indicating that a file cannot be roll forwarded.
Receive 1028 errors when starting the database
Receive 1028 errors when rolling forward AI files against a database
Steps to Reproduce
Clarifying Information
Return codes for previous RFUTIL roll forward commands return success.
Error MessageSYSTEM ERROR: Physical redo, BKUPDCTR=<number>, note updctr=<number>. (1028)
SYSTEM ERROR: Physical redo, BKUPDCTR=21481, note updctr=21558. (1028)
area , dbkey , record type (8999)
area 15, dbkey 1380768, record type 43 (8999)
SYSTEM ERROR: Roll forward of file <filename> did not complete normally (1046)
SYSTEM ERROR: End of last note read is at file offset (1048)
Incomplete ai file detected, expected <blocks>, got <blocks>.
Subsequent roll forwards will fail unless this situation is resolved.
See extended help on this error for further information. (9333)
Defect NumberEnhancement OE00090159 / PSC00141349
Enhancement Number
Cause
RFUTIL Return Code shows success (0) when rolling forward a partial ai file. The Return code is correct because the RFUTIL process did roll forward all transactions found in the partial AI file.
Resolution
Validate that the AI file was successfully archived prior to emptying AI file for reuse.

Enhancement Request OE00090159 / PSC00141349 was implemented in OpenEdge 10.0A that changes the return code to values other than 0 or 2 to indicate that the file is a partial AI file. This allows DBAs to identify probable backup / archive problems when rolling forward offending AI file, rather than waiting for subsequent roll forward processes to experience failures.

Return Code 0 is successful and any other non zero value means an error which are not published.
The value of the return code can indicate an open error or the number of errors discovered in the section of a note it is processing, which are passed to Progress messages. 
Instead the database lg file should be parsed to understand the reason for roll forward failure.
Workaround
Notes
Keyword Phrase
Last Modified Date3/20/2017 3:44 PM

Powered by