Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Exception SQL server
Options
Go to last post Go to first unread
Previous Topic Next Topic
Flugger  
#1 Posted : Friday, February 17, 2012 2:52:05 PM(UTC)
Flugger

Rank: Newbie

Joined: 2/17/2012(UTC)
Posts: 3
Location: Italy
Hi!

I tried ManicTime v2.1.2 and ManicTime Server v1.1.2
I create DB in sql server normally but when I executed the .exe of ManicTime Server i received this exception:

17/02/2012 14.10.37,288 2 3732 1 Starting console host...
17/02/2012 14.10.37,538 2 3732 1 ManicTime server 1.1.2.0 started.
17/02/2012 14.10.39,162 2 3732 1 Connecting to database...
17/02/2012 14.10.39,537 2 3732 1 Connected. Checking database version...
17/02/2012 14.10.39,600 2 3732 1 Database version: 0; Supported version: 1
17/02/2012 14.10.39,600 2 3732 1 Upgrading database to version 1...
17/02/2012 14.10.39,818 1 3732 1 *** System.Data.SqlClient.SqlException: System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value, the istruction will be interrupted., 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() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Finkit.ManicTime.Shared.Database.IDbTransactionExtensions.ExecuteScript(IDbTransaction transaction, String script, Boolean ignoreErrors) at Finkit.ManicTime.Server.Database.UpgradeScript1.Execute(IDbTransaction transaction) at Finkit.ManicTime.Server.Database.DatabaseProvider.UpgradeDatabase(IDbTransaction transaction) at Finkit.ManicTime.Server.Database.DatabaseProvider.UpgradeDatabase() at Finkit.ManicTime.Server.Database.CreateDatabaseService.Start() at Finkit.ManicTime.Server.ServiceStarting.ServiceStarter.Start(Boolean interactive) at Server.Shell.WebHostController.Start(Boolean interactive)
17/02/2012 14.10.39,834 1 3732 1 *** System.Data.SqlClient.SqlException: System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value, the istruction will be interrupted., 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() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Finkit.ManicTime.Shared.Database.IDbTransactionExtensions.ExecuteScript(IDbTransaction transaction, String script, Boolean ignoreErrors) at Finkit.ManicTime.Server.Database.UpgradeScript1.Execute(IDbTransaction transaction) at Finkit.ManicTime.Server.Database.DatabaseProvider.UpgradeDatabase(IDbTransaction transaction) at Finkit.ManicTime.Server.Database.DatabaseProvider.UpgradeDatabase() at Finkit.ManicTime.Server.Database.CreateDatabaseService.Start() at Finkit.ManicTime.Server.ServiceStarting.ServiceStarter.Start(Boolean interactive) at Server.Shell.WebHostController.Start(Boolean interactive) at Finkit.ManicTime.Server.Shell.Program.Start(ServerStartupArguments startupArguments)

What is the cause?

Is there somthing wrong in the newer version about updating sql server db?

Thanks
Back to top
WWW
admin  
#2 Posted : Friday, February 17, 2012 3:21:45 PM(UTC)
admin

Rank: Administration

Joined: 4/13/2010(UTC)
Posts: 872
Could you run the attached app on the same machine as MT server is running. It should just write four dates, could you send me the output.
File Attachment(s):
DateTimeFormatTest.zip (4kb) downloaded 2 time(s).

You cannot view/download attachments. Try to login or register.
Back to top
admin  
#3 Posted : Friday, February 17, 2012 3:54:10 PM(UTC)
admin

Rank: Administration

Joined: 4/13/2010(UTC)
Posts: 872
Never mind, we think we know what the problem is. We will post an update on Monday.
Back to top
Flugger  
#4 Posted : Friday, February 17, 2012 7:21:27 PM(UTC)
Flugger

Rank: Newbie

Joined: 2/17/2012(UTC)
Posts: 3
Location: Italy
Ok, thank you!

I will send you the result anyway.
Back to top
WWW
Flugger  
#5 Posted : Friday, February 17, 2012 7:26:29 PM(UTC)
Flugger

Rank: Newbie

Joined: 2/17/2012(UTC)
Posts: 3
Location: Italy
The result was

2012-02-17 18.27.14.017
2012-02-17 18:27:14.017
2012-02-17 18.27.14.017
2012-02-17 18:27:14.017
Back to top
WWW
admin  
#6 Posted : Monday, February 20, 2012 10:50:17 AM(UTC)
admin

Rank: Administration

Joined: 4/13/2010(UTC)
Posts: 872
There is a new version, v1.1.3.

www.manictime.com/setup/..._3_0/manictimeserver.zip

Let me know if you still have problems.
Back to top
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF | YAF © 2003-2024, Yet Another Forum.NET