Resolve “Failed to initialize database” error message in TCMS V3 & Ingress (MDB)

Tuesday, October 18, 2016 FingerTec 23 Comments





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.

23 comments:

  1. I have a database connection error this article was not useful. I can post error logs if needed. Can you advise?

    ReplyDelete
    Replies
    1. Hi Sir,

      Good 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

      Delete
  2. Hi, I cannot find tcmsv3 under System DSN. Please help!

    ReplyDelete
  3. Dear Sir,

    Good 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

    ReplyDelete
    Replies
    1. 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

      Delete
    2. Hello Sir,

      If 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.

      Delete
  4. Thanks, It worked.

    ReplyDelete
  5. If I done all the things but still the same error come out?

    ReplyDelete
    Replies
    1. Dear Sir,

      Good 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

      Delete
  6. Hi..I got this massage when I try to download the attendance 'Main office failed to connect device'

    ReplyDelete
    Replies
    1. Hello Sir,

      Good 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.

      Delete
  7. May I know what are the steps to ping the device IP address?

    ReplyDelete
    Replies
    1. Hello Sir,

      To ping IP address, open Command Prompt from start Menu > type ping followed by device IP address {eg : ping 192.168.1.201} > click Enter.

      Delete
  8. 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.

    ReplyDelete
  9. it can not run after reinstallation

    ReplyDelete
    Replies
    1. Hello Sir,

      First 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.

      Delete
  10. This comment has been removed by the author.

    ReplyDelete
    Replies
    1. Hi Joey,

      May 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 .

      Delete
  11. Hello
    i'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

    ReplyDelete
    Replies
    1. Dear Sir / Ma'am,

      Good 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

      Delete

  12. I 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.

    ReplyDelete
    Replies
    1. Hello Mr Rahim,

      Regarding 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.

      Delete

Have any questions or inquiries about FingerTec? Drop your input here.