topic Re: Data Load Issue - ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]F in SAS Programming

Data Load Issue - ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]Fetch

Manasmita — Thu, 04 Jan 2024 05:26:04 GMT

Loading data from MySQL to Oracle in DI studio in table loader Transformation , I am getting this ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]Fetch without a SELECT

Re: Data Load Issue - ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]F

s_lassen — Thu, 04 Jan 2024 09:48:20 GMT

I tried looking it up, and the problem seems to come (sporadically) with the ODBC connection to MySQL (not just in SAS, the problem seems to have nothing to do with SAS). If possible, you should switch to the SAS Interface to MySQL, instead of going through ODBC.

Re: Data Load Issue - ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]F

SASKiwi — Thu, 04 Jan 2024 09:54:15 GMT

Does reading the MySQL table into a SAS dataset work reliably? You could do the load via an intermediate SAS table.

Re: Data Load Issue - ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]F

Manasmita — Thu, 04 Jan 2024 09:56:07 GMT

You mean to say , i need to migrate the required tables from MYSql to Oracle and then write a scheduler to perform the activity in scheduled basis.
But , i need to write a SAS ETL job to perform this activity .
Is there any way to overcome this issue in SAS or at DB level ?

Re: Data Load Issue - ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]F

Manasmita — Thu, 04 Jan 2024 10:06:05 GMT

Let me try to load the data in work library & get back to you asap.

Thank you very much for your quick response .

Re: Data Load Issue - ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]F

s_lassen — Thu, 04 Jan 2024 10:34:06 GMT

No, you do not need to migrate the required tables. I think the solution is to use an interface to MySQL that does not go through ODBC, as that seems to be the one creating the problems. So, if you have access for MySQL, you may want to try that instead of the ODBC interface, as suggested here.

Re: Data Load Issue - ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]F

Manasmita — Fri, 05 Jan 2024 06:01:28 GMT

I tried to load the data in work Library,but I am getting the same ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]Fetch Without Select.

Re: Data Load Issue - ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]F

Patrick — Fri, 05 Jan 2024 06:50:49 GMT

Does the source MySQL table physically exist? Can you access it by any other means?

Re: Data Load Issue - ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]F

Manasmita — Fri, 12 Jan 2024 11:43:40 GMT

Hi Patrik,

Thanks for your response.

Does the source MySQL table physically exist?

The MySQL DB is on cloud .

Can you access it by any other means?

Through public IP we are accessing the DB server.

Note:

We have migrated the data to oracle DB . Now we are doing some ETL activity on the same data & again loading the data to another oracle table , at table loader transformation we are facing the below mentioned error.

Error: CLI CURSOR FETCH ERROR , FETCH WITHOUT A SELECT

Re: Data Load Issue - ERROR: CLI cursor fetch error: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.39-log]F

Patrick — Fri, 12 Jan 2024 12:18:11 GMT

I've used in the past DIS with Oracle quite a bit but never with ODBC but the native SAS/Access to Oracle engine. If you have this engine licensed then ideally switch to using it.

I assume the issue is somewhere with the ODBC driver version. I suggest you raise a track with SAS Tech Support.