Error code 3704 In Running Failsafe

Overview

In running the option, Failsafe, there is the error message as “Error: 3704 Operation is not allowed when the object is closed. At ConsoleUtilities Messages.Format CheckForField by Console”. There is no error in the option as Normal Mode in Medicall (SF Case# 00622295 & 00631485 & 00658996).

Resolution/Topic

Please follow the steps.

1. On the SQL Express from the local workstation,  drop or delete the user, xnuser, in the XtendConsole database from the SQL express.

Or you can use the following script. 

USE [XtendConsole]
GO

DROP USER [xnuser]
GO

2. Create the login, xnuser, under the Security--> Logins under the database server, NOT under the XtendConsole database. In user mapping for xnuser, make sure to check the rights, AmcomUserRole, db_ownere, and public. 

3. Make sure the Spok users to have the full right on the database files located in the local workstation. 

4. Test the DSN, “Smart Answer Fail Safe”, in the local workstation, to connect to the database, XtendConsole, located in the workstation. Please make sure the same driver is used in both DSNs, Smart Answer and Smart Answer Fail Safe. The DSN name should be exact as Smart Answer Fail Safe, including the Spaces.

Note: If the driver is different between Smart Answer and Smart Answer Fail Safe as below print screen, the Medicall failsafe will fail with the error code 3704. The DSN, Smart Answer Fail Safe should have the same driver, SQL Server Native Client 11.10 as Smart Answer. To make any change in DSN, the admin right is required on the workstation.