Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

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

Tags

Classifications

Public