5 Replies Latest reply on Nov 15, 2012 2:35 AM by Jurgen Schepens

Extended Loading Metadata Running Time

gall3on Jun 13, 2012 11:07 AM

Hi,

I'm connecting via sql to a work database using the following syntax:

select

CAST(acd_start_date_time AS DATE) 'Date Call',

left(caller_ani,3) 'Area Code',

count (1) as 'Switch Calls',

count (talk_start_date_time) as 'Agent Calls'

FROM db1 A

left join db2 B

On A.dial_id = B.dial_id

where A.campaign_id = 'inbound' and A.acd_start_date_time is not null

GROUP BY CAST(acd_start_date_time AS DATE), left(caller_ani,3)

Running this query in SQL server takes less than a minute. However, as I try to run this in Tableau it's going on 10+ minutes already, with the Loading Metadata status.

Should this be happening?

1. Re: Extended Loading Metadata Running Time

Tracy Rodgers Jun 15, 2012 2:47 PM (in response to gall3on)

Hi Abigail,

This is a good one to send to our support team. You can fill out a form at:

http://www.tableausoftware.com/support/request

If possible send the workbook (twbx file) and log files: http://www.tableausoftware.com/support/knowledge-base/creating-tableau-server-log-files http://kb.tableausoftware.com/articles/knowledgebase/sending-tableau-desktop-log-files

-Tracy
Like Show 0 Likes(0)

Actions
2. Re: Extended Loading Metadata Running Time

Andy Kriebel Oct 23, 2012 5:50 PM (in response to gall3on)

What was Tableau support's response to this? I'm having the same problem with an Oracle live connection. It'll take over 25 minutes to load metadata. Then Tableau craps its pants.
Like Show 0 Likes(0)

Actions
3. Re: Extended Loading Metadata Running Time

Ronak Patel Nov 5, 2012 2:20 PM (in response to gall3on)

same here..what was the fix?
Like Show 0 Likes(0)

Actions
4. Re: Extended Loading Metadata Running Time

Corey Meier Nov 13, 2012 7:11 PM (in response to gall3on)

Hi, is there any update on this original entry? I too have the same situation where executing my SQL query via SQL Management Studio takes ~2 minutes, but when running in Tableau, the metatdata loading takes a very long time...over 10 minutes.

Thanks.

Corey
Like Show 0 Likes(0)

Actions
5. Re: Extended Loading Metadata Running Time

Jurgen Schepens Nov 15, 2012 2:35 AM (in response to gall3on)

Same here, any advice would be welcome.
I kept it running for 1.5h and stopped it.
Using SQLTools it only takes 2mins to complete.
Like Show 0 Likes(0)

Actions