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