NUll pointer exception while connecting to snowflake DB

[#1]

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

[Anonymous]

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

 

[#3]

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

[Anonymous]

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

[ashish_pandey]

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)

[Anonymous]

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