When attempting to rotate the Database Passwords through OnBase Configuration an error occurs

When attempting to rotate the Database Passwords through OnBase Configuration an error occurs

Description

When attempting to rotate the Database Passwords through OnBase Configuration an error occurs about accessing the database.

Database Error encountered:
Native Error: 208 (0x000000d0)
SQL State: [S0002]
SQL Error: [[Microsoft][SQL Server Native Client 10.0][SQL Server][Invalid object name 'hsi.csp_AddDMUser'.]
SQL: [alter procedure hsi.csp_AddDMUser @username varchar(100) with encryption as
             DECLARE @SQLSTRING NVARCHAR (200)
             SET @SQLSTRING = N'create login ['| @username + N'] with password = ' ', check)policy=OFF, default_database = [ONBASE_DEV]'
             EXEC(@SQLSTRING)]
                Source File: [ ]
                Line Number:    11307
                Function Call: [M_pStatement->SQLExecDirect((SQLTCHAR*)szSQL,SQL_NTS)]
                Software Build [18.0.0.37]

Resolution

Removing the csp.AddDMUser Stored Procedure and having it be recreated by Configuration resolved the issue. The csp_AddDMUser stored procedure exists in SQL Server databases. The stored procedure is called when a workstation accesses OnBase for the first time. The stored procedure creates a SQL Server login with the name of that workstation (e.g. WKST12345), makes it a member of the public server role, maps the login to the OnBase database and makes it a member of the clientgp and public database roles. Once this login exists for the workstation, the workstation uses that login to authenticate to SQL Server when accessing OnBase. This procedure is initially created when an OnBase system is created. If the procedure is deleted at any time, it will be recreated by the software automatically (and it will be created by the RecreateDBUsers.exe if it does not exist).