1

Closed

Invalid File Path used in Target Dataviewer

description

If you open the target data in the TargetDataViewer for a file target that has a path with a period in the folder path it generates an invalid path request to the database engine for the target data:
 
************** Exception Text **************
System.Data.SqlClient.SqlException: The log file name "D:\srvapps\Microsoft SQL Server\MSSQL10*.MSSQLSERVER\MSSQL\LOG\wait_stats_monitor" is invalid. Verify that the file exists and that the SQL Server service account has access to it.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at XEvents.Library.Targets.Target_File.GetTargetData(SqlDataReader dr, String data, SqlServer server, EventSessionTarget parent) in C:\Documents and Settings\jkehayias\Desktop\Extended Events Manager\XEvents.Library\XEvents.Library\Targets\Target_File.cs:line 28
at XEvents.Library.Targets.TargetDataFactory.GetTargetData(EventSessionTarget target) in C:\Documents and Settings\jkehayias\Desktop\Extended Events Manager\XEvents.Library\XEvents.Library\Targets\TargetDataFactory.cs:line 28
at XEvents.Library.EventSessionTarget.get_TargetData() in C:\Documents and Settings\jkehayias\Desktop\Extended Events Manager\XEvents.Library\XEvents.Library\EventSessionTarget.cs:line 50
at ExtendedEventsManager.ServerExplorerForm.ViewTargetData_Click(Object sender, EventArgs e) in C:\Documents and Settings\jkehayias\Desktop\Extended Events Manager\ExtendedEventsManager\ServerExplorerForm.cs:line 279
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.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)
Closed Nov 2, 2009 at 11:55 AM by jmkehayias
Fixed in 1.0.1.58

comments