I've noticed this before, but I finally took time to catch some log info so I can post this; I've tried a factory reset (to erase the DB) and backup restore... but these errors keep popping up in the ACC Daemon Log:
2010:10:14-15:50:29 myacc accd: 546109 [0xa6a4dba0] ERROR server.device.AggregatedItem null - Transformation of inline reporting data failed (SQL constraint violation) [259F38DC-C8EF-11DF-8C9B-86322487616E;aggregated.netsec]
2010:10:14-15:51:11 myacc accd: 587759 [0xafa5fba0] ERROR libs.db.TransactionObject null - execute( INSERT INTO aggregated_netsec_fw_targets VALUES('259F38DC-C8EF-11DF-8C9B-86322487616E','2010-10-01',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.xx.***'),acc_get_service_id('(tcp/27977)'),acc_get_protocol_id('tcp'),27977,138),('259F38DC-C8EF-11DF-8C9B-86322487616E','2010-10-01',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.xx.***'),acc_get_service_id('(tcp/8085)'),acc_get_protocol_id('tcp'),8085,129),('259F38DC-C8EF-11DF-8C9B-86322487616E','2010-10-01',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.xx.***'),acc_get_service_id('SOCKS (tcp/1080)'),acc_get_protocol_id('tcp'),1080,36),('259F38DC-C8EF-11DF-8C9B-86322487616E','2010-10-01',acc_get_country_id('US'),acc_get_ipaddr_id('***.xx.***.***'),acc_get_service_id('TINCAN (tcp/1935)'),acc_get_protocol_id('tcp'),1935,34),('259F38DC-C8EF-11DF-8C9B-86322487616E','2010-10-01',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.xx.***'),acc_get_service_id('CSLISTENER (tcp/9000)'),acc_get_protocol_id('tcp'),9000,31),('259F38DC-C8EF-11DF-8C9B-86322487616E','2010-10-01',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.xx.***'),acc_get_service_id('(tcp/8090)'),acc_get_protocol_id('tcp'),8090,30),('259F38DC-C8EF-11DF-8C9B-86322487616E','2010-10-01',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.xx.***'),acc_get_service_id('DVT-SYSTEM (tcp/3246)'),acc_get_protocol_id('tcp'),3246,23),('259F38DC-C8EF-11DF-8C9B-86322487616E','2010-10-01',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.xx.***'),acc_get_service_id('(tcp/9415)'),acc_get_protocol_id('tcp'),9415,22),('259F38DC-C8EF-11DF-8C9B-86322487616E','2010-10-01',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.xx.***'),acc_get_service_id('(tcp/41990)'),acc_get_protocol_id('tcp'),41990,20),('259F38DC-C8EF-11DF-8C9B-86322487616E','2010-10-01',acc_get_country_id('LAN'),acc_get_ipaddr_id('10.99.99.99'),acc_get_service_id('(tcp/9415)'),acc_get_protocol_id('tcp'),9415,18),('259F38DC-C8EF-11DF-8C9B-86322487616E'
2010:10:14-15:51:11 myacc accd: 587759 [0xafa5fba0] ERROR server.device.AggregatedTransformer null - transactional update for guid '259F38DC-C8EF-11DF-8C9B-86322487616E' on item 'aggregated_netsec' for date '2010-10-01' failed
2010:10:14-15:51:11 myacc accd: 587760 [0xafa5fba0] ERROR server.device.AggregatedItem null - Transformation of inline reporting data failed (SQL constraint violation) [259F38DC-C8EF-11DF-8C9B-86322487616E;aggregated.netsec]
2010:10:14-15:51:13 myacc accd: 589310 [0xa7a4fba0] ERROR libs.db.TransactionObject null - execute( INSERT INTO aggregated_netsec_fw_targets VALUES('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-08',acc_get_country_id('LAN'),acc_get_ipaddr_id('***.xx.x.xx'),acc_get_service_id('DOMAIN (udp/53)'),acc_get_protocol_id('udp'),53,520),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-08',acc_get_country_id('UNKNOWN'),acc_get_ipaddr_id('***.xx.x.xx'),acc_get_service_id('DOMAIN (udp/53)'),acc_get_protocol_id('udp'),53,267),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-08',acc_get_country_id('LAN'),acc_get_ipaddr_id('***.xx.x.xx'),acc_get_service_id('SNMP (udp/161)'),acc_get_protocol_id('udp'),161,27),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-08',acc_get_country_id('LAN'),acc_get_ipaddr_id('***.xx.x.xx'),acc_get_service_id('LDAP (udp/389)'),acc_get_protocol_id('udp'),389,22),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-08',acc_get_country_id('LAN'),acc_get_ipaddr_id('***.xx.x.xx'),acc_get_service_id('DOMAIN (udp/53)'),acc_get_protocol_id('udp'),53,11),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-08',acc_get_country_id('US'),acc_get_ipaddr_id('***.xx.x.xx'),acc_get_service_id('DOMAIN (udp/53)'),acc_get_protocol_id('udp'),53,10),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-08',acc_get_country_id('US'),acc_get_ipaddr_id('***.xx.x.xx'),acc_get_service_id('DOMAIN (udp/53)'),acc_get_protocol_id('udp'),53,10),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-08',acc_get_country_id('US'),acc_get_ipaddr_id('***.xx.x.xx'),acc_get_service_id('(ICMP)'),acc_get_protocol_id('icmp'),0,9),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-08',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.162.94'),acc_get_service_id('HTTP-ALT (tcp/8080)'),acc_get_protocol_id('tcp'),8080,8),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-08',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.162.90'),acc_get_service_id('IRDMI (tcp/8000)'),acc_get_protocol_id('tcp'),8000,7),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-08'
2010:10:14-15:51:13 myacc accd: 589310 [0xa7a4fba0] ERROR server.device.AggregatedTransformer null - transactional update for guid '873ED174-99F1-11DF-9199-FDBC42C5C4E5' on item 'aggregated_netsec' for date '2010-08-08' failed
2010:10:14-15:51:13 myacc accd: 589310 [0xa7a4fba0] ERROR server.device.AggregatedItem null - Transformation of inline reporting data failed (SQL constraint violation) [873ED174-99F1-11DF-9199-FDBC42C5C4E5;aggregated.netsec]
2010:10:14-15:51:43 myacc accd: 619838 [0xaf25eba0] ERROR libs.db.TransactionObject null - execute( INSERT INTO aggregated_netsec_fw_targets VALUES('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-06',acc_get_country_id('US'),acc_get_ipaddr_id('***.xx.x.xx'),acc_get_service_id('(tcp/64902)'),acc_get_protocol_id('tcp'),64902,60),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-06',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.162.94'),acc_get_service_id('(udp/17309)'),acc_get_protocol_id('udp'),17309,56),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-06',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.162.84'),acc_get_service_id('(udp/50176)'),acc_get_protocol_id('udp'),50176,40),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-06',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.162.89'),acc_get_service_id('(udp/58992)'),acc_get_protocol_id('udp'),58992,31),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-06',acc_get_country_id('US'),acc_get_ipaddr_id('***.xx.x.xx'),acc_get_service_id('(udp/33555)'),acc_get_protocol_id('udp'),33555,28),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-06',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.162.87'),acc_get_service_id('(tcp/30780)'),acc_get_protocol_id('tcp'),30780,27),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-06',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.162.87'),acc_get_service_id('(udp/30780)'),acc_get_protocol_id('udp'),30780,23),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-06',acc_get_country_id('US'),acc_get_ipaddr_id('xx.***.162.89'),acc_get_service_id('(udp/20326)'),acc_get_protocol_id('udp'),20326,19),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-06',acc_get_country_id('US'),acc_get_ipaddr_id('***.xx.x.xx'),acc_get_service_id('(tcp/45536)'),acc_get_protocol_id('tcp'),45536,18),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-06',acc_get_country_id('US'),acc_get_ipaddr_id('***.xx.x.xx'),acc_get_service_id('(tcp/33555)'),acc_get_protocol_id('tcp'),33555,18),('873ED174-99F1-11DF-9199-FDBC42C5C4E5','2010-08-06',acc_get
2010:10:14-15:51:43 myacc accd: 619840 [0xaf25eba0] ERROR server.device.AggregatedTransformer null - transactional update for guid '873ED174-99F1-11DF-9199-FDBC42C5C4E5' on item 'aggregated_netsec' for date '2010-08-06' failed
2010:10:14-15:51:43 myacc accd: 619840 [0xaf25eba0] ERROR server.device.AggregatedItem null - Transformation of inline reporting data failed (SQL constraint violation) [873ED174-99F1-11DF-9199-FDBC42C5C4E5;aggregated.netsec]
This thread was automatically locked due to age.