hanvon faceid manager

Error Occured while saving attendance to database Hanvon FACEID Manager

tis error when polling

Today our HR department got this error when they started polling Attendance in Hanvon FaceID Manager

Error Occurred while saving attendance to database Hanvon FACEID Manager

To find out why really the Hanvon is spitting out this error and not saving the records, I have to look at the Windonw NT Logs. To look at Windows NT logs, start SQL Server Management Studio, connect to your local SQL Server, then go to Management > SQL Server Logs. Select the log that start with “the current” and click view log. ON the left side, there is bunch of software you can select/deselect to filter the logs. Selects only Windows NT and deselect the rest. There was this error

Error Description:Invalid argument. Insert Into Attendance (MachineID,PinNumber,AttendanceDateTime,Status,MachineName,AttendanceDate,AttendanceTime,AttendancePhoto) Values(01,’7309′,’17-Aug-2015 14:19:07 PM’,’01’,’mydb’,’17-Aug-2015′,’02:19 PM’,@AttendancePhoto)

Access DB has gone Corrupted (once again)

After looking around on google, I found that the error was because Access Database has gone corrupted. For this to fix, click the round button in Access > Access Options > Current database and check

Compact on close.

compact on close

This might take quite a bit. Just leave it running for some time (I left it at end of the day). After it is done, start Hanvon FaceID Manager and start polling, it should work as in my case.

If there is still some problem, you might have to look for the corrupted data that is causing the problem and have to delete it manually (slightly dangerous route).

Update

I got the above error once again in a different scenario. In this case had I moved .dbm file to a different location and hence the above err. After looking at SQL Server Log (Hanvon), I was getting this error

Error Description:ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed. Insert Into Tlog

I resolved this one after I copy the file back to its original location.

Error occured while loading attendance from database – Hanvon

Error loading attendance Hanvon
In Hanvon FaceID Manager, If you go to “Transaction View” and you select “from date” to “to date” when loading data it might spit out this error

Error occured while loading attendance from database

If you fire up SQL Server management studio and look at the logs (under Maintenance > SQL Server Log and double clicking the current log and then selecting “Windows NT” checkbox at left), you will see this error

Stack Trace: at DataAccess.clsDataAccessBaseForMSAccess.ExecuteDataTable()
at DataAccess.HanvonFaceIDPolling.clsPolling.GetAttendanceRecords(String rstrDateTimeFrom, String rstrDateTimeTo)
at HanvonFaceIDManager.frmListDotDatGenerator.LoadDataFromDB(enDateRange miDateRange)

The error message is clearly about ill formatted date. However my date format seems to be in standard format. So what else can be wrong? It is likely related to the corruption of data as I have explain in error while logging in to Hanvor FaceID.

To fix, open the culprit file in Microsoft Access, your .dbm file where Hanvor FACEID stores all its data ( Can be found by going to setting page in Hanvor FacedID). Click Menu > open and the double lick the very first table Attendance. Find out an entry (an invalid date) that might give you this problem. In my case it was the very first record where data was like this

AttendanceID MachineID PinNumber AttendanceDateTime Status MachineName AttendanceDate AttendanceTime AttendancePhoto
################ ################ ################ ################ ################ ################

Right click on the row and delete this record. Now fetch date based data and it should work!