topic NUll pointer exception while connecting to snowflake DB in Talend Studio

NUll pointer exception while connecting to snowflake DB

Sat, 16 Nov 2024 08:12:23 GMT

hi team,

i receive the bellow mentioned error when i tried to transfer huge datas from SAP table to Snowflake DB, whereas i tested to transfer some sample datas(10 rows including null values) from excel file to snowflake, it operates well. but comming to above mentioned scenario, i got this following error

SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/C:/Users/GAIN/workspace/.Java/lib/slf4j-log4j12-1.7.16.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/C:/Users/GAIN/workspace/.Java/lib/slf4j-log4j12-1.7.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
[statistics] connecting to socket on port 3930
[statistics] connected
[FATAL]: testgis.rak_knvv_0_1.RAK_KNVV - tSnowflakeOutput_1 null
java.lang.NullPointerException
at org.talend.daikon.di.DiIncomingSchemaEnforcer.put(DiIncomingSchemaEnforcer.java:318)
at testgis.rak_knvv_0_1.RAK_KNVV.tSAPTableInput_1Process(RAK_KNVV.java:2849)
at testgis.rak_knvv_0_1.RAK_KNVV.runJobInTOS(RAK_KNVV.java:6250)
at testgis.rak_knvv_0_1.RAK_KNVV.main(RAK_KNVV.java:6056)
Exception in component tSnowflakeOutput_1 (RAK_KNVV)
java.lang.NullPointerException
at org.talend.daikon.di.DiIncomingSchemaEnforcer.put(DiIncomingSchemaEnforcer.java:318)
at testgis.rak_knvv_0_1.RAK_KNVV.tSAPTableInput_1Process(RAK_KNVV.java:2849)
at testgis.rak_knvv_0_1.RAK_KNVV.runJobInTOS(RAK_KNVV.java:6250)
at testgis.rak_knvv_0_1.RAK_KNVV.main(RAK_KNVV.java:6056)
[statistics] disconnected

pls help me in this regard

Re: NUll pointer exception while connecting to snowflake DB

Anonymous — Wed, 30 May 2018 09:45:06 GMT

Hello,

Your input column from SAP has null value? Is there any of the columns set to be not nullable and should be nullable?

Generally tLogRow should help to get which data is null. You can check it by using tSAPXXX-->tLogRow.

Best regards

Sabrina

Re: NUll pointer exception while connecting to snowflake DB

Wed, 30 May 2018 11:02:48 GMT

hi,
there is no null values in the input, even thogh this error comes

Re: NUll pointer exception while connecting to snowflake DB

Anonymous — Tue, 05 Jun 2018 09:49:10 GMT

Hello,

Could you please post your current job design screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

Re: NUll pointer exception while connecting to snowflake DB

ashish_pandey — Mon, 27 Aug 2018 18:46:59 GMT

i am trying to upload data from delimited file to snowflake but getting below error -

I am able to read data from snowflake table but not able to write. I have permission to do that. I can insert using same credential through tJdbc component.

@xdshi wrote:

Hello,

Could you please post your current job design screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

Starting job snowflakeconnection at 13:40 27/08/2018.

[statistics] connecting to socket on port 3670

[statistics] connected

Aug 27, 2018 1:40:38 PM net.snowflake.client.loader.StreamLoader start

INFO: No Transaction started

Aug 27, 2018 1:40:39 PM net.snowflake.client.core.SFStatement execute

INFO: execute: select C1, C2 from MYTABLE where C1='1'

Aug 27, 2018 1:40:40 PM net.snowflake.client.loader.StreamLoader throttleUp

INFO: PUT Throttle Up: 1

Aug 27, 2018 1:40:40 PM net.snowflake.client.core.SFStatement execute

INFO: execute: PUT file:///private/var/folders/xw/0q5d3xtj01z07m9fbyhw7sl5qh2wnm/T/snowflake/stage/MYTABLE/INSERT/20180827_134038_960_xEQC9j_1/stream_20180827_134038_9600.gz '@~/MYTABLE/INSERT/20180827_134038_960_xEQC9j_1' parallel=10 overwrite=true auto_compress=false source_compression=gzip

Aug 27, 2018 1:40:40 PM net.snowflake.client.loader.FileUploader run

SEVERE: Failed to PUT on attempt: attempt=[0], Message=[javax/activation/MimeTypeParseException]

java.lang.ClassNotFoundException: javax.activation.MimeTypeParseException

at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:582)

at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:185)

at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:496)

at net.snowflake.client.core.SFStatement.executeFileTransfer(SFStatement.java:543)

at net.snowflake.client.core.SFStatement.executeQuery(SFStatement.java:144)

at net.snowflake.client.core.SFStatement.execute(SFStatement.java:529)

at net.snowflake.client.jdbc.SnowflakeStatementV1.executeInternal(SnowflakeStatementV1.java:204)

at net.snowflake.client.jdbc.SnowflakeStatementV1.execute(SnowflakeStatementV1.java:239)

at net.snowflake.client.loader.FileUploader.run(FileUploader.java:111)

at java.base/java.lang.Thread.run(Thread.java:844)

Re: NUll pointer exception while connecting to snowflake DB

Anonymous — Tue, 28 Aug 2018 03:50:57 GMT

Hello,

On which talend build version you got this issue? What's JDK version are you using? All required external jar files have been already installed in your studio?

Best regards

Sabrina