SAP Knowledge Base Article - Preview

3374988 - Error: "java.sql.SQLException: [Databricks][DatabricksJDBCDriver](500638) The file *** has not been downloaded successfully" when replicate through Databricks


  • Setup Connection through CamelJDBCAdapter to Databricks
  • Try to replicate from a large table failed with error:"java.sql.SQLException: [Databricks][DatabricksJDBCDriver](500638) The file *** has not been downloaded successfully and the driver will not retry due to exceeding of the max retry limit 10"
  • Enable jdbc trace by appending LogLevel=6;LogPath=<agent_installed_folder>/log to "JDBC URL" property in connection URL, reproduce the error again and check jdbc trace with following error
    "com.databricks.client.spark.jdbc.ResultFileDownloadHandler.isFileDownloadSuccessfully: Got an ErrorException when waiting for download to complete: FILE_DOWNLOAD_TIEMOUT Encountered an IOException during downloading"



SAP HANA Smart Data Integration


SAP HANA smart data integration 2.0


Cameljdbcadapter, datasphere, dwc, url, cloud, time out, timeout, Error when persistsing View:
{"code":403, "message":"internal error: \"SPACE_NAME\".\"$$VIEW_MATERIALIZATION_INSERT_DATA$$\": line 163 col 7 (at pos 4745): Prefetch timed out. "errorMessage":"SQL error 403: internal error: \"SPACE_NAME\".\"$$VIEW_MATERIALIZATION_ON$$\": line 206 col 7 (at pos 7515): internal error: \"SPACE_NAME\".\"$$VIEW_MATERIALIZATION_INSERT_DATA$$\": line 163 col 7 (at pos 4745): Prefetch timed out.\n at SQLScript/Executor/Evaluator/SeEvaluatorImpl_ControlFlow.cpp:315" "message":"internal error: Prefetch timed out.
at ptime/query/plan_executor/dml/hex/; Statement: ,INSERT INTO  , KBA , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , DS-DI , Data Integration/Data Builder , DS-DI-RT , Remote Tables , DS-DI-CON , Connections , DS-DI-VIW , View Persistency and Runtime , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.