UIM Data Engine Error

book

Article ID: 143017

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

The data engine probe has max restarts and fails to get a port.Have tried to activate /deactivate probe, validate probe and restart probe but still fails.

Cause

Can see the below error messages in data_engine logs

Jan 13 14:01:30:535 [11544] 0 de: data_engine [main] [main] - Oracle_Database::OCIPrep [main] data_engine [main] status: -2 
Jan 13 14:01:30:535 [11544] 0 de: check_output - Output Parameters returned from SP....size: 0 
Jan 13 14:01:30:535 [11544] 3 de: Oracle_Database::OpenDB OCIEnvNlsCreate init status query to ms_pEnvhp=000000DE9C963560... 
Jan 13 14:01:30:535 [11544] 1 de: Oracle Env Session Lock LOCK 
Jan 13 14:01:30:535 [11544] 1 de: Session pool already initialized. Not initializing again. 
Jan 13 14:01:30:535 [11544] 1 de: Oracle Env Session Lock UNLOCK 
Jan 13 14:01:30:535 [11544] 3 de: OCIWrapper::allocateOCIErrorHandle OCIHandleAlloc errhp... 
Jan 13 14:01:30:535 [11544] 3 de: Oracle_Database::OpenDB (SET) OCIAttrSet OCI_ATTR_USERNAME: apmuim ... 
Jan 13 14:01:30:535 [11544] 2 de: Oracle_Database::OpenDB (RETURN) OCIAttrSet OCI_ATTR_USERNAME: xxxxxx STATUS = 0 
Jan 13 14:01:30:535 [11544] 3 de: Oracle_Database::OpenDB (SET) OCIAttrSet OCI_ATTR_PASSWORD:  ... 
Jan 13 14:01:30:535 [11544] 2 de: Oracle_Database::OpenDB (RETURN) OCIAttrSet OCI_ATTR_PASSWORD:  STATUS=0 
Jan 13 14:01:30:535 [11544] 3 de: Oracle_Database::getOCISvcCtxUnq (GET) OCISessionGet: retrieving from pool OCI:SP:lO3MmufjSMWeFQ0WsOcMdC ... 
Jan 13 14:01:31:300 [11544] 0 de: data_engine [update] [update] - Oracle_Database::getOCISvcCtxUnq [update] data_engine [update] status: 1 
 OCIEnv: 0x000000DE9C963560 OCIAuthInfo: 0x000000DE9C973D90 OCISvcCtx: 0x0000000000000000  
Jan 13 14:01:31:300 [11544] 0 de: slm_40_update - could not connect to the database 
Jan 13 14:01:31:300 [11544] 0 de: main Database update failed. Correct the problem and try again. 
Jan 13 14:01:31:300 [11544] 3 de: Database_global_lock LOCK 
Jan 13 14:01:31:300 [11544] 3 de: Database_global_lock UNLOCK 
Jan 13 14:01:31:300 [11544] 0 de: Database library - program is exiting through exit()... 
Jan 13 14:01:31:300 [11544] 3 de: Database library unloaded 
Jan 13 14:01:31:300 [11544] 3 de: Database_global_lock DESTROY LOCK 
Jan 13 14:01:31:300 [11544] 3 de: Copy Snapshot DESTROY LOCK 
Jan 13 14:01:32:310 [1236] Controller: Max. restarts reached for probe 'data_engine' (command = data_engine.exe) 

Environment

Release : 9.2.0

Component : DATA_ENGINE

Oracle database : 11G

Resolution

This issue has been resolved, after being checked by the DBA team, the credentials used by UIM on the data engine have expired.
 After the password has been updated, the data engine has been activated again and the data has been inserted into the database

 

Attachments