After upgrading from 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.
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.
Note: If the ADO version is updated to 6.1.7601.17857 or above, this will remedy SCAP evaluations yielding the error
Worker Process terminated.