sql_response -Execute SQL, COM Error [0x80040154] Class not registered - [Provider] Class not registered

Products

• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• NIMSOFT PROBES

Issue/Introduction

Errors as below in logs:
Apr 15 14:15:15:445 sql_response: DbConnectionOpen starting for profile TEST_DBCluster, connection timeout=30
Apr 15 14:15:15:445 sql_response: CreateConnString starting - TEST_EPECMDC3
Apr 15 14:15:15:445 sql_response: Profile: TEST_DBCluster - Openning Connection with db authentication
Apr 15 14:15:15:475 sql_response: Profile TEST_DBCluster, DbConnectionOpen - connected to database
Apr 15 14:15:15:475 sql_response: Profile: TEST_DBCluster, Error in Execute SQL
Apr 15 14:15:15:475 sql_response: Profile: TEST_DBCluster, operation: Execute SQL, COM Error [0x80040154] Class not registered - [Provider] Class not registered
Apr 15 14:15:15:475 sql_response: Saving the alarm to the list in profile
Apr 15 14:15:15:475 sql_response: entry found so returning...

No QOS is generated for Response time metric as verified in Dr Nimbus




 

 

Environment

UIM 8.x

Resolution

Changed the Cursor mode to Server from Client in the SQL query tab

Below is information about the setting

- Cursor
Allows you to select Server or Client and manage the cursor.

- Server
Creates the cursor in the database server. This setting delivers realistic data about the database performance.
Disadvantage: Reduces performance when the net-traffic increases.

- Client
Transfers the record set to the client machine by ADO and manage the cursor there.
Advantage: Better performance.
Disadvantage: The results are buffered, depend on ADO provider and can hide real database performance.