NUll pointer exception while connecting to snowflake DB

Six Stars

NUll pointer exception while connecting to snowflake DB

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

Moderator

Re: NUll pointer exception while connecting to snowflake DB

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: NUll pointer exception while connecting to snowflake DB

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

Re: NUll pointer exception while connecting to snowflake DB

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: NUll pointer exception while connecting to snowflake DB

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

 

Screen Shot 2018-08-27 at 1.43.35 PM.png

 

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)

 

 

Moderator

Re: NUll pointer exception while connecting to snowflake DB

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.