Text only | Text with Images

NetXMS Support Forum

English Support => General Support => Topic started by: rsa on August 16, 2021, 09:03:09 AM

Title: Reporting server not starting
Post by: rsa on August 16, 2021, 09:03:09 AM
Hi,

I have NetXMS server version 3.9.178 installed on Windows 10 and connected to mySQL database installed on Centos Linux server.
The reporting service on windows does not start I keep getting Error 1067: The process terminated unexpectedly I tried:

1- changing the reporting IP from the default localhost to 127.0.0.1
2- I tried to start the service with the administrator user

Any help is appreciated
Title: Re: Reporting server not starting
Post by: Filipp Sudanov on August 20, 2021, 01:45:54 PM
Pls show the contents of C:\NetXMS\log\commons-daemon.xxxx-xx-xx.log
Title: Re: Reporting server not starting
Post by: rsa on August 20, 2021, 07:21:02 PM
Thank you Filipp for your reply,

After reinstalling java and changing the reporting server IP from localhost to 127.0.0.1 and also changed the netxms reporting server Log on user to Local System Account I was able to start the reporting server but the Reports Perspective is not showing any reports and I cannot create my own


commons-daemon.2021-08-20
--------------------------

[2021-08-20 14:07:17] [info]  [ 4012] Apache Commons Daemon procrun (1.2.4.0 64-bit) started.
[2021-08-20 14:07:17] [info]  [ 4012] Running Service 'nxreportd'...
[2021-08-20 14:07:17] [info]  [ 2172] Starting service...
[2021-08-20 14:07:19] [info]  [ 2172] Service started in 1437 milliseconds.
[2021-08-20 18:59:34] [info]  [ 1652] Stopping service...
[2021-08-20 18:59:36] [info]  [ 1652] Service stop thread completed.
[2021-08-20 19:00:36] [info]  [ 4012] Run service finished.
[2021-08-20 19:00:36] [info]  [ 4012] Apache Commons Daemon procrun finished.
[2021-08-20 19:01:03] [info]  [ 1396] Apache Commons Daemon procrun (1.2.4.0 64-bit) started.
[2021-08-20 19:01:03] [info]  [ 1396] Running Service 'nxreportd'...
[2021-08-20 19:01:03] [info]  [ 7016] Starting service...
[2021-08-20 19:01:05] [info]  [ 7016] Service started in 1432 milliseconds.




nxreportd
-----------

19:01:04.046 [Main Thread] DEBUG org.netxms.reporting.Server - Initializing server instance
19:01:04.047 [Main Thread] INFO  org.netxms.reporting.Server - Properties file nxreportd.properties not found
19:01:04.080 [Main Thread] DEBUG org.netxms.reporting.Server - Starting server instance
19:01:04.080 [Main Thread] INFO  o.n.reporting.services.ReportManager - Deploying *.jar/*.zip in C:\NetXMS\var\nxreportd\definitions
19:01:04.084 [Main Thread] INFO  org.netxms.reporting.Startup - Server instance initialized
19:01:04.084 [FileMonior] INFO  o.n.reporting.services.FileMonitor - File monitor started
19:01:13.068 [Network Listener] DEBUG org.netxms.reporting.Server - Incoming connection
19:01:13.069 [Network Receiver] INFO  o.n.r.services.CommunicationManager - Communication manager started
19:01:13.072 [Network Receiver] DEBUG o.n.r.services.CommunicationManager - RECV: NXCPMessage
Code (0xb6, flags=0x5020, id=0, fields={}) Select

19:01:13.072 [Network Receiver] DEBUG o.n.r.services.CommunicationManager - SEND: NXCPMessage [code=0xb7, flags=0x20, id=0, fields={}]
19:01:13.074 [Network Receiver] DEBUG o.n.r.services.CommunicationManager - RECV: NXCPMessage [code=0xe8, flags=0x0, id=4, fields={315=NXCPMessageField [id=315, type=0, value=0]}]
19:01:13.074 [Network Receiver] DEBUG o.n.r.services.CommunicationManager - SEND: NXCPMessage [code=0x1d, flags=0x0, id=4, fields={28=NXCPMessageField [id=28, type=0, value=0]}]
19:01:13.075 [Network Receiver] DEBUG o.n.r.services.CommunicationManager - RECV: NXCPMessage [code=0x1a6, flags=0x5000, id=5, fields={736=NXCPMessageField [id=736, type=7, value=netxms-passwd], 737=NXCPMessageField [id=737, type=7, value=localhost], 738=NXCPMessageField [id=738, type=3, value=25], 739=NXCPMessageField [id=739, type=7, value=NetXMS Server], 740=NXCPMessageField [id=740, type=7, [email protected]], 741=NXCPMessageField [id=741, type=7, value=], 732=NXCPMessageField [id=732, type=7, value=mysql.ddr], 733=NXCPMessageField [id=733, type=7, value=nms.metrosuperstore.com], 734=NXCPMessageField [id=734, type=7, value=netxms], 735=NXCPMessageField [id=735, type=7, value=netxms-admin]}]
19:01:13.075 [Network Receiver] INFO  org.netxms.reporting.Server - Server configuration updated
19:01:13.075 [Network Receiver] DEBUG o.n.r.services.CommunicationManager - SEND: NXCPMessage [code=0x1d, flags=0x0, id=5, fields={28=NXCPMessageField [id=28, type=0, value=0]}]
Title: Re: Reporting server not starting
Post by: Filipp Sudanov on August 24, 2021, 05:07:16 PM
Reporting perspective is showing reports that are installed in C:\NetXMS\var\nxreportd\definitions

Here's a forum post that has an example of report:
https://www.netxms.org/forum/general-support/reporting-server-4315/msg20117/#msg20117
Title: Re: Reporting server not starting
Post by: rsa on August 25, 2021, 02:27:37 PM
Thanks a million, The sample report is showing fine. Now I need to find my way in creating new reports
Text only | Text with Images