Return
-
Title
Get "Input string was not in a correct format. Couldn't store in columnorder column..." opening saved query -
Description
Getting the following error when trying to open a query that was saved in a file."Input string was not in a correct format. Couldn't store in columnorder column. Expected type is Int32. Opening query in editor. Please connect to a database and send the query to the Query Builder to be visualized."or"Cannot find column nn. Opening query in editor. Please connect to a database and send the query to the Query Builder to be visualized." -
Cause
After Windows update 'KB4565633' is installed, this issue starts occurring. -
Resolution
WORKAROUND #1:Uninstall the KB4565633 Windows update. However, it may get reinstalled at some point after uninstalling it.
WORKAROUND #2:Add the code in the attached file into the Toad.exe.config file, which can be found in your installation directory. By default, that would be C:\Program Files\Quest Software\Toad Data Point 5.1. It must be placed toward the beginning of the file, right after the configuration tag (line 3).
STATUS:Issue fixed in version 5.2.0.276 *. The latest version can be downloaded here -
Defect ID
TMB-3380 -
Attachments
-
Additional Information
* if you are currently on version 5.2, please go to Help | About to determine exact minor version of 5.2.0. If it is lower than 5.2.0.276, then Toad will need to upgraded as above.