11 Replies Latest reply on Apr 22, 2015 2:43 AM by Willem Botha

    How to isolate an error in creating an extract?

    Jeremy Becker

      Are you able to take the details logged in the backgrounder log files to work backwards and discover exactly what's causing an extract to fail? 

       

      I tried to convert a live data connection to an extract last evening.  During the run to create the extract an error is being logged that fails the process.  The error, while descriptive, falls short of telling me exactly where the problem lies.  I'm posting it below (I think.  These things are fun to read). 

       

      C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Logs\backgrounder_8250_2014_06_04_04_31_29.txt

       

      What I'm trying to determine is, where is this going wrong and how can I troubleshoot? 

       

      2014-06-04 07:05:02.463 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 2b5c: Starting AsyncTask for SessionID: F28271A825B04237A584FDD8582BA629-0:0.

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 2b5c: HTTPRequestor::DoWork::HTTPException 500 http://localhost:80/dataserver/d/Fact_Quote/82B4539823084CEB97E5FD3BCEC1C4A8-0:0/prepare.xml <?xml version='1.0' encoding='utf-8' ?>

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 2b5c:

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 2b5c: <exception name='class DataSourceException' type='Unknown'>

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 2b5c:   <error>DataServer::Dispatch</error>

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 2b5c:   <details>

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 2b5c:     <detail>[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.&#10;</detail>

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 2b5c:     <detail>prepare.xml</detail>

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 2b5c:   </details>

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 2b5c: </exception>

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 2b5c:

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 2b5c: WorkItemSetComplete: 0x000000001115df10

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500: An unknown error related to remote content was detected (500)

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500:

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500: HTTPRequestor: rethrow exception

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500: DataSourceException: type=Unknown

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500: DataSourceException: type=Disconnect

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500: throw DataSourceException (type=Disconnect): [Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500: prepare.xml

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500: class DataSourceException

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500:

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500: Removing path: C:\ProgramData\Tableau\Tableau Server\data\tabsvc\temp\TableauTemp\0xht3j20ajfdrb12a2gg40wg2zh9.tmp

      2014-06-04 07:05:17.954 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500: Removing path: C:\ProgramData\Tableau\Tableau Server\data\tabsvc\temp\TableauTemp\1ihyink1du49ku1dvyqzs11drz0x.tmp

      2014-06-04 07:05:17.970 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500:    [Count] Query returned 0 records from the cache (Q128).

      2014-06-04 07:05:17.970 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500: WorkItemCreate: 0x000000000cb428e0, 0x000000001115d890

      2014-06-04 07:05:17.970 (,,F28271A825B04237A584FDD8582BA629-0:0,-) 1500: AsyncTaskSvcExecute: 0x000000001115d890