Null Pointer error : While exporting data to Snowflake

ManojKalorey
ManojKalorey
in Integrations and extensibility

Hello Team ,

I am getting NULL POINTER error while exporting data to snowflake , below are the development scrips and error screenshot .

Anaplan connect version: anaplan_connect_4.2.1

Snowflake drivers used: Almost tried with all latest snowflake-jdbc-3.13.22 / 3.21/3.16

Error:

I am able to import the csv file but it is not initiating the jdbc to export it . even i tested by loading import csv i my system and i can get the csv file in my system.

image.png
image.png

My Dat file :

image.png

My Property file :

jdbc.connect.url=jdbc:snowflake://<Myaccount>.azure.snowflakecomputing.com/?user=manojkal&warehouse=BI_WH&db=BI_DB&schema=STAGING&role=SNOWFLAKE_N&authenticator=externalbrowser
jdbc.batch.size=1000
jdbc.query=INSERT INTO TABLE(Col1,Col2,col3 till 17 column) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);
#jdbc.params="","","","","","","","","","","","","","","","",""

Tagged:

Answers

  • michs23
    michs23

    The Anaplan Connect export to Snowflake encounters a "Null Pointer" error. Verify JDBC driver compatibility, connection Learn more string accuracy, data file formatting, and column mapping. Enable debug logging and inspect the stack trace. If issues persist, contact Anaplan Support, consider alternative export methods, or explore using Anaplan Data Hub.

Categories