Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Martin Kyukov 36 posts 231 karma points
    Apr 23, 2020 @ 14:35
    Martin Kyukov
    0

    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:

    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.

  • Martin Kyukov 36 posts 231 karma points
    Apr 24, 2020 @ 08:04
    Martin Kyukov
    101

    To reply to my own question - I had to set:

    <!-- VALID Values: Verbose, Debug, Information, Warning, Error, Fatal -->
    <add key="serilog:minimum-level" value="Verbose" />
    

    In config/serilog.config to be able to see the queries that cause problems.

Please Sign in or register to post replies

Write your reply to:

Draft