10 Replies Latest reply on Aug 28, 2018 2:39 AM by venkat g

Extract keeps failing - created with cross-join

Katarina Day Nov 28, 2016 2:37 AM

HI,

I have extract that is cross joining data from Cloudera hadoop and from Oracle (this one is done as custom SQL). I have published the workbook with the extract that i have scheduled to run daily (only takes few mins) but it keeps failing and has so far never run. I have tried to publish data source but even that failed to update. I have asked our data warehouse but even they are not sure why this is happening. This is actually our first extract in tableau 10 with cross join. Any ideas why or how I could resolve this?

thanks in advance

1. Re: Extract keeps failing - created with cross-join

Katarina Day Nov 28, 2016 2:45 AM (in response to Katarina Day)

just to confirm the suggested action i should do says: Check the Data Connection page for necessary updates to an access token or embedded credentials.

we have checked the connection and the credentials are embedded within extract...:(
Like Show 0 Likes(0)

Actions
2. Re: Extract keeps failing - created with cross-join

Ben Page Dec 5, 2016 1:14 PM (in response to Katarina Day)

I am having the same issue. It's my first time working with an extract that leverages the new cross-database join feature. I have a Custom SQL query that connects to Oracle, and the other connection is a simple excel file. I had no issues creating the extract, but once I published to Tableau Server, the automated refresh keeps failing. I'm not having issues manually refreshing in Tableau Desktop though. Anyone have thoughts?
Like Show 0 Likes(0)

Actions
3. Re: Extract keeps failing - created with cross-join

Katarina Day Dec 6, 2016 1:12 AM (in response to Ben Page)

Hi Ben,

I contacted Tableau at the end and it turned out it was a driver bug issue with the Impala and we had to reboot our Tableau Server. Might be worth also for you to contact them. I had to send them the logs when i run the extract.
Like Show 0 Likes(0)

Actions
4. Re: Extract keeps failing - created with cross-join

praveen p Apr 10, 2017 11:32 PM (in response to Ben Page)

Hi Ben

I am having the same issue are you able to resolve the issue if yes please reply with the steps followed to resolve the issue.
Like Show 0 Likes(0)

Actions
5. Re: Extract keeps failing - created with cross-join

venkat g Jun 10, 2017 7:22 AM (in response to Katarina Day)

Hi Katarina,

Am also having same problem.

Tableau online server keep on failing to refresh the extract at scheduled time saying errors that GREENPLUM data base sockets closed and user authentication failed.
The extract was taken by joining tables from ORACLE and GREENPLUM databases.

Please let me know how to solve this issue...

Is it possible to solve the issue using ONLINE SYNC CLIENT option OR tableau BRIDGE option??
Pls let me know.

Thanks,
Venkat.
Like Show 0 Likes(0)

Actions
6. Re: Extract keeps failing - created with cross-join

Katarina Day Jun 12, 2017 12:38 AM (in response to venkat g)

Hi Venkat,

is it just the one extract that is failing or all of them using crossjoin? i had to contact the tableau help at the end and it was our driver that had a bug, it solved at the end by upgrading our impala to the latest version and the rebook of tableau server. I am not sure about Greenplum data base, you might be better off contacting tableau directly.

sorry i couldnt be more of help.
Like Show 0 Likes(0)

Actions
7. Re: Extract keeps failing - created with cross-join

venkat g Jul 17, 2017 4:35 AM (in response to Katarina Day)

Hi All,

I was able to solve the above problem by editing passwords of data sources using 'connections' option on server.

Thanks katarina Day for your reply.

Thanks,
Venkat.
Like Show 0 Likes(0)

Actions
8. Re: Extract keeps failing - created with cross-join

venkat g Jul 17, 2017 4:36 AM (in response to Katarina Day)

Hi All,

I was able to solve the above problem by editing passwords of data sources using 'connections' option on server.

Thanks katarina Day for your reply.

Thanks,
Venkat.
Like Show 0 Likes(0)

Actions
9. Re: Extract keeps failing - created with cross-join

Haan Haan Aug 7, 2018 4:12 AM (in response to venkat g)

Dear Venkat
I am facing the problem too.
May I know where is the connection button? I cant find. Thanks
Like Show 0 Likes(0)

Actions
10. Re: Extract keeps failing - created with cross-join

venkat g Aug 28, 2018 2:39 AM (in response to Haan Haan)

Hi Haan,

Open tableau server.
Search for data source.
choose "connections" option from "view" drop down option.
now click on 3 dots and select edit connection option.

Thanks
venkat
Like Show 0 Likes(0)

Actions