CSS Tools - Backup - Fatal Error - character 0xe28099 of encoding UTF8 has no equivalent in LATIN1

Problem Description

Using CSSBackup, the process fails with the error below :

[XMLtoDB] SQL Error: ERROR:  character 0xe28099 of encoding “UTF8” has no equivalent in “LATIN1” (Severity 1, Msg# 1).

The wrong character number can change.

The error is due to a UTF8 Character entered as a comment of a violation that was marked for ‘Exclusion’.

Applicable in CAST Version

ReleaseYes/No
8.3.x✅

Action Plan

  1. Remove using the query below the non ascii characters and replace it with a ?

update DSS_ENGINE_EXCEPTION set COMMENT = regexp_replace(COMMENT, ‘[^a-zA-Z0-9 \s\n\t\r.,:!_-;/]’, ‘?’, ‘g’)


**Notes / Comments**

**Related Pages**