"(CheckOFSIConnection) -2147221501: Btrieve Error # 3 opening file: T:\PFW\<CompanyID>\xxx\UTMCFile  "Invalid User - xxx" (xxx = user id) in Set as Default

Entry Type: Informational

Product: FRx

Application: FRx Desktop

Version Reported: All

Subject:

"(CheckOFSIConnection) -2147221501: Btrieve Error # 3 opening file: ..\PFW\<Company_Key>\xxx\UTMCFile Invalid User - xxx" (where xxx = user id) occurs in Set as Default.

Possible Resolutions:

Note: Support for FRx has changed. Please see the following notice:

FRx Updates Notice By Microsoft

FRx for Sage PFW

Resolution 1:
These are the most likely causes of the problem:

  1. The Sage PFW user ID and the network logon do not match. To resolve, verify the Sage PFW user ID and the network logon are the same.
  2. The Sage PFW user ID or the network logon is more than eight characters in length. Verify that the network logon and Sage PFW user ID are eight characters or fewer.
  3. The user logged on to the network does not have rights to the specified company in Sage PFW. Verify that the user has rights to the company within Sage PFW.
  4. The company code specified in Company / Information / System Specific Information is incorrect. Verify the company code matches the company ID in Sage PFW.
  5. The System Directory path in Company / Information / System Specific Information has an invalid path to Sage PFW. Verify the System Directory path is at the root of the ...\Platinum\ folder.
  6. For FRx version 6.7: Enable FRx Security to create individual user logon and password requirements. For more information, see the RD_Admin.pdf guide in one of the following locations:
    1. Select from Windows Start / Programs / FRx 6.7 / Table of Contents: Enabling and Using FRx Security.
    2. From Windows Explorer, browse to the ...\FRx 6.7\ Help\LangFiles\Guides\en-us\RD_Admin.pdf file.
      Note: Because of the eight-character limitation in Sage PFW, the Administrator logon using FRx security can only be used to perform Administrator functions. To run reports, log on using the user that was created by the Administrator. 
  8. An older version of FRx may be installed on the workstation. To resolve, perform the following:
    1. Browse to the new ..\FRx folder. Register the .dll files for the new version
      ...\FRx XX\FRxReg.exe.
    2. If the error persists, uninstall the prior FRx version and reregister the .dll files.
    3. Remove or rename all WBT*.* and W32*.* files from the server or local drive where the FRx executables are located.
      Note: Search the entire server or local drive, including subfolders. The following files are used by Pervasive, and should not be removed:
      • C:\PVSW\BIN\wbtrcall.dll
      • C:\PVSW\BIN\wbtrv32.dll
      • C:\Winnt\System32\wbtrvd32.dll
      • C:\PVSW\w32ptkun.dll 
      • C:\PVSW\BIN\w32btxlt.dll
      • C:\PVSW\BIN\w32maint.cnt
      • C:\PVSW\BIN\w32maint.dll
      • C:\PVSW\BIN\w32maint.exe
      • C:\PVSW\BIN\w32maint.hlp
      • C:\PVSW\BIN\w32rbld.cnt
      • C:\PVSW\BIN\w32rbld.dll
      • C:\PVSW\BIN\W32rbld.exe 
      • C:\PVSW\BIN\w32rbld.hlp
      • C:\PVSW\BIN\W32sumsg.dll

  10. Close and reopen FRx.

  11. Set the company as default.

Resolution 2:
If the error is workstation specific, verify that Pervasive is installed on the affected workstation.

Resolution 3:
If the error occurs on all workstations, verify that Pervasive if functioning correctly:

  1. From the Windows Start / Programs menu, run Pervasive System Analyzer. 
  2. Click on Next on the first window.
  3. Select "Test Active Installation" on the next window.  Leave all three options selected.

Resolution 4:
In some cases, this issue occurs due to Pervasive Error 3014.  For more information, see "3014: The MicroKernel Router cannot find an engine" when launching Sage PFW.