GoldenGate

Hi,

I'm testing the sample configuration from Oracle Docs for the new release of Oracle Goldengate For Big Data (12.3.2.1.0). My scenario is a test to replicate data from goldengate to S3 in Parquet file format. The properties file is based on this documentation sample.

I adjusted the properties file to match my environment information, though the replicat keeps failing with error:

May 18, 2018 10:10:22 AM oracle.goldengate.datasource.UserExitMain main
SEVERE: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userExitDataSource' defined i
n class path resource [oracle/goldengate/datasource/DataSource-context.xml]: Bean instantiation via factory method failed; ne
sted exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [oracle.goldengate.datasource.G
GDataSource]: Factory method 'getDataSource' threw exception; nested exception is oracle.goldengate.util.ConfigException: The
 path mapping template is null or empty.  Please configure the pathMappingTemplate configuration property and restart.

But I configured the "pathMappingTemplate" as you can see in my properties file:

gg.handlerlist=filewriter
#The handler properties
gg.handler.name.type=filewriter
gg.handler.name.mode=op
gg.handler.name.pathMappingTemplate=./dirout
gg.handler.name.stateFileDirectory=./dirsta
gg.handler.name.fileNameMappingTemplate=${fullyQualifiedTableName}_${currentTimestamp}.txt
gg.handler.name.fileRollInterval=7m
gg.handler.name.finalizeAction=delete
gg.handler.name.inactivityRollInterval=7m
gg.handler.name.format=avro_row_ocf
gg.handler.name.includetokens=true
gg.handler.name.partitionByTable=true
gg.handler.name.eventHandler=parquet
gg.handler.name.rollOnShutdown=true
gg.eventhandler.parquet.type=parquet
gg.eventhandler.parquet.pathMappingTemplate=./dirparquet
gg.eventhandler.parquet.writeToHDFS=false
gg.eventhandler.parquet.finalizeAction=delete
gg.eventhandler.parquet.eventHandler=s3
gg.eventhandler.parquet.fileNameMappingTemplate=${fullyQualifiedTableName}_${currentTimestamp}.parquet
gg.handler.filewriter.eventHandler=s3
gg.eventhandler.s3.type=s3
gg.eventhandler.s3.region=sa-east-1
#gg.eventhandler.s3.proxyServer=www-proxy.us.oracle.com
#gg.eventhandler.s3.proxyPort=80
gg.eventhandler.s3.bucketMappingTemplate=datalake-hom
gg.eventhandler.s3.pathMappingTemplate=${groupName}/${fullyQualifiedTableName}
gg.eventhandler.s3.finalizeAction=none
gg.classpath=/mnt2/aws-java-sdk-1.11.331/lib/*;/mnt2/aws-java-sdk-1.11.331/third-party/lib/
javawriter.bootoptions=-Xmx512m -Xms32m
#jvm.bootoptions=-Xmx512m -Xms32m -Djava.class.path=ggjava/ggjava.jar
-Djava.class.path=ggjava/ggjava.jar
-Daws.accessKeyId=your_access_key
-Daws.secretKey=your_secret_key

Any ideas on this possible causes for this issue?

Regards,

Jeison Junqueira.