Skip to main content

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"}}

2 answers
  1. Sep 12, 2018, 7:45 PM

    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

0/9000