We have Analysis Server cubes on SQL 2016/Windows 2019 environment.
Using dtexec to process the weekly cubes often fails or if it succeeds then Last Update date is not stamped (Only Last processed date is refreshed)
The Error from dtexec is:
Description: Server: The current operation was cancelled because another operation in the transaction failed.
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (4) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
However, the same cubes when processed from SSDT 2017 Visual studio Full Processing is always successful and both dates are stamped correctly - Last Updated and Last processed.
Why is there a difference in both?
I need to schedule this weekly once, hence am using Dtexec via a batch file.
Many thanks in advance