service down and unable to start

[tilahun]

Dear Sir/madam,

Netxms core service down and I cant start after it down most of time. I am exhausted by re-installation of netxms application.

please help me have look the attached snapshot 

---

[Filipp Sudanov]

There is a log file you can inspect to find the reasons. The exact file name is specified in NetXMS server's config file, usually it's  C:\NetXMS\log\netxmsd.log.

[tilahun]

log info.

2020.01.24 16:21:56.806 Log file opened (rotation policy 2, max size 16777216)
2020.01.24 16:21:56.810 *I* [db.drv            ] Database driver "mssql.ddr" loaded and initialized successfully
2020.01.24 16:21:56.873 *I* [                  ] Server ID 2F1425A900000029
2020.01.24 16:21:56.878 *E* [                  ] Error initializing component locks table

2020.01.24 16:21:57.815 Log file opened (rotation policy 2, max size 16777216)
2020.01.24 16:21:57.819 *I* [db.drv            ] Database driver "mssql.ddr" loaded and initialized successfully
2020.01.24 16:21:57.877 *I* [                  ] Server ID 2F1425A900000029
2020.01.24 16:21:57.881 *E* [                  ] Error initializing component locks table

2020.01.24 16:21:58.761 Log file opened (rotation policy 2, max size 16777216)
2020.01.24 16:21:58.765 *I* [db.drv            ] Database driver "mssql.ddr" loaded and initialized successfully
2020.01.24 16:21:58.830 *I* [                  ] Server ID 2F1425A900000029
2020.01.24 16:21:58.831 *E* [                  ] Error initializing component locks table

2020.01.24 16:22:00.310 Log file opened (rotation policy 2, max size 16777216)
2020.01.24 16:22:00.314 *I* [db.drv            ] Database driver "mssql.ddr" loaded and initialized successfully
2020.01.24 16:22:00.377 *I* [                  ] Server ID 2F1425A900000029
2020.01.24 16:22:00.379 *E* [                  ] Error initializing component locks table

2020.01.24 16:22:05.398 Log file opened (rotation policy 2, max size 16777216)
2020.01.24 16:22:05.402 *I* [db.drv            ] Database driver "mssql.ddr" loaded and initialized successfully
2020.01.24 16:22:05.456 *I* [                  ] Server ID 2F1425A900000029
2020.01.24 16:22:05.458 *E* [                  ] Error initializing component locks table

2020.01.24 16:22:11.045 Log file opened (rotation policy 2, max size 16777216)
2020.01.24 16:22:11.048 *I* [db.drv            ] Database driver "mssql.ddr" loaded and initialized successfully
2020.01.24 16:22:11.128 *I* [                  ] Server ID 2F1425A900000029
2020.01.24 16:22:11.130 *E* [                  ] Error initializing component locks table

2020.01.24 16:22:21.796 Log file opened (rotation policy 2, max size 16777216)
2020.01.24 16:22:21.800 *I* [db.drv            ] Database driver "mssql.ddr" loaded and initialized successfully
2020.01.24 16:22:21.853 *I* [                  ] Server ID 2F1425A900000029
2020.01.24 16:22:21.856 *E* [                  ] Error initializing component locks table

2020.01.24 16:22:30.027 Log file opened (rotation policy 2, max size 16777216)
2020.01.24 16:22:30.031 *I* [db.drv            ] Database driver "mssql.ddr" loaded and initialized successfully
2020.01.24 16:22:30.086 *I* [                  ] Server ID 2F1425A900000029
2020.01.24 16:22:30.088 *E* [                  ] Error initializing component locks table

2020.01.24 16:22:35.825 Log file opened (rotation policy 2, max size 16777216)
2020.01.24 16:22:35.829 *I* [db.drv            ] Database driver "mssql.ddr" loaded and initialized successfully
2020.01.24 16:22:35.884 *I* [                  ] Server ID 2F1425A900000029
2020.01.24 16:22:35.885 *E* [                  ] Error initializing component locks table

2020.01.24 16:23:37.096 Log file opened (rotation policy 2, max size 16777216)
2020.01.24 16:23:37.100 *I* [db.drv            ] Database driver "mssql.ddr" loaded and initialized successfully
2020.01.24 16:23:37.180 *I* [                  ] Server ID 2F1425A900000029
2020.01.24 16:23:37.202 *E* [                  ] Error initializing component locks table

2020.01.24 16:25:36.061 Log file opened (rotation policy 2, max size 16777216)
2020.01.24 16:25:36.064 *I* [db.drv            ] Database driver "mssql.ddr" loaded and initialized successfully
2020.01.24 16:25:36.138 *I* [                  ] Server ID 2F1425A900000029
2020.01.24 16:25:36.141 *E* [                  ] Error initializing component locks table

[tilahun]

this issue happen most of time. I resolve it by re installation dba and netxms application  please help me if any other solution

[Filipp Sudanov]

Can you set DebugLevel=6 in netxms server configuration file and show what's in the log file?

Also, how did you create the database? Using NetXMS installer? Can you just attach a screenshot of netxms installer on the step called "Select database" with all the checkboxes in the state as you use them to created the database?