If you are having an issue logging into Saga Practice Manager at a law office because there are too many users currently using the software this may be due to locked users.
It would be best if you cleared all users from the database by running specific commands from Microsoft SQL Server
First, everyone using Saga Practice Manager needs to save their work and log out
Then you need to go to the computer/server running Microsoft SQL Server Database
Once you open Saga’s Microsoft SQL
Go to Databases
Right Click RLEnterprise
Click on New Query
enter the command below
DECLARE @sourceid varchar(100)
SELECT @sourceid=SOURCE_ID FROM DATASVC_SOURCE WHERE PARENT_ID IS NULL
Right Click Query then Execute
Once you run that command delete it and enter the command Below
SELECT O.PRINCIPLENAME AS ORGUNIT, U.PRINCIPLENAME AS USERNAME, P.NAME AS PRODUCT,
T.* FROM DATASVC_TICKET T
LEFT OUTER JOIN DATASVC_ORGUNIT_USER U ON T.ORGUSER_ID = U.ORGUSER_ID LEFT OUTER JOIN DATASVC_ORGUNIT O ON U.ORGUNIT_ID = O.ORGUNIT_ID LEFT OUTER JOIN DATASVC_SOURCE S ON
T.SOURCE_ID = S.SOURCE_ID LEFT OUTER JOIN DATASVC_PRODUCT P ON S.PRODUCT_ID = P.PRODUCT_ID WHERE T.SOURCE_ID = @sourceid OR S.PARENT_ID = NULL — tracking only PM tickets. to track child modules change to S.PARENT_ID = @sourceid ORDER BY O.PRINCIPLENAME, U.PRINCIPLENAME, T.SOURCE_ID
Right-click query and then Execute
Now all the users will be cleared and everyone can log back in
