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

Create a technical support case if you need further support.

Missing stored procedure sp_Policy_GetServerStuck causes Apex Central policy deployment issue

    • Updated:
    • 24 Jun 2020
    • Product/Version:
    • Apex Central All
    • Apex One All
    • Platform:
Summary

The policy deployment from Apex Central to Apex One fails, and the following status can be seen:

Pending: Managed server deploying

Root Cause Analysis

The following error can be seen in the sCloudProcessor.log file located at ...\Trend Micro\Control Manager\DebugLog:

2020-03-11 15:52:03,480 353740729 [21] ERROR TrendMicro.TMCM.Utilities.PolicyDatabaseWrapper.ServerList - 
[GetServer]: DB Exception: Could not find stored procedure 'sp_Policy_GetServer'.

2020-03-11 15:52:03,480 353740729 [21] ERROR sCloudProcessor - Exception @ running step: PolicyTask which 
calls Run.TrendMicro.TMCM.sCloudProcessor::PolicyTask.Run

2020-03-11 15:52:03,480 353740729 [21] ERROR sCloudProcessor - 
Reason: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an 
invocation. ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'sp_Policy_GetServer'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, 
Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, 
Boolean breakConnection, Action`1 wrapCloseInAction)

One possible cause for this issue is that the 'sp_Policy_GetServer' is missing from the database of Apex Central.

Details
Public

As a workaround for this issue, export the stored procedure 'sp_Policy_GetServer' from an environment with the same Apex Central same build, and then import it to the customer's database.

 
This procedure is recommended only for those with strict policies against providing the database for further checking. If a similar issue is encountered, it is suggested to collect the database for further investigation.
 
Premium
Internal
Partner
Rating:
Category:
Troubleshoot
Solution Id:
000250594
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.