_EMPTYTOSPACE And _EMPTYTOSPACENULLABLE Parameters Not Working On OGG BigData 21.4
(Doc ID 2928665.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate Big Data and Application Adapters - Version 21.4.0.0.0 and laterInformation in this document applies to any platform.
Goal
When receiving message with a column having NULL value, the user wants it to convert to EMPTY value.
User has tried _EMPTYTOSPACE And _EMPTYTOSPACENULLABLE parameters and found that it is not working for REPLICAT on OGG 21.4 BigData adapter.
-----
2023-02-02T12:31:49.908-0500 ERROR OGG-10144 Oracle GoldenGate Delivery, <processname>.prm: (<processname>.prm) line 4: Parameter [_EMPTYTOSPACE] is not valid for this configuration.
2023-02-02T12:31:49.908-0500 ERROR OGG-01668 Oracle GoldenGate Delivery, <processname>.prm: PROCESS ABENDING.
-----
2023-02-02T12:48:36.918-0500 ERROR OGG-10144 Oracle GoldenGate Delivery, <processname>.prm: (<processname>.prm) line 5: Parameter [_EMPTYTOSPACENULLABLE] is not valid for this configuration.
2023-02-02T12:48:36.918-0500 ERROR OGG-10143 Oracle GoldenGate Delivery, <processname>.prm: (<processname>.prm) line 4: Parameter [#_EMPTYTOSPACE] is unrecognized. No parameter definition with that name could be found.
2023-02-02T12:48:36.991-0500 ERROR OGG-01668 Oracle GoldenGate Delivery, <processname>.prm: PROCESS ABENDING.
-------
Please advise which parameter we can use to convert NULL VALUE to EMPTY value.
Solution
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
| Goal |
| Solution |
| References |