Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Troubleshooting : "No error handle available to report exact OCI_ERROR"

Alteryx
Alteryx
Created

Issue

 

Users can experience the below error message in Alteryx Designer

 

OCIEnvCreate Error: No error handle available to report exact OCI_ERROR

 

Environment

 

  • Alteryx Designer
  • Drivers :
    • Oracle Instant Client

 

Diagnosis

 

This error will occur on different occasions

  • When attempting to connect to Oracle using the Instant client
  • Screen Shot 2018-01-09 at 1.48.35 PM.png

 

  • When attempting to publish workflows using the Instant Client
  • image005.png

 

Cause

 

This issue is caused by any of the following :

  1. The Oracle client software has been installed in a version < 8.1.7
  2. The ORACLE_HOME variable on the machine is pointing to the wrong directory
  3. There is a Run.. As User on the Gallery and it doesn't have the Oracle client installed and/or the appropriate rights on the Oracle Instant Client installation folder

 

For each of these causes there is a solution outlined below.

 

Solution A

 

  1. Download the client directly from Oracle  (Instant Client Downloads for Microsoft Windows (x64) 64-bit)
  2. Follow the installation instructions provided by them at the bottom of the page
  3. Restart Designer

 

Solution B

 

  1. Locate the ORACLE_HOME folder on the machine, this is typically :
    • the "Ora92" folder under the "Oracle" folder (i.e. D:\Oracle\Ora92) in Oracle9iR2 or
    • the "Client_1" folder under the "Oracle\product\10.1.0" folder (i.e. D:\Oracle\product\10.1.0\Client_1) in Oracle10gR1 or
    • the "Db_1" folder under the "Oracle\product\10.1.0" folder (i.e. D:\Oracle\product\10.1.0\Db_1) in Oracle10gR1 
  2. Locate the ORACLE_HOME environment variable in the registry editor of the machine
  3. If this variable it doesn't match the path, change it to the right one
  4. Restart Designer

 

Solution C

 

  1. Log on to Windows as either :
    • a user with Administrator privileges
    • the Run As.. User set in the Alteryx System Settings
    • the Service Account behind Alteryx Service
  2. Start Windows File Explorer and navigate to the ORACLE_HOME folder.
  3. Choose properties on the ORACLE_HOME folder.
  4. Click the Security tab of the Properties window.
  5. Click on Authenticated Users item in the Name list.
  6. Un-check the Read and Execute box in the Permissions list under the Allow column.
  7. Re-check the Read and Execute box under the Allow column.
  8. Click the Advanced button :
    • in the Permission Entries verify that Authenticated Users are listed with permission: Read & Execute, and Apply To: This folder, subfolders and files.
    • If not, edit that line and make sure that Apply To drop-down box is set to This folder, subfolders and files. This should already be set properly but it is important that you verify it.
  9. Click the OK button until you close out all of the security properties windows. The cursor may present the hour glass for a few seconds as it applies the permissions you just changed to all subfolders and files.
  10. Reboot, to assure that the changes have taken effect.
  11. Re-execute the application and it should now work.

 

Additional Resources

 

 

As always, don't hesitate to contact us over at Customer Support if you run into any trouble.