For about a year now, we've been unable to refresh our RedCap WDC from Tableau Desktop (2022.3.5) or Tableau Server (2022.3.5 - Windows Server 2016 on-prem) using https://redcap.ccf.org/redcap/api/?content=tableau. Tableau support suggested I put in a Github ticket to you. Below are the error messages in the Tableau Desktop logs and Server logs. Have you seen this before?
{"ts":"2023-08-03T17:29:15.999","pid":15136,"tid":"3c94","sev":"info","req":"-","sess":"-","site":"-","user":"-","k":"begin-commands-controller.invoke-command","l":{},"a":{"depth":2,"id":"M2FXmRfSkftJo+UYmvgqED","name":"commands-controller.invoke-command","root":"0Cp8XnJP0YjIXBvgDgG6kJ","sponsor":"IVQsv8ll0H4LudMJ5RlSzq","type":"begin"},"v":{"args":"tabdoc:show-detailed-error-dialog error-code-id=\"2176029519\" error-details=[\"***\"] error-dialog-title=\"An error occurred while communicating with the data source\" error-help-link=\"https://www.tableau.com/en-us/app/producthelp?build=20223.23.0310.1054&edition=pro&errorcode=81b3934f&errormessage=Tableau failed to create an extract for the \\"REDCap Data\\" data source. %0AToggle between the Data Source tab and the sheet tab to create the required extract.%0A?=en-us&platform=windows&type=redirect&version=2022.3\" error-short-message=\"Bad Connection: Tableau could not connect to the data source.\" issue-helper-links=\"\" query-details=\"\" use-copy-command=\"true\"","name":"tabdoc:show-detailed-error-dialog"},"ctx":{}}
{"ts":"2023-08-03T17:29:19.648","pid":15136,"tid":"3c94","sev":"error","req":"-","sess":"-","site":"-","user":"-","k":"detailed-error-msg","e":{"excp-error-code":"0xBAD0A3FA","excp-source":"NeedsClassification","excp-status-code":"UNKNOWN"},"v":{"details":["> Tableau failed to create an extract for the \"REDCap Data\" data source. \nToggle between the Data Source tab and the sheet tab to create the required extract.\n"],"headline":"An error occurred while communicating with the data source","shortMessage":"Bad Connection: Tableau could not connect to the data source.",
**"support-help-link":"https://www.tableau.com/en-us/app/producthelp?build=20223.23.0310.1054&edition=pro&errorcode=81b3934f&errormessage=Tableau failed to create an extract for the \"REDCap Data\" data source. %0AToggle between the Data Source tab and the sheet tab to create the required extract.%0A?=en-us&platform=windows&type=redirect&version=2022.3"}}
HyperD Log error :
{"ts":"2023-08-03T17:29:54.923437","pid":19988,"tid":"3028","sev":"info","req":"4","sess":"I7yIKABSRuChX2QFTOQHmA","k":"connection-released","v":{"establishing-connections-count":0,"retained":false,"was-active":true}}
{"ts":"2023-08-03T17:30:06.733779","pid":19988,"tid":"2b68","sev":"error","req":"-","sess":"-","k":"connection-communication-failure","v":{"std-exception":{"type":"system_error","message":"No process is on the other end of the pipe.","error-code":233,"error-category":"system","error-message":"No process is on the other end of the pipe."},"source":"CallbackConnectionCheck"}}
Hi @xHeliotrope ,
For about a year now, we've been unable to refresh our RedCap WDC from Tableau Desktop (2022.3.5) or Tableau Server (2022.3.5 - Windows Server 2016 on-prem) using https://redcap.ccf.org/redcap/api/?content=tableau. Tableau support suggested I put in a Github ticket to you. Below are the error messages in the Tableau Desktop logs and Server logs. Have you seen this before?
{"ts":"2023-08-03T17:29:15.999","pid":15136,"tid":"3c94","sev":"info","req":"-","sess":"-","site":"-","user":"-","k":"begin-commands-controller.invoke-command","l":{},"a":{"depth":2,"id":"M2FXmRfSkftJo+UYmvgqED","name":"commands-controller.invoke-command","root":"0Cp8XnJP0YjIXBvgDgG6kJ","sponsor":"IVQsv8ll0H4LudMJ5RlSzq","type":"begin"},"v":{"args":"tabdoc:show-detailed-error-dialog error-code-id=\"2176029519\" error-details=[\"***\"] error-dialog-title=\"An error occurred while communicating with the data source\" error-help-link=\"https://www.tableau.com/en-us/app/producthelp?build=20223.23.0310.1054&edition=pro&errorcode=81b3934f&errormessage=Tableau failed to create an extract for the \\"REDCap Data\\" data source. %0AToggle between the Data Source tab and the sheet tab to create the required extract.%0A?=en-us&platform=windows&type=redirect&version=2022.3\" error-short-message=\"Bad Connection: Tableau could not connect to the data source.\" issue-helper-links=\"\" query-details=\"\" use-copy-command=\"true\"","name":"tabdoc:show-detailed-error-dialog"},"ctx":{}} {"ts":"2023-08-03T17:29:19.648","pid":15136,"tid":"3c94","sev":"error","req":"-","sess":"-","site":"-","user":"-","k":"detailed-error-msg","e":{"excp-error-code":"0xBAD0A3FA","excp-source":"NeedsClassification","excp-status-code":"UNKNOWN"},"v":{"details":[" > Tableau failed to create an extract for the \"REDCap Data\" data source. \nToggle between the Data Source tab and the sheet tab to create the required extract.\n"],"headline":"An error occurred while communicating with the data source","shortMessage":"Bad Connection: Tableau could not connect to the data source.", **"support-help-link":"https://www.tableau.com/en-us/app/producthelp?build=20223.23.0310.1054&edition=pro&errorcode=81b3934f&errormessage=Tableau failed to create an extract for the \"REDCap Data\" data source. %0AToggle between the Data Source tab and the sheet tab to create the required extract.%0A?=en-us&platform=windows&type=redirect&version=2022.3"}}
HyperD Log error : {"ts":"2023-08-03T17:29:54.923437","pid":19988,"tid":"3028","sev":"info","req":"4","sess":"I7yIKABSRuChX2QFTOQHmA","k":"connection-released","v":{"establishing-connections-count":0,"retained":false,"was-active":true}} {"ts":"2023-08-03T17:30:06.733779","pid":19988,"tid":"2b68","sev":"error","req":"-","sess":"-","k":"connection-communication-failure","v":{"std-exception":{"type":"system_error","message":"No process is on the other end of the pipe.","error-code":233,"error-category":"system","error-message":"No process is on the other end of the pipe."},"source":"CallbackConnectionCheck"}}