Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
bcesar2002
Contributor
Contributor

Unable to get tables list from the database: ERROR [HY000] [Qlik][Presto] (1050) JSON parsing error: 3.

When using the presto connector on the Qlik Sense Enterprise, after select Database and Owner, return the message: 
"Unable to get tables list from the database: ERROR [HY000] [Qlik][Presto] (1050) JSON parsing error: 3." and don't list the tables list.

Labels (2)
3 Replies
Alan345
Contributor
Contributor

Hello,

   Verify the connection details: Double-check that the database and owner information you entered in the Presto connector settings are correct. Ensure that you have the necessary permissions to access the specified database.

Check the compatibility: Make sure that the version of Presto you are using is compatible with the version of the Presto connector in Qlik Sense Enterprise. Check the documentation or release notes for any known compatibility issues.

Review the connection settings: Go through the connection settings in the Presto connector Pay My Doctor Login and ensure that all the required parameters, such as host, port, username, password, etc., are correctly configured.

Test the connection: Use external tools or command-line utilities to verify if you can connect to the Presto database using the provided connection details. This step will help determine if the issue is specific to Qlik Sense or related to the database itself.

Update Qlik Sense and the connector: Ensure that you are using the latest version of Qlik Sense Enterprise and the Presto connector. Upgrading to the latest versions might resolve any known issues or bugs.

Consult Qlik Support: If the issue persists, it's recommended to reach out to Qlik support for further assistance. They can provide you with specific guidance based on the version and configuration of your Qlik Sense deployment.

By following these,

you should be able to troubleshoot the JSON parsing error you encountered and hopefully resolve the issue.

 

bcesar2002
Contributor
Contributor
Author

@Alan345 , Unfortunately, all of yours suggestions has been testing, but it have not successful.
Thanks

RenuLalwani
Employee
Employee

Hello, 

Can you check if the query responses from your presto server is coming as HTML or JSON ?