Configuration imports fails due to unsupported operations that write to the log file
In case you are using SQL Server 2014 or older in standard edition, the Configuration import profile might fail with:
The current transaction cannot be committed and cannot support operations that write to the log file.
If that happens, it can be fixed by:
- modifying
[dbo].CCreateColumnstoreIndexes]
in the ODW database, so it skips all the logic. - running the Configuration import profile again