How to isolate an error in creating an extract?
Jeremy Becker Jun 4, 2014 9:35 AMAre 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. </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