We implemented the AD synch trigger on our Deployment Solution to ensure our DS structure matched our AD structure

https://www-secure.symantec.com/connect/downloads/updated-version-sql-trigger-sync-ds-computer-group-structure-active-directory

We are using the updated version with fixes to some of the known issues. This trigger has been working fine and adding groups to the structure etc.

We have recently seen some machines appearing in the console that do not have hardware and software information listed even though this information is being collected by the client.

When troubleshooting with Symantec support we found several logs in the Application Log like this

Event ID 1
Category None
Source Altiris Deployment Server
Database Error: The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

These are also accompanied by
EventID 3
Category None
Source Altiris Deployment Server
update computer set node_type = 3, aclient_ver = '6.9.366 (32 Bit)', model_num = 'DQ45CB', prod_name = 'RM EXPERT 3040', os = 'Windows XP Professional 5.1.2600 (Service Pack 3)', os_bit = '32', ip_hostname = 'mowa120-5', lic_os_key = '76487-640-6734332-23515', lic_os_org = 'Information Services', lic_os_user = 'Information Services', domain_member = 1, computer_name = 'MOWA120-5', domain_name = 'UNIVERSITY', msnet_dns_domain = 'university.brighton.ac.uk', msnet_domain_ou = 'learning network/workstations/testing', bw_ip_addr = NULL, uac = 0, logged_on_user = null,manuf = 'RM plc', limited_license = 0, asset_tag = 'WO53787401', serial_num = 'WO53787401', uuid = '{A64ED80F-8370-DD11-B2AC-00E01884FCE4}', svs_agent_ver = '2.1.2081', time_zone_index = 85, bios_release_date = '11/17/2008', bios_version = 'CBQ4510H.86A.0065.2008.1117.1553', name = 'MOWA120-5', os_type = 2, hidden = null where computer_id = 5005316

When we removed the trigger we found that these errors went away

We have now had to leave the trigger out, but would appreciate it if anyone with a better knowledge of SQL might be able to answer this one?

We are running:

Windows Server 2003 SP2 Enterprise Edition
SQL 2005
Deployment Solution 6.9 SP1