SQL Server 2017 cluster service pack1 apply error

ajay gupta 1

while trying to install SQL Server 2017 cluster service pack1 its giving error :

Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
Exit code (Decimal): -2068709375
Exit facility code: 1202
Exit error code: 1
Exit message: The directory 'd:\56d1f98125de24a1d36bba039e1733\' doesn't exist.

The service pack exe file is situated in C:\ drive but the d:\ was offline as SQL Server service got offline during service pack installation and the above error is coming.

Could you please help how can I proceed?

Seeya Xi-MSFT 16,436 Reputation points

2022-08-31T06:52:28.15+00:00

Hi @ajay gupta ,

For better troubleshooting, could you add some more logs, such as summary.txt?

Seeya Xi
Best regards
Bjoern Peters 8,781 Reputation points

2022-08-31T08:09:10.053+00:00
1.) There is no ServicePack for SQL Server 2017 there are only Cumulative Updates... but that is just the wording and not your trouble

2.) Normally, you should follow the recommendations:

Backup all databases/Wait until the next LogBackup has finished

Failover all SQL cluster roles to Node A.

Install the patches on Node B (passive).

Restart Node B.

Failover all SQL cluster roles to Node B.

Install the patches on Node A (passive).

Restart Node A.

So, there won't be any unexpected disk movement during an update.
Seeya Xi-MSFT 16,436 Reputation points

2022-09-02T05:48:34.147+00:00

Hi @ajay gupta ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

6 answers

Seeya Xi-MSFT 16,436 Reputation points

2022-09-01T06:20:59.147+00:00
Hi @ajay gupta ,

Please refer to this official document: KB4041553 - SQL Server Service Packs are discontinued starting from SQL Server 2017.
Starting from SQL Server 2017:

SPs will no longer be available. Only Cumulative Updates (CUs) and critical updates (GDRs) will be provided.

CUs will contain localized content if it's necessary as what SPs have done.

CUs will be delivered more frequently at first and then less frequently: every month for the first 12 months, and then every quarter for the final four years of the five-year mainstream lifecycle.
Here is an document about SQL Server 2017 build versions: KB4047329. You can select the latest cumulative update to install.
In addition, to upgrade a SQL Server failover cluster instance, use SQL Server setup to upgrade each node participating in the failover cluster instance, one at a time, starting with the passive nodes. As you upgrade each node, it is left out of the possible owners of the failover cluster instance. If there is an unexpected failover, the upgraded nodes do not participate in the failover until Windows Server failover cluster role ownership is moved to an upgraded node by setup.

Seeya Xi
Best regards

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Please sign in to rate this answer.

0 comments No comments
Sign in to comment