SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 ClearTrace Support Forum
 CrearTrace 2008.38 and SQL Server 2005 Express
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Riq
Starting Member

Chile
2 Posts

Posted - 02/07/2014 :  11:38:36  Show Profile  Reply with Quote
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

USA
36942 Posts

Posted - 02/07/2014 :  12:47:59  Show Profile  Visit tkizer's Homepage  Reply with Quote
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/
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

USA
4137 Posts

Posted - 02/07/2014 :  17:16:59  Show Profile  Visit graz's Homepage  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.25 seconds. Powered By: Snitz Forums 2000