token with getenv bugs in 11.2.1 and 12.1
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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:
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.
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