PSconfig fails Oct 2024 CU - Upgrade [SearchAdminDatabase Name=Name_SearchSADB] failed

Question

My Oct 2024 cumulative update is failing. I am using this command: Psconfig.exe -cmd upgrade -inplace b2b -wait -force

In the log file I see: ERROR Upgrade [SearchAdminDatabase Name=name_SearchSADB] failed. and ERROR Exception: Cannot find the object 'proc_MSS_SetScopeInfo', because it does not exist or you do not have permission.

ERROR at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

From the PSCDiagnostics File: An unknown failure has occurred when configuring the SharePoint Products.

An exception of type System.ArgumentException was thrown. Additional exception information: Log entry string is too long. A string written to the event log cannot exceed 32766 characters.

System.ArgumentException: Log entry string is too long. A string written to the event log cannot exceed 32766 characters.

I am not sure where to look to troubleshoot. My service account is the CA and has the permissions to the SQL databases.

Please help.

Answer 1

Hi @Patty C,

Gald to hear this issue has been resolved. Thanks for posting the question and sharing your solution here. As we cannot accept answers by ourselves, it will be it would be appreciated if you can mark this answer so that others who stuck in similar issues could get answered quickly.

Here is a brief summary about this case.

[Issue symptoms]:

My Oct 2024 cumulative update is failing. I am using this command:

Psconfig.exe -cmd upgrade -inplace b2b -wait -force

[Error]:

1. ERROR Upgrade [SearchAdminDatabase Name=name_SearchSADB] failed. and ERROR Exception: Cannot find the object 'proc_MSS_SetScopeInfo', because it does not exist or you do not have permission. ERROR at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
2. From the PSCDiagnostics File: An unknown failure has occurred when configuring the SharePoint Products. An exception of type System.ArgumentException was thrown. Additional exception information: Log entry string is too long. A string written to the event log cannot exceed 32766 characters. System.ArgumentException: Log entry string is too long. A string written to the event log cannot exceed 32766 characters.

[solution]:

The service account was removed and re-added to the SQL DB permissions. I restarted the server and retried the command. Success. I did not come across anywhere that mentioned removing and adding the service account but it was in SQL solutions.

Thanks for your contribution to our community:)

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.