Can't seem to validate this error.

Hi,

The validation takes into account all the application languages. Could it be that not in all languages the translations match the db value? You can also negate this validation by not adding it as a Sorting column for tables.

Hope this helps!

This is the validation query (2023.1) in its core, you can look into the exists queries of it. Maybe there's a duplicate translation? From my position is it difficult to tell why the validation returns what it returns

declare @model_id model_id = ''
      , @branch_id branch_id = ''

select
    d.model_id as pk_col_1,
    d.branch_id as pk_col_2,
    d.dom_id   as pk_col_3
from dom d
where d.model_id = @model_id 
  and d.branch_id = @branch_id 
  and exists (
            select 1 
            from col c
            where c.model_id = d.model_id
              and c.branch_id = d.branch_id
              and c.dom_id = d.dom_id
              and c.sort_no is not null)
  and exists (
    select 1 from (
        -- Ordered by translation
        select e.elemnt_id, t.appl_lang_id, row_number() over(partition by t.appl_lang_id order by t.transl) as nr
        from elemnt e
        join transl_object_transl t
          on t.model_id = e.model_id
         and t.branch_id = e.branch_id
         and t.type_of_object = 2 --dom_elemnt
         and t.transl_object_id = e.elemnt_id
        where e.model_id = d.model_id 
          and e.branch_id = d.branch_id
          and e.dom_id = d.dom_id

        except
        -- Ordered by db value
        select e.elemnt_id, t.appl_lang_id, row_number() over(partition by t.appl_lang_id order by e.db_value)
        from elemnt e
        join transl_object_transl t
          on t.model_id = e.model_id
         and t.branch_id = e.branch_id
         and t.type_of_object = 2 --dom_elemnt
         and t.transl_object_id = e.elemnt_id
        where e.model_id = d.model_id 
          and e.branch_id = d.branch_id
          and e.dom_id = d.dom_id
    ) a
  )

(Replace model_id / branch_id with project_id / project_vrs_id in case of 2022.2 or older)