I just upgraded my database from version 3.1 to 3.2.
When I assign work orders to myself, I don't see them in my "Assigned to current user" list.
What's wrong?
This comes from a bug in the upgrade procedure.
Due to an oversight, the upgrade procedure creates incorrect Contacts Table records for existing users.
This bug will be fixed in the next release of the software.
In the meantime, you can correct erroneous contact records as described below.
-
On a computer with access to the MainBoss database, login to an account with SQL Server Administrator permissions.
-
Start SQL Server Management Studio.
Connect to the instance of SQL Server that manages the MainBoss database.
-
In the left-hand part of the Management Studio window, expand the entry for Databases.
-
In the list of databases, click the entry for the MainBoss database.
-
In the Management Studio control bar, click New Query.
-
Management Studio opens a window where you can enter SQL commands. In this window, enter the following exactly as shown:
UPDATE Contact Set UserID = dbo.mbfn_Contact_Userid(Id)
(Just copy the above lines from this web page and paste them into the Management Studio window.)
-
In the Management Studio control bar, click Execute.
-
Management Studio should report that a number of rows have been affected. Quit Management Studio.
Executing this once corrects all the erroneous contact records.
Back to FAQ index
|
