Developer forum

Forum » Development » Exception after upgrading to dw7

Exception after upgrading to dw7

E-mail notifications

Reply
Posted on 28/04/2010 13:12:54

After upgrading a solution to 19.0.4.0 both backend and frontend cracks. Backend throws this exception in Access_User_Login.aspx


The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

Stack Trace:

[SqlException (0x80131904): The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlDataReader.HasMoreRows() +157
   System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +197
   System.Data.SqlClient.SqlDataReader.Read() +9
   Dynamicweb.Login.Login() +324
   Dynamicweb.Login.NormalLogin() +769
   Dynamicweb.Login.StartLogin() +546
   Dynamicweb.Admin.Access_User_Login.Page_Load(Object sender, EventArgs e) +39
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

 


Frontend throws this exception:


The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

Stack Trace:

[SqlException (0x80131904): The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlDataReader.HasMoreRows() +157
   System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +197
   System.Data.SqlClient.SqlDataReader.Read() +9
   System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +78
   System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +164
   System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +353
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +164
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94
   Dynamicweb.Database.getDataSet(String SQL, String Database, Boolean WithSchema) +294
   Dynamicweb.ParagraphTemplateCollectionClass..ctor(String strSQL, Boolean boolPreview) +69
   Dynamicweb.Frontend.Content.setData(Int32 PageID) +470
   Dynamicweb.Frontend.Content.CreateContent(Int32 PageID) +91
   Dynamicweb.Frontend.Content.getContent(Int32 PageID) +1095
   Dynamicweb.Frontend.PageView.SetPageTemplateValues() +5709
   Dynamicweb.Frontend.PageView.Output() +189
   Dynamicweb.Frontend.PageviewControl.ParseControls() +33
   Dynamicweb.Admin.Load.Page_Load(Object sender, EventArgs e) +155
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082


I downgraded to 19.0.3.1 and experienced the same exceptions. I then downgraded to 18.16.4.6, and thing work fine even in the old "new UI".


What is that all about? The SQL Server collation was Latin1_General_CI_AI, but changed to SQL_Latin1_General_CP1_CI_AS


I assume that the exception in backend is related to either AccessUserValidFrom, AccessUserValidTo, or AccessUserPasswordDate, but these are IMHO valid dates (2006-06-12 00:00:00.000, 2999-12-31 23:59:59.000, and 2010-02-10 13:46:36.000)


It's kinda urgent!


Replies

 
Posted on 28/04/2010 13:21:31
Reply
If hosted at Hostnordic: which solution?


/Snedker
 
Posted on 28/04/2010 13:24:05
Reply
Nope, the customer hosts the solution themselves.
 
Posted on 28/04/2010 13:26:43
Reply
Could we aquire a BAK of the database?

/Snedker
 
Posted on 28/04/2010 13:36:46
Reply
Hm... It's quite large, so it's not that easy. Perhaps you have som debug DLLs I could dump on the solution?
 
Nicolai Høeg Pedersen
Posted on 28/04/2010 14:10:09
Reply
What version of SQL Server - and what mode is the database in?
 
Posted on 28/04/2010 14:15:36
Reply
2005 sp3 (90)
 
Nicolai Høeg Pedersen
Posted on 28/04/2010 14:22:44
Reply
Sending you a possible fix in 5 mins. Think it is the datetime format of you DB installation that is the problem.
 
Nicolai Høeg Pedersen
Posted on 28/04/2010 14:38:13
Reply
You should have them by now - let me know how it works. 
 
Posted on 28/04/2010 14:58:47
Reply
Excellent, it works now. I was about to get "spat":)

Thanks for the fast effort!
 
Posted on 28/04/2010 22:25:40
Reply

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
 

I have the same problem!!! I need help, what is the solution??

//MEdo



 
Nicolai Høeg Pedersen
Posted on 29/04/2010 10:27:32
Reply

The solution was, that he got a fix from me that forced a specific datetime conversion format.

It is possible that it can be solved without that fix.

What is the collation of your database, SQL Server version, and database compatability level? (Right click the database, choose properties and find the information there).

 
Posted on 30/04/2010 15:09:50
Reply
Set the default language of your database user to english-english.

That's all it needs.
 
Posted on 12/05/2010 09:47:05
Reply
Sorry for the late response. Thanks, Josef. I haven't tried that, but wouldn't that mess up a Danish database? I assume you've tried this on a German database, so you problably have better experience than me.
 
Posted on 12/05/2010 10:25:02
Reply
Hi

We are currently using a german and an english sql server.

If you are concerned about the content of that database: The Czech Weber Stephen site (www.weberstephen.cz) is a DW7 installation with the database user's default language set to english-english.

Did you know that there is a way to access the html mode of the editor in this forum? For example you can embed a video, but also you can do more dangerous stuff, like including javascripts...

Dynamicweb design implementation in 10 minutes from Dynamicweb Software on Vimeo.

 
Nicolai Høeg Pedersen
Posted on 12/05/2010 10:55:45
Reply
Hi Josef

Yes - I know it is possible. And with 7.1 we've added the switch to html mode option to the forum editor so you do not have to 'cheat'...

And what a great Video by the way :-)
 
Posted on 12/05/2010 10:59:05
Reply
Is this a new forum or just an improoved version of the current one?

I can't wait to see/use 7.1 ...
 
Nicolai Høeg Pedersen
Posted on 12/05/2010 11:03:02
Reply
I'm affraid it's just a new button in the editor...

You can already download Beta 1 of 7.1 at engage.

Follow me at http://twitter.com/nicped - there you also find some links to preliminary docs etc.
 
Posted on 12/05/2010 11:13:40
Reply
About the button: Still an improvement ;)

About the Beta: I can't find it :( Is it not at the downloads page? or am i blind already...
 
Nicolai Høeg Pedersen
Posted on 12/05/2010 11:17:49
Reply
Well - you need to know what to look for of course:

http://engage.dynamicweb-cms.com/Download-software-438.aspx

Download the file Application(19.1.0.0 Beta 1).zip
 
Posted on 12/05/2010 11:19:50
Reply
Thanks a lot, you made my day!! :)
 
Posted on 12/05/2010 11:49:46
Reply

Excellent, Josef, thanks!

 

You must be logged in to post in the forum