Upgraded from version 0.2.27 to version 0.2.29 and having problems

[MEVALDEZ]

Hi Victor and Team,

I upgraded from upgraded my server from version 0.2.27 to version 0.2.29 and now I am having having problems. I tried starting the service manually and it won't start.

I checked the NETXMS using nxdbmgr check and I get the following:

C:\NetXMS\bin>nxdbmgr check
NetXMS Database Manager Version 0.2.29

Configuration file OK
Checking database:
Your database has format version 95, this tool is compiled for version 98.
Use "upgrade" command to upgrade your database first.
Database check aborted

C:\NetXMS\bin>nxdbmgr upgrade
NetXMS Database Manager Version 0.2.29

Configuration file OK
Upgrading database...
Upgrading from version 95 to 96
SQL query failed ([Microsoft][ODBC SQL Server Driver][SQL Server]The data types
text and varchar are incompatible in the equal to operator.):
UPDATE object_properties SET comments='' WHERE comments='#00'
Rolling back last stage due to upgrade errors...
Database upgrade failed

My question is where do I make this change or what is the best way to correct this problem.

Thank You

Mauricio

[Jmp_3f8h]

@mevaldez said in Upgraded from version 0.2.27 to version 0.2.29 and having problems:

Hi Victor and Team,

I upgraded from upgraded my server from version 0.2.27 to version 0.2.29 and now I am having having problems. I tried starting the service manually and it won't start.
---8<----
My question is where do I make this change or what is the best way to correct this problem.

Same problem here!

[victor]

Please try to replace nxdbmgr.exe with attached one and run upgrade process again.

Best regards,
Victor

---

nxdbmgr.exe

[MEVALDEZ]

Victor,

I upgraded and checked the database and this is what I get. I still can't seem to start the service on the server. It still fails to start. I have removed and reinstalled NETXMS and it is still hanging up on starting the service.

Any idea?
----------------------------------------------------------------------------------------------------

C:\NetXMS\bin>nxdbmgr check
NetXMS Database Manager Version 0.2.29

Configuration file OK
Checking database:
* Checking node objects...                                            [PASSED]
* Checking interface objects...                                      [PASSED]
* Checking network service objects...                                [PASSED]
* Checking cluster objects...                                        [PASSED]
* Checking template to node mapping...                                [PASSED]
* Checking object properties...                                      [PASSED]
* Checking event processing policy...                                [PASSED]
* Checking collected data...                                          [PASSED]
Database doesn't contain any errors
Database check completed

C:\NetXMS\bin>nxdbmgr upgrade
NetXMS Database Manager Version 0.2.29

Configuration file OK
Upgrading database...
Your database format is up to date

C:\NetXMS\bin>

[victor]

Please direct netxmsd output to file by replacing

LogFile = {syslog}

to

LogFile = some_file_name

in netxmsd.conf, then to start it from command line in debug mode:

netxmsd -D 9

and post debug output here or send it to [email protected].

Best regards,
Victor

[MEVALDEZ]

Victor,

Our NETXMS server is back up and running. I will continue to monitor the NETXMS server and I will update you on the status.

Thank you for all of your support. Hope all is well.

Mauricio