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 Upland AccuRoute 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 v5.1.1 to v6.x	Truncating is required.
Server upgrade from v6.x to v6.x; for example, v6.0 to v6.2	Truncating is required.

Upland AccuRoute 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 Upland AccuRoute Database.
2. Click New Query on the toolbar.
3. On the toolbar, change the database name on the drop-down list from Master to the Upland AccuRoute Server’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 Technical Support if you have any questions or require further assistance.