Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Error while connecting to ODBC

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";

3 Replies

Re: Error while connecting to ODBC

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.


talk is cheap, supply exceeds demand
MVP
MVP

Re: Error while connecting to ODBC

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

- Ralf

Not applicable

Re: Error while connecting to ODBC

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.

Community Browser