Snowflake Extension failing with JDBC driver internal error

Products

• CA Application Performance Management (APM / Wily / Introscope)

Issue/Introduction

After start the Agent we can see below exception over the logs, also no metrics is generated:

ERROR

7/31/23 04:04:22 PM EDT [ERROR] [IntroscopeAgent.DBMonitor]
net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: exception creating result java.lang.ExceptionInInitializerError at net.snowflake.client.jdbc.internal.apache.arrow.memory.UnsafeAllocationManager.<clinit>(UnsafeAllocationManager.java:27).
        at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQueryInternal(SnowflakeStatementV1.java:291)
        at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQuery(SnowflakeStatementV1.java:140)
        at com.ca.agent.extensions.dbmon.commands.DBMonExecuteQueryCommand.fireAndUpdateMetric(DBMonExecuteQueryCommand.java:158)
        at com.ca.agent.extensions.dbmon.commands.DBMonExecuteQueryCommand.execute(DBMonExecuteQueryCommand.java:123)
        at com.ca.agent.extensions.dbmon.DBMonChain.run(DBMonChain.java:66)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.base/java.lang.Thread.run(Unknown Source)

Environment

Release : 23.2

Resolution

You can workaround this exception by adding the below entry into wrapper.conf from Snowflake application:

set.JDK_JAVA_OPTIONS=--add-opens java.base/java.nio=ALL-UNNAMED