Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 1 subscriber
  • Views 948 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

ACC 2.202 - definition deployment error

rbremer
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.
Parents
  • 0
    Hello Ronny,
    no this issue is new, your are the first who reported it.I have tried to reproduce it and deployed some global objects using ACC2.202 to an ASG8.102 and it worked without any errors. So far as I can see from your log file inserting aggregated netsec data fails due to an incorrect ip address '1. 1.1.1' with an superfluous whitespace. But its not clear where that incorrect ip address comes from.

    If its possible for you to give us access to the ACC and one of the ASGs on which the deployment fails, you would help us a lot to find out the reason for that problem. If that's not possible, please also send us the lines of the accd.log before any error is logged and the device-agent.log of one of the ASGs on which the deployment fails.

    Regards
    Peter
Reply
  • 0
    Hello Ronny,
    no this issue is new, your are the first who reported it.I have tried to reproduce it and deployed some global objects using ACC2.202 to an ASG8.102 and it worked without any errors. So far as I can see from your log file inserting aggregated netsec data fails due to an incorrect ip address '1. 1.1.1' with an superfluous whitespace. But its not clear where that incorrect ip address comes from.

    If its possible for you to give us access to the ACC and one of the ASGs on which the deployment fails, you would help us a lot to find out the reason for that problem. If that's not possible, please also send us the lines of the accd.log before any error is logged and the device-agent.log of one of the ASGs on which the deployment fails.

    Regards
    Peter
Children
No Data
Unfiltered HTML