Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Knowledge
SQL##f - SqlState: S1000, ErrorCode: 20001 with ErrorMsg No Such Table
Article Number: 000068114 | Last Modified: 2019/03/13Description
The following error message was happening in the reload of the app:
Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 20001, ErrorMsg: There was an error executing an SQL query: 'no such table: ' (1): SQL SELECT <sql details here>
Environment: Qlik Sense June 2018
Cause
The app was using a loop and the peek function to look at existing files to determine the table name to use for the SQL FROM clause. This table name was then stored in a variable. Use of the debug mode and the Variables property window revealed that this value for this variable was not being properly populated and hence there was no table name for the SQL statement in the FROM clause and the "No such Table" error listed above occurred.
Resolution
The root cause was that one of the sheets that the script loop was expecting to be present was missing. This caused the script to fail to obtain the information needed and it then failed to get the proper value for the table name.
The missing data files/sheets were added and then the script started to function properly again.
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us