Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

SQL Collation causes Apex Central Policy deployment to be stuck at "Pending: Managed server deploying"

    • Updated:
    • 23 Jun 2020
    • Product/Version:
    • Apex One 2019
    • Platform:
Summary

Policy deployment from Apex Central to Apex One stuck at:

Pending: Managed Server Deploying

Trend Micro Apex One integrated Service cannot start successfully.

Root Cause Analysis

The following error can be seen from ofcdebug.log file located at ...\Trend Micro\Apex One\PCCSRV\Log\

2019 09/17 13:10:25 [0444 : 004d] (00) (F) [-OSFDB-][w3wp.exe]SQLException Error = 468, Msg = Cannot resolve the collation conflict between "Modern_Spanish_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. - [OSF_Data_Svc_Core.cs(74)]
2019 09/17 13:10:25 [0444 : 004d] (00) (F) [-OSFDB-][w3wp.exe][DisplaySqlErrors] Got SQL exceprion: (Index #0
Message: Cannot resolve the collation conflict between "Modern_Spanish_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
LineNumber: 87
Source: .Net SqlClient Data Provider
Procedure: osp_cb_dbUpdatePolicyStatus_V2
). - [OSF_Data_Svc_Core.cs(498)]

This happens when the Apex One SQL database is installed on a Microsoft SQL Server that users a collation method other than the default "SQL_Latin1_General_CP1_CI_AS".

What is Collation?

SQL collation specifies the bit patterns that represent each character in a dataset. Collations also determine the rules that sort and compare data. These are used with character data types, such as char and varchar, dictate the code page and corresponding characters that can be represented for that data type.

Details
Public

To resolve this issue, apply Apex One Hot Fix Build 2047. This hot fix updates the stored procedure osp_cb_dbUpdatePolicyStatus_V2 with correct collation. This fixes the SQL exception.

Enhanced security policies may not be sent to Security Agents across the network successfully when users manage the Apex One server from the Apex Central web console. This happens when the Apex One SQL database is installed on a Microsoft SQL Server that users a collation method other than the default "SQL_Latin1_General_CP1_CI_AS".

Premium
Internal
Partner
Rating:
Category:
Troubleshoot
Solution Id:
000250610
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.