My Oracle Support Banner

OGGBD - PathMappingTemplate and optimestamp (Doc ID 2945274.1)

Last updated on JANUARY 17, 2024

Applies to:

Oracle GoldenGate Big Data and Application Adapters - Version and later
Information in this document applies to any platform.


In Golden Gate Big Data Adapter, using file adapter to generate the files to Google Cloud Bucket and as part of it want to create a folder and then store the Json file in that.

When using



The replicat fail with error like

2023-04-10 11:51:34 INFO OGG-03010 Performing implicit conversion of column data from character set CESU-8 to UTF-8.

Exception in thread "main" oracle.goldengate.util.GGException: Error detected handling operation added event.

at oracle.goldengate.datasource.UserExitDataSource.addOperationToTransactionAndFireEvent(


From Replicat log


ERROR 2023-04-10 11:51:20.000442 [TaskEngine_2(FileFinalizeTask)] - An exception occurred in an event handler execute call.

java.lang.NullPointerException: null

at oracle.goldengate.datasource.mapping.TimestampMappingMethodology.performMapping( ~[ggaddons-]

at oracle.goldengate.datasource.mapping.TemplateNameMapper.performMapping( ~[ggaddons-]

at oracle.goldengate.eventhandler.objectstore.gcs.GCSEventHandler.execute( ~[gggcseh-]

at oracle.goldengate.datasource.eventhandler.EventHandlerFramework.executeHandlers( [ggaddons-]

at oracle.goldengate.handler.filewriter.FileFinalizeManager$ [ggfw-]

at [ggutil-]

at java.util.concurrent.ThreadPoolExecutor.runWorker( [?:1.8.0_291]

at java.util.concurrent.ThreadPoolExecutor$ [?:1.8.0_291]

at [ggutil-]

INFO 2023-04-10 11:51:34.000495 [main] - == JNI == setSourceIsTable(false)

INFO 2023-04-10 11:51:34.000497 [main] - Metadata changed <Schema>.<Table name>

INFO 2023-04-10 11:51:34.000497 [main] - == JNI == setRecOpts for table[<Schema>.<Table name>]: insertUpdates[false] insertDeletes[false]

WARN 2023-04-10 11:51:34.000509 [main] - Error sending event to listener filewriter, status: ABEND, event: Add operation

If using currentTimestamp it works but when using opTimestamp it does not

Below is the property which is working with currentTimestamp


Do we have a option to capture only date from the opTimestamp, something like ${opTimestamp[yyyy-MM-dd] ?




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

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