Fetch_many error

[timlee30]

Hi,

fetch_many worked fine two weeks before, but recently This is the error. Is there anyone know how to fix this ? Lots of thanks !

File "C:\Python310\lib\site-packages\sqlalchemy\engine\cursor.py", line 1122, in fetchmany
l = dbapi_cursor.fetchmany(size)
sqlalchemy.exc.DBAPIError: (pyodbc.Error) ('HY010', '[HY010] [Microsoft][ODBC Driver 17 for SQL Server]Function sequence error (0) (SQLFetch)')
(Background on this error at: https://sqlalche.me/e/20/dbapi)

[zzstoatzz]

hi @timlee30 - thank you for the question, can you elaborate on how you ended up here? the above isn't quite enough information to know how to reproduce

[timlee30]

I had a block set up in prefect cloud and it has been used 6 months and worked until two weeks ago.

and my task is simply grabbing data by using fetch_many.

This is the task.

test the task.