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
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
Quote
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