token with getenv bugs in 11.2.1 and 12.1 (Doc ID 1948440.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

When improving a performance issue through bug 17709470, several fixes were involved and caused some side effects.
The final fix is in bug 18085944. This Node lists the symptoms of those bugs:

Sympotoms:

1. 12c/11.2 classic extract Performance degradation, in compared with 11.1, when using tokens. 

2. Extract abends:

     OGG-00369 Error in token clause for TK-ORAENV-DBUSER = @GETENV('ORAENVIRONMENT','DBUSER'

3. Initial load failed as it requires runtime parsing for @GETENV() 

4. TOKEN w/ GETENV("TRANSACTION","USERNAME") is NULL when using nodynamicresolution.

5. REPLICAT ABENDS:

     ERROR OGG-01163 Bad column length (8) specified for column ... in table ..., maximum allowable length is 1.

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