2 Replies Latest reply on Jul 26, 2018 4:08 AM by Joe Morris

    Tableau desktop: Bad connection: Tableau could not connect to the data source

    Joe Morris

      When i try and edit a workbook in tableau desktop I keep getting the above error and data fails to load. eventually with enough refreshes it does resolve itself.

       

      The same workbooks perform fine on tableau server - although there are some time out issues on occasion they are no where near as frequent as i am seeing on desktop.

       

      Can someone point me in the right direction to resolve this?

       

      Full error message:

       

      An error occurred while communicating with data source 'DI 50 Days - Tracking Status Report'.

       

       

      Bad Connection: Tableau could not connect to the data source.

      HTTP 503: <html><head><style type='text/css'>html, body, iframe {margin: 0px; padding: 0px; border: none;}</style></head><body><iframe src ='/errors/5xx.html' width='100%' height='100%' frameborder='0' marginheight='0' marginwidth='0' scrolling='auto'/></body></html>

      <?xml version='1.0' encoding='utf-8' ?>

       

       

      <sqlproxy>

        <logical-query version='1.1.0'>

          <selects>

            <field>[Calculation_795448295580524544]</field>

            <field>[TEMP(Calculation_626844823138664449)(2578455615)(0)]</field>

            <field>[TEMP(TC_)(2281669525)(0)]</field>

            <field>[TEMP(TC_)(989307306)(0)]</field>

          </selects>

          <dictionaryOp class='logical-operator'>

            <bindings>

              <binding ref='1'>

                <funcallExp class='logical-expression' function='==' shape='scalar'>

                  <identifierExp class='logical-expression' identifier='[NormalisedEventIdentifier]' />

                  <literalExp charset='0' class='logical-expression' collation='LEN_RGB_S2' datatype='string' value='&quot;UNDELIVERABLE&quot;' />

                </funcallExp>

              </binding>

              <binding ref='2'>

                <funcallExp class='logical-expression' function='==' shape='scalar'>

                  <identifierExp class='logical-expression' identifier='[NormalisedEventIdentifier]' />

                  <literalExp charset='0' class='logical-expression' collation='LEN_RGB_S2' datatype='string' value='&quot;CANCELLED&quot;' />

                </funcallExp>

              </binding>

              <binding ref='3'>

                <funcallExp class='logical-expression' function='==' shape='scalar'>

                  <identifierExp class='logical-expression' identifier='[NormalisedEventIdentifier]' />

                  <literalExp charset='0' class='logical-expression' collation='LEN_RGB_S2' datatype='string' value='&quot;RETURN_TO_SENDER&quot;' />

                </funcallExp>

              </binding>

              <binding ref='4'>

                <funcallExp class='logical-expression' function='==' shape='scalar'>

                  <identifierExp class='logical-expression' identifier='[NormalisedEventIdentifier]' />

                  <literalExp charset='0' class='logical-expression' collation='LEN_RGB_S2' datatype='string' value='&quot;REFUSED_BY_RECIPIENT&quot;' />

                </funcallExp>

              </binding>

              <binding ref='5'>

                <funcallExp class='logical-expression' function='==' shape='scalar'>

                  <identifierExp class='logical-expression' identifier='[NormalisedEventIdentifier]' />

                  <literalExp charset='0' class='logical-expression' collation='LEN_RGB_S2' datatype='string' value='&quot;DELIVERY_REFUSED&quot;' />

                </funcallExp>

              </binding>

            </bindings>

            <projectOp class='logical-operator'>

              <expressions>

                <binding name='[TEMP(Calculation_626844823138664449)(2578455615)(0)]'>

                  <identifierExp class='logical-expression' identifier='[TEMP(TC_)(2281669525)(0)]' />

                </binding>

              </expressions>

              <aggregateOp class='logical-operator'>

                <measures>

                  <binding name='[TEMP(TC_)(2281669525)(0)]'>

                    <funcallExp class='logical-expression' function='SUM' shape='aggregate'>

                      <caseExp class='logical-expression'>

                        <literalExp class='logical-expression' datatype='boolean' value='true' />

                        <referenceExp class='logical-expression' ref='1' />

                        <identifierExp class='logical-expression' identifier='[Parcel Count]' />

                        <referenceExp class='logical-expression' ref='2' />

                        <identifierExp class='logical-expression' identifier='[Parcel Count]' />

                        <referenceExp class='logical-expression' ref='3' />

                        <identifierExp class='logical-expression' identifier='[Parcel Count]' />

                        <referenceExp class='logical-expression' ref='4' />

                        <identifierExp class='logical-expression' identifier='[Parcel Count]' />

                        <referenceExp class='logical-expression' ref='5' />

                        <identifierExp class='logical-expression' identifier='[Parcel Count]' />

                        <literalExp class='logical-expression' datatype='integer' value='%null%' />

                      </caseExp>

                    </funcallExp>

                  </binding>

                  <binding name='[TEMP(TC_)(989307306)(0)]'>

                    <funcallExp class='logical-expression' function='SUM' shape='aggregate'>

                      <identifierExp class='logical-expression' identifier='[Parcel Count]' />

                    </funcallExp>

                  </binding>

                </measures>

                <groupbys>

                  <binding name='[Calculation_795448295580524544]'>

                    <identifierExp class='logical-expression' identifier='[Calculation_795448295580524544]' />

                  </binding>

                </groupbys>

                <selectOp class='logical-operator'>

                  <predicate>

                    <funcallExp class='logical-expression' function='$SYS_NARY_AND$' shape='scalar'>

                      <identifierExp class='logical-expression' identifier='[$temp0_cse]' />

                      <identifierExp class='logical-expression' identifier='[$temp0_cse]' />

                    </funcallExp>

                  </predicate>

                  <projectOp class='logical-operator'>

                    <expressions>

                      <binding name='[$temp0_cse]'>

                        <caseExp class='logical-expression'>

                          <literalExp class='logical-expression' datatype='boolean' value='true' />

                          <funcallExp class='logical-expression' function='CONTAINS' shape='scalar'>

                            <identifierExp class='logical-expression' identifier='[USER_String]' />

                            <funcallExp class='logical-expression' function='$COLLATE_REMOTE$' shape='scalar'>

                              <literalExp charset='0' class='logical-expression' collation='LROOT' datatype='string' value='&quot;-Asos Demo-&quot;' />

                              <literalExp charset='0' class='logical-expression' collation='LROOT' datatype='string' value='&quot;LEN_RGB_S2&quot;' />

                            </funcallExp>

                          </funcallExp>

                          <literalExp class='logical-expression' datatype='boolean' value='true' />

                          <literalExp class='logical-expression' datatype='boolean' value='false' />

                        </caseExp>

                      </binding>

                    </expressions>

                    <projectOp class='logical-operator'>

                      <expressions>

                        <binding name='[Calculation_795448295580524544]'>

                          <caseExp class='logical-expression'>

                            <literalExp class='logical-expression' datatype='boolean' value='true' />

                            <referenceExp class='logical-expression' ref='1' />

                            <identifierExp class='logical-expression' identifier='[$temp1_cse]' />

                            <referenceExp class='logical-expression' ref='2' />

                            <identifierExp class='logical-expression' identifier='[$temp1_cse]' />

                            <referenceExp class='logical-expression' ref='3' />

                            <identifierExp class='logical-expression' identifier='[$temp1_cse]' />

                            <referenceExp class='logical-expression' ref='4' />

                            <identifierExp class='logical-expression' identifier='[$temp1_cse]' />

                            <referenceExp class='logical-expression' ref='5' />

                            <identifierExp class='logical-expression' identifier='[$temp1_cse]' />

                            <literalExp charset='0' class='logical-expression' collation='LROOT' datatype='string' value='%null%' />

                          </caseExp>

                        </binding>

                      </expressions>

                      <projectOp class='logical-operator'>

                        <expressions>

                          <binding name='[$temp1_cse]'>

                            <funcallExp class='logical-expression' function='+' shape='scalar'>

                              <funcallExp class='logical-expression' function='+' shape='scalar'>

                                <identifierExp class='logical-expression' identifier='[CountryName]' />

                                <literalExp charset='0' class='logical-expression' collation='LEN_RUS_S2' datatype='string' value='&quot; | &quot;' />

                              </funcallExp>

                              <funcallExp class='logical-expression' function='$COLLATE_REMOTE$' shape='scalar'>

                                <identifierExp class='logical-expression' identifier='[RecipientCountryCode]' />

                                <literalExp charset='0' class='logical-expression' collation='LROOT' datatype='string' value='&quot;LEN_RUS_S2&quot;' />

                              </funcallExp>

                            </funcallExp>

                          </binding>

                        </expressions>

                        <relationOp class='logical-operator' connection='' name='[sqlproxy]'>

                          <relation type='parameterized'>

                            <parameters>

                              <parameter name='[Data Type (copy)]' value='&apos;Returned Due to Non-Delivery&apos;' />

                              <parameter name='[Manifest Month Parameter]' value='&apos;Actual&apos;' />

                              <parameter name='[Parameter 1]' value='&apos;Days&apos;' />

                            </parameters>

                            <relation name='sqlproxy' type='table' />

                          </relation>

                          <cols />

                        </relationOp>

                      </projectOp>

                    </projectOp>

                  </projectOp>

                </selectOp>

              </aggregateOp>

            </projectOp>

          </dictionaryOp>

        </logical-query>

        <datasource hasconnection='false' inline='true' name='Parameters' version='18.1'>

          <aliases enabled='yes' />

          <column caption='Parcel Status' datatype='string' name='[Data Type (copy)]' param-domain-type='list' role='measure' type='nominal' value='&quot;Returned Due to Non-Delivery&quot;'>

            <calculation class='tableau' formula='&quot;Returned Due to Non-Delivery&quot;' />

          </column>

          <column caption='Data Type' datatype='string' name='[Manifest Month Parameter]' param-domain-type='list' role='measure' type='nominal' value='&quot;Actual&quot;'>

            <calculation class='tableau' formula='&quot;Actual&quot;' />

          </column>

          <column alias='Days' caption='Time Period' datatype='string' name='[Parameter 1]' param-domain-type='list' role='measure' type='nominal' value='&quot;Days&quot;'>

            <calculation class='tableau' formula='&quot;Days&quot;' />

            <aliases>

              <alias key='&quot;Days&quot;' value='Days' />

              <alias key='&quot;Months&quot;' value='Months' />

              <alias key='&quot;Weekdays&quot;' value='Weekdays' />

              <alias key='&quot;Weeks&quot;' value='Weeks' />

            </aliases>

          </column>

        </datasource>

      </sqlproxy>