U4-5513 - publish at error caused by a conversion from varchar to datetime. Maybe the cause date field in publish at?

Created by Biagio Paruolo 18 Sep 2014, 15:32:00 Updated by Claus Jensen 17 Jan 2017, 08:18:08

Is duplicated by: U4-5516

Relates to: U4-4159

My server has italian datetime settings. Do I need setting it in English?

2014-09-18 17:11:51,039 [5] ERROR Umbraco.Web.WebServices.ScheduledPublishController - [Thread 20] Error executing scheduled task

System.Data.SqlClient.SqlException (0x80131904): La conversione di un tipo di dati varchar in datetime ha generato un valore non compreso nell'intervallo dei valori consentiti.

in System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

in System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

in System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)

in System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)

in System.Data.SqlClient.SqlDataReader.Read()

in Umbraco.Core.Persistence.Database.d__1c`1.MoveNext()

in System.Collections.Generic.List1..ctor(IEnumerable1 collection)

in System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

in Umbraco.Core.Persistence.Repositories.ContentRepository.d__22.MoveNext()

in System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()

in Umbraco.Core.Publishing.ScheduledPublisher.CheckPendingAndProcess()

in Umbraco.Web.WebServices.ScheduledPublishController.Index()

ClientConnectionId:c48fc8c8-dcd6-4592-acbe-cae0d7049121

2014-09-18 17:11:51,039 [5] ERROR Umbraco.Web.Scheduling.ScheduledPublishing - [Thread 11] An error occurred with the scheduled publishing

System.Net.WebException: Errore del server remoto: (400) Richiesta non valida.

in System.Net.WebClient.UploadDataInternal(Uri address, String method, Byte[] data, WebRequest& request)

in System.Net.WebClient.UploadString(Uri address, String method, String data)

in Umbraco.Web.Scheduling.ScheduledPublishing.Start(ApplicationContext appContext)

LINK on Umbraco forum: http://our.umbraco.org/forum/ourumb-dev-forum/bugs/56727-622-publish-at-error-caused-by-a-conversion-from-varchar-to-datetime-Maybe-the-cause-date-field-in-publish-at

1 Attachments

Comments

Biagio Paruolo 19 Sep 2014, 13:31:53

The issue is still there also after to configure database to English language.


Biagio Paruolo 25 Sep 2014, 20:53:29

Any news?


Biagio Paruolo 26 Sep 2014, 12:44:34

Se this ticket http://issues.umbraco.org/issue/U4-4159 too.


Biagio Paruolo 03 Oct 2014, 14:35:35

Any update and help?


Biagio Paruolo 27 Oct 2014, 11:28:06

Sorry, but I think that a small reply is mandatory


Biagio Paruolo 28 Oct 2014, 08:21:38

Am I only person affected by this bug?


Biagio Paruolo 29 Dec 2014, 09:49:26

Solved with 6.2.4


Priority: Critical

Type: Bug

State: Fixed

Assignee:

Difficulty: Difficult

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions: 6.2.2

Due in version: 6.2.4

Sprint:

Story Points:

Cycle: