TechKnowledge Content
Issue
I am receiving a table hierarchy inconsistency error on some of my reports. What should I do?
Resolution
Table hierarchy inconsistency errors means that a table relationship is missing. To fix the report, please refer to the following steps.
1. Open RW (tools-customize-report writer)
2. Click on reports and open the report with the Table Hierarchy Error
3. Click on the Tables button to view table relationships
4. Review the main table. All tables after it with a single dash (-) to its left has a table relationship with the main table.
5. To check the table relationship of the main table to the others, select Tables on the toolbar>Tables. Open the main table and click on the relationship button. All tables after it with a single dash (-) to its left in the tables window should be listed here.
6. On the Report table Relationships window of the report, review the next "parent" table. It has table relationships with all tables with two dashes to its left.
7. To check the table relationship of the next parent table, select Tables on the toolbar>Tables. Open the next parent table and click on the relationship button. The tables with the two dashes from before should exist on the Table Relationship window. In most cases, one of the tables does not exist so you have to re-add the table relationship for the Hierarchy Table error to go away.
8. Continue going through these series of steps for each “parent” table. If one of the tables is missing, make sure to read the table through the Table Relationship Window.
*******************************************************************
For Example, in the case of the PA Billing Invoice Format-Invoice Format 1 report, the PA Billing HDR TEMP Project - PA Billing Notes Master table relationship is missing.
* Open RW
* Open the report with the Table Hierarchy Error (PA Billing Invoice Format-Invoice Format 1)
* Click on the Tables button to view table relationships
* The PA Billing Header TEMP table is the main table. All tables after PA Billing Header TEMP with a single dash (-) to its left has a table relationship with PA Billing Header TEMP. In this case the RM Customer MSTR and PA Billing HDR TEMP Project tables.
* To check the table relationship of PA Billing Header TEMP, select Tables on the toolbar>Tables. Open PA_Billing_HDR_TEMP table and click on the relationship button. The RM Customer MSTR and PA Billing HDR TEMP Project tables should exist.
* On the Report table Relationships window of the report, the next "parent" table is the PA Billing HDR TEMP Project. It has table relationships with the tables PA Project Master File, PA Billing Notes Master, PA Billing LINE TEMP Project2 (All tables with two dashes to its left after the PA Billing HDR TEMP Project table).
* To check the table relationship of PA Billing HDR TEMP Project, select Tables on the toolbar>Tables. Open PA_Billing_HDR_TEMP_Project table and click on the relationship button. The tables PA Project Master File, PA Billing Notes Master, PA Billing LINE TEMP Project2 should exist on the Table Relationship window. In this case, the PA Billing Notes Master does not exist so you have to re-add the table relationship for the Hierarchy Table error to go away.
* Click New on the table relationship window. The table relationship definition window opens. Lookup PA Billing Notes Master as the secondary table. Select key number one on the secondary table key. Select Note Index on the primary table key segment (PA Billing HDR TEMP Project). Click OK and close the Table Relationship and Table definition window.
* Go back to the Report table Relationships window of the report, the next "parent" table is the PA Billing LINE TEMP Project2 with PA Billing ITEM TEMP2 under it (tables with 3 dashes to its left under PA Billing LINE TEMP Project2 table). Check the table relationship of PA Billing LINE TEMP Project2 on the table definition window and re-add missing table relationship as necessary.
* Go back to the Report table Relationships window of the report, the next "parent" table is the PA Billing ITEM TEMP2 with PA Cost Category Master File under it (tables with 4 dashes to its left under PA Billing ITEM TEMP2 table). Check the table relationship of PA Billing ITEM TEMP2 on the table definition window and re-add missing table relationship as necessary.
This article was TechKnowledge Document ID: 25300
|
Keywords: |
kbMBSPartner kbMBSMigrate kbRetire BemisKB856203 |
DISCLAIMER
MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE.
THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.
