We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Input Data Tool is adding 100 duplicate records to number of records read when connected to Oracle

Suskil
Alteryx
Alteryx
Created

Issue


When connecting to Oracle 12c using a connection string of the following format, Alteryx Designer is adding 100 more records to the result set.

e.g. If the number of rows in the database is 499 for a specific query, Alteryx Designer is duplicating the first 100 rows, showing 599 in the result set.
 

Input Data (16): 599 records were read from odb:Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SUSANK)));User Id=susan;Password=__EncPwd1__ (Select ...


Environment Details

 
  • Alteryx Designer
    • Version 2019.3+.
  • Oracle
    • Server 12c
    • Client 12c
  • OLEDB
    • All versions


Cause

The issue only occurs when using OLEDB to connect to Oracle.



Resolution


Connect using the OCI option and utilize the TNSnames.ora file:
 

oci:username/password@TNSaliasName



or enter the following if not using a TNSnames.ora file:
 

oci:username/password@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=port number)))(CONNECT_DATA=(SERVICE_NAME=servicename)))


Additional Resources