DataStage - Data Integration

 View Only

Datastage Oracle - Snowflake Load From File unexpected Error

  • 1.  Datastage Oracle - Snowflake Load From File unexpected Error

    Posted Tue June 22, 2021 05:38 PM
    Hi everyone,
    we are trying to load a table from an Oracle Db to a Snwoflake Db using Load From file feature of the Snowflake connector.
    The Snowflake connector is able to perform all the steps, including the copy into stament on the Snowflake Database, but after that it returns an error:

    Snowflake_Connector_2: java.lang.NullPointerException
    at com.ibm.is.cc.snowflake.SnowflakeAdapter.postRun (SnowflakeAdapter.java: 685)
    Snowflake_Connector_2: Java runtime exception occurred: java.lang.NullPointerException (com.ibm.is.cc.snowflake.SnowflakeAdapter::postRun, file SnowflakeAdapter.java, line 685)
    Snowflake_Connector_2: The connector closed the connection to the data source.
    main_program: Fatal Error: Operator(PXBridgeOp) terminated abnormally due to fatal error in the function postRun

    It seems that the connector is not able to delete the Snowflake's stage, but also disabling the delete stage option it returns the same error.

    The Connector has all the grant as it works as SYSADMIN.

    ------------------------------
    Riccardo Papotti
    ------------------------------