Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

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

Suskil
Alteryx
Alteryx
Created

‎09-03-2021 04:22 PM - edited ‎09-08-2021 08:37 AM

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

 
0 Likes
Labels