After changing the Nimsoft Watcher Service user on primary hub data_engine won't start
search cancel

After changing the Nimsoft Watcher Service user on primary hub data_engine won't start

book

Article ID: 402470

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

You have updated the primary hub Nimsoft Watcher Service "Log On As" properties from one user to another and after this the data_engine is no longer able to start. 

The log is firing these messages referring to different tables and data_engine is restarting in a loop. 

Jun 26 09:47:59:942 [26256] 0 de: CreateFastLoad - ERROR: Code=0x80004005 Source=Microsoft SQL Server Native Client 11.0 Description=Invalid object name 'RN_QOS_DATA_0547'.Jun 26 09:47:59:937 [26256] 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
Jun 26 12:38:47:876 [24048] 0 de: CreateFastLoad - ERROR: Code=0x80004005 Source=Microsoft SQL Server Native Client 11.0 Description=Invalid object name 'RN_QOS_DATA_0548'.
Jun 26 12:38:47:876 [24048] 0 de: CreateFastLoad - create failed for IID_IRowsetFastLoad
Jun 26 12:38:47:876 [24048] 0 de: QoSInsert::Add_BulkInsertObject - CreateFastLoad failed
Jun 26 12:38:47:876 [24048] 0 de: QoSInsert::InitalizeBulkObjects - failed.  m_definition_map size: 553 ...
Jun 26 12:38:48:211 [24048] 0 de: qos_check - Initialize failed, restart again 
Jun 26 12:38:49:754 [21320] 0 de: qos_data_thread - stop received ...
Jun 26 12:38:53:846 [21320] 0 de: main - waiting for commit threads to terminate
Jun 26 12:38:53:846 [21320] 0 de: main - commit threads terminated
Jun 26 12:38:53:846 [21320] 0 de: main - waiting for bulk thread to terminate
Jun 26 12:38:54:837 [21320] 0 de: main - bulk thread completed
Jun 26 12:38:54:839 [21320] 0 de: ######################## STOP DATA ENGINE #########################

Environment

DX UIM 23.4.*

Cause

When Windows Authentication is used, and the user is updated in both Nimsoft Watcher Service and data_engine the default schema of the new created user on the DB might not be defauling to [dbo]. If the schema is not [dbo] for the user the data_engine starts inserting data in same named tables but in a different schema (Eg. "DOMAIN\newuser" instead of "dbo"). 

If you then modify the default schema for the user to be DBO, the RN/HN/DN tables created under a wrong schema may create these issues. 

Resolution

  • Engage your DBA and backup your Production DX UIM DB Before doing any change
  • Analyze the information_schema.tables and check if there is any mismatch of TABLE_SCHEMA
  • If there are discrepancies and the tables for which there are errors in the data_engine have a TABLE_SCHEMA different from DBO, alter the schema and set it to DBO.
  • Open a Case with Broadcom support if any assistance is required. 

Additional Information

Powered by Wolken Software