Charmap not working in Postgresql- OGG-02132 Invalid character mapping definition (Doc ID 2561427.1)

Last updated on FEBRUARY 05, 2024

Applies to:

Oracle GoldenGate - Version 12.2.0.1.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

SOURCECHARSET ISO-8859-1

TARGETCHARSET UTF-8

\x00 \x20

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

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.