Invalid Cursor State Error

[Former Member]

First off, I created a new MySQL ODBC connection and everything connected successfully.

When I open a Crystal Report, I click on the refresh button and select that newly created datasource (that I created via the MySQL ODBC driver), enter in the user credentials associated with this datasource (and the user has all grants to all tables used in this report) BUT when the credentials go through and the refresh is actually taking place I get the following error:

Database Connector Error: '24000:[MySQL][ODBC 5.2(a) Driver][mysqld-5.5.49-0ubuntu0.14.04.1]Invalid Cursor State

And, then it says Database Connector Error: ''

It only happens on certain reports and not others.

Please help this is extremely frustrating.  Thanks!!

[former_member183750 · Accepted solution]

The error is from the SQL client, so google the error. E.g.; Database Connector Error: 24000. From what I quickly read on the error, it appears to be some client config issue. Nothing to do with CR as such...

- Ludek

Senior Support Engineer Product Support, Global Support Center Canada

Follow me on Twitter

Got Enhancement ideas? Use the SAP Idea Place

[Former Member · Accepted solution]

If it has nothing to do with CR then why do some reports work and some don't.  Any other ideas?  I agree it doesn't make sense that the database connect error would be triggered on some and not others - but that is really confusing.

[Former Member · Accepted solution]

I figured it out! The error was related to the views within that report being defined by another user. So, we followed the directions at the link below and altered the user who defined the different views:  permissions - MySQL error 1449: The user specified as a definer does not exist - Stack Overflow.  If you run into this error, I would recommend making sure all of the tables and views that are in the report have been defined by the user accessing those reports or the user has access to them.

[former_member183750 · Accepted solution]

Hi Ben

Many, many thanks for letting us know. I'm sure your post will help in the future

- Ludek