This page handles the case when you are getting large number of false violations for Quality rules referring to the Sort or Search on non-indexed Fields. The Quality rules are the following:

• Avoid BusComp using Sort specifications on non-indexed Fields
• Avoid PickList using Sort specifications on non-indexed Fields
• Avoid Link using Sort specifications on non-indexed Fields
• Avoid BusComp using Search specifications on non-indexed Fields
• Avoid PickList using Search specifications on non-indexed Fields
• Avoid Link using Search specifications on non-indexed Fields
• Avoid Applet using Search specifications on non-indexed Fields

Step by Step scenario

1. Take a full snapshot
2. Open CED
3. Observe large number of false violations for Quality rules referring to the Sort or Search on non-indexed Fields

Action Plan

1. If you are using the Siebel extraction 5.0.x or 5.1.x (x lower then 2). then this is a known bug in the Siebel extraction 5.0.x and 5.1.x. This bug occurs due to missing links between Siebel table columns and index created on those columns -
   
   • • If you are using Siebel extraction 5.0.x, then please install the following script Fix_QualityRules_5.0.x.sql on your local base (Project and Vanilla) and run a snapshot on project by skipping analysis.
     • If you are using Siebel extraction 5.1.x, then please install the following script Fix_QualityRules_5.1.x.sql on your local base(Project and Vanilla) and run a snapshot on project by skipping analysis.
2. Else if you are using a higher version of Siebel 5.1.x x> 2 then please contact CAST Technical Support with the following Relevant input.

Ticket # 8645