Deleting Change Log Entries in Sparkrock 2016

Information 

• Products: Sparkrock 2016 
• Summary: Deleting Change Log Entries in Sparkrock 2016 

Details

This Knowledge Base Article (KBA) provides instructions for deleting change log entries in Sparkrock 2016. The change log records the modifications made to data in the system and can accumulate over time, potentially impacting performance or consuming storage space

Resolution

To delete change log entries in Sparkrock 2016, follow these steps: 

Option 1: Deleting Change Log Entries via the Application 

1. Open the Sparkrock 2016 application. 
2. Go to the "Change Log Setup" page. 
3. Set the appropriate filters to specify the range of change log entries you want to delete. For example, you can filter by table, date, or specific records. 
4. Select the desired entries to delete. 
5. Choose the "Delete" option to remove the selected change log entries from the system. 

Option 2: Deleting Change Log Entries via SQL. If you prefer to delete change log entries directly through SQL, you can use one of the following options: 

a) Delete by Date Use the following SQL statement to delete change log entries older than a specific date, such as January 1, 2016: 

DELETE FROM "NAV_PROD$Change Log Entry" WHERE CAST("Date and Time" AS DATE) <= '01/01/2016'  

 

b) Delete by Age Use the following SQL statement to delete change log entries older than a certain number of months, such as 6 months: 

DELETE FROM "NAV_PROD$Change Log Entry" WHERE CAST("Date and Time" AS DATE) < DATEADD(MONTH, -6, GETDATE())  

Please exercise caution when performing SQL operations and ensure you have appropriate backups before executing any delete statements directly in the database. 

Impact / Risks: 

• Deleting change log entries permanently removes historical data and may affect auditing and tracking capabilities.
• It is recommended to create a backup of the database before executing any SQL statements to ensure data integrity.

Workaround

Not applicable. 

Related Information

For more information and discussions on deleting change log entries in Sparkrock 2016, you can refer to the Dynamics Community forum thread: Truncate ChangeLog entries 

Update History

The following are the dates and actions pertinent to the history of this issue. 

Attachment

Not Applicable.