NetXMS Support Forum

Судя по логу падает сервер при исполнении transformation скрипта на каком-то DCI при работе с SNMP из скрипта. Сейчас попробую разобратся почему.

Попробуйте запустить

nxdbmgr check

и поудалять все битые объекты.

Ну да, обрезается. Я просто думал что реальная длинна меньше, просто из-за того, что Oracle может определять длинну поля в байтах а не символах (это определяет NLS_LENGTH_SEMANTICS) реально поле создалось меньшей длинны. Я могу увеличить размер имени обьекта, но это уже будет только в следующем релизе.

Quote from: andrey--k on March 24, 2014, 09:55:46 AM
Netxms snapshot (2014-03-21)
Debian 7
Oracle 11g
Сделал переинициализацию БД. Выскакивают следующие ошибки:

Code Select Expand


[24-Mar-2014 04:22:09.876] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63)
[24-Mar-2014 04:22:09.876] [DEBUG] EVENT 52 (ID:40123 F:0x0001 S:4 TAG:"") FROM i0mon2.bank.gov.ua: Database query failed (Query: INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); Error: ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63))
[24-Mar-2014 04:22:09.879] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 87, maximum: 63)
[24-Mar-2014 04:22:09.879] [DEBUG] EVENT 52 (ID:40124 F:0x0001 S:4 TAG:"") FROM i0mon2.bank.gov.ua: Database query failed (Query: INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); Error: ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 87, maximum: 63))
[24-Mar-2014 04:22:09.881] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63)
[24-Mar-2014 04:22:09.881] [DEBUG] EVENT 52 (ID:40125 F:0x0001 S:4 TAG:"") FROM i0mon2.bank.gov.ua: Database query failed (Query: INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); Error: ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63))
[24-Mar-2014 04:22:09.883] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63)
[24-Mar-2014 04:22:09.883] [DEBUG] EVENT 52 (ID:40126 F:0x0001 S:4 TAG:"") FROM i0mon2.bank.gov.ua: Database query failed (Query: INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); Error: ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63))



Some objects have too long names. Max acceptable name is 63 characters. I suspect this could be due to encoding of Russian characters. I will check this. As a workaround, you can expand column name in table object_properties to varchar(127).

Best regards,
Victor

Hi!

So nxdbmgr can login to database? That's very strange, because both nxdbmgr and netxmsd uses same library and same config. Just in case please show me your pg_hba.conf.

Best regards,
Victor

Hi!

Currently NetXMS does not support port layout detection and just uses most common layout to display ports. I have plans that driver will provide also port layout to GUI so ports can be displayed correctly. One of the next versions will have this implemented.

Best regards,
Victor

You mean "disable network discovery polling"? If this option is on node will not be polled for network discovery information (information in it's ARP cache and routing table will not be used to find potential new nodes).

Best regards,
Victor

Hi!

Can you do the following on node with failed upgrade:

1. check agent version by running

nxagentd.exe -v

2. If version was changed, check for errors in agent's log (or Windows event log) - maybe something prevents it from starting. Then try to start agent manually.

Best regards,
Victor

Hi!

This is one of the most mysterious bugs I've encounter during NetXMS development Let's wait for a few days to see if problem disappears. In 1.2.12 we found somewhat different problem with subnet objects being duplicated, and fixed this in 1.2.13. Not sure if this is related though.

Best regards,
Victor

Hi!

Yes, there is a bug in portcheck subagent - you can only use IP address. I already fix that. If you need it before next release, I can provide updated subagent binary. If you are building NetXMS from source, you can replace inet_addr with ResolveHostNameA in file src/agent/subagents/portcheck/net.cpp line 40 and rebuild.

Best regards,
Victor

Hi!

You can create your own list on agent using ExternalList configuration option. Agent will execute command given and return all it's output as list elements. For example, to add list which will return all files in /tmp, add the following to nxagentd.conf:


ExternalList = TemporaryFiles:/bin/ls /tmp


Best regards,
Victor

В новой версии формат базы новее. Запустите обновление схемы на новом сервере:

nxdbmgr upgrade

Update: I've repacked source archive - now it should work on Ubuntu.

Best regards,
Victor

Sorry, due to mistake fix for this bug didn't get to release. I'll repack source code package with fix included. I can also repack deb packages if someone uses them on Ubuntu.

Best regards,
Victor

Hi all!

NetXMS version 1.2.13 is out. Changes since previous release:

- Improved layer 2 topology discovery performance
- Special handling of incorrect LLDP data provided by some D-Link switches
- Optimizations in NXCP processing
- Added driver for Cisco Small Business switches
- Improved file retrieve from agent
- Windows agent: added service list and service table (System.Services)
- Fixed bug with SQL initialization script generation on HP-UX
- Fixed Oracle DB initialization error
- New macro %K (alarm key) in event actions
- Management console:
   - Implemented alarm sounds
   - Fixed "broken pipe" errors
   - Macros with alarm data in object tools
   - Added option "Manage image library" in user access rights property page
   - Fixed image upload in web console
- Added support for sticky acknowledge in nxalarm tool
- Fixed bug causing excessive memory usage by AIX agent
- Fixed bug with interface status detection if agent runs in Solaris zone
- Fixed agent crash if HTTPS service status requested
- Android Console:
   - Fix bug missing hide notification alarm in status bar
   - Implemented "Font size in graph/dashboard sessions" (Feature #240)
- Fixed issues: #109, #240, #425, #428, #438, #462, #466, #471, #493, #507, #508, #527

Best regards,
Victor