NetXMS 3.8 Reporting Service not starting
-
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.
-
-
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 -
-
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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login