Input tool bringing back half of the records as nulls

[eliasg]

Hi,

I have a workflow that connects to a Db2 environment (odbc driver version 11.05.00.1077). The issue is that while all expected rows are returned, only 50% of the rows are returned with values. For example, in below scenario i expect 8 fully populated records, and can show the same query result when run using sql dev. IDE. In Alteryx 4/8 rows are populated while the remaining 4, while present, return with nulls for every column. 

Has anyone else come across this before?

Regards,
Elias

[patrick_mcauliffe]

Last time I saw this is was due to the DSN settings in Windows that Alteryx was using.

Are you using the same DSN for the query tool you're comparing to?

[eliasg]

The other tool is sql developer and it's using JDBC to connect to DB2

[patrick_mcauliffe · Accepted solution]

Is the DB2 ODBC driver the same version as the server?

[ntobon]

@eliasg 

Are you running this workflow locally on the machine or running the workflow on a Gallery?
Do they have the same driver installed on the server machine? (it should be)
Is the database connection name exactly the same on the server machine as it is for the user>? (it should be)

[eliasg]

@patrick_mcauliffe  thank you for this suggestion. I removed my current driver and installed exact same version and hotfix as what's on db side and it's working now!

[eliasg]

@ntobon thank you for following on this. I was running it locally. All set now!