Print Page - Reporting Server 2.2.10 (Failed to load reports from the server:...)

Title: Reporting Server 2.2.10 (Failed to load reports from the server:...)
Post by: 91jme on October 29, 2018, 05:09:36 PM

Hi all,

Attempting to get the Reporting Server set up at the minute and can't seem to get past this final hurdle.

Running 2.2.10 on CentOS 7 x64, kernel 3.10.0-862.14.4.el7.x86_64

I've followed instructions here for setup: https://www.netxms.org/documentation/adminguide/reporting.html.

I used the .sql files from https://git.netxms.org/public/reporting-server.git/tree/HEAD:/sql/mysql?js=1 to create the required tables (links in wiki are dead).

Reporting Server seems to start and listen correctly:

(https://i.imgur.com/tkntwrf.png)

Reporting Server is enabled in NetXMS Server however when trying to load the Reports view the following error is received:

(https://i.imgur.com/YIw9PFC.png)

I've checked netxmsd.log with debug at 9 and the only reference I can find to Reporting Server is a message that the connector has started:

(https://i.imgur.com/3zsutDs.png)

/usr/local/etc/netxmsd.conf contains the following:

(https://i.imgur.com/hsSaUlX.png)

/opt/nxreporting/conf/nxreporting.xml contains:

Code Select

<config>
  <workspace>/opt/nxreporting/workspace</workspace>
    <netxmsdConfig>/usr/local/etc/netxmsd.conf</netxmsdConfig>
    <smtp>
        <server>127.0.0.1</server>
        <from>[email protected]</from>
    </smtp>
</config>

Any help or tips on troubleshooting this would be greatly appreciated.

Title: Re: Reporting Server 2.2.10 (Failed to load reports from the server:...)
Post by: Tatjana Dubrovica on October 30, 2018, 11:59:44 AM

Do you have EnableReportingServer=1 in netxms server configuration(netxmsd.conf)?
This section describes possible additional configuration options: https://www.netxms.org/documentation/adminguide/reporting.html#netxms-server

Title: Re: Reporting Server 2.2.10 (Failed to load reports from the server:...)
Post by: 91jme on October 30, 2018, 04:17:40 PM

Quote from: Tatjana Dubrovica on October 30, 2018, 11:59:44 AM
Do you have EnableReportingServer=1 in netxms server configuration(netxmsd.conf)?
This section describes possible additional configuration options: https://www.netxms.org/documentation/adminguide/reporting.html#netxms-server

Hi Tatjana, yes I have the Reporting Server enabled. You can see the configuration option on my third screenshot of the netxmsd.log output:

Quotename=EnableReportingServer value="1"

Title: Re: Reporting Server 2.2.10 (Failed to load reports from the server:...)
Post by: 91jme on November 01, 2018, 11:08:50 AM

Hi all,

For anybody reading, I think I've fixed the issue. Seems to have been the firewall; I'll list all the troubleshooting steps anyway just in case they help anybody else:

Noticed Java listening on tcp6 (IPv6), switched Java to bind to IPv4 using this command:
export _JAVA_OPTIONS="-Djava.net.preferIPv4Stack=true"
I could't telnet to the server on 4710, which lead me to look at the firewall.
Allowed all traffic on the local interface with the following:
firewall-cmd --permanent --zone=trusted --add-interface=lo
Restarted the reporting engine and netxmsd, waited around 30 seconds and the Report Server perspective loaded correctly:

(https://i.imgur.com/PWTOEEQ.png)

NetXMS Support Forum

English Support => General Support => Topic started by: 91jme on October 29, 2018, 05:09:36 PM