Print Page - Upgraded from version 0.2.27 to version 0.2.29 and having problems

Title: Upgraded from version 0.2.27 to version 0.2.29 and having problems
Post by: MEVALDEZ on October 09, 2009, 06:39:37 PM

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

Title: Re: Upgraded from version 0.2.27 to version 0.2.29 and having problems
Post by: Marco Incalcaterra on October 11, 2009, 05:25:04 PM

Quote from: MEVALDEZ on October 09, 2009, 06:39:37 PM
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! :-(

Title: Re: Upgraded from version 0.2.27 to version 0.2.29 and having problems
Post by: Victor Kirhenshtein on October 11, 2009, 07:01:09 PM

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

Best regards,
Victor

Title: Re: Upgraded from version 0.2.27 to version 0.2.29 and having problems
Post by: MEVALDEZ on October 13, 2009, 05:21:29 AM

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>

Title: Re: Upgraded from version 0.2.27 to version 0.2.29 and having problems
Post by: Victor Kirhenshtein on October 13, 2009, 09:52:19 AM

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

Title: Re: Upgraded from version 0.2.27 to version 0.2.29 and having problems
Post by: MEVALDEZ on October 13, 2009, 06:25:40 PM

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

NetXMS Support Forum

English Support => General Support => Topic started by: MEVALDEZ on October 09, 2009, 06:39:37 PM