Menu

Search

GlobalSCAPE Knowledge Base


ARM database ERROR - auditing STOPPED. Error converting data type varchar to datetime.


GlobalSCAPE 5
EFT Express (SMB) & Enterprise

THE INFORMATION IN THIS ARTICLE APPLIES TO:

  • EFT Server with the Auditing and Reporting Module (ARM), all versions

SYMPTOM

ARM database ERROR - auditing STOPPED. Error converting data type varchar to datetime.

RESOLUTION

The user account that is doing the auditing for ARM must be set to English. If you have installed EFT Server and ARM or the database on a computer that has a non-US English operating system, the date-time format is not compatible with the ARM database. For example, the system may be trying to push in a date/time string in the format of "DD/MM/YYYY" and the database server is trying to convert that to "MM/DD/YYYY" and failing.

SQL Server is installed and configured using US English during EFT Server/ARM installation. You can set the default language to English for the user account that EFT Server uses to audit data using Microsoft SQL Server Management Studio (refer to the procedure in the EFT Server help topic Configuring the ARM Database in SQL Server, if necessary). Alternatively, you can execute a SQL query that uses the system stored procedure "sp_setdefaultlanguage" to change the language setting.


Also In This Category


On a scale of 1-5, please rate the helpfulness of this article


Not Helpful
Very Helpful
Optionally provide private feedback to help us improve this article...

Thank you for your feedback!


Comments require login or registration.

Details
Last Modified: 8 Years Ago
Last Modified By: GlobalSCAPE 5
Type: ERRMSG
Article not rated yet.
Article has been viewed 18K times.
Options
Find Similar