Invalid Credentials error in Operator Console (OC)

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

After the upgrade to UIM 20.3, every attempt to login to the Operator console (OC) fails with this error.

Invalid Credentials

 

Wasp.log shows the following:

ERROR [http-nio-80-exec-5, com.firehunter.ump.auth.NmsAuth] Unable to authenticate user XXXXXX: com.firehunter.ump.exceptions.DataFactoryException: Invalid object name 'CM_COMPANY'.

 

Environment

Release : 20.3

Component : UIM - OPERATOR CONSOLE 20.3

Database: SQLSERVER 2014

Cause

For some reason, there were some tables missing from the backend UIM database:

• CM_COMPANY
• CM_USER
• UMPALARMVIEWERINFO

 

Resolution

Recreate the missing tables copying and pasting the contents of this script into MS SQL Server studio:

Navigate to:

...\Nimsoft\nis\sql\sqlserver_cm_user_company_umpalarmviewerinfo_create.sql