My Oracle Support Banner

Microservices : Edit Utility (EDIT Params <process_name>) In Adminclient Is Removing Trailing Comma In Parameter File (Doc ID 2978601.1)

Last updated on JANUARY 08, 2024

Applies to:

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

Symptoms

In Microservices, when editing parameter file in microservices using " EDIT PARAMS <NAME>”, it is removing , (comma) in end of multi line statement and causing process to abend.
example :
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------
MAP <owner>.<tab1>, TARGET <owner>.<tab1>,
COLMAP(USEDEFAULTS),
FILTER(ON UPDATE,(
(@STREQ(@IF(@COLTEST(@BEFORE (<col1>),MISSING,NULL),0,@BEFORE (<col1>)), ◄◄◄◄ Before editing Commas are existing
@IF(@COLTEST(@AFTER (<col1>),MISSING,NULL),0, @AFTER (<col1>))) = 0 ) OR
(@STREQ(@IF(@COLTEST(@BEFORE (<col2>),MISSING,NULL),0,@BEFORE (<col2>)), ◄◄◄◄◄
@IF(@COLTEST(@AFTER (<col2>),MISSING,NULL),0, @AFTER (<col2>))) = 0 ) OR
...........
---------------------------------------
Use EDIT PARAMS <NAME> and just saving using :q! , Comma ‘,’ in end disappears automatically as mentioned below

---------------------------------------
MAP <owner>.<tab1>, TARGET <owner>.<tab1>,
COLMAP(USEDEFAULTS),
FILTER(ON UPDATE,(
(@STREQ(@IF(@COLTEST(@BEFORE (<col1>),MISSING,NULL),0,@BEFORE (<col1>)) ◄◄◄◄◄ After editing Commas are disappearing
@IF(@COLTEST(@AFTER (<col1>),MISSING,NULL),0, @AFTER (<col1>))) = 0 ) OR
(@STREQ(@IF(@COLTEST(@BEFORE (<col2>),MISSING,NULL),0,@BEFORE (<col2>)) ◄◄◄◄
@IF(@COLTEST(@AFTER (<col2>),MISSING,NULL),0, @AFTER (<col2>))) = 0 ) OR
.........
---------------------------------------

 

- Tried creating new parameter file with "edit params <name>" , it is still showing same issue
- Editing from vi and GUI is working fine
- When using ‘&’ after each line in Multi-line parameter statement then it is working fine

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.