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
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.
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
this issue happen most of time. I resolve it by re installation dba and netxms application please help me if any other solution
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?