1 Reply Latest reply on Nov 12, 2012 5:44 AM by Vusi Nkomo

    publishing large extract timeout

    Ronak Patel

      I created a extract on desktop that is 120million rows and 770mb in size. When I go to publish the data (not workbook), the process goes through the "sending data to sever" screen but then timeouts at the next one which says "Sending data to server, completing request" after about 8-10min. Also, on the server side, when I'm publishing the extract and view the performance history page on the tableau server, the data extract is listed at about 5GB!

       

      Here are some lines from the log file as well:

       

      2012-11-07 09:19:07.100 (13b0): Action: Getting data from server  SubAction: Getting data from server Status: Completing request... Observers: 0

      2012-11-07 09:19:07.317 (13b0): Action: Getting data from server  SubAction: Getting data from server Status: Completing request... Observers: 0

      2012-11-07 09:19:07.348 (13b0): Action: Optimizing extract.  SubAction:  Status:  Observers: 0

      2012-11-07 09:19:07.675 (13b0): <connections>

      2012-11-07 09:19:07.675 (13b0):   <connection class='dataengine' dbname='C:\WINDOWS\TEMP\1s6u3gy14a8xyd1g96z5k1qlf47n\Data\Extracts\oracle_41142_703278842593.tde' server='' this='0478b620' />

      2012-11-07 09:19:07.675 (13b0):   <connection authentication='RDBMS' class='oracle' password='********' port='' server='revdb01p' service='' this='0746d938' username='pp45435' />

      2012-11-07 09:19:07.675 (13b0): </connections>

      2012-11-07 09:19:07.675 (13b0): ProtocolBase::~ProtocolBase( <connection class='firebird' dbname='c:\Program Files\Tableau\Tableau 7.0\local\data\GEOCODING.FDB' password='********' server='' this='046f9170' username='sysdba' /> )

      2012-11-07 09:19:07.675 (13b0): <connections>

      2012-11-07 09:19:07.675 (13b0):   <connection class='dataengine' dbname='C:\WINDOWS\TEMP\1s6u3gy14a8xyd1g96z5k1qlf47n\Data\Extracts\oracle_41142_703278842593.tde' server='' this='0478b620' />

      2012-11-07 09:19:07.675 (13b0):   <connection authentication='RDBMS' class='oracle' password='********' port='' server='revdb01p' service='' this='0746d938' username='pp45435' />

      2012-11-07 09:19:07.675 (13b0): </connections>

      2012-11-07 09:30:17.094 (13b0): Action: Saving Packaged Data Source  SubAction:  Status:  Observers: 0

      2012-11-07 09:30:18.249 (13b0): Action: Getting data from server  SubAction: Getting data from server Status: Completing request... Observers: 0