data_engine probe cannot be started
search cancel

data_engine probe cannot be started

book

Article ID: 111934

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM) CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

The data_engine probe has lost its port and pid and cannot be started (red status).

Depending on the case, you can see similar lines to the ones below logged in "data_engine.log" file (at loglevel 5):

Scenario 1: "password" parameter is either missing or blank:

Aug 20 12:04:40:214 [10408] 3 de: [BasicCredentials::ReadConfiguration] Reading configuration from data_engine.cfg setup
Aug 20 12:04:40:214 [10408] 2 de:    provider=xxxxx
Aug 20 12:04:40:214 [10408] 2 de:    server=xxxxxxxxx,xxxx
Aug 20 12:04:40:214 [10408] 2 de:    database=<UIM_Database_name>
Aug 20 12:04:40:214 [10408] 2 de:    user=xxxxx
Aug 20 12:04:40:214 [10408] 2 de:    parameters=xxxxx
Aug 20 12:04:40:214 [10408] 2 de:    servicename=
Aug 20 12:04:40:214 [10408] 2 de:    port=xxxxx
Aug 20 12:04:40:214 [10408] 1 de: Connection Interface OK - ADO Version: 6.3
Aug 20 12:04:40:214 [10408] 1 de: Recordset Interface OK
Aug 20 12:04:40:214 [10408] 1 de: Command Interface OK
Aug 20 12:04:40:231 [10408] 0 de: [main] Open - 1 errors
Aug 20 12:04:40:231 [10408] 0 de: (1) Open [Microsoft OLE DB Provider for SQL Server] Login failed for user 'xxxxx'.

Aug 20 12:04:40:231 [10408] 0 de: COM Error [0x80040e4d] IDispatch error #3149 - [Microsoft OLE DB Provider for SQL Server] Login failed for user 'xxxxx'.
Aug 20 12:04:40:231 [10408] 1 de: Database script - processing 3 database scripts
Aug 20 12:04:40:231 [10408] 1 de: Database script - Module: [ NIS_BASE            ], File: [scripts\sqlserver_nis_base_create.sql], run check: [yes], run script: [ no]
Aug 20 12:04:40:231 [10408] 0 de: COM Error [0x800a0e7d] Unknown error 0x800A0E7D - [ADODB.Recordset] The connection cannot be used to perform this operation. It is either closed or invalid in this context.
Aug 20 12:04:40:231 [10408] 0 de: COM Error [0x800a0e7d] Unknown error 0x800A0E7D - [ADODB.Recordset] The connection cannot be used to perform this operation. It is either closed or invalid in this context.


Scenario 2: "password" parameter is present, but there are some password encryption errors logged:

Aug 21 13:48:20:906 [2956] 3 de: [BasicCredentials::ReadConfiguration] Reading configuration from data_engine.cfg setup 
Aug 21 13:48:20:906 [2956] 2 de: provider=xxxxx
Aug 21 13:48:20:906 [2956] 2 de: server=xxxxxxxx,xxxx 
Aug 21 13:48:20:906 [2956] 2 de: database=xxxxx
Aug 21 13:48:20:906 [2956] 2 de: user=xxxxx
Aug 21 13:48:20:906 [2956] 2 de: password=****** 
Aug 21 13:48:20:906 [2956] 0 de: (nimDecrypt) decoding of encrypted string failed. 
Aug 21 13:48:20:906 [2956] 0 de: (NimCryptographerCfgKeyReadEncryptedValue) failed to decrypt value. RC=1 
Aug 21 13:48:20:906 [2956] 0 de: Did not receive a valid connection string from data_engine (using cached: yes) 
Aug 21 13:48:20:906 [2956] 2 de: parameters=Network Library=dbmssocn;Language=us_english
Aug 21 13:48:20:907 [2956] 1 de: Connection Interface OK - ADO Version: 6.3 
Aug 21 13:48:20:907 [2956] 1 de: Recordset Interface OK 
Aug 21 13:48:20:907 [2956] 1 de: Command Interface OK 
Aug 21 13:48:20:944 [2956] 0 de: [main] Open - 1 errors 
Aug 21 13:48:20:944 [2956] 0 de: (1) Open [Microsoft OLE DB Provider for SQL Server] Login failed for user 'xxxxx'
Aug 21 13:48:20:944 [2956] 0 de: COM Error [0x80040e4d] IDispatch error #3149 - [Microsoft OLE DB Provider for SQL Server] Login failed for user 'xxxxx'. 
Aug 21 13:48:20:944 [2956] 1 de: Database script - processing 3 database scripts 
Aug 21 13:48:20:944 [2956] 1 de: Database script - Module: [ NIS_BASE ], File: [scripts\sqlserver_nis_base_create.sql], run check: [yes], run script: [ no] 
Aug 21 13:48:20:945 [2956] 0 de: COM Error [0x800a0e7d] Unknown error 0x800A0E7D - [ADODB.Recordset] The connection cannot be used to perform this operation. It is either closed or invalid in this context.

Environment

  • UIM 8.5.x or higher
  • data_engine
     

Cause

  • This problem can be caused if data_engine.cfg file was corrupted or incorrect due to manual editing.

Resolution

There are 3 possible solutions available:

  1. Try to open the probe configuration using IM or AC consoles and reconfigure the password:

  2. Restore the data_engine.cfg file from a working backup.

  3. If you have a lab/test environment, you can set the password in another UIM environment and then copy the password encryption string from the .cfg file from that environment.

If the problem persists after executing these actions, please contact Broadcom Support.

Additional Information

Other possible errors in the data_engine.log:

de: (NimCryptographerCfgKeyReadEncryptedValue) failed to decrypt value. RC=3

and/or

0 de: data_engine [main] [main] - Open - Error: [main] thread_id: 400525, error: Open: Access denied for user 'userid'@'<IP address>' (using password: NO) (errno:1045)
0 de: Unable to connect to database. so exiting

 

If all else fails, alternatively you can try the following to force the re-encryption of the database password:

  1. Open the Infrastructure Manager
  2. Deactivate the data_engine probe
  3. Open the configuration (double-click on the data_engine probe)
  4. Wait until the 'timeout' occurs and then click on Ignore to get to the configuration
  5. Enter the new password in the Database tab
  6. Confirm that the password gets encrypted by checking the data_engine.cfg in Raw configure mode
  7. Activate the data_engine probe
  8. Restart the robot so that all other probes use the new connection string

Note: many data_engine failures are a result of a failure in the environment (e.g. network/database).  For a guide to identifying these issues please see this guide.

Powered by Wolken Software