Search

GlobalSCAPE Knowledge Base

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

Karla Marsh
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.

Details
Last Modified: 8 Years Ago
Last Modified By: GlobalSCAPE 5
Type: ERRMSG
Article not rated yet.
Article has been viewed 18K times.
Options
Also In This Category
Tags