After applying the 2.202 code update we get strange behavior when deploying network definitions to ASG 8.102 devices. The definition will get deployed, but is shown as "pending" or "error" in the ACC and the log shows the following messages:
2011:03:03-08:59:52 wdacc accd: 72363903 [0xa1a10ba0] ERROR libs.db.TransactionObject null - execute( INSERT INTO aggregated_netsec_fw_targets VALUES('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-02-06',acc_get_country_id('LAN'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('HTTP (tcp/80)'),acc_get_protocol_id('tcp'),80,3607),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-02-06',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('(ICMP)'),acc_get_protocol_id('icmp'),0,54),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-02-06',acc_get_country_id('LAN'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('HTTP-ALT (tcp/8080)'),acc_get_protocol_id('tcp'),8080,30),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-02-06',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('EPMAP (tcp/135)'),acc_get_protocol_id('tcp'),135,13),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-02-06',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('MICROSOFT-DS (tcp/445)'),acc_get_protocol_id('tcp'),445,12),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-02-06',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('TELNET (tcp/23)'),acc_get_protocol_id('tcp'),23,8),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-02-06',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('SSH (tcp/22)'),acc_get_protocol_id('tcp'),22,8),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-02-06',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('HTTP (tcp/80)'),acc_get_protocol_id('tcp'),80,8),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-02-06',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('MS-SQL-S (tcp/1433)'),acc_get_protocol_id('tcp'),1433,5),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-02-06',acc_get_country_id('US'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('HTTP (tcp/80)'),acc_get_protocol_id('tcp'),80,4),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011
2011:03:03-08:59:52 wdacc accd: 72363903 [0xa1a10ba0] ERROR server.device.AggregatedTransformer null - transactional update for guid 'BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2' on item 'aggregated_netsec' for date '2011-02-06' failed
2011:03:03-08:59:52 wdacc accd: 72363904 [0xa1a10ba0] ERROR server.device.AggregatedItem null - Transformation of inline reporting data failed (SQL constraint violation) [BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2;aggregated.netsec]
2011:03:03-08:59:55 wdacc accd: 72367639 [0xa5217ba0] ERROR libs.db.TransactionObject null - execute( INSERT INTO aggregated_netsec_fw_targets VALUES('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-01-15',acc_get_country_id('US'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('HTTP (tcp/80)'),acc_get_protocol_id('tcp'),80,144),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-01-15',acc_get_country_id('US'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('HTTP (tcp/80)'),acc_get_protocol_id('tcp'),80,66),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-01-15',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('(ICMP)'),acc_get_protocol_id('icmp'),0,54),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-01-15',acc_get_country_id('US'),acc_get_ipaddr_id('321.1.1.1'),acc_get_service_id('HTTP (tcp/80)'),acc_get_protocol_id('tcp'),80,42),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-01-15',acc_get_country_id('US'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('HTTPS (tcp/443)'),acc_get_protocol_id('tcp'),443,36),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-01-15',acc_get_country_id('LAN'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('HTTP-ALT (tcp/8080)'),acc_get_protocol_id('tcp'),8080,33),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-01-15',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('TELNET (tcp/23)'),acc_get_protocol_id('tcp'),23,22),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-01-15',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('(tcp/9363)'),acc_get_protocol_id('tcp'),9363,21),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-01-15',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('MICROSOFT-DS (tcp/445)'),acc_get_protocol_id('tcp'),445,10),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2011-01-15',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('MS-WBT-SERVER (tcp/3389)'),acc_get_protocol_id('tcp'),3389,9),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F
2011:03:03-08:59:55 wdacc accd: 72367640 [0xa5217ba0] ERROR server.device.AggregatedTransformer null - transactional update for guid 'BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2' on item 'aggregated_netsec' for date '2011-01-15' failed
2011:03:03-08:59:55 wdacc accd: 72367640 [0xa5217ba0] ERROR server.device.AggregatedItem null - Transformation of inline reporting data failed (SQL constraint violation) [BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2;aggregated.netsec]
2011:03:03-09:00:00 wdacc accd: 72372067 [0xada28ba0] ERROR libs.db.TransactionObject null - execute( INSERT INTO aggregated_netsec_fw_targets VALUES('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2010-12-19',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('(ICMP)'),acc_get_protocol_id('icmp'),0,54),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2010-12-19',acc_get_country_id('LAN'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('HTTP-ALT (tcp/8080)'),acc_get_protocol_id('tcp'),8080,30),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2010-12-19',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('MICROSOFT-DS (tcp/445)'),acc_get_protocol_id('tcp'),445,15),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2010-12-19',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('TELNET (tcp/23)'),acc_get_protocol_id('tcp'),23,11),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2010-12-19',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('SSH (tcp/22)'),acc_get_protocol_id('tcp'),22,9),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2010-12-19',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('MS-SQL-S (tcp/1433)'),acc_get_protocol_id('tcp'),1433,8),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2010-12-19',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('(tcp/4899)'),acc_get_protocol_id('tcp'),4899,8),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2010-12-19',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('EPMAP (tcp/135)'),acc_get_protocol_id('tcp'),135,7),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2010-12-19',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('MYSQL (tcp/3306)'),acc_get_protocol_id('tcp'),3306,6),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','2010-12-19',acc_get_country_id('DE'),acc_get_ipaddr_id('1.1.1.1'),acc_get_service_id('(tcp/9363)'),acc_get_protocol_id('tcp'),9363,5),('BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2','
2011:03:03-09:00:00 wdacc accd: 72372068 [0xada28ba0] ERROR server.device.AggregatedTransformer null - transactional update for guid 'BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2' on item 'aggregated_netsec' for date '2010-12-19' failed
2011:03:03-09:00:00 wdacc accd: 72372068 [0xada28ba0] ERROR server.device.AggregatedItem null - Transformation of inline reporting data failed (SQL constraint violation) [BB10015E-B9E9-11DF-AD6C-8FA4BE44B4F2;aggregated.netsec]
2011:03:03-09:16:32 wdacc accd: 73364591 [0xafa2cba0] WARN server.device.DeploymentCallback null - deploy global objects for device 1F039962-C725-11DF-B391-9F111492BC5C failed: 10403
Is this a know issue?
Thanks,
Ronny
This thread was automatically locked due to age.
