5 Replies Latest reply on Aug 20, 2016 9:44 PM by Manideep Bhattacharyya

Error occurred while communicating with the data source

yashwanth nekirikanti Aug 18, 2016 7:25 AM

I'm experiencing the following error when trying select a worksheet after refresh, can you please advise on how to rectify it?

no such function: $IN_SET$
Unable to properly calculate the domain for the field 'Facility Name'. Displayed data may be incorrect.

no such function: $IN_SET$
Unable to properly calculate the domain for the field 'Financial Class Group'. Displayed data may be incorrect

Above error messages are showing up after the query completes on the data source tab. When I go to worksheet to update the actual reports, that’s when the errors begin appearing. The query runs and returns data without any problems in Teradata (I'm using custom SQL Query in tableau).

Thank you in Advance

Yashwanth Nekirikanti

Here is the one that pops up first.PNG 43.0 KB

1. Re: Error occurred while communicating with the data source

Dmitry Chirkov Aug 15, 2016 10:09 PM (in response to yashwanth nekirikanti)

What version are you using? (9.x.x?)
Issue similar to this was addressed earlier in the year...

Would you be able to share the workbook (without the data)?
Like Show 0 Likes(0)

Actions
2. Re: Error occurred while communicating with the data source

zhou.roger Aug 16, 2016 1:32 AM (in response to yashwanth nekirikanti)

Hi Yashwanth,
Maybe you can use EXTRACT not LIVE data in data source.

Thanks,
Roger
Like Show 0 Likes(0)

Actions
3. Re: Error occurred while communicating with the data source

yashwanth nekirikanti Aug 16, 2016 4:43 AM (in response to Dmitry Chirkov)

Hi Dmitry,

I'm using Version 9.3.1

Can you share me the link page where you addressed the problem.

I'm new to Tableau so i'm not sure how can I share you a workbook without data?

Thanks,
yashwanth
Like Show 0 Likes(0)

Actions
4. Re: Error occurred while communicating with the data source

yashwanth nekirikanti Aug 16, 2016 4:45 AM (in response to zhou.roger)

This Problem occured after I extract the data and try to select one of the worksheet.
Like Show 0 Likes(0)

Actions
5. Re: Error occurred while communicating with the data source

Manideep Bhattacharyya Aug 20, 2016 9:44 PM (in response to yashwanth nekirikanti)

Dear Yashwanth - Looks like this has something to do with the Custom SQL that has written. Please use a simple SQL like
Select * from <Table Name> and try if you are facing the similar error.
Like Show 0 Likes(0)

Actions