Return
-
Title
Blocking (Current) Dashboard Error SQL Server -
Description
The blocking (current) dashboard displays normally when there are no blockings, but displays an error when there is blocking.
A message similar to the following appears in the FMS log.
DBWC_ERROR: Error in getBlockingSessions: RemoteException occurred in server thread; nested exception is:com.quest.qsi.fason.framework.connections.common.exceptions.JDBCServerException: Failed to run BLOCKING_LIST collection. Failed to execute query on instance [INSTANCE_NAME], user account [.]. Reason : [[Foglight][SQLServer JDBC Driver][SQLServer]Error converting data type nvarchar to float. -
Cause
Datatype conversion error -
Resolution
WORKAROUND
None
STATUS
This issue has been logged as defect FOM-75 and has been fixed in the 5.9.7.10 and higher releases of the SQL Server cartridges.
-
Defect ID
FOM-75