Saturday, June 7, 2014

OGG-01028 : Formatting error on: table name schema_name.table_name, rowi d AACjvQAFtAAAFYrAAA, XID 1155.38.90011, position (Seqno 125631, RBA 1673159256). Error converting timestamp with timezone from Oracle to ASCII format for column xxx.

One of the extract group failed with the above error today on 10g database:

Formatting error on: table name SCHEMA_NAME.TABLE_NAME, rowi
d AACjvQAFtAAAFYrAAA, XID 1155.38.90011, position (Seqno 125631, RBA 1673159256). Error converting timestamp with timezone from Oracle to ASCII format for column COLUMN_NAME.

Metalink Note: 1558791.1 says that this is db bug and apply a patch 15947884.

The other Note: 1350728.1 (OGG Extract support for Data Type TIMESTAMP WITH TIME ZONE, Oracle to ASCII) says that:
Extract requires the TRANLOGOPTIONS INCLUDEREGIONID or INCLUDEREGIONIDWITHOFFSET to support this data type correctly.

For now, added below to extract parameter and started the extract and it's running fine:
TRANLOGOPTIONS INCLUDEREGIONID

The other option might be considered is by adding below right before userid:
setenv (nls_lang="AMERICAN_AMERICA.US7ASCII")


No comments:

Post a Comment