x First time here? Check out the FAQ
  • Avatar176posts520karma

    Unable to publish/republish 8000 nodes - URGENT

    Masood Afzal started this topic February 11, 2010 @ 04:27

    Umbraco 4.0.3 / ASP.NET 3.5 / Windows Server 2003/ MS SQL Server 2005

    I have created approx 8000 published nodes and trying to update cahce but it fails after running some time. Looks like some of nodes have been added to umbraco cache file but not all of 8000.

    I have tried 'Republish entire site' and 'Publish' options.

    Any help would be highly appreciated




  • Avatar275posts396karma
    Comment with ID: 26085
    Seth Niemuth posted this reply February 11, 2010 @ 04:49

    Make a copy of the umbraco.config file (in your data folder) and delete it or just rename it. Then do the 'Republish Entire Site', it will recreate the 'cache' or XML file of all the nodes. Sometimes the file can just go weird.

  • Avatar176posts520karma
    Comment with ID: 26086
    Masood Afzal posted this reply February 11, 2010 @ 04:53

    Thanks Seth,

    I have removed it and tried 'republishing entire site' many times, but it didn't work. When i pulish the folder, it displays number of published documents and at 400+, restarts counting from 1 again


  • Avatar4329posts9835karma2015 MVP
    CoreadminMVPComment with ID: 26087
    Jeroen Breuer posted this reply February 11, 2010 @ 04:56

    The display number doesn´t always work. If you look at the size of you umbraco.config file does it still get bigger if the count restart from 1 again? If it is the nodes are still being published and you should probably just wait.

  • Avatar1138posts2261karma
    Comment with ID: 26089
    dandrayne posted this reply February 11, 2010 @ 05:10

    Publishing problems are often caused by lucene indexing, so perhaps disabling that will help

    Also, in your web.config you could try to increase the

    executionTimeout = "number" 


    Inside the httpRuntime tag.


  • Avatar27posts48karma
    Comment with ID: 26094
    Christian W. Larsen posted this reply February 11, 2010 @ 05:36

    Did you check the umbracoLog-table? There might be a clue. 

    Could be corrupt data in some node/document.

  • Avatar176posts520karma
    Comment with ID: 26099
    Masood Afzal posted this reply February 11, 2010 @ 05:49
    Error updating item: umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: Arithmetic overflow error converting expression to data type datetime.
    The statement has been terminated.
       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(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
       at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters)
       at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)
       --- End of inner exception stack trace ---
       at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)
       at umbraco.cms.businesslogic.datatype.DefaultData.set_Value(Object value)

  • Avatar176posts520karma
    Comment with ID: 26100
    Masood Afzal posted this reply February 11, 2010 @ 05:55

    Looks like breaking at converting data to DateTime

  • Avatar1794posts1834karma
    adminComment with ID: 26105
    Morten Bock posted this reply February 11, 2010 @ 06:52

    Umbraco 4.0.3 has had a problem with datepicker datatypes, caused by a bug in the datalayer code.

    There was a fix released that might help you out. 

    Some relevant links in this post (also link to a build containing the fix):


  • Morten Christensen posted this reply February 11, 2010 @ 06:57

    Does this problem also occur if you only publish a few nodes or maybe just the second lowest level - or only when doing a complete (re)publish?

    I'm wondering if the exception can be traced to a single node, document type or data type.

    - Morten

  • Avatar176posts520karma
    Comment with ID: 26109
    Masood Afzal posted this reply February 11, 2010 @ 07:11

    If i publish even a single page, publishing is ok but in audit trial, following message is recorded

    Error removing node from umbraco index: 
    'System.IO.FileNotFoundException: Could not find file 'C:\PROJECTS\XYZ\trunk\wwwroot\data\_systemUmbracoIndexDontDelete\_ze.fnm'. File name: 'C:\PROJECTS\XYZ\trunk\wwwroot\data\_systemUmbracoIndexDontDelete\_ze.fnm' at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) at Lucene.Net.Store.FSIndexInput.Descriptor..ctor(FSIndexInput enclosingInstance, FileInfo file, FileAccess mode) at Lucene.Net.Store.FSIndexInput..ctor(FileInfo path) at Lucene.Net.Store.FSDirectory.OpenInput(String name) at Lucene.Net.Index.FieldInfos..ctor(Directory d, String name) at Lucene.Net.Index.SegmentReader.Initialize(SegmentInfo si) at Lucene.Net.Index.SegmentReader.Get(Directory dir, SegmentInfo si, SegmentInfos sis, Boolean closeDir, Boolean ownDir) at Lucene.Net.Index.IndexReader.AnonymousClassWith.DoBody() at Lucene.Net.Store.Lock.With.Run() at Lucene.Net.Index.IndexReader.Open(Directory directory, Boolean closeDirectory) at Lucene.Net.Index.IndexReader.Open(String path) at umbraco.cms.businesslogic.index.Indexer.RemoveNode(Int32 Id)'


Please login or Sign up To post replies