Truncating Table Routing Rules

Server Upgrade RuleSets Conflict

For Administrators planning an upgrade

Issue:

Significant enhancements were made to RuleSets in the Server upgrade v5.1.1. The following RuleSets issues have been reported after a Server upgrade.

• Empty rulesets, rules no longer exist
• Disabled rulesets are enabled
• Deleted rulesets reappear
• Rules moved to different rulesets
• Action items missing from rules

During the upgrade there is a conflict between the previous and current RuleSets tables and  migrations that result in the issues listed above.

Note: Backup your server and database and consult the HP CR Server and Clients Upgrade Guide before upgrading.

Tip/Solution: Truncate Table RoutingRules

See the table below before using the Truncate Table Routing Rules resolution.

Upgrade Scenario	Truncate
Server upgrade from v1.5.1 to v1.7.x	Truncating is required.
Server upgrade from v1.7.x to v1.7.x; for example, v1.7.0 to v1.7.1	Truncating is required.

HP CR recommends that you complete the following procedure before you upgrade.

1. Open Microsoft SQL Server Management Studio and connect to the SQL server hosting the HP CRDatabase.
2. Click New Query on the toolbar.
3. On the toolbar, change the database name on the drop-down list from Master to the HP CRServer’s Core Database.
4. Type the following query into the query window: Truncate Table RoutingRules.
5. Click Execute on the toolbar.  Command(s) completed successfully message appears.

Contact Customer Support if you have any questions or require further assistance.