cancel
Showing results for 
Search instead for 
Did you mean: 

Failed to get GMT offset Errors in WVLOG on a CRA server

Failed to get GMT offset Errors in WVLOG on a CRA server

In the WVLOG of a Prognosis server that has Call REcording Assurance (CRA) configured you may see many instances of the following error:

2020-05-10 03:24:20 F-05542057 SQL9Inst 00571 IRMSSQL  11.7.0       003952 - Unknown error.                                                                         CSQLInstance::RefreshDataBaseList(00000043CF609CB0:V15L-WHDB01) Failed to get GMT offset

 

Cause of this error:
The < irmssql user> does not have enough privilege to execute the following SQL statement:
select NodeName from sys.dm_os_cluster_nodes with (nolock)

(The < irmssql user> is the user that is configured in the Prognosis Passwords configuration which is used to make the SQL connection and run the queries)

To test to see if this is the problem:

  1. Log on with MS SQL Server management Studio using the credentials for the <irmssql user>
  2. Run the following query:

select NodeName from sys.dm_os_cluster_nodes with (nolock)

 

To Resolve:

  1. Login into MSSQL from MS SQL Management studio with enough privilege, then execute the following SQL statement:

 

GRANT VIEW SERVER STATE TO <user login name for irmssql>

Tags (3)
Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar
Top Liked Members