Report Manager - How to monitor Export and ETL/How to know when data is available in Report Manager for reports

Last Modified

Fri Apr 21 16:07 GMT 2023

Description

This article describes where to look for the status of export and ETL as well as details about the architecture of Report Manager.

Environment

  • Report Manager 3.2+

Solution

>> Is there a way I can check that the information provided in my reports is accurate?

The info below describes observing the status of Export and ETL from Report Manager. Data will be available for reports if and only ifBOTH Export and ETL have completed successfully.

Finally, if you install a N-able N-central Agent onto the RM server, you can then apply the Report Manager service template within N-able N-central. This will monitor logs mentioned below automatically.

Export and ETL overview:

To view the status of export from N-able N-central,/ETL within Report Manager, browse to: Report Manager Admin Console > N-able N-central Configuration.
N-central Configuration Overview

Export

Use the Data Export Log to see the minute-by-minute status of export from N-able N-central: Log in to theReport Manager Admin Console > Log Management > Data Export Logl

Export Completed Successfully

INFO - 2018-06-07 16:08:21,658 [main                ] nable.export              - Update export status to: Completed INFO - 2018-06-07 16:08:21,674 [main                ] nable.export              - EXPORT RESULT STATUS: COMPLETED INFO - 2018-06-07 16:08:21,676 [main                ] nable.export              - About to reinitcache for sysconfig. INFO - 2018-06-07 16:08:21,676 [main                ] nable.export              - Running /opt/nable/usr/sbin/runNCLI.sh reinitcachesysconfig: This can take a few minutes, please wait... INFO - 2018-06-07 16:08:21,676 [main                ] nable.export              - executeCmd: /opt/nable/usr/sbin/runNCLI.sh reinitcache sysconfig INFO - 2018-06-07 16:08:24,397 [main                ] nable.export              - FINISHED RUNNING EXPORT TOOL

ETL Services

There are two services that both need to be running in order for the ETL process to successfully function. Check that the two services below are running in services.msc
  • Report Manager Maintenance
  • Report Manager Maintenance Watchdog


ETL Log

ETL logs and report generation errors can also be seen at: Report Manager Admin Console > System Setup and Logs > Logs.

ETL Logs on demand

The full ETL log is found in the location below (default location below!). Note this powershell command can be run on RM to watch ETL updates in realtime:

Get-Content "C:\Program Files (x86)\N-able Technologies\Report Manager\logs\Etl.DS001.log" -Wait

ETL Processes

A quick way to check if ETL is currently running would be the presence of 'dtexec.exe' in task manager. Alternately, you may run the following command from the command prompt (as administrator):

tasklist /FI "IMAGENAME eq dtexec.exe"

ETL Finished

How to check that all ETL packages have finished running. Open the log and check for the final entry in the ETL procedure.
Example of ETL completed in the log:

PackageStart - Maintenance - Staging Cleanup on: 3/9/2017 4:11    OnSuccess - the package completed successfullyPackageEnd - Maintenance - Staging Cleanup on: 3/9/2017 4:11   Duration: 0 hrs, 0 mins, 1 secs

Problem Still Unresolved

Please raise a support case and follow article 000041502 to have your issue dealt with as quickly as possible.