Sign in Register
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.

    Copy Link
  • 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.

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies