-
Title
"Cannot resolve connection for saved query..." opening .TSM file for connection that does not exist -
Description
When trying to open a .TSM file that is associated to a connection that no longer exists, the following message is returned...
"Cannot resolve connection for saved query: <file name>. Opening query in editor. Please connect to a database and send the query to the Query Builder to be visualized." -
Cause
When the file is launched it is trying to make the connection associated to it. Since the connection no longer exists, it cannot connect to the database the query was written for.
-
Resolution
WORKAROUND 1:
Clicking OK on the message received should allow you to view the statement created and saved in the file.
WORKAROUND 2:Copy the statement and paste it to the editor for a new connection that contains the same table structure needed for this query. Then right click in the editor and select “Send to Query Builder”. This will send the statement to the query builder and should reverse engineer the statement to give you the diagram again for the query for the database you are connected to.
Save this to file. It will save with the new connection information.