NetXMS Support Forum

Hello,

I installed the latest NetXMS version (Windows) together with the Reporting Service, but the Reporting Service refuses to start with the following error: System error 5 has occurred. Access is denied.

The service is running under a Local Service account (set by installer).

Is there a log where I can check for further details?

Best regards

Stefan

Do you have reporting related logs in C:\NetXMS\log? Also, when exactly you get this error - when trying to start reporting service from Service Manager? Did you choose "hardening file system permissions" during installation?

Best regards,
Victor

Hi,

thanks for the fas reply. Please check the attached screenshots to see how I installed NetXMS, hardened permissions are enabled. I installed it to D:\Program Files\NetXMS, so I assume the logfiles should be there. I found a file named commons-daemon.2021-02-15.log which looks like the right one. Does this help?


[2021-02-15 08:57:57] [info]  [ 4068] Apache Commons Daemon procrun (1.2.4.0 64-bit) started.
[2021-02-15 08:57:57] [info]  [ 4068] Installing service 'nxreportd' name 'NetXMS Reporting Server'.
[2021-02-15 08:57:57] [error] [ 4068] The specified service already exists.
[2021-02-15 08:57:57] [error] [ 4068] Failed installing service 'nxreportd'.
[2021-02-15 08:57:57] [error] [ 4068] The specified service already exists.
[2021-02-15 08:57:57] [error] [ 4068] Apache Commons Daemon procrun failed with exit value: 8 (failed to install service).
[2021-02-15 08:57:57] [error] [ 4068] The specified service already exists.
[2021-02-15 08:57:57] [info]  [ 7524] Apache Commons Daemon procrun (1.2.4.0 64-bit) started.
[2021-02-15 08:57:57] [info]  [ 7524] Updating service...
[2021-02-15 08:57:57] [warn]  [ 7524] Failed to obtain service description
[2021-02-15 08:57:57] [info]  [ 7524] Updated service 'nxreportd'.
[2021-02-15 08:57:57] [info]  [ 7524] Finished updating service 'nxreportd'.
[2021-02-15 08:57:57] [info]  [ 7524] Apache Commons Daemon procrun finished.
[2021-02-15 08:57:57] [info]  [ 2120] Apache Commons Daemon procrun (1.2.4.0 64-bit) started.
[2021-02-15 08:57:57] [info]  [ 2120] Starting service 'nxreportd'...
[2021-02-15 08:57:57] [warn]  [ 2120] Failed to obtain service description
[2021-02-15 08:57:58] [error] [ 2120] apxServiceControl(): dwState(4) != dwCurrentState(1); dwWin32ExitCode = 0, dwWaitHint = 2000, dwServiceSpecificExitCode = 0
[2021-02-15 08:57:58] [error] [ 2120] Access is denied.
[2021-02-15 08:57:58] [error] [ 2120] apxServiceControl(): returning FALSE
[2021-02-15 08:57:58] [error] [ 2120] Access is denied.
[2021-02-15 08:57:58] [error] [ 2120] Failed to start service 'nxreportd'.
[2021-02-15 08:57:58] [error] [ 2120] Access is denied.
[2021-02-15 08:57:58] [info]  [ 2120] Finished starting service 'nxreportd', returning 0.
[2021-02-15 08:57:58] [error] [ 2120] Apache Commons Daemon procrun failed with exit value: 5 (failed to start service).
[2021-02-15 08:57:58] [error] [ 2120] Access is denied.
[2021-02-15 08:59:21] [info]  [ 6096] Apache Commons Daemon procrun (1.2.4.0 64-bit) started.
[2021-02-15 08:59:21] [info]  [ 6096] Running Service 'nxreportd'...
[2021-02-15 08:59:21] [info]  [ 5564] Starting service...
[2021-02-15 09:02:06] [info]  [ 5932] Apache Commons Daemon procrun (1.2.4.0 64-bit) started.
[2021-02-15 09:02:06] [info]  [ 5932] Running Service 'nxreportd'...
[2021-02-15 09:02:06] [info]  [ 6276] Starting service...
[2021-02-15 09:39:33] [info]  [ 9200] Apache Commons Daemon procrun (1.2.4.0 64-bit) started.
[2021-02-15 09:39:33] [info]  [ 9200] Installing service 'nxreportd' name 'NetXMS Reporting Server'.
[2021-02-15 09:39:34] [error] [ 9200] The specified service already exists.
[2021-02-15 09:39:34] [error] [ 9200] Failed installing service 'nxreportd'.
[2021-02-15 09:39:34] [error] [ 9200] The specified service already exists.
[2021-02-15 09:39:34] [error] [ 9200] Apache Commons Daemon procrun failed with exit value: 8 (failed to install service).
[2021-02-15 09:39:34] [error] [ 9200] The specified service already exists.
[2021-02-15 09:39:34] [info]  [ 4696] Apache Commons Daemon procrun (1.2.4.0 64-bit) started.
[2021-02-15 09:39:34] [info]  [ 4696] Updating service...
[2021-02-15 09:39:34] [warn]  [ 4696] Failed to obtain service description
[2021-02-15 09:39:34] [info]  [ 4696] Updated service 'nxreportd'.
[2021-02-15 09:39:34] [info]  [ 4696] Finished updating service 'nxreportd'.
[2021-02-15 09:39:34] [info]  [ 4696] Apache Commons Daemon procrun finished.
[2021-02-15 09:39:34] [info]  [ 8744] Apache Commons Daemon procrun (1.2.4.0 64-bit) started.
[2021-02-15 09:39:34] [info]  [ 8744] Starting service 'nxreportd'...
[2021-02-15 09:39:34] [warn]  [ 8744] Failed to obtain service description
[2021-02-15 09:39:35] [error] [ 8744] apxServiceControl(): dwState(4) != dwCurrentState(1); dwWin32ExitCode = 0, dwWaitHint = 2000, dwServiceSpecificExitCode = 0
[2021-02-15 09:39:35] [error] [ 8744] Access is denied.
[2021-02-15 09:39:35] [error] [ 8744] apxServiceControl(): returning FALSE
[2021-02-15 09:39:35] [error] [ 8744] Access is denied.
[2021-02-15 09:39:35] [error] [ 8744] Failed to start service 'nxreportd'.
[2021-02-15 09:39:35] [error] [ 8744] Access is denied.
[2021-02-15 09:39:35] [info]  [ 8744] Finished starting service 'nxreportd', returning 0.
[2021-02-15 09:39:35] [error] [ 8744] Apache Commons Daemon procrun failed with exit value: 5 (failed to start service).
[2021-02-15 09:39:35] [error] [ 8744] Access is denied.



Let me know if there is more information required.

Hi,

found it - for some reason installer sets "login as" for reporting service to "LocalService" account instead of "LocalSystem". Change "login as" to local system and it should start.

Best regards,
Victor

Hi,

now it looks different. After changing to Local System I now get:

Windows could not start the NetXMS Reporting Server service on Local Computer.
Error 1067: The process terminated unexpectedly.

On the log is only:

[2021-02-16 14:41:10] [info]  [ 9168] Apache Commons Daemon procrun (1.2.4.0 64-bit) started.
[2021-02-16 14:41:10] [info]  [ 9168] Running Service 'nxreportd'...
[2021-02-16 14:41:10] [info]  [ 1112] Starting service...


Any ideas?

Best regards

Stefan

Did it create another log file nxreportd.log? What Java version you have installed?

We are a big step further! The Java version was a good tip, because I never installed Java on the server. NetXMS Core was running without it, so I totally missed that. After installing Java 15 the reporting service is starting, but the NetXMS Console is unable to connect to the service for some reason.

I've found that there are some settings in NetXMS related to reporting which I changed to match our environment (see attached screeenshot)

I now also have a nxreportd.log file which shows the following:


07:58:21.889 [Main Thread] DEBUG org.netxms.reporting.Server - Initializing server instance
07:58:21.893 [Main Thread] INFO  org.netxms.reporting.Server - Properties file nxreportd.properties not found
07:58:22.008 [Main Thread] DEBUG org.netxms.reporting.Server - Starting server instance
07:58:22.008 [Main Thread] INFO  o.n.reporting.services.ReportManager - Deploying *.jar/*.zip in D:\Program Files\NetXMS\var\nxreportd\definitions
07:58:22.018 [Main Thread] INFO  org.netxms.reporting.Startup - Server instance initialized
07:58:22.018 [FileMonior] INFO  o.n.reporting.services.FileMonitor - File monitor started
07:59:28.561 [Main Thread] INFO  org.netxms.reporting.Startup - Server instance destroyed
07:59:28.563 [Network Listener] ERROR org.netxms.reporting.Server - Error accepting incoming connection
java.net.SocketException: Socket closed
at java.base/sun.nio.ch.NioSocketImpl.endAccept(NioSocketImpl.java:689)
at java.base/sun.nio.ch.NioSocketImpl.accept(NioSocketImpl.java:762)
at java.base/java.net.ServerSocket.implAccept(ServerSocket.java:684)
at java.base/java.net.ServerSocket.platformImplAccept(ServerSocket.java:650)
at java.base/java.net.ServerSocket.implAccept(ServerSocket.java:626)
at java.base/java.net.ServerSocket.implAccept(ServerSocket.java:583)
at java.base/java.net.ServerSocket.accept(ServerSocket.java:540)
at org.netxms.reporting.Server$2.run(Server.java:151)
at java.base/java.lang.Thread.run(Thread.java:832)


It looks like the reporting server is refusing the connection for some reason. Is there some thing like a whitelist I have to configure?

And one additional question. Where can I find some example reports, or is there a manual on how to create reports?

Thanks a lot for Your help

Hi,

change localhost to 127.0.0.1 as reporting server address. This is known issue - localhost resolved to IPv6 loopback, but reporting server process listens on IPv4 only.

Best regards,
Victor

That was it! The service is starting and I can connect to it now.
Now I have to find out ho to create reports.
The manual is not really helpful on this topic. Is there another source I coukd check?

The report engine used is Jasper Reports: https://en.wikipedia.org/wiki/JasperReports

An example of report could be found, e.g., in this forum message: https://www.netxms.org/forum/general-support/reporting-server-4315/msg20117/#msg20117