NetXMS Support Forum

Hi,
I have just tried to upgrade our 1.2.1 installation on a 32 bit W2K3 server to 1.2.9. but the service wont start.
Db is sql2005.
Looks like there's a db issue. Any ideas how to proceed?

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

Checking database (excluding collected data):
* Checking zone objects...                                            [PASSED]
* 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]
Database doesn't contain any errors
Database check completed

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

Upgrading database...
Upgrading from version 265 to 266
SQL query failed ([Microsoft][SQL Native Client][SQL Server]Incorrect syntax nea
r the keyword 'WHERE'.):
CREATE INDEX idx_event_log_root_id ON event_log(root_event_id) WHERE root_event_
id > 0
Rolling back last stage due to upgrade errors...
Database upgrade failed

C:\NetXMS\bin>

Thanks

Heres the debug output:
C:\NetXMS\bin>netxmsd -D3
Using configuration file "C:\NetXMS\etc\netxmsd.conf"
[14-Nov-2013 16:30:23.424] Debug callback set for DB library
[14-Nov-2013 16:30:23.424] Database driver "odbc.ddr" loaded and initialized suc
cessfully
[14-Nov-2013 16:30:23.487] Successfully connected to database netxms_db@localhos
t
[14-Nov-2013 16:30:23.487] Your database has format version 265, but server is c
ompiled for version 291
NetXMS Core initialization failed

thanks

Ive got an issue with a process not disposing handles. I have setup data collection on the agent:
Counter = Process.Handle.Count:"\Process(ClientProcessor)\Handle Count":60:A:INT:"ClientProcessor Handle Count"

The data in perfmon does not correlate to the data captured by the netxms console.
For instance in perfmon i'm currently looking at 38000 handles yet in the console i'm seeing -2147483648 then 2147483647 repeatedly.

Any ideas/pointers as to what i'm doing wrong?

Thanks in advance

thanks again Victor

thanks Victor.

Hi,
Im trying to create a new parameter in the DCC page, but i'm unable to select windows performance counters, is this because i'm using version 1.2.1 (i can do this on my 1.2.9 installation) or have i configured something incorrectly?
thanks in advance
Chris

Hi Victor,
I've got an old version running, 1.2.1, could you let me know the upgrade path to reach 1.2.9.
Thanks in advance.
Chris