Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Graham Carr 277 posts 389 karma points
    Jul 20, 2015 @ 14:07
    Graham Carr
    0

    Scheduled publishing error showing in log file

    The publish at and unpublish at functionality is not currently working on my site which is running Umbraco 7.1.4 if I view the UmbracoTraceLog.txt file in the App_Data/Logs folder I see the following error showing up every minute.

    Any ideas what the cause might be??

    2015-07-20 15:01:55,679 [38] ERROR umbraco.presentation.publishingService - [Thread 7] Error executing scheduled publishing
    System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
       at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
       at System.Data.SqlClient.SqlDataReader.Read()
       at Umbraco.Core.Persistence.Database.<Query>d__1c`1.MoveNext()
       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       at Umbraco.Core.Persistence.Repositories.ContentRepository.<PerformGetByQuery>d__24.MoveNext()
       at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
       at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
       at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
       at umbraco.presentation.publishingService.CheckPublishing(Object sender)
    ClientConnectionId:5838da32-95d5-4103-9554-399f4775cdcc
    
  • Dennis Aaen 4500 posts 18255 karma points admin hq c-trib
    Jul 20, 2015 @ 14:18
    Dennis Aaen
    0

    Hi Graham,

    Try this issue from the issue tracker. http://issues.umbraco.org/issue/U4-5379

    Maybe it could be an idea for you to an upgrade. Then you should follow the general upgrade documentation.

    https://our.umbraco.org/documentation/installation/upgrading/general

    Hope this helps,

    /Dennis

Please Sign in or register to post replies

Write your reply to:

Draft