Unable to create generate Catalogue for SharePoint 2013

Im unable to catalogue a SharePoint 2013 content database with DPM 2012R2.

I see the following exception in the DPM Logs.

Any assistance would be most appreciated

1B04 1888 05/16 22:00:16.628 31 WSSCatalogGenerator.cs(234)   WARNING [UniqueId 37] Caught Exception trying to generate a Catalog for Database [UK-SPT01\WSS_Content]
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1269)   WARNING --------------------------------------------------
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1270)   WARNING Exception Message   =
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1270)   WARNING Invalid object name 'TVF_EventCache_ReadPast_LEQId'.
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1270)   WARNING Invalid object name 'TVF_EventCache_Id'.
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING Exception Stack     =
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at System.Data.SqlClient.SqlDataReader.get_MetaData()
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at Microsoft.SharePoint.SPChangeToken.GetCurrentChange(SqlSession session, Int64& changeNumber, DateTime& changeTime)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at Microsoft.SharePoint.SPChangeToken..ctor(SPContentDatabase db)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at WSSCmdlets.WssContentDatabaseCatalogGenerator.DetermineCatalogType(SPChangeToken& spFinalChangeToken)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at WSSCmdlets.WssContentDatabaseCatalogGenerator.EnumerateContentDatabase()
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass5.<RunWithElevatedPrivileges>b__3()
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1271)   WARNING    at WSSCmdlets.WssCatalogGenerator.GenerateCatalogCallback(Object objState)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1272)   WARNING Inner Exception     =
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING Exception String    =
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'TVF_EventCache_ReadPast_LEQId'.
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING Invalid object name 'TVF_EventCache_Id'.
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at System.Data.SqlClient.SqlDataReader.get_MetaData()
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at Microsoft.SharePoint.SPChangeToken.GetCurrentChange(SqlSession session, Int64& changeNumber, DateTime& changeTime)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at Microsoft.SharePoint.SPChangeToken..ctor(SPContentDatabase db)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at WSSCmdlets.WssContentDatabaseCatalogGenerator.DetermineCatalogType(SPChangeToken& spFinalChangeToken)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at WSSCmdlets.WssContentDatabaseCatalogGenerator.EnumerateContentDatabase()
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass5.<RunWithElevatedPrivileges>b__3()
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING    at WSSCmdlets.WssCatalogGenerator.GenerateCatalogCallback(Object objState)
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1273)   WARNING ClientConnectionId:d0a16d06-4feb-4267-b5ce-4c7009574677
1B04 1888 05/16 22:00:16.628 31 WSSCmdlets.cs(1274)   WARNING --------------------------------------------------


January 8th, 2015 10:07pm

Hi,

Please check if any specific error will occur when using a PowerShell command to catalougue database:

$PG = get-protectiongroup dpmservername  yourdpmservername

$DS = Get-Datasource ProtectionGroup $PG

start-createcatalog -datasource $DS

Free Windows Admin Tool Kit Click here and download it now
January 12th, 2015 8:25am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics