I have had two web app installations now where sometime after installation users were not able to login. Users see the message “The user name or password provided is incorrect.” This occurs even when the user name and password are correct. Behind the scenes, the service log file contains “SQLDBException… 16302… InsertSessionRecord…”
Upon investigation the system database installation script seems to have skipped the part where it adds some new columns to the WebServiceAccess table. An XEvent Profiler session revealed the stored procedure WebServiceAccess_Cleanup failed because the column “UserRecID” was missing from the table. Running WebApps2.01_Sys.sql again added that and some other columns, resolving the issue.
This is strange for two reasons. First, because the stored procedure is defined after the table definition changed in the script, and it ran without an error during the initial installation. Second, because it was possible to login during installation, but that changed later when users started trying to test the system. It’s as if the table definition reverted back without the new version of the stored procedure changing.
Hopefully this will help jog my memory the next time this happens, and may be helpful to someone else as well.