Hi, I have Toad Data Point 3.4 and when I try import any data to Oracle (to existing table or to new created table), I always get this error:
14:55 Thread (24) Tried to access non existing SQL name (Quest.Toad.Db.CommonSql.ChangeCurrentDatabase)
14:55 Thread (24) Error importing data, please check file format options: Tried to access non existing SQL name (Quest.Toad.Db.CommonSql.ChangeCurrentDatabase)
14:55 Thread (24) Import Finished [24.1.2014 14:55]
14:55 Thread (24) Import time: 00:00:05.0245024
I have TDP for half year, always importing same file in same format without any errors. Is this problem caused by file or connection configuration? Any ideas how to resolve it? I’m importing .csv file.
The error stack is complaining about the schema name. See image. Is the schema name valid? If it is can you Save the import template to a file and post?
Schema name is valid. See import template in attachment. It is my own schema, where I'm currently logged. In previous installation of TDP, all seems to be OK, import was fast and without problem. After my system re install in January this happens. In old Toad for Oracle 9 import was finished without problem, but is much much slower then import in TDP.
Here are some screens of my TDP screen, so you can see how I'm logged in.
What version of Oracle are you connecting to? It appears that your SQL Dictionary gpt messed up.
Please save the attached SqlDictionary.xml to your Toad Application Data Directory ( you can find the path by clicking Application Data Directory link in About box), restart Toad and try the import again.
Yes, I reinstall it several times. Even with some special uninstall tool for deleting all temp files and register entries. I testeted old version (3.3) and beta version (3.5) too.
Logging will be great, this can be some problem in our Oracle configuration, but now i can’t identify it.
My company considering the purchase about 30 licenses. I have it for testing (i have only trial version now) . But if we can’t resolve this issue, it will be big problem for us. Importing large files is with us on a daily basis and TDP can be user-friendly alternative for all our platforms (Oracle, Teradata, MySQL).
Since the issue is quite perplexing, we also want to know if you are open to have a webex with us if the new log files do not reveal the information we are expecting.
