Using the Repair Tree Program

Use the Repair Tree page (RUN_TREE_UTILITIES) to audit, troubleshoot, or repair problem trees.

Note: Use the Repair Tree Application Engine program to audit and repair trees. You can also use the Tree Auditor Application Engine program to audit trees.

Navigation:

Access the Repair Tree page by selecting Tree Manager > Tree Utilities > Repair Trees.

Optionally, access the batch audit function by selecting Tree Manager > Tree Auditor.

Field or Control	Description
Report Manager	Click the link to access the report manager inquiry page.
Process Monitor	Click the link to access the process manager inquiry page. Note: If any trees are skipped while running any repair or audit programs due to an existing checkout, you see a status of Warning after the repair or audit program has completed. When this occurs, you should check the log to determine which trees have been skipped, and then rerun the appropriate program after the checked-out trees have been released. See Viewing the Process List.
Run	Click to run a Process Scheduler request.
Tree Utility Type	Note: Typically, you would run the audits first, and then select a repair program as indicated by the audit results. Select a tree utility from the following options: Tree Audits: Audits a selected tree or subset of trees. Correct Level Numbers: Ensures level numbers are correct. Reset node numbers are equal to the parent node's level number plus one. Correct Parent Node Numbers: Ensures parent node numbers are correct in the tree node table. Delete Orphan Tree Objects: Ensures there are no orphan nodes or levels. When running this repair program and specifying a tree, the program only deletes orphan nodes and leaves, not orphan levels. When running the program for all trees, this program deletes orphan nodes and leaves, and then deletes orphan levels. This is because orphan levels are not tied to a specific tree. Orphans can be the result of the following three situations: The parent node that the orphan leaf refers to no longer exists. These orphans are removed when running this program either for a specific tree or all trees. The tree name that the orphan leaf refers to no longer exists. These orphans are removed only when running this program for all trees. The Query Access Group record no longer exists in PSRECDEFN. These orphans are removed when running this program either for a specific tree or all trees. Remove Tree Branches: Removes all branches from the selected tree. Remove Tree Reservations: Cancels all current checkouts. This utility is helpful because if you try to audit or repair any trees that are currently reserved, the audit or repair utility will skip the reserved trees. For this reason, you can use this utility before running any audit or repair tree utility to ensure that the audits or repairs are performed on every tree. Also use this utility during emergency situations. Note: PeopleSoft recommends you use this utility judiciously. When you run this utility, all unsaved changes of users currently editing trees will be lost. Reset Tree Node Gaps: Re-gaps a tree, so that intervals between tree nodes and their node numbers are evenly distributed. Consider running this program if you start to get messages that nodes can no longer be inserted into a tree. Note: The SQR program PTUGAPTR is also available for re-gaps. PTUGAPPTR.SQR is an interactive SQR program which prompts for user inputs and can only run interactively from a Windows client. Update Tree Table Statistics: Calls the databases Update Statistics utility on the PeopleSoft Tree Manager tables. This program can be run whenever large changes have been made to trees or a large tree is imported or deleted from the database. Report Only: Select to run a report to view results prior to updating the tree. Not available for all utilities.
Audit Scope	Available options are: Single Tree: Select to run the selected utility for a single tree. Not all utilities can be run for single trees. Multiple Trees: Select to run the selected utility for multiple trees. Fields in the Tree Definition group box become unavailable. Not all utilities can be run for multiple trees.
Tree Definition	Available options are: Tree Name: Select a tree to audit or repair. SetId,Business Unit, or Tree Key Value: Select the setID, business unit, or tree key value for the specified tree. The field is not available if the selected tree does not have a setID, business unit, or tree key value.
Date Selection	Available options are: Effective Date of Tree: You can select an effective date to run the audit on a single instance of the tree. As of Current Date: Select to audit trees which have the most recent effective date. If you select Single Tree in the Audit Scope group box and select a specific tree, only the instance of the tree with the most recent effective date will be audited. If you select the Multiple Trees option in the Audit Scope group box, all trees whose effective dates are current will be audited. This option is only available for the Tree Audits utility. As of Specific Date: Select to enter a specific date. If you select the Single Tree option in the Audit Scope group box and select a specific tree, only the instance of the tree whose effective date matches the specified date will be audited. If you select the Multiple Trees option in the Audit Scope group box, all trees whose effective dates match the specified date will be audited. This option is only available for the Tree Audits utility. All Trees: Select to audit all trees. If you select the Single Tree option in the Audit Scope group box and select a specific tree, all instances of this tree will be audited, regardless of effective dates. If you select the Multiple Trees option in the Audit Scope group box, all instances of all trees will be audited. When you select Multiple Trees, fields in the Tree Definition group box become unavailable. This option is only available for the Tree Audits utility.
View Results	Click the link to open a new browser instance that displays the Batch Report page. Enter a run control ID to view the results from running audits or a utility program.

Audits Performed

The following table lists the types of audits performed from the Repair Tree program. These audits differ from those performed on the Tree Definition and Properties page.

Audit Type	Checks For	Purpose
Detail Values	Orphan tree leaves.	Lists detail values that refer to an invalid tree node number.
Detail Values	Detail values not found in the tree.	Lists any detail values that are found in application table but are not defined in the tree. This audit is only performed if the All Detail Values option on the tree’s Definition and Properties page is selected.
Detail Values	Duplicate detail values.	Lists any detail values that are defined more than once in the tree. This audit is only performed if the Allow Duplicate Detail Values option on the Definition and Properties page of tree is cleared.
Detail Values	Detail values with overlapping ranges.	Lists detail values that are defined as a range of values that overlap another detail value’s range of values. This audit is only performed if the Allow Duplicate Detail Values option on the tree’s Definition and Properties page is cleared.
Detail Values	Nodes with no child nodes or detail values specified.	Lists any nodes that do not have any detail values or child nodes defined. This audit is performed for detail value trees only.
Node Audit	Nodes without a parent.	Lists tree nodes that refer to an invalid tree node number.
Node Audit	Tree node numbers that are greater than end numbers.	Lists tree nodes with end numbers greater than the node number.
Node Audit	Tree node end numbers that are greater than the end number of parent.	Lists tree nodes with end numbers greater than the parent node's end number.
Node Audit	Tree nodes with overlapping ranges.	Lists tree nodes whose node number and ending node number overlaps with another range of node numbers. Note: When this occurs the tree is corrupted.
Node Audit	Node level numbers that are less than the parent node’s level number.	Lists any tree node with level numbers less than the level number of parent.
Structure Audit	A level record name in the Tree Structure table that does not exist in Record Definition table.	Lists tree structures that reference an invalid record name for the tree level application data.
Structure Audit	A node record name in the Tree Structure table that does not exist in Record Definition table.	Lists tree structures that reference an invalid record name for the tree node application data.
Structure Audit	A detail record name in the Tree Structure table that does not exist in Record Definition table.	Lists tree structures that reference an invalid record name for the tree detail values application data.
Structure Audit	A missing tree structure record.	Lists any trees that refer to a tree structure that is not found in the Tree Structure table.