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

[table]
AttendanceID, MachineID ,PinNumber ,AttendanceDateTime ,Status ,MachineName ,AttendanceDate ,AttendanceTime ,AttendancePhoto
,################ ,################ ,################ ,################ ,################ ,################
[/table]

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

Advertisements
This entry was posted in Tutorials/Tips and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s