What is the error (PERVASIVE.DATA.SQL CLIENT.LNA [NA][PERVASIVE][ODBC ENGINE INTERFACE][DATA RECORD MANAGER][DATA CONVERSION FAILED BECAUSE DATA CANNOT BE CONVERTED DUE TO DATA TYPE MISTACH OR DATA OVER FLOW]. When i select ENTER PAYROLL FOR MULTIPLE EMPLOYEES. How can i fix this error?

Parents
  • Cause:

    Damaged Pervasive installation

    Incorrect Version of Pervasive is Installed

    Resolution:

    Note: These steps should be applied at the computer that hosts the data and all users should be signed out of the

    program.

    1. Run the Sage 50 Database Repair Utility to remove Pervasive. For more information and to download the Repair

    Utility go to the following link na.sage.com/.../db-repair-utility

    a) Near the bottom of the link download and install the Sage 50 Database Repair Utility for the release you're using.

    b) In the Database Repair Utility click Run to Remove Pervasive.

    c) Then follow steps 2 thru 6 below.  

    Note: If Pervasive fails to uninstall try again to Remove Pervasive.  

    2. If it is still present, delete the Pervasive Software folder located in:

    Windows XP - C:\Documents and Settings\All Users\Application Data\

    Windows Vista / Windows 7 - C:\ProgramData\

    3. If it is still present, delete the following registry key:

    64-bit Windows - HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Pervasive Software

    32-bit Windows - HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software

    4. Select Run on the Install Pervasive line of the Database Repair Utility.

    Note: If step 5 fails, try a 2nd time

    5. Open Sage 50 and go to Tasks, then Select for Payroll Entry

    6. Verify the error no longer occurs

  • in reply to Pamela-2583

    I have follow your above instructions. But I could not fix the error.

Reply Children
  • in reply to AlluSakku

    I am facing problem to enter payroll. I have to select Entry Payroll for One Employee and it is time taking process. I have to enter payroll at a time for all employee. Again I repeat the error  (PERVASIVE.DATA.SQL CLIENT.LNA [NA][PERVASIVE][ODBC ENGINE INTERFACE][DATA RECORD MANAGER][DATA CONVERSION FAILED BECAUSE DATA CANNOT BE CONVERTED DUE TO DATA TYPE MISTACH OR DATA OVER FLOW]. When i select ENTER PAYROLL FOR MULTIPLE EMPLOYEES.

  • in reply to AlluSakku

                                                                                    Waiting for the response from payroll

    Waiting for the response from payroll

    Between John Parr , AlluSakku

                       Above screenshots are the errors, I received when I select Enter Payroll for Mutliple Employees. How can i fix these errors?

                       We have restore data of our company from peachtree 2010 quantum accounting to sage 50 quantum accounting. 

                        I have to solve the problem as soon as possible because I have to enter payroll for 2month. Till now, We have manage in excel.