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.
| Author |
Topic |
|
xellos
Starting Member
1 Post |
 Posted - 2010-06-09 : 10:24:55
|
| Hi,When I try to create cleartrace DB, I get the following error : ******************************************************************************ClearTrace Error******************************************************************************Version: 2008.35.0Last 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.SqlExceptionException 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.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()I use SQLServer 2005 in french.Thanks |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2010-06-15 : 08:23:35
|
| Are you creating a brand new database or updating an existing one?=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
 |
|
|
dbaffaleuf
Starting Member
1 Post |
Posted - 2010-06-17 : 10:01:11
|
| Hi Bill,I faced the same problem with the latest release:Last Exception: La conversion du type de données char en smalldatetime a donné une valeur smalldatetime hors limite.The message is a french translation for "datatype conversion from char to smalldatetime resulted in an out of range smalldatetime value", or something close. HTHDavid B. |
|
|
|
|
|
|
|
|
Issue creating cleartrace DB