I have a cross database query that pulls data from 2 MS SQL servers and imports that data into an Oracle table. This has been working fine until this morning, and when I try to troubleshoot the task file and look at the query that generates the data to import I get the following error:
Quest.Toad.CloudDB.HubDatabaseException
Unable to copy data files. The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.
Stack Trace:
at Quest.Toad.CloudDB.CloudDBConnection.DoBeforeConnect()
at Quest.Toad.Db.Connection.Connect(Boolean notify)
at Quest.Toad.Db.Provider.CreateConnection(ConnectMediator connOptions)
at Quest.Toad.Db.Provider.Connect(ConnectMediator options)
at Quest.Toad.ConnectionManager.ConnectionFacade.NewConnection(ConnectMediator connectOptions, Boolean promptUI)
at Quest.Toad.ConnectionManager.ConnectionFacade.GetConnection(ConnectMediator connectOptions, Boolean promptUI)
at Quest.Toad.Db.Provider.GetHeterogeneousHubConnection()
at Quest.Toad.Db.Provider.GetHeterogeneousConnection()
at Quest.Toad.ImportExport.Readers.ReaderQuery.get_QueryConnection()
at Quest.Toad.ImportExport.ImportWizard.wizardPageQuery_ShowFromNext(Object sender, EventArgs e)
at Quest.Toad.Controls.Wizard.WizardPage.OnShowFromNext(Wizard wiz)
at Quest.Toad.Controls.Wizard.Wizard.NextTo(WizardPage page)
at Quest.Toad.ImportExport.ImportWizard.GotoPageAfterAddImport(ImportData newImport)
at Quest.Toad.ImportExport.ImportWizard.EditImport()
at Quest.Toad.ImportExport.ImportWizard.simpleButtonEditImport_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)