You can translate the question and the replies:

Continuous Error at Excel Microsoft Query data retrieval from Denodo (6.0) through ODBC connectivity

All the time when retrieving data from Denodo (6.0) to Microsoft Excel using Excel Microsoft Query intermediated by ODBC connectivity, I faces next error, and can't retrieve data to Excel from Denodo. <Error Description when retrieving data from Denodo (6.0) to Microsoft Excel using Excel Microsoft Query intermediated by ODBC connectivity> 'java.sql.SQLException: Field not found ... in view ... Error while excecuting the query' <Reference> https://community.denodo.com/answers/question/details?questionId=9060g000000XfEUAA0&title=Microsoft+Query+%28Excel%29+not+Compatible+to+Denodo+Query <Root Cause Suggestion> I have heard that the double quotes in Denodo view column names for handling Camel casing of name, using numbers and special characters in column names caused this error. <Workaround Suggestion> Firstly, using Microsoft Query and retrieve relatively compact Denodo views not including double quotes in column names to Excel. Secondly, once the data retrieval established at any Denodo view, there appears [Query and Connection], so click on property of that. Thirdly, [Data]-[Connection Property]-[Definition]-[CommandLine(SQL)] can be freely rewritten any query using once established same connectivity, so freely rewrite query even retrieving data from Denodo Views including double quoted column names. Fouthly, data retrieval from Denodo view to Excel will automatically start without error.
user
07-01-2021 20:36:17 -0500

1 Answer

Hi, Virtual DataPort is compatible with the standard SQL. For example, if the data type of data source is NVARCHAR or VARCHAR, each will be recognized as TEXT when creating a view in Virtual DataPort. I recommend you to try debugging this issue by setting the log trace level to fine granularity and then to check the log files. For instance, you can follow the knowledge base article [Using logcontroller and useful log categories](https://community.denodo.com/kb/view/document/Using%20logcontroller%20and%20useful%20log%20categories?category=Operation) to check for log details. As example, you can change the log level in VQL Shell as follows: * CALL LOGCONTROLLER('com.denodo.vdp.engine.wrapper.raw.[DataSourceType]','DEBUG') DataSourceType can be changed in your environment according to your source type. Based on the information you find there, you may find some idea about what is going on when querying the view. If the issue persists and you are a valid support user, you may open a **Support Case** at the [Denodo Support Site](https://support.denodo.com/) and Support Team will help you. Hope this helps!
Denodo Team
08-01-2021 05:42:07 -0500
You must sign in to add an answer. If you do not have an account, you can register here