Golden Gate同步至Microsoft Fabric镜像数据库遇Azure身份验证错误

操作系统：Oracle Linux 8 #

SDK依赖： #

• onelake v12.20.0
• hadoop v3.4.0
• parquet v1.12.0

问题描述 #

尝试将<OGG_HOME>/opt/AdapterExamples/trail中的示例trail文件同步至Microsoft Fabric工作区的镜像数据库（Mirrored Database），启动Replicat进程时遇到如下错误：
Azure Identity => ERROR in getToken() call for scopes [https://storage.azure.com/.default]: java.io.UncheckedIOException: io.netty.channel.StacklessClosedChannelException

已使用Python脚本通过azure-identity (1.10.0)和azure-storage-file-datalake (12.8.0)库验证凭据，成功列出Fabric数据湖仓库（Fabrics Lakehouse）中的文件。

以下为Replicat test1的属性文件及Replicat报告文件中的完整错误信息：

Replicat test1的属性文件 #

将GoldenGate trail操作记录加载至Microsoft Fabric中镜像数据库的配置：

gg.target=fabric_mirrored_database
#TODO: Edit the Fabric workspace name.
gg.eventhandler.onelake.workspace=fabric
#TODO: Edit the Fabric mirror name.
gg.eventhandler.onelake.mirror=testfabricdb
#TODO: Edit the tenant ID of the application.
gg.eventhandler.onelake.tenantId=<tenant id>
#TODO: Edit the client ID of the application.
gg.eventhandler.onelake.clientId=<client id>
#TODO: Edit the client secret for the authentication.
gg.eventhandler.onelake.clientSecret=<secret>
#TODO: Edit the classpath to include Hadoop, Parquet, and Azure DataLake SDK dependencies.
gg.classpath=/u01/app/oracle/product/ogg/opt/DependencyDownloader/dependencies/hadoop_3.4.0/:/u01/app/oracle/product/ogg/opt/DependencyDownloader/dependencies/parquet_1.12.3/:/u01/app/oracle/product/ogg/opt/DependencyDownloader/dependencies/onelake/*
#TODO: Edit the proxy configuration.
#jvm.bootoptions=-Dhttps.proxyHost=some-proxy-address.com -Dhttps.proxyPort=80 -Djava.net.useSystemProxies=true

Replicat报告文件中的完整错误信息： #

ERROR 2024-12-25 11:24:48.000991 [ForkJoinPool.commonPool-worker-5] - {"az.sdk.message":"Retry attempts have been exhausted.","exception":"io.netty.channel.StacklessClosedChannelException","tryCount":3}
=ERROR 2024-12-25 11:24:48.000991 [ForkJoinPool.commonPool-worker-5] - io.netty.channel.StacklessClosedChannelException
=ERROR 2024-12-25 11:24:48.000992 [ForkJoinPool.commonPool-worker-5] - Azure Identity => ERROR in getToken() call for scopes [https://storage.azure.com/.default]: java.io.UncheckedIOException: io.netty.channel.StacklessClosedChannelException
=ERROR 2024-12-25 11:24:48.000992 [ForkJoinPool.commonPool-worker-5] - {"az.sdk.message":"Failed to acquire a new access token.","exception":"java.io.UncheckedIOException: io.netty.channel.StacklessClosedChannelException"}
=ERROR 2024-12-25 11:24:48.000996 [TaskEngine_5(FileFinalizeTask)] - ONELAKE-00053 Error occurred while uploading a file to Microsoft Fabric OneLake. Inspect the replicat handler log file and the replicat report file for further troubleshooting. Contact Oracle support if you cannot resolve the error.

内容的提问来源于stack exchange，提问作者Khudoyberdi Rahimov