Application logs on VMware-hosted Cloud Connector show SQLWRITER EventID 8193

Description

Application event logs on the Cloud Connector may show repeated errors for SQLWRITER with the EventID 8193.

SQL writer error: Unexpected error calling routine CoCreateInstance. hr = 0x80040154.

The SqlWriterLogger.txt file will show repeated errors similar to the following.

[02/12/2025 21:15:26, TID 20e0] Entering SQL Writer OnIdentify.
[02/12/2025 21:15:26, TID 20e0] SQLInstanceNames Registry was not found
[02/12/2025 21:15:26, TID 20e0] Enumerating Local DB User Instances
[02/12/2025 21:15:26, TID 20e0] SqlConnection::Connect: Unexpected error in routine CoCreateInstance.  hr = 0x80040154
[02/12/2025 21:15:26, TID 20e0] SqlConnection::Connect: Throwing HRESULT code 0x8000ffff. Previous HRESULT code = 0x80040154
[02/12/2025 21:15:26, TID 20e0] SqlConnection::Connect: Unexpected error in routine CoCreateInstance.  hr = 0x80040154
[02/12/2025 21:15:26, TID 20e0] SqlConnection::Connect: Throwing HRESULT code 0x8000ffff. Previous HRESULT code = 0x80040154
[02/12/2025 21:15:26, TID 20e0] SqlConnection::Connect: Unexpected error in routine CoCreateInstance.  hr = 0x80040154
[02/12/2025 21:15:26, TID 20e0] SqlConnection::Connect: Throwing HRESULT code 0x8000ffff. Previous HRESULT code = 0x80040154
[02/12/2025 21:15:26, TID 20e0] SqlConnection::Connect: Unexpected error in routine CoCreateInstance.  hr = 0x80040154
[02/12/2025 21:15:26, TID 20e0] SqlConnection::Connect: Throwing HRESULT code 0x8000ffff. Previous HRESULT code = 0x80040154
[02/12/2025 21:15:26, TID 20e0] HRESULT EXCEPTION CAUGHT: hr: 0x8000ffff
[02/12/2025 21:15:26, TID 20e0] PopulateDatabasesOnBasicAGSecondary: rethrowing
[02/12/2025 21:15:26, TID 20e0] PopulateDatabasesOnBasicAGSecondary: Throwing HRESULT code 0x8000ffff. Previous HRESULT code = 0x8000ffff
[02/12/2025 21:15:26, TID 20e0] CSqlWriter::OnIdentify: Enumerating databases failed.  hr = 0x8000ffff
[02/12/2025 21:15:26, TID 20e0] CSqlWriter::OnIdentify: Throwing HRESULT code 0x8000ffff. Previous HRESULT code = 0x8000ffff
[02/12/2025 21:15:26, TID 20e0] HRESULT EXCEPTION CAUGHT: hr: 0x8000ffff

Environment

Citrix is not responsible for and does not endorse or accept any responsibility for the contents or your use of these third party Web sites. Citrix is providing these links to you only as a convenience, and the inclusion of any link does not imply endorsement by Citrix of the linked Web site. It is your responsibility to take precautions to ensure that whatever Web site you use is free of viruses or other harmful items.

Resolution

This error is non-impactful and can be dismissed. In order to locate what is initiating Volume Shadow Copy Service, look into any services or third-party products that may be performing incremental backups of the host VM. If you wish to disable the ability to perform snapshots via VSS, you can remove disk.EnableUUID=TRUE from the VM's parameters.

Problem Cause

Citrix Cloud Connectors utilize Microsoft SQL Server 2022 LocalDB as a database solution for Local Host Cache. SQL Writer is part of the default installation for SQL Server and serves to provide backup and restore functionality through the Volume Shadow Copy Service, but it is not compatible with LocalDB. When vssadmin is initiated, it will attempt to enumerate the databases through SQL Writer and fail, resulting in these errors.

Citrix Cloud Connectors do not utilize, or initiate, this functionality. Since Local Host Cache data must be current at all times, backups are unnecessary. However, other backup services may be utilizing VMware's snapshot capability, which utilizes VSS, to perform incremental backups at scheduled intervals.

Issue/Introduction

Backups or snapshots utilizing Volume Shadow Copy Service can result in SQL Writer errors due to lack of support for SQL Server LocalDB

Additional Information

https://knowledge.broadcom.com/external/article?legacyId=52815

Welcome to "KB Articles"