Salesforce

Enhancement Request: IDXCHECK should continue scanning index after recid out of sequence error.

« Go Back

Information

 
TitleEnhancement Request: IDXCHECK should continue scanning index after recid out of sequence error.
URL NameEnhancement-Request-IDXCHECK-should-continue-scanning-index-after-recid-out-of-sequence-error
Article Number000187810
EnvironmentProduct: OpenEdge
Version: 10.2B, 11.x, 12.x
OS: All supported platforms
Question/Problem Description
Index corruption detected in database.
Corruption revolves around index block pointers pointing to the wrong next/previous index block.
proutil <dbname> -C idxcheck loops endlessly
proutil <dbname> -C idxcheck skips recids
 
Steps to Reproduce
Clarifying Information
Error MessageIDXCHECK: (8781) SYSTEM ERROR: Index 20 (PUB.customer, name): key <686429><0><1><CUSTOMER NAME> recid 88600108 is out of sequence.
Defect Number
Enhancement Number
Cause
Resolution
An enhancement has been requested.

Index Block point sequence corruption breaks the idxcheck utility by causing it to either loop indefinitely if the recid sequence corruption is pointing backwards to a previously scanned recid, or will cause it to skip past recids completely if pointed forward towards the end of the index.  This error prevents the utility from ever being able to complete the scan all the way through the index.  This issue has been fixed for most cases in that IDXCHECK will skip over them and start processing the next index so that one can find out which indexes need to be rebuilt without exhausting the IDXCHECK error limit on the same index: Index corruption causes IDXCHECK to loop on the 8781 error  

It was determined that the Progress Product is functioning as designed.

An enhancement request has been submitted as an Idea on the Progress Community. To promote the Idea, click on this link: https://openedge.ideas.aha.io/ideas/OPENEDGE-I-512. Customer feedback is valuable and Idea submissions are monitored by our Product Management team. Enhancement requests are reviewed during the planning phase of each new product release and a list of the enhancements chosen for implementation can be found in the Release Notes documents that accompany each release. Once an Idea is submitted the Progress Software Community will have the opportunity to comment on and vote for the Idea. It's priority will be evaluated as customer demand weighs in through Article Feedback and through vote count in the Ideas Portal

For detailed information on how to submit an Idea, please refer to Knowledge Base article How to submit an enhancement request for a Progress product?.
 
Workaround
Notes
Keyword Phrase
Last Modified Date9/27/2021 9:08 AM

Powered by