Applications Systems

VMAN appliance dashboard list does not contain any dashboards or dashboards have disappeared after migrating the appliance

This article will provide a workaround solution to restore the default dashboards of VMAN in case the dashboards are missing after migrating the VMAN appliance; You may see the error < Workspace error while running query > when attempting to restore the dashboards in the VMAN appliance web console.

First published date

11/6/2018 5:22 PM

Last published date

1/30/2025 4:18 PM

Overview

This article will provide a workaround solution to restore the default dashboards of VMAN.

This screenshot shows that the dashboard list does not contain any dashboards:

This screenshot shows the error < Workspace error while running query > when trying to restore the dashboards:

This screenshot shows another possible issue where the dashboards are missing completely:

Product section

Virtualization Manager

Cause

This issue can occur after migrating the data hard disk (harddisk 2) of the old VMAN virtual appliance (7.1 or previous) to a new VMAN 7.2, 8.0, or 8.1 virtual appliance.

Resolution

As a workaround, you can download and execute a customized sql script (included in this article) on the VMAN appliance, which will restore the default VMAN dashboards. Note that this will not restore any custom dashboards.

Here are the steps to apply the workaround solution:

---------------------------------------------------------------------------

Download the psql script, update_dashboards.sql.

Transfer the script to the VMAN virtual appliance's /tmp folder (use winscp or any tool or method that you prefer to transfer the file).

Connect to the VMAN virtual appliance through SSH (use putty or any SSH connection tool).

Run the following command to elevate the permission level to root:
```
sudo su - root
```

Run the following command to apply the script:

psql -d hyper9db -U h9pgsu -f /tmp/update_dashboards.sql

Note: the 'update_dashboards.sql' script file must be in the /tmp folder.

Run the following command to restart the tomcat service:
```
service tomcat restart
```
Log in to the VMAN appliance web console to verify that the dashboards have been restored and are in the dashboard list.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.