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

3 REPLIES
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.