InvalidTrackerView and InvalidCbQL
 |
For a general, step-by-step guide on using the corrector module, see Using the Data Inconsistency Corrector Module.
|
|
|
In DICM versions 2.0, 2.1, and 2.2, this correction is called InvalidView and corrects tracker views only. In DICM 2.3 and later, it is renamed to InvalidCbQL and corrects more types of Codebeamer items.
|
Description
This correction fixes errors that cause certain Codebeamer items to fail to load. Codebeamer items can sometimes fail to load if the description of the Codebeamer item includes invalid queries. For example, this can happen if the Codebeamer items in the query have been deleted, which causes the query to become invalid. This correction finds records with invalid queries and deletes those records.
The following Codebeamer item types are affected:
• Tracker views—Corrected by deleting invalid ArtifactType.VIEW records.
• Reference views—Corrected by deleting invalid ArtifactType.REFERENCE_VIEW records.
• Simple reports—Corrected by deleting invalid ArtifactType.CBQL_QUERY records.
• Traceability reports—Corrected by deleting invalid ArtifactType.TRACEABILITY_REPORT records.
• Test coverage presets—Corrected by deleting invalid ArtifactType.COVERAGE_PRESET records.
Clicking Detect finds records with invalid queries.
Clicking Restore deletes the detected records with invalid queries.
Report Table
The report table for the InvalidTrackerView correction is named INVALID_VIEW_CORRECTION_REPORT.
The report table for the InvalidCbQL correction is named INVALID_CBQL_CORRECTION_REPORT.
The report table for this correction contains the following information:
|
Column
|
Description
|
|---|---|
|
id
|
The ID number for the detected issue.
Detected issues are numbered, starting at 1.
|
|
project_id
|
The ID of the project that contains the Codebeamer item where the issue was detected.
This field can be empty depending on the type of the Codebeamer item where the issue was detected.
|
|
project_name
|
The name of the project that contains the Codebeamer item where the issue was detected.
This field can be empty depending on the type of the Codebeamer item where the issue was detected.
|
|
tracker_id
|
The ID of the tracker that contains the Codebeamer item where the issue was detected.
This field can be empty depending on the type of the Codebeamer item where the issue was detected.
|
|
tracker_name
|
The name of the tracker that contains the Codebeamer item where the issue was detected.
This field can be empty depending on the type of the Codebeamer item where the issue was detected.
|
|
artifact_name
|
The name of the Codebeamer item where the issue was detected. For example, this is the name of the tracker view where invalid queries were detected.
|
|
artifact_type_id
|
The type ID of the Codebeamer item where the issue was detected. This is an integer code associated with the type of Codebeamer item. For example, the type ID of tracker views is 47.
|
|
artifact_type_name
|
The type of the Codebeamer item where the issue was detected. For example, tracker view or reference view.
|
|
invalid_queries
|
A list of the invalid queries detected by this correction.
|
|
flag
|
The flagged status of the issue, which can be 0 or 1. Clicking Restore corrects issues with a flagged status of 1.
For more information, see Flagging and Processing Inconsistencies.
|
|
processed
|
The processed status of the issue, which can be 0 or 1.
For more information, see Flagging and Processing Inconsistencies.
|