topic Error while connecting to ODBC in QlikView

Error while connecting to ODBC

Wed, 05 Jun 2013 10:28:16 GMT

Hello All,

I'm getting the following error while connecting to ODBC. Can anybody help me out on this?

SQL##f - SqlState: S1000, ErrorCode: 10232, ErrorMsg: [DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]Disk cache error. Field length:100494 exceeds maximum limit of 65535.[10232]

SQL SELECT *

FROM "SCHEMA".xxUSER."change_request"

I tried and checked to extract the data from a different table belonging to the same schema xxUSER, which is coming fine.The only problem is with the change_request table. Whenever i'm trying to pull the data I'm getting the above following error.

My script goes like this:

ODBC CONNECT TO S*******W (XUserId is EAxxxxxxxxxxxxx, XPassword is UMxxxxxxxxxxxxxxx);

LOAD *;

SQL SELECT *

FROM "SCHEMA".xxUSER."change_request";

Re: Error while connecting to ODBC

Gysbert_Wassenaar — Wed, 05 Jun 2013 13:46:11 GMT

You're probably trying to extract some sort of memo field that contains a very large amount of text (or binary data). It seems your odbc driver does not support that. Try finding out which field that is and don't include it in your sql statement. You'll have to replace the * with actual field names.

Re: Error while connecting to ODBC

rbecher — Wed, 05 Jun 2013 14:05:18 GMT

It seems to be that the SQL parser of the ODBC driver missinterprets the column "order" as ORDER BY clause.

- Ralf

Re: Error while connecting to ODBC

Wed, 05 Jun 2013 14:19:52 GMT

I commented the order field and ran the script and guess what??

The same error:

SQL##f - SqlState: S1000, ErrorCode: 10232, ErrorMsg: [DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]Disk cache error. Field length:100494 exceeds maximum limit of 65535.[10232]

SQL SELECT *

FROM "SCHEMA".OAUSER."change_request"

I think the only solution left with me is, I need to check the data type which is not supported by ODBC, remove it and reload it again as told by Gysbert Wassenaar.