Error when switching between Dashboards in an App

Hi. I have 3 dashboards in one app. I have no error when I open them. But if I switch from one visual to another, the following error appears:

Visual 10470 - Could not load data

error: (HY000, None) AnalysisException: Syntax error in line 2: ...lendarweek` as **INTEGER)))=, (TA_0.`fw`)**, NULL))) as `(... ^ Encountered: COMMA Expected: CASE, CAST, DEFAULT, EXISTS, FALSE, IF, INTERVAL, NOT, NULL, REPLACE, TRUNCATE, TRUE, IDENTIFIER CAUSED BY: Exception: Syntax error

I have 3 global filters and when I am switching the dashboard, it looks like a comma (…INTEGER)))=, …) is in the filter out of nowhere. What is the problem here?

Thank you
Georg

@Georgio You might want to check the dataset definition and see if any of the columns you are using have been changed to be a different type.

  1. What version of Arcadia are you using?

  2. And what connection type?

Hi Shaun. You were right, I changed the data type while importing data. Right now, I did not change the data and still have the problem. It does not affect my dashboard or data, I just have an annoying error message.

  1. We use 4.5
    2, I am using uploaded csv data

Visual 10470 - Could not load data
error: (HY000, None) AnalysisException: Syntax error in line 2: …lendarweekas INTEGER)))=, (TA_0.fw), NULL))) as(… ^ Encountered: COMMA Expected: CASE, CAST, DEFAULT, EXISTS, FALSE, IF, INTERVAL, NOT, NULL, REPLACE, TRUNCATE, TRUE, IDENTIFIER CAUSED BY: Exception: Syntax error

@Georgio so are using a sqlite connection or something else for your source data?

Also is calendarweeks a column in your dataset? is it a calculated column with a custom expression?