topic Re: Error displaying data from the connector in App Development

Error displaying data from the connector

07mishin — Wed, 09 Feb 2022 08:54:22 GMT

Good day.

I have Error displaying data from the connector ODBC.

Problem with encodings or connector?

Screenshots in attachment.

Re: Error displaying data from the connector

Akshesh_Patel — Wed, 09 Feb 2022 14:07:36 GMT

Hello,

The error needs to fix from the SQL side. please refer to this for possible solutions: https://sebhastian.com/mysql-error-1054-fix/#:~:text=The%20ERROR%201054%20in%20MySQL,UPDATE%20%2C%20or%20ALTER%20TABLE%20statement.

Thanks

Re: Error displaying data from the connector

Akshesh_Patel — Thu, 17 Feb 2022 14:26:15 GMT

Hi,

Please try to just insert the script in the data load editor and then comment on the field that is throwing the error and load the data without that field and see if any error there, that way we can narrow down the error to just a particular field. Next, rename the field from SQL end or try renaming the script itself in Qlik. Load data again

Thanks

Re: Error displaying data from the connector

Akshesh_Patel — Wed, 02 Mar 2022 14:52:05 GMT

Hi,

Thanks