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
Release
Yes/No
8.3.x(tick)
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