Reporting server not starting

[rsa]

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

[Filipp Sudanov]

Pls show the contents of C:\NetXMS\log\commons-daemon.xxxx-xx-xx.log

[rsa]

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
0xb6, flags=0x5020, id=0, fields={}:

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]}]

[Filipp Sudanov]

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

[rsa]

Thanks a million, The sample report is showing fine. Now I need to find my way in creating new reports