TOAD version: 3.1.0.638 “Read only Base Edition - Trial Override license expires 9/12/2012”
Just installed it today. I have already input my current valid license info, don’t know why it’s still thinking it’s a trial.
SQL:
Select bvcr.*
from BV_CLM_RCVR bvcr
inner join BV_CLM bvc on bvc.CLM_ID = bvcr.CLM_ID
left outer join BV_DSCRP_RSLT bdr on bdr.DSCRP_RSLT_ID = bvc.DSCRP_RSLT_ID
left outer join VACS_DEBT vd on vd.
where bvcr.RCVR_AUTH_CD=‘AU’
and bvcr.UPD_DTM>=convert(varchar,dateadd(month,datediff(month,0,getdate()) -1,0),101) --‘Begin Prior month’
and bvcr.UPD_DTM<convert(varchar,dateadd(month,datediff(month,0,getdate()),0),101) --‘Begin Current month’
and (bdr.PGM_AID_CD=‘03’ or bdr.PGM_AID_CD=‘42’)
Errors occur when:
I’m working in Editor to create a new query. I always assign table aliases.
I’m connected directly in TOAD to the datasource, an SQL2005 database.
Adding a table and typing alias name with a ‘.’ to pull up the column list to link the new table to an existing table in the SQL (see line 5 of SQL)
Actually, it was giving me errors pretty much every time I typed the table alias name and a ‘.’ to use the ‘auto-fill’ feature. Version 2.7 never gave me these errors.
Plus, when I highlighted the SQL to copy it to this error log I got multiple errors…just for highlighting the sql in the editor.
Error 1
Quest.Toad.Exceptions.DatabaseException
SQL Server Database Error
System.Data.SqlClient.SqlException
Database ‘vd’ does not exist. Make sure that the name is entered correctly.
Stack Trace:
at Quest.Toad.Trl.BaseSqlTrl.ExecuteQuery()
at Quest.Toad.Trl.BaseSqlTrl.Execute()
at Quest.Toad.Trl.BaseSqlTrl.CreateData(ILiveCache entry, IFilterLiveCache filter, FilterInfo filterInfo)
at Quest.Toad.Trl.BaseSqlTrl.GetData(Boolean filtered, FilterInfo filterInfo)
at Quest.Toad.Trl.SqlTrl.GetTrls()
at Quest.Toad.CodeInsight.LanguageDialect.ReadOwnerList(IConnection connection, Insight insight, Boolean filtering, String defaultSchema, Boolean refresh)
Error 2
Quest.Toad.Exceptions.BaseException
Encountered exception while processing exception
System.IO.FileNotFoundException
Could not load file or assembly ‘Teradata.Client.Provider, Version=13.11.0.1, Culture=neutral, PublicKeyToken=76b417ee2e04956c’ or one of its dependencies. The system cannot find the file specified.
Stack Trace:
at Quest.Toad.Teradata.TeradataExceptionWrapper.HandleException(Object sender, ExceptionEventArgs args)
at Quest.Toad.Notification.NotificationManager.ExceptionDelegate(Object sender, ExceptionEventArgs args)
Error 3
Quest.Toad.Exceptions.DatabaseException
SQL Server Database Error
System.Data.SqlClient.SqlException
Database ‘vd’ does not exist. Make sure that the name is entered correctly.
Stack Trace:
at Quest.Toad.Trl.BaseSqlTrl.ExecuteQuery()
at Quest.Toad.Trl.BaseSqlTrl.Execute()
at Quest.Toad.Trl.BaseSqlTrl.CreateData(ILiveCache entry, IFilterLiveCache filter, FilterInfo filterInfo)
at Quest.Toad.Trl.BaseSqlTrl.GetData(Boolean filtered, FilterInfo filterInfo)
at Quest.Toad.Trl.SqlTrl.GetTrls()
at Quest.Toad.CodeInsight.LanguageDialect.ReadObjectList(IConnection connection, IncludeInsight include, String schema, List1 owners, String partialMatch, Boolean filtering, String defaultSchema, List1 defaultOwners, Boolean refresh)
Error 4
Quest.Toad.Exceptions.BaseException
Encountered exception while processing exception
System.IO.FileNotFoundException
Could not load file or assembly ‘Teradata.Client.Provider, Version=13.11.0.1, Culture=neutral, PublicKeyToken=76b417ee2e04956c’ or one of its dependencies. The system cannot find the file specified.
Stack Trace:
at Quest.Toad.Teradata.TeradataExceptionWrapper.HandleException(Object sender, ExceptionEventArgs args)
at Quest.Toad.Notification.NotificationManager.ExceptionDelegate(Object sender, ExceptionEventArgs args)
I’ve seen where you’ve told others that Error 2 and 4 should be fixed…maybe I need an even newer version?