NetXMS 1.2.15 released

[user54119]

Thanks for the new release!
But I get this db upgrade error when I upgrade from V1.2.14 to V1.2.15 on linux 64bit with PostgreSQL:

Upgrading database...
Upgrading from version 318 to 319
Upgrading from version 319 to 320
Upgrading from version 320 to 321
Upgrading from version 321 to 322
Upgrading from version 322 to 323
Upgrading from version 323 to 324
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "tdata_257_record_id_key" for table "tdata_257"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "tdata_records_257_pkey" for table "tdata_records_257"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "tdata_rows_257_pkey" for table "tdata_rows_257"
SQL query failed (42830 ERROR:  there is no unique constraint matching given keys for referenced table "tdata_records_257"):
CREATE TABLE tdata_rows_257 (row_id bigint not null,column_id integer not null,value varchar(255) null,PRIMARY KEY(row_id,column_id),FOREIGN KEY (row_id) REFERENCES tdata_records_257(row_id) ON DELETE C                                     ASCADE)
SQL query failed (25P02 ERROR:  current transaction is aborted, commands ignored until end of transaction block):
SELECT id FROM clusters
SQL query failed (25P02 ERROR:  current transaction is aborted, commands ignored until end of transaction block):
SELECT id FROM mobile_devices
SQL query failed (25P02 ERROR:  current transaction is aborted, commands ignored until end of transaction block):
DELETE FROM metadata WHERE var_name='ValidTDataIndex'
Rolling back last stage due to upgrade errors...
Database upgrade failed

[alk]

@user54119 said in NetXMS 1.2.15 released:

But I get this db upgrade error when I upgrade from V1.2.14 to V1.2.15 on linux 64bit with PostgreSQL:

Hello.

Thank you for report. This bug in upgrade procedure is already fixed, we testing it right now.

[user54119]

Hi Alex

Ok, thanks. So I wait for your patched version.

[victor]

Hi,

updated source package and Windows installers are on web site.

Best regards,
Victor

[user54119]

I just tested the fixed version. DB update is working now. Thanks for the fast fix!!

[ArtKZ]

I download latest source package, but also have error when upgrade on Solaris 10 SPARC with PostgreSQL:

bash-3.2# /opt/netxms/bin/nxdbmgr upgrade
NetXMS Database Manager Version 1.2.15 Build 7881

Upgrading database...
Upgrading from version 323 to 324
SQL query failed (42P01 ERROR:  table "tdata_rows_500" does not exist):
DROP TABLE tdata_rows_500
SQL query failed (25P02 ERROR:  current transaction is aborted, commands ignored until end of transaction block):
DELETE FROM metadata WHERE var_name='ValidTDataIndex'
Rolling back last stage due to upgrade errors...
Database upgrade failed

[victor]

Hi!

Seems that table is missing while it should exist. Try to create table with that name (any structure, it will be dropped anyway) and run upgrade again.

Best regards,
Victor

[ArtKZ]

I created all the missing tables and the db upgrate was successful. Thank you, Victor!

[user54119]

Is there somewhere a documentation of the new file management subagent (filemgr.nsm)?
I didn't found anything in the wiki.

[zev]

All new documentation is added there:
https://www.netxms.org/documentation/adminguide/index.html

Information about file management:
https://www.netxms.org/documentation/adminguide/file-management.html
https://www.netxms.org/documentation/adminguide/subagents.html#filemgr-subagent-label

[user54119]

Thank you. I was looking in the wiki.
Is the file management subagent only available on linux agents?

[zev]

Should work on all platforms. Tested also on Windows.

Windows path:
RootFolder = C:\log

[user54119]

I installed the windows agent by the 'nxagent-1.2.15-x64.exe' but there is no File Management Subagent in the subagent selection list of the installer (only ecs.nsm, ping.nsm, logwatch.nsm, portcheck.nsm, winperf.nsm, wmi.nsm, ups.nsm) and there is no 'filemgr.nsm' file in the 'bin'-directory after installation.
In log file I get:

Error loading subagent module "filemgr.nsm": The specified module could not be found.

[lindeamon]

wooooooooohooooooooooo

finally. i will wait for the fix of the missing nsm file and then...
partyyyyyyyyyyyy

[lindeamon]

Hi,

was the problem with the filemgr.nsm fixed ? can i download ?

10x,
Lindeamon

[victor]

Hi,

I forgot to include filemgr.nsm into binary package. I'll repack agent installer soon. For now filemgr.nsm for Windows x64 attached.

Best regards,
Victor
 

---

filemgr.nsm

[victor]

and for Windows x86

---

filemgr.nsm

[andrey--k]

System: Debian 7
DB: Oracle 11.2

Upgrade troubles

Upgrading database...
Upgrading from version 318 to 319
Upgrading from version 319 to 320
Upgrading from version 320 to 321
Upgrading from version 321 to 322
SQL query failed (ORA-01440: column to be modified must be empty to decrease precision or scale):
ALTER TABLE users MODIFY system_access number(20)
Rolling back last stage due to upgrade errors...
Database upgrade failed

After truncate table users
appeared:

$ nxdbmgr upgrade
NetXMS Database Manager Version 1.2.15 Build 7881

Upgrading database...
Upgrading from version 321 to 322
SQL query failed (ORA-01440: column to be modified must be empty to decrease precision or scale):
ALTER TABLE user_groups MODIFY system_access number(20)
Rolling back last stage due to upgrade errors...
Database upgrade failed

upd.
All ok.
I have made backup, truncated data and restored.
nxdbmgr upgrade finished in 40 minutes.

[lindeamon]

hi victor,

how soon will you do it ? i want to download a full working version without extra files.

Best Regards,
Lindeamon

[andrey--k]

Debian 7
Oracle 11

An error apears after upgrade

Target: INSERT INTO dc_tables (node_id,template_id,template_item_id,name,description,flags,source,snmp_port,polling_interval,retention_time,status,system_tag,resource_id,proxy_node,perftab_settings,transformation_script,comments,item_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Alert: ORA-00947: not enough values