Salesforce

IDXFIX doesn't log Warnings listed in 2806 to database lg file

« Go Back

Information

 
TitleIDXFIX doesn't log Warnings listed in 2806 to database lg file
URL NameIDXFIX-Warnings-issued-2806-not-in-database-lg
Article Number000149983
EnvironmentProduct: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Other: IDXFIX
Question/Problem Description
IDXFIX reports that Warnings were found but no details what these warnings are in the database .lg file
IDXFIX 2806 message lists the number of Warnings found but the details of these Warning messages cannot be found
Steps to Reproduce
Clarifying Information
The Description of the 2806 message is:
 
<num> warnings issued. (2806)
This message lists the number of warnings issued by the index check utility while it was running. The warnings can also be found in the database log file (dbname.lg)
Error Message<num> warnings issued. (2806)
Defect NumberDefect OE00218901 / PSC00242616 / OCTA-2798
Enhancement Number
Cause
The details of the number of Warnings in the 2806 message, should be found in the database log file (dbname.lg) but are only printed to STDOUT.
Resolution
Upgrade to OpenEdge 12.0, where there were changes made to the 2806 message to ensure it is written to the database log file.
Workaround
When running IDXFIX, send the screen output to a file. These errors are listed in the screen output.

Example 1:  Manually run IDXFIX Menu Options with re-direct
$   proutil dbname -C idxfix | tee idxfix.out

Example 2:  Script IDXFIX Menu Options with an input and STDOUT re-direct

1. Create an input file with the IDXFIX input you need

#IDX.in
3
T
4
G
A
G
Y
Y
Y
all
y

Run IDXFIX as follows:
 
$   proutil dbname -C idxfix < idxfix.in >> idxfix.out

The resulting "idxfix.out" file will contain all the messages.
Notes
Keyword Phrase
Last Modified Date3/4/2020 5:31 PM

Powered by