Error SQLExtendedFetch:Could not complete cursor operation because the table schema change

[Raj_007]

Hi, I have tried for the following error in google but no luck,

I have an Alteryx workflow that is scheduled and it has few SQL Select statements may 3 or 4 different input box where the SQL SELECT is used (SQL Server) - there are 1 or 2 excel files (mapping files) - one of the query has the group by 

workflow is scheduled to run morning and evening every day - i dont get this error every time on and off i get this error - 

Error SQLExtendedFetch: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Could not complete cursor operation because the table schema changed after the cursor was declared.

I do not have stored procedures, cursors etc. I just use the select statements to pull the data from the SQL server, 1 select has group by a
what should be the approach? where do i start from
I use table alias names for ex FROM Sales  S    - 

any help

[Raj_007]

Bumping
any suggestions on what could be the issue...where to start with

[Christian_Holm]

Bumping this! 
Also experience the same error.

[cheins_velero]

Hi everyone,

i have found that what Alteryx probably does is save an initial Version of the schema of the table we initially selected. After any table modifications inside the Database, Alteryx will still keep the same Schema and not register the table with these changes. What i have done is resetting the caching of the table and "reselecting again".

1. Setup a new connection or edit existing one.
2. Go to the tab "Select Table" when the window with the title "Choose table or Specific Query" pops up.
3. Below the table, click on the "Refresh" button.
4. Select the table from within the "Select Table" tab.
5. Run the workflow again.
6. Save the changes.

Refresh button and tables