Summary

The initial Oracle database connection fails.

Error (connection could not be established)

Error, the connection could not be established.

• DocuPerformer.log (C:\Users\<USER>\Documents\BI Docu Performer\Log)
  writes the following line:

  'System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException.
  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.

Cause

Your Docu Performer BIT-version is incompatible with your Oracle Client.

Solution

Install the same BIT-version for the Docu Performer and the Oracle Client.
i.e. 64-bit Docu Performer ↔ 64-bit Oracle Client

Error (requires Oracle client software version 8.1.7 or greater)

DocuPerformer.log (C:\Users\<USER>\Documents\BI Docu Performer\Log)
writes the following line:

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater

Cause

Oracle Client folder missing permissions.

Solution

1. Go to the Oracle Client folder.
2. Right-click on the folder → Properties → Security
3. Add “Authenticated Users” and give this account Read & Execute permission.
4. Apply this security for all folders, subfolders, and files (IMPORTANT).
5. REBOOT your machine (if you don't do this you will still face the same problem)

Solution 2.1

• Set your environment variable to the Oracle Client path