Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Log & Event Manager (LEM) > Failed to retrieve data from the database. error code: -2147189166

Failed to retrieve data from the database. error code: -2147189166

Updated February 14, 2017

Overview

In LEM 6.3.1 and later,  the following error displays when running any report from the Reports console:

Failed to retrieve data from the database.

Details: [Database Vendor Code: -466]

Error Code: -2147189166

 

Environment

LEM 6.3.1 and later

Cause 

This is caused by a TLS connection failure between the Reports Console and LEM.

Resolution

There are two ways to address this error, by disabling TLS or by making sure that the correct certificate is in use.

 

To disable TLS (also useful to verify the issue is related to TLS and the certificate):

  1. Log into the cmc either by connecting over SSH to port 32022 or through the hypervisor's console
  2. Type
    • manager
    • disabletls

 

To recreate the TLS certificate:

  1. Disable and re-enable TLS on the manager.
  2. Re-import the certificate into the Reports console.

 

Reboot LEM if hasn't been rebooted in a while via cmc->appliance-> reboot

 

If all else fails, refer to LEM Reports Troubleshooting Guide

 

Last modified

Tags

Classifications

Public