Duplicate entries in the symcICDxEventData table in the CSM_Reports Database for CCS
search cancel

Duplicate entries in the symcICDxEventData table in the CSM_Reports Database for CCS

book

Article ID: 282351

calendar_today

Updated On:

Products

Control Compliance Suite Standards Server Control Compliance Suite Control Compliance Suite Standards Module

Issue/Introduction

After running the spGenerateCCSEventDataForICDx, there are now duplicate entries in the symcICDxEventData in Control Compliance Suite.

Resolution

It was found that the stored procedure had been run more than once at a time, which caused the duplication in the database.

If duplicates show up and need assistance with removing those, open a ticket with support for assistance.