Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Server & Application Monitor (SAM) > Unexpected error occurred. OdbcNoLibrary: ODBC Library is not found. Is LD_LIBRARY_PATH set

Unexpected error occurred. OdbcNoLibrary: ODBC Library is not found. Is LD_LIBRARY_PATH set

Updated November 24, 2016

Overview

When attempting to poll a database server using the "ODBC User Experience Monitor" in SAM, the following error appears:

Unexpected error occurred.
OdbcNoLibrary: 'ODBC Library is not found. Is LD_LIBRARY_PATH set?'

Environment

  • SAM 6.3 and later
  • Node polled via Linux Agent

Cause 

The cause for this issue is the Linux Agent. When polling a node with the Linux Agent, the "ODBC User Experience Monitor" will initiate the request on the Linux machine and attempt to use ODBC drivers on the Linux machine.

The error is produced when the specified ODBC driver does not exist on the Linux machine.

Resolution

There are two options to resolve this issue depending on the configuration.

 

Install ODBC drivers on the Linux machine

Go to the vendor's website and install the ODBC driver on the Linux machine for the database where you are trying to poll.

 

Also, "unixODBC" will need to be installed. This package should be available for most Linux Distros. After installing unixODBC and the relevant driver it should be detected.

 

You may need to update the Connection string also in the SAM template to match your driver version that's been installed.

 

Switch the template to Agentless

  1. Open the Orion Web Console.
  2. Go to Settings > SAM Settings > Manage Application Monitors.
  3. Edit the Application Monitor.
  4. Go to Advanced > Preferred Polling Method: and then switch to Agentless.
  5. Click Save.

Note: Switching to Agentless will attempt to use ODBC drivers installed locally on the Orion Polling Engine. If these are not present, then they will need to be downloaded and installed from the vendor's website.

 

Last modified
07:00, 29 Mar 2017

Tags

Classifications

Public