Bug NetXMS 2.1/Linux, Agent Policy with UTF-8 gets truncated

[twenrich]

Hi,

installing a policy containing german Umlauts might truncate my policy file.

I just added a comment like below:

Query = Query.smv01.Sync.CountExpQError:smv01:3600:SELECT count(*) FROM AKMSync.dbo.expandedqueue with (nolock) WHERE status = 'ERROR'
Query = Query.smv01.Sync.CountSyncQError:smv01:3600:SELECT count(*) FROM AKMSync.dbo.synchronizationqueue with (nolock) WHERE status = 'ERROR'

# Überwachung Backups

Query = Query.TEST_Folio01.Backup.CountNoFull:test_folio01:3600:SELECT count(*) FROM sys.sysdatabases db WHERE db.name != 'tempdb' AND not exists(SELECT 1 FROM msdb.dbo.backupset bck WHERE bck.database_name = db.name AND bck.backup_finish_date > dateadd(DAY, -8, current_timestamp) AND bck.type = 'D')
Query = Query.TEST_Folio02.Backup.CountNoFull:test_folio02:3600:SELECT count(*) FROM sys.sysdatabases db WHERE db.name != 'tempdb' AND not exists(SELECT 1 FROM msdb.dbo.backupset bck WHERE bck.database_name = db.name AND bck.backup_finish_date > dateadd(DAY, -8, current_timestamp) AND bck.type = 'D')
Query = Query.Folio01.Backup.CountNoFull:prod_folio01:3600:SELECT count(*) FROM sys.sysdatabases db WHERE db.name != 'tempdb' AND not exists(SELECT 1 FROM msdb.dbo.backupset bck WHERE bck.database_name = db.name AND bck.backup_finish_date > dateadd(DAY, -8, current_timestamp) AND bck.type = 'D')
Query = Query.Folio02.Backup.CountNoFull:prod_folio02:3600:SELECT count(*) FROM sys.sysdatabases db WHERE db.name != 'tempdb' AND not exists(SELECT 1 FROM msdb.dbo.backupset bck WHERE bck.database_name = db.name AND bck.backup_finish_date > dateadd(DAY, -8, current_timestamp) AND bck.type = 'D')
# Query = Query.TEST_Folio02.Backup.CountNoFull:test_folio02:3600:SELECT count(*) FROM sys.sysdatabases db WHERE db.name != 'tempdb' AND not exists(SELECT 1 FROM msdb.dbo.backupset bck WHERE bck.database_name = db.name AND bck.backup_finish_date > dateadd(DAY, -8, current_timestamp) AND bck.type = 'D')
# Query = Query.TEST_Folio02.Backup.CountNoFull:test_folio02:3600:SELECT count(*) FROM sys.sysdatabases db WHERE db.name != 'tempdb' AND not exists(SELECT 1 FROM msdb.dbo.backupset bck WHERE bck.database_name = db.name AND bck.backup_finish_date > dateadd(DAY, -8, current_timestamp) AND bck.type = 'D')
# Query = Query.TEST_Folio02.Backup.CountNoFull:test_folio02:3600:SELECT count(*) FROM sys.sysdatabases db WHERE db.name != 'tempdb' AND not exists(SELECT 1 FROM msdb.dbo.backupset bck WHERE bck.database_name = db.name AND bck.backup_finish_date > dateadd(DAY, -8, current_timestamp) AND bck.type = 'D')

The resulting file in /usr/local/var/lib/netxms/config_ap looks like

...
Query = Query.smv01.Sync.CountSyncQError:smv01:3600:SELECT count(*) FROM AKMSync.dbo.synchronizationqueue with (nolock) WHERE status = 'ERROR'

# berwachung Backups

Query = Query.TEST_Folio01.Backup.CountNoFull:test_folio01:3600:SELECT count(*) FROM sys.sysdatabases db WHERE db.name != 'tempdb' AND not exists(SELECT 1 FROM msdb.dbo.backupset bck WHERE bck.dat

Removing the Umlaut in the comment transfers the entire file.

Kind regards,
Thomas

[victor]

Hi,

I've registered it as a bug. Are you using UNICODE version of netxmsd (you can check by running netxmsd -v)?

Best regards,
Victor

[twenrich]

Are you using UNICODE version of netxmsd (you can check by running netxmsd -v)?

NetXMS Server Version 2.1 Build 9012 (2.1-RELEASE) (UNICODE)
NXCP: 4.48.1.11 (AES-256, Blowfish-256, IDEA, 3DES, AES-128, Blowfish-128)
Built with: g++ (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11)

Kind regards,
Thomas