Error "Query contains error(s)" when activating Log Collection in VCF Operations

Products

• VCF Operations

Issue/Introduction

When enabling Activate Log Collection for vCenter in VCF Operations > Administrator > Integrations > VCF > vCenter > Edit page, the task fails with: "Query contains error(s). Check the logs for more details." (Refer to the Screenshot below)

Symptoms include:

• VCF Operations for Logs displays an evaluation mode banner (You are in an evaluation mode which expires on <date>) and a "No License" status in Management > License page.

• VCF Logs /storage/core/loginsight/var/runtime.log reports: ["SslCertificateManagerScheduler-thread-1"/###.###.###.### ERROR] [com.vmware.loginsight.commons.security.UrlConnectionManager] [Failed to create trust manager]java.security.KeyStoreException: Failed to load default trust store.

• vCenter account(s) is missing from VCF Operations for Logs > Integrations > vSphere and VCF Operations > Infrastructure Operations > Configurations > Log Collection pages.

Environment

VCF Operations 9.x

VCF Operations for Logs 9.x

Cause

This error occurs when the Java truststore (/usr/java/jre-vmware/lib/security/cacerts) on the VCF Operations for Logs node is corrupted. This prevents the appliance from establishing secure connections for licensing and API communication with VCF Operations, causing the Log Collection activation query to fail.

Resolution

To resolve this issue, you must replace the corrupted truststore file in VCF Operations for Logs using How to replace a corrupted truststore in VCF Operations for Logs and retry the Activate Log Collection step in the VCF Operations > Administrator > Integrations > VCF > vCenter > Edit page.

Additional Information

Reference KB for the Evaluation license banner in VCF Operations for Logs UI: No License message or evaluation mode in VMware Cloud Foundation Operations for Logs 9.0