8 Replies Latest reply on Jan 3, 2017 3:50 AM by munawar abad

    query gives error but reports are working fine

    munawar abad

      error.jpeg

      I get this error when i try to update the data source but the reports on the dashboards show the data properly. I have tried executing the query directly which doesn't work. Even if i remove the extra bracket it keeps giving error. The query remains the same even if I delete the calculated field giving the error. The query remains the same even if I export a single report as a new twb file. I don't get this error for other data sources and I am using the redshift data source one tableau 9.2.7.

        • 1. Re: query gives error but reports are working fine
          Sagar Sanjay Joshi

          Can you paste the whole error? you can click on "Copy" and paste it in here.

          • 2. Re: query gives error but reports are working fine
            Jim Dehner

            I am having a similar problem - I had developed a workbook on 10.1 the last week and then tried to open it on Tuesday and got the message below:

             

             

            Today I updated to version 10.1.3 and was able to open the file and work on it. I closed (saved) the file but then was unable to open it again

             

            Then complete message is:

             

            (restrict

              (aggregate

                (project

                  (project

                    (table [TableauTemp].[map#txt])

                    (

                      ([$temp0_output]

                        (case

                          (isnull [FIPS Code])

                          "Other"

                          (case

                            (= [FIPS Code] "48001")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48005")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48037")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48063")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48067")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48073")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48097")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48119")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48147")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48159")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48181")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48183")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48203")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48213")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48223")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48225")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48277")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48315")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48337")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48343")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48347")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48365")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48379")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48387")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48401")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48403")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48405")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48419")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48423")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48449")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48455")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48459")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48467")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48499")

                            "48001, 48005, 48037 and 31 more"

                            (= [FIPS Code] "48003")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48009")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48011")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48017")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48023")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48033")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48043")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48045")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48049")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48059")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48069")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48075")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48077")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48079")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48081")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48083")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48087")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48095")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48101")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48103")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48105")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48109")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48111")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48115")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48125")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48127")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48129")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48133")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48135")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48137")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48151")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48155")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48163")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48165")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48173")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48179")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48191")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48195")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48197")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48205")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48207")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48211")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48227")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48235")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48237")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48243")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48253")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48263")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48265")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48267")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48269")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48271")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48275")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48283")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48295")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48301")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48307")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48317")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48319")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48327")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48329")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48335")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48341")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48345")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48353")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48357")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48359")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48363")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48369")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48371")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48377")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48383")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48385")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48389")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48393")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48399")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48413")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48415")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48417")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48421")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48429")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48431")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48433")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48435")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48441")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48443")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48447")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48451")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48461")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48463")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48465")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48475")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48483")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48485")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48487")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48495")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48501")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48503")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48507")

                            "48003, 48009, 48011 and 96 more"

                            (= [FIPS Code] "48007")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48025")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48047")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48057")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48175")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48249")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48255")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48261")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48273")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48297")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48355")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48391")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48409")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48469")

                            "48007, 48025, 48047 and 11 more"

                            (= [FIPS Code] "48013")

                            "48013, 48019, 48029 and 5 more"

                            (= [FIPS Code] "48019")

                            "48013, 48019, 48029 and 5 more"

                            (= [FIPS Code] "48029")

                            "48013, 48019, 48029 and 5 more"

                            (= [FIPS Code] "48091")

                            "48013, 48019, 48029 and 5 more"

                            (= [FIPS Code] "48187")

                            "48013, 48019, 48029 and 5 more"

                            (= [FIPS Code] "48259")

                            "48013, 48019, 48029 and 5 more"

                            (= [FIPS Code] "48325")

                            "48013, 48019, 48029 and 5 more"

                            (= [FIPS Code] "48493")

                            "48013, 48019, 48029 and 5 more"

                            (= [FIPS Code] "48015")

                            "48015, 48039, 48157 and 6 more"

                            (= [FIPS Code] "48039")

                            "48015, 48039, 48157 and 6 more"

                            (= [FIPS Code] "48157")

                            "48015, 48039, 48157 and 6 more"

                            (= [FIPS Code] "48167")

                            "48015, 48039, 48157 and 6 more"

                            (= [FIPS Code] "48201")

                            "48015, 48039, 48157 and 6 more"

                            (= [FIPS Code] "48321")

                            "48015, 48039, 48157 and 6 more"

                            (= [FIPS Code] "48339")

                            "48015, 48039, 48157 and 6 more"

                            (= [FIPS Code] "48473")

                            "48015, 48039, 48157 and 6 more"

                            (= [FIPS Code] "48481")

                            "48015, 48039, 48157 and 6 more"

                            (= [FIPS Code] "48021")

                            "48021, 48053, 48055 and 5 more"

                            (= [FIPS Code] "48053")

                            "48021, 48053, 48055 and 5 more"

                            (= [FIPS Code] "48055")

                            "48021, 48053, 48055 and 5 more"

                            (= [FIPS Code] "48149")

                            "48021, 48053, 48055 and 5 more"

                            (= [FIPS Code] "48209")

                            "48021, 48053, 48055 and 5 more"

                            (= [FIPS Code] "48287")

                            "48021, 48053, 48055 and 5 more"

                            (= [FIPS Code] "48453")

                            "48021, 48053, 48055 and 5 more"

                            (= [FIPS Code] "48491")

                            "48021, 48053, 48055 and 5 more"

                            (= [FIPS Code] "48027")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48031")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48035")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48041")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48051")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48089")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48093")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48099")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48123")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48143")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48145")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48161")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48171")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48177")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48185")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48193")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48217")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48239")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48281")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48285")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48289")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48293")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48299")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48309")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48313")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48331")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48333")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48395")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48411")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48425")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48477")

                            "48027, 48031, 48035 and 28 more"

                            (= [FIPS Code] "48061")

                            "48061, 48131, 48215 and 7 more"

                            (= [FIPS Code] "48131")

                            "48061, 48131, 48215 and 7 more"

                            (= [FIPS Code] "48215")

                            "48061, 48131, 48215 and 7 more"

                            (= [FIPS Code] "48247")

                            "48061, 48131, 48215 and 7 more"

                            (= [FIPS Code] "48311")

                            "48061, 48131, 48215 and 7 more"

                            (= [FIPS Code] "48323")

                            "48061, 48131, 48215 and 7 more"

                            (= [FIPS Code] "48427")

                            "48061, 48131, 48215 and 7 more"

                            (= [FIPS Code] "48479")

                            "48061, 48131, 48215 and 7 more"

                            (= [FIPS Code] "48489")

                            "48061, 48131, 48215 and 7 more"

                            (= [FIPS Code] "48505")

                            "48061, 48131, 48215 and 7 more"

                            (= [FIPS Code] "48065")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48107")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48117")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48153")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48169")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48189")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48219")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48233")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48279")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48303")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48305")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48375")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48381")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48437")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48445")

                            "48065, 48107, 48117 and 12 more"

                            (= [FIPS Code] "48071")

                            "48071, 48199, 48241 and 8 more"

                            (= [FIPS Code] "48199")

                            "48071, 48199, 48241 and 8 more"

                            (= [FIPS Code] "48241")

                            "48071, 48199, 48241 and 8 more"

                            (= [FIPS Code] "48245")

                            "48071, 48199, 48241 and 8 more"

                            (= [FIPS Code] "48291")

                            "48071, 48199, 48241 and 8 more"

                            (= [FIPS Code] "48351")

                            "48071, 48199, 48241 and 8 more"

                            (= [FIPS Code] "48361")

                            "48071, 48199, 48241 and 8 more"

                            (= [FIPS Code] "48373")

                            "48071, 48199, 48241 and 8 more"

                            (= [FIPS Code] "48407")

                            "48071, 48199, 48241 and 8 more"

                            (= [FIPS Code] "48457")

                            "48071, 48199, 48241 and 8 more"

                            (= [FIPS Code] "48471")

                            "48071, 48199, 48241 and 8 more"

                            (= [FIPS Code] "48085")

                            "48085, 48113, 48139 and 4 more"

                            (= [FIPS Code] "48113")

                            "48085, 48113, 48139 and 4 more"

                            (= [FIPS Code] "48139")

                            "48085, 48113, 48139 and 4 more"

                            (= [FIPS Code] "48231")

                            "48085, 48113, 48139 and 4 more"

                            (= [FIPS Code] "48257")

                            "48085, 48113, 48139 and 4 more"

                            (= [FIPS Code] "48349")

                            "48085, 48113, 48139 and 4 more"

                            (= [FIPS Code] "48397")

                            "48085, 48113, 48139 and 4 more"

                            (= [FIPS Code] "48121")

                            "48121, 48221, 48251 and 3 more"

                            (= [FIPS Code] "48221")

                            "48121, 48221, 48251 and 3 more"

                            (= [FIPS Code] "48251")

                            "48121, 48221, 48251 and 3 more"

                            (= [FIPS Code] "48367")

                            "48121, 48221, 48251 and 3 more"

                            (= [FIPS Code] "48439")

                            "48121, 48221, 48251 and 3 more"

                            (= [FIPS Code] "48497")

                            "48121, 48221, 48251 and 3 more"

                            (= [FIPS Code] "48141")

                            "48141 & 48229"

                            (= [FIPS Code] "48229")

                            "48141 & 48229" null)

                          )

                        )

                      )

                    )

                  (

                    ([FIPS Code (group)] [$temp0_output])

                    )

                  )

                (

                  ([FIPS Code (group)] [FIPS Code (group)])

                  ([FIPS Code] [FIPS Code])

                  )

                ()

                )

              ([FIPS Code (group)] [FIPS Code])

              )

             

            sorry about the lengthy message -

            • 3. Re: query gives error but reports are working fine
              Sagar Sanjay Joshi

              Hi Jim,

                   Thanks for sharing the query.

              Could you also provide what does it say when you click on "Show Details"?

               

              • 4. Re: query gives error but reports are working fine
                Jim Dehner

                Sure - here you go - and thanks for looking at this

                 

                Tableau Data Engine Error: 48032: no such function (= integer string)

                • 5. Re: query gives error but reports are working fine
                  Sagar Sanjay Joshi

                  Hi Jim,

                       From what I could research,

                            It could be due to having an underscore '_' in the query. It is pretty odd but it could be some special character issue. Could you please try renaming [$temp0_output] without the '_' ?

                   

                  Hope that helps.

                   

                  --Joshi

                  1 of 1 people found this helpful
                  • 8. Re: query gives error but reports are working fine
                    munawar abad

                    Thanks Sanjay for your time. I managed to resolve the issue by cleaning up the un-used calculated fields (some of them had errors also).