java.lang.NullPointerException while connecting snowflake with using user defined Java routine

[PMurari1675362631]

Hello,

We are using user defined encryption and decryption java routine and calling it in tmap, it's working fine but when we open snowflake connection within job, it's throwing "NullPonter Exception" error.

The Bonnycastle libraries that being used in java code not supporting snowflake connection. 

Please find attached job and log and let me know if you need anything else.

Thanks

[Anonymous]

Hello @Prasad Murari​ ,

To help us understand your issue, could you please give a snapshot of the issue and provide the job execution error log for more investigation? thanks a lot

[Anonymous]

I don't see any relationship between tDBConnection (snowflake connection) and the subjob you use the java routine, if you deactivate the subjob (starting from tFileInputDelimited_7) and only keep tDBConnection component in the job, run the job again and let us know if you have the same error?

[PMurari1675362631]

It will work if only tDBConnection but when we keep it and run the flow it thrown error, see another example below it trying to brings the data from snowflake and loads into file but it thrown same error.

Basically, whenever it uses snowflake connection component, its giving same error. Our observation is uses of Bonnycastle libraries in java routine ne causing it ?