I am struggling with Circular References.
Finished executing project 'Discovery_Hub' Execution Package 'Report Booking' Execution failed
Start Time : 8/21/2025 11:52:42 AM
End Time : 8/21/2025 11:52:42 AM
on server: TX-SERVER-DEV -Execute Execution Package Report Booking 'Failed'
'Execute DSA DSA_F.Management Data Cleansing Rules' has a circular relation with the following steps:
'Execute DSA DSA_TX.sub_agrDIM_RentContract Data Cleansing Rules'
'Fill Aggregate Table DSA_TX.sub_agrDIM_RentContract'
'Execute DSA DSA_F.RentContract Data Cleansing Rules'
The execution job Report Booking uses DSA_F.Management, but not DSA_TX.sub_agrDim_RentContracts.
I have also tried excluding DSA_TX.sub_agrDim_RentContracts from the execution job, but it still fails.
What i find strange is that when i run the following tables individually, i do not get any errors:
DSA_F.Management
DSA_TX.sub_agrDIM_RentContract
Also, DSA_TX.sub_agrDIM_RentContract is not the part of Report Booking prespective
Only when i run the execution job, the job fails