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
 Error creating database

Author  Topic 

Quaraz
Starting Member

1 Post
Posted - 2012-01-05 : 08:25:50
Hi,

i am getting this error when creating the database (win 2K3 French / SQL 2005 enterprise 9.00.3042.00 French_CI_AI)

******************************************************************************
ClearTrace Error
******************************************************************************
Version: 2008.38.0
Last Exception: La conversion du type de données char en smalldatetime a donné une valeur smalldatetime hors limite.
Last Target Site: Void OnError(System.Data.SqlClient.SqlException, Boolean)
******************************************************************************

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

Thank you

graz
Chief SQLTeam Crack Dealer

4149 Posts
Posted - 2012-01-05 : 15:47:37
Hmmm. I remember getting this before but thought I'd fixed. Let me go look through the code.

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts
Posted - 2012-01-05 : 16:03:35
See if this works better: http://www.scalesql.com/cleartrace/ClearTrace.2008.39.beta.zip



=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page

snussbaumer
Starting Member

3 Posts
Posted - 2012-06-22 : 03:21:59
Hum, no answer from Quaraz ... a bit rude after your quick answer ...
Anyways, I've got quite the same error on a french setup too. I'm trying to create the database on my Win7 64bits FR dev machine; using a SQL Server 2008 R2 Dev edition, French too, version 10.50.2500, French_CI_AS too.

I've tried version 39 beta, but still the same :


******************************************************************************
ClearTrace Error
******************************************************************************
Version: 2008.39.0
Last Exception: La conversion d'un type de données varchar en type de données smalldatetime a créé une valeur hors limites.
Last Target Site: Void OnError(System.Data.SqlClient.SqlException, Boolean)
******************************************************************************

Exception Type: System.Data.SqlClient.SqlException
Exception Message: La conversion d'un type de données varchar en type de données smalldatetime a créé une valeur hors limites.
à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
à System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
à System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
à System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
à System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
à System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
à ClearData.ClearTrace.Helper.ExecuteNonQuery(SqlConnection sqlConnection, String sqlStatement, Int32 commandTimeout)
à ClearData.ClearTrace.Helper.ExecuteNonQuery(String serverName, String databaseName, String sqlStatement, Int32 commandTimeout)
à ClearData.ClearTrace.Helper.UpgradeDatabase(String serverName, String databaseName)
à ClearTraceGui.OptionsForm.ConfigureDatabase()
à ClearTraceGui.OptionsForm.btnSave_Click(Object sender, EventArgs e)
à System.Windows.Forms.Control.OnClick(EventArgs e)
à System.Windows.Forms.Button.OnClick(EventArgs e)
à System.Windows.Forms.Button.PerformClick()
à System.Windows.Forms.Form.ProcessDialogKey(Keys keyData)
à System.Windows.Forms.Control.ProcessDialogKey(Keys keyData)
à System.Windows.Forms.Control.ProcessDialogKey(Keys keyData)
à System.Windows.Forms.Control.ProcessDialogKey(Keys keyData)
à System.Windows.Forms.TextBoxBase.ProcessDialogKey(Keys keyData)
à System.Windows.Forms.Control.PreProcessMessage(Message& msg)
à System.Windows.Forms.Control.PreProcessControlMessageInternal(Control target, Message& msg)
à System.Windows.Forms.Application.ThreadContext.PreTranslateMessage(MSG& msg)
à System.Windows.Forms.Application.ThreadContext.System.Windows.Forms.UnsafeNativeMethods.IMsoComponent.FPreTranslateMessage(MSG& msg)
à System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
à System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
à System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
à System.Windows.Forms.Application.RunDialog(Form form)
à System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
à System.Windows.Forms.Form.ShowDialog()
à ClearTraceGui.MainForm.optionsToolStripMenuItem_Click(Object sender, EventArgs e)
à System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
à System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
à System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
à System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
à System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
à System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
à System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
à System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
à System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
à System.Windows.Forms.Control.WndProc(Message& m)
à System.Windows.Forms.ScrollableControl.WndProc(Message& m)
à System.Windows.Forms.ToolStrip.WndProc(Message& m)
à System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
à System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
à System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
à System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
à System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
à System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
à System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
à System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
à System.Windows.Forms.Application.Run(Form mainForm)
à ClearTraceGui.Program.Main()

Thanks !
Sebastien
Go to Top of Page

snussbaumer
Starting Member

3 Posts
Posted - 2012-06-22 : 03:28:29
Just in case, this is the translation of the exception message :
The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value
Thanks
Go to Top of Page

Raphi
Starting Member

1 Post
Posted - 2012-06-24 : 04:23:00
I seem to have the same issue. Could this be something local ? like the way a country formats it's dates ?

Translated this message says as well The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value

oh yea I tried it will all the versions out there up to the 2012'er

The System is a Windows Server 2008 R2 Enterprise ( German ) with SQL Server 2008 R2

******************************************************************************
ClearTrace Error
******************************************************************************
Version: 2008.37.0
Last Exception: Bei der Konvertierung eines varchar-Datentyps in einen smalldatetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
Last Target Site: Void OnError(System.Data.SqlClient.SqlException, Boolean)
******************************************************************************

Exception Type: System.Data.SqlClient.SqlException
Exception Message: Bei der Konvertierung eines varchar-Datentyps in einen smalldatetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei ClearData.ClearTrace.Helper.ExecuteNonQuery(SqlConnection sqlConnection, String sqlStatement, Int32 commandTimeout)
bei ClearData.ClearTrace.Helper.ExecuteNonQuery(String serverName, String databaseName, String sqlStatement, Int32 commandTimeout)
bei ClearData.ClearTrace.Helper.UpgradeDatabase(String serverName, String databaseName)
bei ClearTraceGui.OptionsForm.ConfigureDatabase()
bei ClearTraceGui.OptionsForm.btnSave_Click(Object sender, EventArgs e)
bei System.Windows.Forms.Control.OnClick(EventArgs e)
bei System.Windows.Forms.Button.OnClick(EventArgs e)
bei System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
bei System.Windows.Forms.Control.WndProc(Message& m)
bei System.Windows.Forms.ButtonBase.WndProc(Message& m)
bei System.Windows.Forms.Button.WndProc(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
bei System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
bei System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
bei System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
bei System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.RunDialog(Form form)
bei System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
bei System.Windows.Forms.Form.ShowDialog()
bei ClearTraceGui.MainForm.optionsToolStripMenuItem_Click(Object sender, EventArgs e)
bei System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
bei System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
bei System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
bei System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
bei System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
bei System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
bei System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
bei System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
bei System.Windows.Forms.Control.WndProc(Message& m)
bei System.Windows.Forms.ScrollableControl.WndProc(Message& m)
bei System.Windows.Forms.ToolStrip.WndProc(Message& m)
bei System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
bei System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
bei System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
bei System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
bei System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.Run(Form mainForm)
bei ClearTraceGui.Program.Main()
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts
Posted - 2012-06-26 : 17:48:59
Hmmm. This is annoying. I was really sure I had everything culture specific taken out of the code. Let me look through this again and see if I can't get you guys a private build to test.

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts
Posted - 2012-06-26 : 18:35:07
Try this build: http://www.scalesql.com/cleartrace/ClearTrace.2012.43.beta.zip

I found the code that I believe was causing the problem. Please note, this is the 2012 version and requires SQL Server 2012. If someone can verify that this works I'll look into updating the 2008 version.

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page

snussbaumer
Starting Member

3 Posts
Posted - 2012-06-29 : 03:35:10
Hi graz ! This new version is OK.
I Just downloaded SQL Server Express 2012 and I checked that version 2012.42.beta has the bug whereas version 2012.43.beta does not.
Thanks !
Go to Top of Page

sql_pizza
Starting Member

2 Posts
Posted - 2013-05-06 : 03:41:18
Hi,

thanks for this great peace of work. I still have the same problem with ClearTrace.2008.39.beta. Im on a german database. Could you plz fix this issue in the 2008 version?

Thanks in Advance!
Greetz
Michael
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts
Posted - 2013-05-14 : 14:30:00
I'll try to find the time to go back to SQL Server 2008 but I'm not making any promises. As a work around, that's just populating a date lookup table. You can easily write a script to populate 10 years in the future and going back a bit. That's all I'm doing. Let me know if that works for now.

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page

sql_pizza
Starting Member

2 Posts
Posted - 2013-05-24 : 03:34:42
quote:
Originally posted by graz

I'll try to find the time to go back to SQL Server 2008 but I'm not making any promises. As a work around, that's just populating a date lookup table. You can easily write a script to populate 10 years in the future and going back a bit. That's all I'm doing. Let me know if that works for now.


Sorry, but can you give me some more details plz...how can I modify it without the sources?
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site