none
tp_Level Event id 5586 RRS feed

  • Question

  • Unknown SQL Exception 207 occurred. Additional error information from SQL Server is included below.

    Invalid column name 'tp_Level'.

    Every 1 mints on my WFE SERVER  i have found in Event Viewer and ULS Logs

    my version 2010+SP1+ CU12 , i have recently upgrade form SharePoint 2007 to SharePoint 2010

    IS tp_Level a BUG in SharePoint 2010 or other Issue ?? 

    ---------------------

    System.Data.SqlClient.SqlException: Invalid column name 'tp_Level'.    
     at System.Data.SqlClient.SqlConnection.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.SqlDataReader.ConsumeMetaData()    
     at System.Data.SqlClient.SqlDataReader.get_MetaData()    
     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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)    
     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)    
     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)    
     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)    
     at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock)    
     at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock)

    --------------------------------------------------------------

    SqlCommand: 'SET NOCOUNT ON;EXEC proc_StartUndirtyList '390DB6AC-0288-41C0-B77E-913FAE401296','3E008E1D-23EE-40D9-8046-038AEF8783C2','1EAB2DBC-0CCC-4889-966C-BACD803A1EBE';SELECT TOP 1000 D.MetaInfo,D.DirName,D.LeafName,D.tp_Level FROM dbo.TVF_Docs_DirNameEqLike_Value('44656878-E7F6-46FD-8DC5-EB1E369EF598',N'sites/A/B', N'sites/A/B/%') AS D CROSS APPLY dbo.TVF_UserData_PId_DId_Level(D.SiteId, D.ParentId, D.Id, D.Level) AS U WHERE D.ListDataDirty = 1 AND U.tp_RowOrdinal=-1 ORDER BY D.DirName Asc, D.LeafName Asc, D.Level OPTION (FORCE ORDER, MAXDOP 1)'     CommandType: Text CommandTimeout: 0

    --------------------------------

    ConnectionString: 'Data Source=MossPRD;Initial Catalog=WSS_Content_U;Integrated Security=True;Enlist=False;Asynchronous Processing=False;Connect Timeout=15'    ConnectionState: Closed ConnectionTimeout: 15

    --------------------------------

    SqlError: 'Invalid column name 'tp_Level'.'    Source: '.Net SqlClient Data Provider' Number: 207 State: 1 Class: 16 Procedure: '' LineNumber: 1 Server: 'US\MOSS'


    Deepesh Yevle - MCTS MCITP



    Monday, July 8, 2013 8:14 AM

Answers

All replies