Lookup Table Error: The columns on the server do not match.

You may receive the following error when running a Lookup Table job:

"The columns on the server do not match."

This indicates that there is a mismatch between the fields already present on the doForms server and the fields that are being uploaded.


There are two different approaches to fixing this error:
  1. Edit the source of the Lookup Table job until it exactly matches the fields present in the Lookup Table that exists on the doForms server, and then run the job again.
  2. Manually delete the existing Lookup Table on the doForms server and run the job again.
Note that option 2 requires you to re-connect any forms that are already using the Lookup Table to the new Lookup Table.

Extended instructions for option 2

  1. Delete the existing Lookup Table (e.g. Customer) on the doForms server.

    Click OK on the confirmation dialog.

  2. Run the Lookup Table job again.
  3. Re-connect any Forms that use the Lookup Table.

    Before deleting the Lookup Table, a Form that referenced the Customer Lookup Table will have fields with properties like this:

    After deleting the Lookup Table, the field properties will be cleared:

    Once the Lookup Job has been run, you can choose the Lookup Table again:


  1. 500 Server Error
  2. QuickBooks: A QuickBooks company data file is already open and it is different from the one requested or there are multiple company files open.
  3. Error parsing c:\Windows\Microsoft.NET\Framework\v4.0.30319\config\machine.config Parser returned error 0x80070005
  4. QuickBooks: This application requires Single User file access mode and there is already another application sharing data with this QuickBooks company data file.
  5. Invoke or BeginInvoke cannot be called on a control until the window handle has been created
  6. Some required QuickBooks components do not apear to be installed. Please search for and download QBFC11_0Installer.exe
  7. Errors: OLEDB
  8. WebService error in Sync And Save
  9. How come only two records are exported?
  10. No attachments are exported
  11. Upload from Excel source has truncated values
  12. Why don't any records export when I run a job?
  13. LoadSchemaDataSet Column 'Column' is constrained to be unique. Value 'XX' is already present.
  14. GetSubmissionNext Could not find a part of the path
  15. How to completely uninstall Sync & Save
  16. System.ApplicationException: Oracle Import: System.TypeInitializationException
  17. Error: Sync & Save is already running under another user account.
  18. Oracle.DataAccess.Client.OracleException: ORA-00904: "XXXXX": invalid identifier
  19. Excel cannot open the file 'xxxx.xlsm' because the file format or file extension is not valid.
  20. System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client
  21. Lookup Table Error: The columns on the server do not match.
  22. Jobs disappear after upgrading from 1.2.x to 1.3.x
  23. Export Data Error System.Xml.XmlException: System.Xml.XmlException: An error occurred while parsing EntityName.
  24. Sync Dispatch Status Error System.Xml.XmlException: An error occurred while parsing EntityName.
  25. Communication Error The remote server returned an error: (401) Unauthorized
  26. The remote name could not be resolved: 'wss-dot-mydoforms-hrd.appspot.com'
  27. Export Connection Error Sage.Peachtree.DataAccess.DTIException: DTI PvConnectServer returned error: 7025
  28. Save Changes Error System.NullReferenceException: System.NullReferenceException: Object reference not set to an instance of an object.
  29. System.Net.WebException: The request failed with HTTP status 417: Expectation Failed.
  30. Currency values are not exported if the Sync & Save data type is set to Decimal
  31. Error: "Record is too large." when exporting to Access
  32. The Local Date Time Data Type option does not convert to local time
  33. Export Connection Error System.DllNotFoundException: System.DllNotFoundException: Unable to load DLL 'OraOps11w.dll'
  34. Error: UnauthorizedAccessException
  35. Upload Dispatch Error System.ApplicationException: Missing filer params
  36. The underlying connection was closed: An unexpected error occurred on a receive.
  37. Errors when communicating through proxy server
  38. System.ApplicationException: Access Automation Import ---> System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).
  39. Windows Task Scheduler System.UnauthorizedAccessException: System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  40. System resource exceeded.
  41. Web service returned: {"error":"Forbidden"}
  42. Lookup Table Job: No records found
  43. SMTP Time Out when sending notification through Gmail account
  44. QuickBooks: The application trying to connect to QuickBooks is not supported while multiple instances of QuickBooks are running.
  45. QuickBooks: The user you are trying to log in with is already logged in from another machine.
  46. System.Exception: deleteLookupTableData called 10 times. Aborting delete.
  47. Error in Quickbooks Invoice Response, Status Code: 3250
  48. Receive Data Error System.ArgumentOutOfRangeException: System.ArgumentOutOfRangeException: The added or subtracted value results in an un-representable DateTime.
  49. Sync & Save will not start
  50. Error: System.IO.DirectoryNotFoundException: Could not find a part of the path
  51. QuickBooks: COMException: A QuickBooks company data file is already open and it is different from the one requested or there are multiple company files open.
  52. QuickBooks: COMException: The user you are trying to log in with is already logged in from another machine.
  53. QuickBooks Time Entry: Status Code 3310
  54. QuickBooks: COMException (0x80040408): Could not start QuickBooks.
  55. QuickBooks Time Entry: Exception from HRESULT 0x80040300
  56. Lookup table data from Access database is scrambled
  57. Error: The database schema does not match the job schema. Please choose the Delete Previous Table option to recreate the table.

Feedback and Knowledge Base