CrearTrace 2008.38 and SQL Server 2005 Express

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

ClearTrace Support Forum

CrearTrace 2008.38 and SQL Server 2005 Express

Author

Topic

Riq
Starting Member

2 Posts

Posted - 2014-02-07 : 11:38:36

Dear Developers:

Is there any problem with this combination? I ask this question because i have an error with the configuration of the ClearTrace Database on my desktop. The following log is generated when the application is started (configuration of the database is already done):

******************************************************************************
ClearTrace Error
******************************************************************************
Version: 2008.38.0
Last Exception: El nombre de objeto 'dbo.CTTraceSummaryView' no es válido.
Last Target Site: Void PopulateResults(Int32, System.String, System.String, System.String)
******************************************************************************

Exception Type: System.Data.SqlClient.SqlException
Exception Message: El nombre de objeto 'dbo.CTTraceSummaryView' no es válido.
en ClearTraceGui.MainForm.PopulateResults(Int32 rows, String groupBy, String orderBy, String keyword)
en ClearTraceGui.MainForm.ResetTrace(String traceName, Boolean populateResults)
en ClearTraceGui.MainForm.ddlTraceToQuery_SelectedIndexChanged(Object sender, EventArgs e)
en System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
en System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
en ClearTraceGui.MainForm.PopulateTraces(ComboBox comboBoxToPopulate, String traceName, String connectionString)
en ClearTraceGui.MainForm.PopulateQueryScreen(Boolean populateResults)
en ClearTraceGui.MainForm.MainForm_Load(Object sender, EventArgs e)
en System.Windows.Forms.Form.OnLoad(EventArgs e)
en System.Windows.Forms.Form.OnCreateControl()
en System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
en System.Windows.Forms.Control.CreateControl()
en System.Windows.Forms.Control.WmShowWindow(Message& m)
en System.Windows.Forms.Control.WndProc(Message& m)
en System.Windows.Forms.ScrollableControl.WndProc(Message& m)
en System.Windows.Forms.ContainerControl.WndProc(Message& m)
en System.Windows.Forms.Form.WmShowWindow(Message& m)
en System.Windows.Forms.Form.WndProc(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
en System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
en System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
en System.Windows.Forms.Control.SetVisibleCore(Boolean value)
en System.Windows.Forms.Form.SetVisibleCore(Boolean value)
en System.Windows.Forms.Control.set_Visible(Boolean value)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Application.Run(Form mainForm)
en ClearTraceGui.Program.Main()

This error is persistent. When i first tried to create the ClearTrace Database, the next error appeared. The error does not appear anymore:

******************************************************************************
ClearTrace Error
******************************************************************************
Version: 2008.38.0
Last Exception: La conversión del tipo de datos char a smalldatetime generó un valor smalldatetime fuera de intervalo.
Last Target Site: Void OnError(System.Data.SqlClient.SqlException, Boolean)
******************************************************************************

Exception Type: System.Data.SqlClient.SqlException
Exception Message: La conversión del tipo de datos char a smalldatetime generó un valor smalldatetime fuera de intervalo.
en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
en System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
en System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
en System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
en System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
en System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
en ClearData.ClearTrace.Helper.ExecuteNonQuery(SqlConnection sqlConnection, String sqlStatement, Int32 commandTimeout)
en ClearData.ClearTrace.Helper.ExecuteNonQuery(String serverName, String databaseName, String sqlStatement, Int32 commandTimeout)
en ClearData.ClearTrace.Helper.UpgradeDatabase(String serverName, String databaseName)
en ClearTraceGui.OptionsForm.ConfigureDatabase()
en ClearTraceGui.OptionsForm.btnSave_Click(Object sender, EventArgs e)
en System.Windows.Forms.Control.OnClick(EventArgs e)
en System.Windows.Forms.Button.OnClick(EventArgs e)
en System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
en System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
en System.Windows.Forms.Control.WndProc(Message& m)
en System.Windows.Forms.ButtonBase.WndProc(Message& m)
en System.Windows.Forms.Button.WndProc(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
en System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
en System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
en System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Application.RunDialog(Form form)
en System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
en System.Windows.Forms.Form.ShowDialog()
en ClearTraceGui.MainForm.optionsToolStripMenuItem_Click(Object sender, EventArgs e)
en System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
en System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
en System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
en System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
en System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
en System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
en System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
en System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
en System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
en System.Windows.Forms.Control.WndProc(Message& m)
en System.Windows.Forms.ScrollableControl.WndProc(Message& m)
en System.Windows.Forms.ToolStrip.WndProc(Message& m)
en System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
en System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
en System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
en System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Application.Run(Form mainForm)
en ClearTraceGui.Program.Main()

I have searched to any configuration restriction that could be generate this error on this forum, but i couldn't find anything. Please help.

My configurations are:
- Windows 7, pro, 32 bit
- ClearTrace 2008.38
- SQL server 9.0.5000 2005 Express Edition

Enrique G.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-02-07 : 12:47:59

I haven't had any issue with that ClearTrace version and SQL Server 2005. But just in case, maybe try a lower build of ClearTrace such as 2008.36.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2014-02-07 : 17:16:59

There was a bug a long time back when creating the original dimension tables. That appears to be the datetime bug. It's fixed in later versions. You can always look in the database for the date dimension table and populate it manually.

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources