Information

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

URL Name	IDXFIX-Warnings-issued-2806-not-in-database-lg

Article Number	000149983

Environment	Product: 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 Number	Defect 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 Date	3/4/2020 5:31 PM

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

Information