Charmap not working in Postgresql- OGG-02132 Invalid character mapping definition
(Doc ID 2561427.1)
Last updated on MARCH 02, 2020
Applies to:Oracle GoldenGate - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
When using CHARMAP to map 0x00 to \x20(space), the postgresql replicat abends with error
2019-05-01 11:31:01 ERROR OGG-02132 Invalid character mapping definition
\x00 \x20 in the character mapping file ./dirprm/charmapdesc.txt.
The following was the contents of the charmapdesc.txt
The table have a column Cus_code which is char(3) and has three 0x00 value which cause the issue
2019-04-01 07:57:00 WARNING OGG-01154 SQL error 3452617 mapping
$QA04.NQA1TBLT.ERRORTBL to lvfui.errortbl [SQL error 3452617
(0x34aec9)][Oracle][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR:
invalid byte sequence for encoding "UTF8": 0x00(File wchar.c; Line 2017;
Routine report_invalid_encoding; ).
As REPLACEBADCHAR won't work tried to use charmap and the above error happened.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document