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.
Apex CentralAll , Apex OneAll
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.
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.
