Resolve “Failed to initialize database” error message in TCMS V3 & Ingress (MDB)
INTRODUCTION
TCMS V3 and Ingress (MDB) utilize Microsoft Access Database, a small sized database with 2GB size limit, to ease database management, particularly for small and medium sized company. Ingress also supports MySQL database, a more suited database for large company usage, and TCMS V3 will follow suit shortly. It is important to make sure that your database is in good condition before you proceed with any other actions.
In TCMS v3 or Ingress (MDB), when the database is corrupted, an error message as shown below will be shown when you launch the software. This tip provides a way to repair this situation easily.
BENEFITS
By knowing how to resolve this error, you would not panic when it happens, and you could continue with your other tasks without having to reach FingerTec support.
PROCESS
1) Open your PC’s Control Panel > Open Administrative Tools
2) Open ODBC Data Sources (32-bits)
3) Go to System DSN and select TCMS v3 or Ingress (depending on which software that you are using), then click “Configure”
4) Click Repair
5) Click OK
6) The system will display that the database has been repaired.
7) Once completed, run Ingress or TCMS v3 again, and check if the problem persists.
I have a database connection error this article was not useful. I can post error logs if needed. Can you advise?
ReplyDeleteHi Sir,
DeleteGood day to you,
Regarding your issue, please send the screenshot error message to support@fingertec.com and please provide us with your TCMSv3 database for further checking too.
To check the database file:
Right click on TCMSv3 icon > Click Open file location > C:\Program Files (x86)\FingerTec\FingerTec TCMS V3\TCMS V3 [by default] > send to us the file named as ingress.mdb
Hi, I cannot find tcmsv3 under System DSN. Please help!
ReplyDeleteDear Sir,
ReplyDeleteGood day to you,
Please refer the troubleshooting guideline below to resolve the System DSN issue
1) Go to Administrative tool > Right click on ODBC Data Source > Select Properties [ refer http://prntscr.com/memzoo ]
2) Go to Shortcut tab, copy the path below and replace these in your PC [ refer http://prntscr.com/men0u8 ] > Apply > save
Target:%windir%\syswow64\odbcad32.exe
Start In:%windir%\syswow64
Dear Sir, thank you, it worked. I can find the tcmsv3 on System DSN now, but the Repair didnt work, It is rolling for hours now
DeleteHello Sir,
DeleteIf the problem still persist and you cannot repair the database successfully, kindly try to uninstall the software from Control Panel then reinstall back with the latest installer file. You can download the latest installer file for TCMSv3 from below link.
https://www.fingertec.com/softwareupdate/TCMSV3/software-tcmsv3_download_e.html
Regards.
Thanks, It worked.
ReplyDeleteIf I done all the things but still the same error come out?
ReplyDeleteDear Sir,
DeleteGood day to you,
In regards to your inquiry, please provide the error message that you're facing in your software by sending an email to support@fingertec.com
Hi..I got this massage when I try to download the attendance 'Main office failed to connect device'
ReplyDeleteHello Sir,
DeleteGood day to you.
Regarding your query, please try to activate your device from the Device tab as it could be caused by no connection from software to your fingertec machine.
Click on the device, and click Activate device. If you can successfully activated the device, you may proceed to download the attendance record.
However, if you are unable to download attendance, you may try to ping the device IP address to ensure there is a connection established to the device accordingly.
May I know what are the steps to ping the device IP address?
ReplyDeleteHello Sir,
DeleteTo ping IP address, open Command Prompt from start Menu > type ping followed by device IP address {eg : ping 192.168.1.201} > click Enter.
I have this problem :'Unrecognized database format'C:\program files(x86)\ ...'' and I try to uninstall the software from Control Panel with the latest installer file. But TCMSv3 can not run on my PC.
ReplyDeleteit can not run after reinstallation
ReplyDeleteHello Sir,
DeleteFirst of all, you have to uninstall and delete the TCMS v3 folder inside the drive. Normally this issue is because the new software installed are still referring to the old database files which leads to the error happen. Once the TCMS v3 has been uninstall and the folder is deleted, then you may proceed to reinstall the software.
This comment has been removed by the author.
ReplyDeleteHi Joey,
DeleteMay I know, what is your current software? Whether TCMSv3 or Ingress Software?
If Ingress Software,what is the database? Whether MDB or MYSQL?
If you are using MDB, kindly follow the steps given in this article.
However if you are using MYSQL database, ,kindly close Ingress software and Ingress server.exe , after that you need to run the Ingress DB installer .
i m using TCMS v3
ReplyDeleteHello
ReplyDeletei'm using Ingress MDB and i have a problem when editing in attendence sheet like adding a clocking time IN or OUT the data will not be saved even if i made this steps and i generate it
Dear Sir / Ma'am,
DeleteGood day to you,
Please follow the steps below and see whether the problem can be resolved or not
1) Backup your database in System Settings > Database Configuration > Browse Database Server Backup Path > Backup
2) Uninstall current Ingress Software from Control Panel
3) Rename FingerTec Ingress folder as "old FingerTec Ingress"
4) Install the latest Ingress below
https://www.fingertec.com/softwareupdate/ingress/software-ingress-mdb_download_e.html
5) Run Ingress Software and restore the backup database above
If the problem persists, kindly provide us a copy of your backup database for further checking, go to system settings > database configuration > backup. If the database quite large, please upload to any sharing website such as www.sendspace.com or google drive then provide us the download link.
Please send email to support@fingertec.com should you require further clarification on above issue as our team can assist you further.
Thanks & Best Regards,
Nursyafawani Kasram binti Mohd Hisham
ReplyDeleteI cant load the program
https://prnt.sc/ojodz7
I've been advised to repair the database.
I cant seems to repair the database.
It said "Unrecognized database format"
https://prnt.sc/ojod31
Please advise.
Hello Mr Rahim,
DeleteRegarding your query, kindly reinstall the software and try to repair again, and see if you are able to run the software or not.
TCMSv3 installer : https://www.fingertec.com/softwareupdate/TCMSV3/software-tcmsv3_download_e.html
If still facing the same issue, please direct your email to support@fingertec.com for further assistance on your issue.
Thanks for the fix! It worked for my Ingress Server.
ReplyDeleteThe database executive will acquire crafted by the information draftsman assuming that one is utilized to plan a database, or a database expansion, as a feature of an undertaking. placement cells database
ReplyDeleteInformation demonstrating is additionally an ability your engineer ought to have. On the off chance that your association doesn't have anybody with these abilities and you are kept from enlisting remotely, https://onohosting.com/
ReplyDeleteThe reason for IT is the catch, stockpiling, and recovery of business data to additional the association's center business targets.https://hostinglelo.in/
ReplyDeleteHye.. my old PC crush now I'm using new PC (windows 10), I have download attlog.dat and user.dat using USB in the device. When I tried to open FingerTec software it has pop up said Database server error. Please check database connection. I try to fixed it said unrecognized database format 'C:Program Files (x86)\FingerTec\FingerTec TCMS V3\ TCMS V3\ ingress.mdb'
ReplyDelete