data_engine is not inserting data due to missing RN tables

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Data engine is queued up and data is not inserting to database:

We see the following error in log. 

Mar 27 18:41:32:668 [1628] 1 de: ADO_QoSInsert::InitializeQoSData - 661543 objects took 171 seconds 
Mar 27 18:41:32:668 [1628] 1 de: Creating bulk object - table: RN_QOS_DATA_0310 for qos: QOS_AVAILABILITY_AVAILABILITY 
Mar 27 18:41:32:735 [1628] 0 de: CreateFastLoad - ERROR: Code=0x80004005 Source=Microsoft SQL Server Native Client 11.0 Description=Unspecified error 
Mar 27 18:41:32:735 [1628] 0 de: CreateFastLoad - ERROR: Code=0x80004005 Source=Microsoft SQL Server Native Client 11.0 Description=The metadata could not be determined because every code path results in an error; see previous errors for some of these. 
Mar 27 18:41:32:735 [1628] 0 de: CreateFastLoad - ERROR: Code=0x80004005 Source=Microsoft SQL Server Native Client 11.0 Description=Invalid object name 'RN_QOS_DATA_0310'. 

Environment

• DX UIM 23.4.*
• MS SQL Server 

Cause

Some QOS_DEFINITION is making reference to missing RN tables, which is causing data_engine to being unable to insert data and then restart. 

Resolution

The QOS_DEFINITIONS that make reference to the missing RN Tables must be deleted. 

Contact Broadcom support for assistance. 

 

 

Additional Information

Related KBs:

• After changing the Nimsoft Watcher Service user on primary hub data_engine won't start
• After changing the Nimsoft Watcher Service user on primary hub can't see dashboards in OC