Refresh Error: Invalid Cursor State

emilyannnmay12 · ‎07-24-2018

I am using Power BI desktop and i get an error everytime I refresh one of my queries. The error is "Unable to connect: IBM DB2:ERROR [24000] [ibm] CLI0115E Invalid cursor state. SQLSTATE = 24000"

emilyannnmay12 · ‎07-24-2018

I get the same error everytime I try to refresh my data set in the desktop version. The error says "Unable to Connect. Details IBM DB2 ERROR [24000] [IBM] CLI0115E Invalid cursor state. SQLSTATE = 24000"

v-yuta-msft · ‎07-25-2018

Hi emilyannnmay12,

It seems like there's something wrong with the cursor state when you implement your sql statement. So the error is more about the SQL statement. In addtion, please check if there's same error when you implememt the same script in your database.

Regards,

Jimmy Tao