SQL error, please help - "Invalid Cursor State"

Trying to pull monthly data for a portfolio, I have 600k+ rows on 30+ fields. ODBC connection seems fine, but when importing the code I get the following errors - looks like it might be a memory management issue? Would appreciate the help from anyone. (Blacked out server names)

Datasets

Input

Database Connection

Accepted answers

jwest

I've had this error before and adding a "BEGIN" before your query then "SET NOCOUNT ON END" after solved the problem.

So it should look like this:

BEGIN

/***Insert Query Here***/

SET NOCOUNT ON

END

All comments

patrick_mcauliffe

Are you calling any stored procedures on the SQL?

mattd17

No, I just copied my usual query from SQL Server Studio into Alteryx

TJM686

I had the same error due to the USE DATABSE command in my SQL. Removing it from the query and setting a default database in the ODBC configuration resolved the issue for me.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703