Hello All,
I have created a web data connector and trying to create an extract using it in tableau desktop. The data source has around 760K rows and 25 columns, which is coming to around 1.5GB. I get the below error.
The same connection works when I reduce the rows to 650K.
Is there any limitation on the size of data for web data connector extracts? and is there a work around to get around this?
Thanks in advance
Vijay R.
{"ts":"2018-08-21T13:24:08.374","pid":27148,"tid":"2b28","sev":"warn","req":"-","sess":"-","site":"{FFE32FBF-E570-4F86-B523-F19E00ED0F3D}","user":"-","k":"msg","v":"ExternalProtocol::PipeMessageSource::ReadBytes: Communication with the Tableau Protocol Server process was lost. IPC_NamedPipeConnection::Read(len=4, connection=tab.pipe://./pipe/{BD000669-454D-4ED7-8D3E-E3EC1EA9C09B}): The pipe has been ended."}
{"ts":"2018-08-21T13:24:08.374","pid":27148,"tid":"4810","sev":"warn","req":"-","sess":"-","site":"{FFE32FBF-E570-4F86-B523-F19E00ED0F3D}","user":"-","k":"msg","v":"ExternalProtocol::PipeMessageSink::WriteBytes: IPC_NamedPipeConnection::Write(len=4, connection=tab.pipe://./pipe/{BD000669-454D-4ED7-8D3E-E3EC1EA9C09B}): The pipe is being closed."}
{"ts":"2018-08-21T13:24:08.378","pid":27148,"tid":"4810","sev":"warn","req":"-","sess":"-","site":"{FFE32FBF-E570-4F86-B523-F19E00ED0F3D}","user":"-","k":"msg","v":"ExternalProtocol::PipeMessageSink::WriteBytes: Communication with the Tableau Protocol Server process was lost."}
{"ts":"2018-08-21T13:24:08.378","pid":27148,"tid":"2b28","sev":"info","req":"-","sess":"-","site":"{FFE32FBF-E570-4F86-B523-F19E00ED0F3D}","user":"-","k":"msg","v":"Exception: ExternalProtocol::PipeMessageSource::ReadBytes: Communication with the Tableau Protocol Server process was lost."}
{"ts":"2018-08-21T13:24:08.378","pid":27148,"tid":"4810","sev":"fatal","req":"-","sess":"-","site":"{FFE32FBF-E570-4F86-B523-F19E00ED0F3D}","user":"-","k":"msg","v":"*** Fatal Exception: Communication with the Tableau Protocol Server process was lost."}
{"ts":"2018-08-21T13:24:08.415","pid":27148,"tid":"4810","sev":"error","req":"-","sess":"-","site":"{FFE32FBF-E570-4F86-B523-F19E00ED0F3D}","user":"-","k":"msg","v":"Exception when requesting progress report. Communication with the Tableau Protocol Server process was lost.\n"}
{"ts":"2018-08-21T13:24:08.420","pid":27148,"tid":"4810","sev":"info","req":"-","sess":"-","site":"{FFE32FBF-E570-4F86-B523-F19E00ED0F3D}","user":"-","k":"msg","v":"ProgressPollingTask complete"}
{"ts":"2018-08-21T13:24:08.459","pid":27148,"tid":"2b28","sev":"warn","req":"-","sess":"-","site":"{FFE32FBF-E570-4F86-B523-F19E00ED0F3D}","user":"-","k":"msg","v":"Protocol Server disconnected. Process ID: 22056, operation ExternalProtocol::RunQueryTask::ExecuteImpl"}
{"ts":"2018-08-21T13:24:08.464","pid":27148,"tid":"2b28","sev":"warn","req":"-","sess":"-","site":"{FFE32FBF-E570-4F86-B523-F19E00ED0F3D}","user":"-","k":"excp","v":{"class":"","dse-type":"Disconnect","excp-msg":"The connection to the data source might have been lost.\nExternalProtocol::PipeMessageSource::ReadBytes: Communication with the Tableau Protocol Server process was lost.\n","excp-type":"class DataSourceException","is-bad-request":false,"is-local-configuration-error":false,"is-remote-configuration-error":false,"msg":"DataSourceException::Throw"}}
{"ts":"2018-08-21T13:24:08.476","pid":27148,"tid":"2568","sev":"warn","req":"-","sess":"-","site":"{FFE32FBF-E570-4F86-B523-F19E00ED0F3D}","user":"-","k":"compute-task-error","v":{"msg":"The connection to the data source might have been lost.\nExternalProtocol::PipeMessageSource::ReadBytes: Communication with the Tableau Protocol Server process was lost.\n","stack":"disabled","task-name":"class ExternalProtocol::RunQueryTask"}}
{"ts":"2018-08-21T13:24:08.476","pid":27148,"tid":"2568","sev":"warn","req":"-","sess":"-","site":"{FFE32FBF-E570-4F86-B523-F19E00ED0F3D}","user":"-","k":"excp","v":{"class":"","dse-type":"Disconnect","excp-msg":"The connection to the data source might have been lost.\nExternalProtocol::PipeMessageSource::ReadBytes: Communication with the Tableau Protocol Server process was lost.\n","excp-type":"class DataSourceException","is-bad-request":false,"is-local-configuration-error":false,"is-remote-configuration-error":false,"msg":"DataSourceException::Throw"}}
Hello Vijay,
There is not specific restrictions in the WDC datasource. What I suspect is occurring is the system running the WDC or extract is underpowered for the given task. There is a good Community Forums post that disucsses this here: ODBC issues
Hope this helps!
Cheers,
Byrne, Patrick