To resolve the issue, please do the following:
For Clarity version below 15.4.1 (steps 0-3)
0. Download the Stored Procedure attached for 15.4 and lower (it's already included with PPM 15.4.1 and above).
1. Create the Stored Procedure by running the scripts for versions below 15.4.1 on the Data Warehouse database
For Clarity version above 15.4.1 (steps 2-3)
2. Backup your trending tables if you need to.
3. Now run the Stored Procedure by connecting to the Data Warehouse database and executing:
Note you have to replace the DBLINK and database name/schema with the appropriate values.
EXEC DWH_TRD_CLEANUP_TRENDS_SP @P_DBLINK='PPMDBLINK.niku.niku'
This should fix the synchronization issue.