About the error message "Internal Error: Adapter InitDataSession failedException"

analytics_test 1 Reputation point
2020-12-25T06:01:14.377+00:00

I'm connecting to Azure Synapse from an external service.
When I try to access the DB, I get the following error:

Address node: Couldn't retrieve data from external source for object 'CustomerAddress': WCA Error. Received http '500'. {"errorMsg":"Internal Error: Adapter InitDataSession failedException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'HADOOP'.\n\tat com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:845)\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:752)\n\tat com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)\n\tat com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:729)\n\tat com..adapter.azuredw.metadata.adapter.DWUtil.execSqlQuery(DWUtil.java:80)\n\tat com..adapter.azuredw.metadata.adapter.DWUtil.createExternalDataSource(DWUtil.java:189)\n\tat com..adapter.azuredw.runtime.adapter.read.AzureDWNativeReader.readDatafromSourceToStage(AzureDWNativeReader.java:239)\n\tat com..adapter.azuredw.runtime.adapter.read.AzureDWNativeReader.init(AzureDWNativeReader.java:213)\n\tat com..adapter.azuredw.runtime.adapter.AzureDWTableDataAdapter.initDataSession(AzureDWTableDataAdapter.java:175)\n\tat com..cci.runtime.impl.CDataAdapterImpl.init(CDataAdapterImpl.java:71)\n\tat ...

I don't know what settings are missing.
If you have any information, please let me know.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,988 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 90,221 Reputation points Microsoft Employee
    2020-12-28T08:26:31.103+00:00

    Hello @analytics_test ,

    Welcome to the Microsoft Q&A platform.

    From the error message, it shows an incorrect syntax near 'HADOOP'.\n\.

    In case if you are unable to resolve the issue, could you share the exact query which you are running along with the complete stack trace of the error message and screenshot?

    Hope this helps. Do let us know if you any further queries.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.