SQL Server 2019 Patch got failed through Azure update manager

Question

Hi ,

Recently we tried to push SQL Patch KB5049235 for Azure VM hosted with SQL Instance were got failed through Azure Update Manager . Received error as

"2 errors reported. The latest 3 errors are shared in details. To view all errors, review this log file on the machine:[C:\WindowsAzure\Logs\Plugins\Microsoft.CPlat.Core.WindowsPatchExtension\1.5.71] "["There is no enough time left to continue applying the next update"]." "["There is no enough time left to continue applying the next update"]."

Can I have some workaround to fix this issue , also may I know the reason for it . Not only on our environment . I referred some blogs they also faced same error .

Answer 1

Hi Seelan, Sathiya!

Welcome to Microsoft Q&A!

It sounds like you're encountering a common issue with SQL Server 2019 patch KB5049235 failing through Azure Update Manager. The error message indicates that there wasn't enough time left to continue applying the update. Here are some detailed steps and workarounds to help you resolve this issue:

Possible Reasons for the Failure

1. Insufficient Maintenance Window: The update process may have exceeded the allocated maintenance window, causing the update to fail.
2. Resource Constraints: The Azure VM might not have enough resources (CPU, memory) to complete the update within the given time.
3. Network Issues: Network latency or interruptions can also cause the update process to fail.

Workarounds to Fix the Issue

1. Extend Maintenance Window
   • Ensure that the maintenance window is long enough to accommodate the update process. You can adjust the maintenance window settings in the Azure Update Manager.
2. Increase VM Resources
   • Temporarily increase the resources (CPU, memory) of the Azure VM to ensure that the update process has enough resources to complete.
   • You can resize the VM in the Azure portal under Virtual Machines > [Your VM] > Size.
3. Manual Update Installation
   • Download the patch manually from the Microsoft Update Catalog.
   • Connect to the Azure VM and install the patch manually. This can help bypass any issues related to the automated update process.
4. Check and Clear Logs
   • Review the log file located at C:\WindowsAzure\Logs\Plugins\Microsoft.CPlat.Core.WindowsPatchExtension\1.5.71 for more detailed error information.
   • Clear any unnecessary logs or temporary files to free up space and resources on the VM.
5. Retry the Update
   • After addressing the above issues, retry the update through Azure Update Manager. Ensure that the VM is in a healthy state before initiating the update.

Additional Resources

• Troubleshoot SQL Server Cumulative Update Installation Issues: Microsoft Learn.
• SQL Server Patch Installation Failure: SQL Authority.
• Cumulative Update 30 for SQL Server 2019: Microsoft Learn.

I hope these tips help resolve your issue! If you need further assistance, I am here to help.

Best regards, Jonathan

---

Your feedback is very important to us! If this answer resolved your query, please click 'YES'. This helps us continuously improve the quality and relevance of our solutions. Thank you for your cooperation!