# Dashboard - No data displayed

# Problem

Sometimes, when creating a dashboard, there is no data displayed in portlets.

Analysis Server Troubleshooting: No data displayed in Dashboard

Analysis Server Troubleshooting: No data displayed in Dashboard

# Resolution

Use the following list of suggestions to troubleshoot the issue:

# Check the configured Core Server database path

Follow these instructions to check if the configured Core Server database path is correct:

  1. Go to the Configuration page under the Administration tab of the Analysis Server web interface.

  2. Look for the configuration key Root.Etl.CoreDatabasePath.

  3. Verify that the value of the key is correct.

    Analysis Server Troubleshooting: Check Core Server Database Path

    Analysis Server Troubleshooting: Check Core Server Database Path

  4. If the value is incorrect, update the configuration key and execute the command RunEtl using the Analysis Server console.

# Check if License Status data is processed successfully

Follow these instructions to check the status of the License Status processing:

  1. Go to the Analysis Server Log directory, which is by default in C:\Program Files\OpeniT\Analysis Server\Log.

  2. Open the OpeniT.Server.Etl.Console.log log file.

  3. Look for the latest execution of the job SyncLicenseStatusLabelJob

Example
2022-12-05 19:31:08,005 +08:00 INFO SyncLicenseStatusLabelJob - Open iT Analysis
Server Version: 9.12.1 (6c4c0256)
2022-12-05 19:31:08,008 +08:00 INFO SyncLicenseStatusLabelJob - Job started.
Running as SVG\jplanas
2022-12-05 19:31:08,013 +08:00 INFO Config - License file is
valid. "core" valid until
2021-12-15 (374 days), "server_license" valid until 2021-12-15 (374 days),
"server_olapreports" valid until 2022-12-15 (9 days)
2022-12-05 19:31:08,014 +08:00 INFO SyncDataTypeJob - Open iT Analysis
Server Version: 9.12.1 (6c4c0256)
2022-12-05 19:31:08,016 +08:00 INFO SyncDataTypeJob - Job started.
Running as SVG\jplanas
2022-12-05 19:31:08,190 +08:00 INFO SyncDataTypeJob - Scanning core
server data type 999 from
\\mnlnas\global_share\data\customer\data-db-customer-Saipem\license-status
2022-12-05 19:31:08,197 +08:00 INFO SyncDataTypeJob - Packet size: 32764.
Batch size: 30000
2022-12-05 19:31:08,206 +08:00 INFO SqlTableCreator - Table LicenseData
exists in the database.
2022-12-05 19:31:08,211 +08:00 INFO SqlTableCreator - Checking column
definitions for table LicenseData
2022-12-05 19:31:08,321 +08:00 INFO SyncDataTypeJob - Loading 0 files...
2022-12-05 19:31:08,328 +08:00 INFO SyncDataTypeJob - Loaded a total
of 0 records. Average
throughput for datatype 999: 0 records/min
2022-12-05 19:31:08,331 +08:00 INFO SyncDataTypeJob - Job done.
Duration 00.31s
2022-12-05 19:31:08,439 +08:00 INFO SyncLicenseStatusLabelJob - Finished running
procedure
ProcessLicenseData. Affected rows: 992.
2022-12-05 19:31:08,442 +08:00 INFO SyncLicenseStatusLabelJob - Job done.
Duration 00.43s
  1. Verify that job is successful and has loaded the data.

  2. If ERRORS occurred, try to execute again the command SyncLicenseStatus /reload. If errors persist, please send the log file to support@openit.com for response.

# Check if License Status data is available

Follow these instructions to check if the License Status data is available in the Core Server database:

  1. Go to the Configuration page under the Analysis Server Administration tab.

  2. Look for the configuration key Root.Etl.CoreDatabasePath.

    Analysis Server Troubleshooting: Check Core Server Database Path

    Analysis Server Troubleshooting: Check Core Server Database Path

  3. Navigate to the value of the configuration key.

  4. Open the folder license-status and verify if a .gz file is available.

    Analysis Server Troubleshooting: Check License Status File

    Analysis Server Troubleshooting: Check License Status File

  5. If not available, check the Core Server to see why it is not generating license status data.

# Check for Web Browser Console Errors

Follow these instructions to check for errors in the web browser console:

  1. In the Dashboard page, right-click anywhere inside the page and choose Inspect.

    Analysis Server Troubleshooting: Inspect Web Browser

    Analysis Server Troubleshooting: Inspect Web Browser

    The Developer Tools should appear.

  2. Choose Console from the available tabs of the tool.

  3. The Console lists web browser transactions including errors.

    Analysis Server Troubleshooting: Check Web Browser Console Errors

    Analysis Server Troubleshooting: Check Web Browser Console Errors

  4. Errors in the console may sometimes be too technical. For immediate response, send the error details to support@openit.com.

We value your feedback!

Please take a few minutes to complete our survey and share your thoughts on your recent experience with our documentation.

Take survey

Close