https://community.databricks.com/t5/data-engineering/informatica-cloud-mapping-with-databricks-connection-failing/m-p/6860#M2862 <P>@Mahesh D​&nbsp;:</P><P></P><P>Based on the error message, it seems that the issue could be related to the JDBC driver used by Informatica Cloud to connect to Databricks.</P><P>Here are a few suggestions you can try to troubleshoot the issue:</P><OL><LI>Ensure that you have the correct JDBC driver version installed in Informatica Cloud to connect to Databricks. You may need to update the driver version to be compatible with your Databricks cluster.</LI><LI>Verify that the Databricks connection properties (such as host, port, and authentication) are correctly configured in Informatica Cloud.</LI><LI>Check that the SQL query is correctly formatted and that it returns valid results when run in Databricks.</LI><LI>Try running the SQL query in a different SQL editor to ensure that it works correctly.</LI><LI>Check the logs for any additional error messages that might provide more information about the issue.</LI><LI>Contact Informatica Cloud support for further assistance.</LI></OL><P>I hope this helps you resolve the issue. Let me know if you have any further questions or concerns.</P><P></P><P></P><P></P><P></P> Sun, 02 Apr 2023 14:02:19 GMT Anonymous 2023-04-02T14:02:19Z https://community.databricks.com/t5/data-engineering/informatica-cloud-mapping-with-databricks-connection-failing/m-p/6859#M2861 <P>Hi Team,</P><P></P><P>When we tried to configure our source with Databricks table with Databricks connection on Informatica Cloud, we received below error.</P><P></P><P>We already tried the suggestions mentioned in the below community post which seems to be similar error as ours.</P><P></P><P><A href="https://community.databricks.com/s/question/0D53f00001HKIEHCA5/while-loading-data-from-blob-to-delta-lake-facing-below-issue" target="test_blank">https://community.databricks.com/s/question/0D53f00001HKIEHCA5/while-loading-data-from-blob-to-delta-lake-facing-below-issue</A></P><P></P><P>The highlighted query is running fine on Databricks SQL editor. </P><P></P><P>Please review and advise</P><P></P><P>READER_1_1_1&gt; DATABRICKSDELTA_10000 [2023-03-30 03:49:33.654] [INFO] SQL QUERY: <B>SELECT `hash_key`,`mre_code`,`mre_mrcc` FROM `sitsint`.`eidb_men_mre` WHERE EIDB_MEN_MRE.RECORD_STATUS&lt;&gt;'D'</B></P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.704] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P><B>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.705] [ERROR] java.util.NoSuchElementException</B></P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.705] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.705] [ERROR] at java.util.StringTokenizer.nextToken(StringTokenizer.java:349)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.705] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.705] [ERROR] at com.simba.spark.jdbc.common.BaseConnectionFactory.acceptsURL(Unknown Source)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.705] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.705] [ERROR] at com.simba.spark.jdbc.common.AbstractDriver.connect(Unknown Source)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.705] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.705] [ERROR] at java.sql.DriverManager.getConnection(DriverManager.java:664)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.705] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.705] [ERROR] at java.sql.DriverManager.getConnection(DriverManager.java:270)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.705] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.705] [ERROR] at com.informatica.adapter.databricksdelta.runtime.adapter.DatabricksdeltaDatabricksdeltaDataConnection.connect(DatabricksdeltaDatabricksdeltaDataConnection.java:124)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.705] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.705] [ERROR] at com.informatica.adapter.databricksdelta.runtime.adapter.read.DeltaJdbcReader.initDataSession(DeltaJdbcReader.java:73)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.705] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.705] [ERROR] at com.informatica.adapter.databricksdelta.runtime.adapter.DatabricksdeltaDatabricksdeltaDataAdapter.beginDataSession(DatabricksdeltaDatabricksdeltaDataAdapter.java:145)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.705] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.705] [ERROR] at com.informatica.cci.runtime.impl.CDataAdapterImpl.read(CDataAdapterImpl.java:195)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.705] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.705] [ERROR] at com.informatica.cci.cloud.client.impl.CCIRuntimeDataClientImpl.readData(CCIRuntimeDataClientImpl.java:306)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.705] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.705] [ERROR] at com.informatica.cloud.api.adapter.cci.reader.CCIRdrPartitionDriver.run(CCIRdrPartitionDriver.java:322)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; DATABRICKSDELTA_10000 [2023-03-30 03:49:33.710] [FATAL] databricksdelta_EXCEPTION_OCCURED_205</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; DATABRICKSDELTA_10000 [2023-03-30 03:49:33.710] [ERROR] The following error occurred: [com.informatica.adapter.sdkadapter.exceptions.AdapterSDKException: [SDK_APP_COM_20000] error [No suitable driver found for EnableArrow=0;UID=token;PWD=dapif35000b8a83f7c61714477a7d4c95f68;UserAgentEntry=Informatica_IICS;]]</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; DATABRICKSDELTA_10000 [2023-03-30 03:49:33.710] [ERROR] Read Failed. Internal Error: Adapter BeginDataSession failed</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; DATABRICKSDELTA_10000 [2023-03-30 03:49:33.710] [ERROR] Error occured while reading data using CCI Data Adapter&nbsp;com.informatica.cci.runtime.internal.utils.impl.CExceptionImpl: Read Failed. Internal Error: Adapter BeginDataSession failed</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; CONNECTOR_10000 [2023-03-30 03:49:33.710] [ERROR] Error Occured while reading data from the source for Transformation - SQ_EIDB_MEN_MRE | Connector Name - databricksdelta - Read Failed. Internal Error: Adapter BeginDataSession failed</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.710] [ERROR] com.informatica.cci.cloud.client.impl.CCIClientExceptionImpl: Read Failed. Internal Error: Adapter BeginDataSession failed</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.710] [ERROR] at com.informatica.cci.cloud.client.impl.CCIRuntimeDataClientImpl.readData(CCIRuntimeDataClientImpl.java:309)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.710] [ERROR] at com.informatica.cloud.api.adapter.cci.reader.CCIRdrPartitionDriver.run(CCIRdrPartitionDriver.java:322)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.710] [ERROR] Caused by: com.informatica.cci.runtime.internal.utils.impl.CExceptionImpl: Read Failed. Internal Error: Adapter BeginDataSession failed</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.710] [ERROR] at com.informatica.cci.runtime.impl.CDataAdapterImpl.read(CDataAdapterImpl.java:198)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.710] [ERROR] at com.informatica.cci.cloud.client.impl.CCIRuntimeDataClientImpl.readData(CCIRuntimeDataClientImpl.java:306)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.710] [ERROR] ... 1 more</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.710] [ERROR] com.informatica.powercenter.sdk.SDKException: Read Failed. Internal Error: Adapter BeginDataSession failed</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; JAVA PLUGIN_1762 [2023-03-30 03:49:33.710] [ERROR] at com.informatica.cloud.api.adapter.cci.reader.CCIRdrPartitionDriver.run(CCIRdrPartitionDriver.java:326)</P><P>READER_1_1_1&gt; CMN_1761 [2023-03-30 03:49:33.710] Timestamp Event: [Thu Mar 30 03:49:33 2023]</P><P>READER_1_1_1&gt; SDKS_38200 [2023-03-30 03:49:33.710] Partition-level [SQ_EIDB_MEN_MRE]: Plug-in #606801 failed in run().</P><P>TRANSF_1_1_1&gt; DBG_21511 [2023-03-30 03:49:33.711] TE: Fatal Transformation Error.</P> Wed, 29 Mar 2023 17:03:19 GMT https://community.databricks.com/t5/data-engineering/informatica-cloud-mapping-with-databricks-connection-failing/m-p/6859#M2861 MaheshDR 2023-03-29T17:03:19Z https://community.databricks.com/t5/data-engineering/informatica-cloud-mapping-with-databricks-connection-failing/m-p/6860#M2862 <P>@Mahesh D​&nbsp;:</P><P></P><P>Based on the error message, it seems that the issue could be related to the JDBC driver used by Informatica Cloud to connect to Databricks.</P><P>Here are a few suggestions you can try to troubleshoot the issue:</P><OL><LI>Ensure that you have the correct JDBC driver version installed in Informatica Cloud to connect to Databricks. You may need to update the driver version to be compatible with your Databricks cluster.</LI><LI>Verify that the Databricks connection properties (such as host, port, and authentication) are correctly configured in Informatica Cloud.</LI><LI>Check that the SQL query is correctly formatted and that it returns valid results when run in Databricks.</LI><LI>Try running the SQL query in a different SQL editor to ensure that it works correctly.</LI><LI>Check the logs for any additional error messages that might provide more information about the issue.</LI><LI>Contact Informatica Cloud support for further assistance.</LI></OL><P>I hope this helps you resolve the issue. Let me know if you have any further questions or concerns.</P><P></P><P></P><P></P><P></P> Sun, 02 Apr 2023 14:02:19 GMT https://community.databricks.com/t5/data-engineering/informatica-cloud-mapping-with-databricks-connection-failing/m-p/6860#M2862 Anonymous 2023-04-02T14:02:19Z https://community.databricks.com/t5/data-engineering/informatica-cloud-mapping-with-databricks-connection-failing/m-p/6861#M2863 <P>Hi @Mahesh D​&nbsp;</P><P></P><P>Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.&nbsp;</P><P></P><P>We'd love to hear from you.</P><P></P><P>Thanks!</P><P></P><P></P> Tue, 04 Apr 2023 06:30:04 GMT https://community.databricks.com/t5/data-engineering/informatica-cloud-mapping-with-databricks-connection-failing/m-p/6861#M2863 Anonymous 2023-04-04T06:30:04Z