EXTRACT abend Unable to convert an Oracle NUMBER attribute to a CHARACTER string. OCI Error OCI-22061: invalid format text [TM9] (Doc ID 1585073.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.5 and later
Information in this document applies to any platform.

Symptoms

 EXTRACT is abending with

TABLE resolved (entry APPLSYS.WF_ITEM_ATTRIBUTE_VALUES):
  TABLE "APPLSYS"."WF_ITEM_ATTRIBUTE_VALUES";
Using the following key columns for source table APPLSYS.WF_ITEM_ATTRIBUTE_VALUES: ITEM_TYPE, ITEM_KEY, NAME.

2013-09-16 16:21:15  ERROR   OGG-06100  Unable to convert an Oracle NUMBER attribute to a CHARACTER string. OCI Error OCI-22061: invalid format text [TM9].

2013-09-16 16:21:15  ERROR   OGG-01668  PROCESS ABENDING.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms