Summary
The initial Oracle database connection fails.
Error 1
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 1
Your Docu Performer BIT-version is incompatible with your Oracle Client.
Solution 1
Install the same BIT-version for the Docu Performer and the Oracle Client.
i.e. 64-bit Docu Performer ↔ 64-bit Oracle Client
Error 2
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 2
Oracle Client folder missing permissions.
Solution 2
- Go to the Oracle Client folder.
- Right-click on the folder → Properties → Security
- Add “Authenticated Users” and give this account Read & Execute permission.
- Apply this security for all folders, subfolders and files (IMPORTANT).
- 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