Is it possible to enable the logging of the query that failed to execute? Or any kind of extra-detailed logging? I am hitting an issue in RebuildPublishedSnapshot that is throwing a collation exception:
System.Data.SqlClient.SqlException (0x80131904): Cannot resolve collation conflict between \"Danish_Norwegian_CI_AS\" and \"SQL_Latin1_General_CP1_CI_AS\" in CASE operator occurring in SELECT statement column 35
As far as I'm aware the only way to fix this is to change the collation of a column/table to the correct one, but I don't know which is the problematic table or column.
Umbraco 8 content migration - detailed failed query logging
Is it possible to enable the logging of the query that failed to execute? Or any kind of extra-detailed logging? I am hitting an issue in RebuildPublishedSnapshot that is throwing a collation exception:
As far as I'm aware the only way to fix this is to change the collation of a column/table to the correct one, but I don't know which is the problematic table or column.
To reply to my own question - I had to set:
In
config/serilog.config
to be able to see the queries that cause problems.is working on a reply...