Summary

After migrating a repository, Workflow Distribution Manager does not finish loading. It may stop responding while displaying "User Integrity."

More Information

Repository migration may erroneously create an invalid user ID in the WorkUsers table.

This issue will not occur when migrating a repository using the Laserfiche 6 to 7 Migration wizard provided with Laserfiche 7.1.1. If you are already experiencing this issue, please see the resolution provided below.

Resolution

This issue can be resolved by removing the invalid user ID from the WorkUsers table using either Enterprise Manager or osql.

To remove an invalid user ID using Enterprise Manager

1. Open Enterprise Manager.
2. Expand the appropriate SQL Server group.
3. Expand the appropriate SQL Server.
4. Expand the Databases item.
5. Expand the database associated with the Laserfiche repository.
6. Select Tables.
7. Select the WorkUsers table.
8. From the Action menu, point to Open Table, and then select Return All Rows.
9. The UserID column in the first row of the table will be set to 0. Select the entire first row and then press Delete. Click Yes to confirm the deletion of the first row.
10. Restart the computer.

To remove an invalid user ID using osql

1. From the Start menu, select Run.
2. Type the following and then press ENTER:

   cmd

3. At the command prompt, type the following and then press ENTER:

   osql -E -S SQLInstance -d DatabaseName

   SQLInstance is the name assigned to the desired instance of SQL Server. This term should be replaced by the name of the computer hosting SQL Server. If you are using MSDE (i.e. Laserfiche Server (Team) or Standalone), then you should also append "\Laserfiche" (e.g. Computer\Laserfiche).
   
   DatabaseName is the name of the SQL database associated with a Laserfiche repository. If you are using MSDE (i.e. Laserfiche Server (Team) or Standalone), then it is important that you specify the main SQL database and not one of the expansion databases.
   
   
4. You should see a prompt that looks like this:

   1>

5. Type the following and then press ENTER:

   Delete From WorkUsers where UserID=0;

6. Type the following and then press ENTER:

   GO

7. Restart the computer.