Talend v8 - R2025-10 - Snowflake JDBC -tDBInput Error java.lang.NullPointerException: null

[Mediaocean]

I am getting following issue during the Talend upgrade from 8.0 R2025-07v2 to R2025-10. Can you please help?

After the Talend upgrade, Snowflake JDBC tDBInput getting error as below.

INFO: Connecting to GLOBAL Snowflake domain [FATAL] 00:49:45 etl.main- tDBInput_1 null java.lang.NullPointerException: null at java.util.Objects.requireNonNull(Objects.java:209) ~[?:?] at java.util.stream.Collectors.lambda$uniqKeysMapAccumulator$1(Collectors.java:180) ~[?:?] at java.util.stream.ReduceOps$3ReducingSink.accept(ReduceOps.java:169) ~[?:?] at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179) ~[?:?] at java.util.HashMap$EntrySpliterator.forEachRemaining(HashMap.java:1850) ~[?:?] at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[?:?] at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) ~[?:?]

For the Snwoflake database connection, we need to use JDBC data component (snowflake-jdbc-3.22 driver) using Key Pair Authentication. We cannot use native snowflake data object.

I reversed upgrade and back to R2025-07v2 - not getting this error.

I tried R2025-09 - getting same issue.

[Shicong_Hong]

@Mediaocean This appears to be a bug. Could you kindly share us with a simple example Job that we can use to reproduce and investigate the issue? Please ensure to conceal the actual database connection information from the Job.

Regards

Shicong

[Mediaocean]

Hi Shicong

I have attached the exported files. I confirmed code worked on 8.0 R2025-07v2 but not from the latest R2025-10.

note: please create your own p8 key file for Key Pair Authentication.

Thank you for your support.

Paul Lee