Return
-
Title
Getting error "Lookup Error: Table 'mappingtable' already exists" when running a cross connection -
Description
Getting error "Lookup Error: Table 'mappingtable' already exists" when running a cross connection into Query Builder.
The steps to reproduce the problem are:
- Connect to an oracle and mysql databases
- Pull tables from both databases into the query builder
- Infer a relationship between a column in an oracle table with a column in a mysql table
-
Cause
the Local Storage, which we use for cross queries, may have been damaged . -
Resolution
To rebuild the local storage please follow the steps below:
1. Open Toad Data Point
2. Go to Tools | Options and, on the left hand side,check the Local Storage folder path.
3.Close Toad Data Point,
4. With a Windows Explorer navigate to the folder that you saw in the options and rename it (which would give you the opportunity to restore the folder if anything goes wrong).
5. Reopen Toad and connect to local storage. Once you are completely connected, go ahead and try your cross query again (you do not need to have the Local Storage connection open when you use cross query).