After upgrading from Symantec Control Compliance Suite Windows (CCS) 11.5.2 (SCU 2017-1) up to CCS 12 (SCU 2017-3), Windows Data Collection begins to fail and a variety of queries will fail as well after a short duration.
This can include Windows Assets which originally reported back without error and any machine reporting to a CCS Manager with a Data Collector Role. Windows Patch Assessment queries will fail as well as included IIS Standards to ensure Compliance is achieved will also fail.
Windows Server 2008 R2
Worker Process terminated
It has been observed in prior environments for a few Assets after executing an evaluation job for Security Content Automation Protocol (SCAP) will fail. This is due to ActiveX Data Objects (ADO) not equivalent or greater than the recommended version:
ADO is used to help CCS complete SQL queries and display information at a textual level.