topic Re: Script Error: Did not recognise connector reply SQL SELECT * From ******** in QlikView

Script Error: Did not recognise connector reply SQL SELECT * From ********

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to load multiple excel binary files (.xlsb) by ODBC connection. I am getting the following error.

What interesting here is i was able to load 3 of such files a couple of days ago and now i am getting the error. The load time was quite a good (~ 7-8 mins for a file with ~750000 records). I expected the size of file may be an issue so i created a dummy small file with just 10 records in it and tried to load the same.

The small .xlsb file (with 10 records) get loaded and my original .xlsb file (~ 750000 records) throws the said error.

My script is like:

Reload throws this:

The files type and location is exactly the same.

Any lead to this problem will higly appreaciated.

Thanks,

Ashar

Re: Script Error: Did not recognise connector reply SQL SELECT * From ********

jaumecf23 — Thu, 06 Jul 2017 09:43:56 GMT

Do you have the solution? I'm facing the same issue...

Re: Script Error: Did not recognise connector reply SQL SELECT * From ********

kaushiknsolanki — Thu, 06 Jul 2017 09:48:39 GMT

Check if there are any special character in your data. At times the connector do not understand those character and we get this kind of error.

Regards,

Kaushik Solanki

Re: Script Error: Did not recognise connector reply SQL SELECT * From ********

Anonymous — Thu, 06 Jul 2017 09:48:44 GMT

Hi !

Are you really in 32 bit?

Re: Script Error: Did not recognise connector reply SQL SELECT * From ********

prma7799 — Thu, 06 Jul 2017 09:50:15 GMT

firstly comment your first connection and check second one is working or not.

Re: Script Error: Did not recognise connector reply SQL SELECT * From ********

craig157 — Thu, 06 Jul 2017 09:58:22 GMT

Morning Ashar,

Maybe you should try setting up some Incrimental Loads? Just if the file is 750,000 records it might be using up all your RAM or just timeout?

I'd also try Debugging your script with a Limited load on a couple different values,

So first time 100,000 and if that works then 200,000 etc etc. Hopefully you'll be able to see the value it is maxing out at...

Re: Script Error: Did not recognise connector reply SQL SELECT * From ********

Thu, 06 Jul 2017 16:24:41 GMT

As far i can see in the dataset , there are no any special chars.

Regards,

Ashar

Re: Script Error: Did not recognise connector reply SQL SELECT * From ********

Thu, 06 Jul 2017 16:27:27 GMT

Hi,

No, i am using a 64 bit machine, but the ODBC driver is 32 bit. Hence while connecting i am using 'Force 32 bit' connection.

Regards,