SharePoint 2013 - Failed config wizard and CA not accessible

Question

Hi All,

I have spent over night and no luck to resolve upgrade issues. Unfortunately automatic windows patch enabled and bulk SP KB were install including multiple security update and Cu's. So after installed missing packages in other servers then i could able to run configuration wizard. But getting below error in both PSCONFIG.EXE and PSCONFIGUI.EXE.

So I just tired to validate health analysis rule with Get-SPHealthAnalysisRule getting

Get-SPHealthAnalysisRule : Object reference not set to an instance of an object.

Suspect that farm config/content might broken somewhere, because CA also not accessible with database SharePoint_Admin_Con and marked IsAttachedToFarm as False. So tried to dismount and mount database back throwing an exception as Mount-SPContentDatabase : Invalid object name 'Webs'.

Configuration wizard ERROR:

10/27/2020 05:32:59 18 ERR Task upgrade has failed with an unknown exception
10/27/2020 05:32:59 18 ERR Exception: Microsoft.SharePoint.Upgrade.SPUpgradeException: Action 15.0.2.0 of Microsoft.SharePoint.Upgrade.SPFarmSequence failed. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.SharePoint.Upgrade.TurnOffHealthAnalyzerRules.TurnOffHealthAnalyzerRule(String className, String dllName, SPHealthCheckSchedule schedule, SPHealthCheckScope scope, Boolean autoRepair)
at Microsoft.SharePoint.Upgrade.TurnOffHealthAnalyzerRules.Upgrade()
at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()
--- End of inner exception stack trace ---
at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()
at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)
at Microsoft.SharePoint.Upgrade.SPManager.InplaceUpgradeAdministrationWebApplication()
at Microsoft.SharePoint.PostSetupConfiguration.UpgradeTask.Run()
at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

Could someone help to fine root cause and fixes? Thanks in advance!

Regards,

Sathiya

Answer 1

Thanks All!

Crack above error after couple of days! Tried to clear config cache using https://sathiya.io/sharepoint/powershell-sharepoint/clear-sharepoint-2013-config-cache.php but no luck.

So validated database view status and created view manually from working content database which got corrupted some reason to sort Mount-SPContentDatabase issues. Then ran below psconfig.exe command to fix patch issues;

psconfig.exe -cmd helpcollections -installall -cmd secureresources -cmd services -install -cmd installfeatures -cmd applicationcontent -install -cmd upgrade -inplace b2b -force -wait

Error:
10/27/2020 11:30:53 13 INF SyncUpgradeTimerJob: SPTIMERV4 is not running anymore. Return -1.
10/27/2020 11:30:53 13 ERR The exclusive inplace upgrader timer job failed.

Solution:
Tips: In case SPTimerV4 service error occurred then manually start SharePoint admin service and SharePoint timer service during Upgrading 6 or 9 stage to avoid unexpected service start exceptions;

Error:
Exception: System.Data.SqlClient.SqlException (0x80131904): The operation cannot be performed on database "WSS_UsageApplication" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.
ALTER DATABASE statement failed.

Solution:
Note: If mirroring enabled in SQL server end make sure you have removed WSS_UsageApplication database from mirroring to complete configuration wizard.

Answer 2

Update:
I have found Admin content database views were corrupted so created manually from working DB. So i can mount db against Central admin site. But getting below exceptions while trying to access site or Test-SPContentDatabase.

SqlError: 'Invalid object name 'TVF_DatabaseInformation_Name'.' Source: '.Net SqlClient Data Provider' Number: 208 State: 1 Class: 16 Procedure: 'proc_SetDatabaseInformation' LineNumber: 13 Server:

System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'TVF_DatabaseInformation_Name'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command) ClientConnectionId:e86eadff-a464-498b-8918-1932e9083c75 Error Number:208,State:1,Class:16