Error upgrading to 1.1.9

[DanG]

Hi,

Trying to upgrade from Windows 2008 x64 NetXMS 1.1.6. with SqlExpress to 1.1.9 using u full install.
The programs stops with:

nxdbmgr.exe has stopped working

Problem signature:
  Problem Event Name: APPCRASH
  Application Name: nxdbmgr.exe
  Application Version: 0.0.0.0
  Application Timestamp: 4f10559e
  Fault Module Name: ntdll.dll
  Fault Module Version: 6.0.6002.18541
  Fault Module Timestamp: 4ec3e855
  Exception Code: c0000005
  Exception Offset: 0000000000049669
  OS Version: 6.0.6002.2.2.0.400.8
  Locale ID: 2067
  Additional Information 1: 153d
  Additional Information 2: 65c33816e286fcda867b11e451b1909a
  Additional Information 3: b6d7
  Additional Information 4: f5b2f9f9f15205c69cb45696238ca7a6

Read our privacy statement:
  http://go.microsoft.com/fwlink/?linkid=50163&clcid=0x0409

running nxdbmgr check manually gives:
Your database has format version 244, this tool is compiled for version 245. Use "upgrade" command to upgrade your database first.

running then the upgrades result in the same error as above.

Any idea of how to proceed?

Kind regards,

Dan

[victor]

Hi!

Could you please run nxdbmgr upgrade with -t option? I want to see at what query it crashes.

Best regards,
Victor

[DanG]

Hi,

Here's the result:

nxdbmgr.exe upgrade -t
NetXMS Database Manager Version 1.1.9

Upgrading database...
Upgrading from version 244 to 245
>>> ALTER TABLE nodes ADD runtime_flags integer
>>> UPDATE nodes SET runtime_flags=0
>>> UPDATE actions SET rcpt_addr='' WHERE CAST(rcpt_addr AS nvarchar(4000))=N'#0
0'
>>> SELECT action_id,rcpt_addr FROM actions WHERE rcpt_addr LIKE '%#%'
>>> UPDATE actions SET email_subject='' WHERE CAST(email_subject AS nvarchar(400
0))=N'#00'
>>> SELECT action_id,email_subject FROM actions WHERE email_subject LIKE '%#%'
>>> UPDATE actions SET email_subject='%m' WHERE action_id=1
>>> UPDATE actions SET email_subject='%m' WHERE action_id=2
>>> UPDATE actions SET email_subject='%m' WHERE action_id=3
>>> UPDATE actions SET email_subject='%m' WHERE action_id=5
>>> UPDATE actions SET email_subject='%m' WHERE action_id=6
>>> UPDATE actions SET email_subject='%m' WHERE action_id=7
>>> UPDATE actions SET action_data='' WHERE CAST(action_data AS nvarchar(4000))=
N'#00'
>>> SELECT action_id,action_data FROM actions WHERE action_data LIKE '%#%'
>>> UPDATE actions SET action_data='Event Name: %n\nIp: %a\nEvenID: %i\nTimestam
p: %t\nEvenCode: %c\nSeverity: %s\nSeverity text: %S\nNetXms server version: %v
nUser tag: %u\nCustom message: %M\nCurrent value: %<currentValue>\nValue text: %
[ServiceStateName]\nThreshold: %<thresholdValue>\nIs repeat: %<isRepeatedEvent>'
 WHERE action_id=1

[victor]

Hi!

It is a bug in nxdbmgr. Attached is patched nxdbmgr.exe for x64 platform. It should work.

Best regards,
Victor

---

nxdbmgr.exe

[DanG]

Hi,

The patched nxdbmgr worked fine. Afterwords the core service starts and there is no error messages in the xmslog.txt log file.
Thank you for the fix!

The only thing is that as the update initially failed I reverted the live server to 1.1.6. I cloned the VM and did the test on that machine.
Will there be a full install package that I could apply to the live server?

Kind regards,

Dan

[victor]

Hi!

Release 1.1.10 planned to be somewhere next week, which will include all these fixes. In the meantime you can just install 1.1.9, replace nxdbmgr.exe, and run database upgrade manually. It will not affect server operation in any way, because this bug is only within database upgrade tool.

Best regards,
Victor

[DanG]

Hi Victor,

I think I'll wait for the next release. Thanks for clarifying.

Regards,

Dan