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

Create a technical support case if you need further support.

Stuck at "Pending: Managed server deploying" status in Apex One due to SQL collation

    • Updated:
    • 22 May 2020
    • Product/Version:
    • Apex One 2019
    • Platform:
Summary

Policies are pending and stuck in "Managed server deploying" status. Both IServices IAC and IVP Services will start but eventually stop for some reason.

When the SQL server default collation is not "SQL_Latin1_General_CP1_CI_AS", for example customer has "Modern_Spanish_CI_AS" installed, deploying policy to Apex One machine will have a SQL exception.

In ofcdebug.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 is caused in stored procedure osp_cb_dbUpdatePolicyStatus_V2, where 5 NVARCHAR columns in the temp table tblUpdatePolicyStatus2 are not specified with collation.

Details
Public

To resolve this issue, apply Apex One Hot Fix Build 2047.

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.