Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Error while trying to retrieve text for error ORA-12705 when adding multiple IN-DB tools to different Oracle databases

Alteryx
Alteryx
Created

Environment Details


When adding in at least two In-DB tools to a workflow where each one connects to a different database, one of the In-DB tools will error with the following message:
 

ERROR [HY000] [Oracle][ODBC][Ora] Error while trying to retrieve text for error ORA-12705

ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed

ERROR [HY000][Oracle][ODBC][Ora] Error while trying to retrieve text for error ORA-12705
 

idea Skyscrapers
  • Alteryx Designer
    • 2019.1.7.18602
    • 2019.4.8.22007
  • Oracle 11g+
  • It doesn't matter the order in which connection is brought into the workflow, a single In-DB Oracle connection works fine, the error only exists if multiple In-DB tools to different Oracle databases.


Cause


Multiple Oracle clients setup or incomplete Oracle client cleanup left on the system.

Resolution


Setup the variable NLS_LANG in the Environment Variables.
  1. Go to Start and in the Run field type sysdm.cpl and press Enter.
  2. Click the Advanced tab and then click the Environment Variables button.
  3. In the System Variables section, click New.
  4. Type the following for each field:
    • Variable name: NLS_LANG
    • Variable value: AMERICAN_AMERICA.WE8MSWIN1252
  5. Click OK and close Designer and re-test the issue.