SAP Knowledge Base Article - Preview

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

Symptom

  • 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
    com.databricks.client.spark.jdbc.ResultFileDownloadHandler.run: Encountered an IOException during downloading"


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

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/qe_hex_search.cc:484; 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.