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

Create a technical support case if you need further support.

Special characters in the SQL account password causes "System error. Error ID: -1" when deploying policies from Apex Central to Apex One

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

Policy deployment from Apex Central to Apex One fails, and the following error is returned:

Error Code: System error. Error ID: -1

Root Cause Analysis

The following is found in the ApexOne_ofcdebug.log file:

2019 10/17 15:13:12 [5484 : 0009] (00) (F) [-OSFDB-][w3wp.exe]SQLException Error = 18456,
Msg = Login failed for user '[username]'. - [OSF_Data_Svc_Core.cs(74)]
 
2019 10/17 15:13:12 [5484 : 0009] (00) (F) [-OSFDB-][w3wp.exe][DisplaySqlErrors]
    Got SQL exceprion: (Index #0
 
Message: Login failed for user '[username]'.
 
LineNumber: 65536
 
Source: .Net SqlClient Data Provider
 
Procedure:
 
). - [OSF_Data_Svc_Core.cs(498)]

The issue happens when special characters (e.g. Turkish characters) were used in the password of the SQL database. The encrypted password might become mismatched between ofcserver.ini and web.config file of OSF, which will cause policy deployment failure.

Details
Public

To fix this issue:

  1. Reset the SQL account password using the SqlTxfr tool and test if issue can be fixed.
  2. If the issue persists, consider removing special characters used in the SQL account password (e.g. Turkish characters).
Premium
Internal
Partner
Rating:
Category:
Troubleshoot
Solution Id:
000250397
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.