Forum Discussion

emilyannnmay12's avatar
emilyannnmay12
Frequent Visitor
8 years ago

Invalid Cursor State Error

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"

2 Replies

  • emilyannnmay12's avatar
    emilyannnmay12
    Frequent Visitor
    8 years ago

    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's avatar
    v-yuta-msft
    Community Support
    8 years ago

    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