topic Access SQL Error Loading Table in QlikView

Access SQL Error Loading Table

Thu, 21 Jul 2016 14:57:26 GMT

Hello everyone,

I am using QlikSense Desktop and have tried most of the ways to figure out what this error means but still can't fix it.

QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1001, ErrorCode: 4294966285, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded.

If the file in the table is small, then it works fine, but if I imported 2-3 more Excel files, that's when it doesn't work.

I also have a query running.

I hope someone can help me solve this issue

Thanks

Re: Access SQL Error Loading Table

Gysbert_Wassenaar — Thu, 21 Jul 2016 15:57:17 GMT

System resource exceeded sounds like your system ran out of disk space or ram memory. There could also be an issue if you have more than 255 columns. Regardless, it's not Qlik Sense causing the error. The ODBC driver generated the message. Try searching the internet for more information about possible causes and solutions.

Re: Access SQL Error Loading Table

squeakie_pig — Thu, 21 Jul 2016 15:58:31 GMT

I had this same error for the first time this morning. I googled the error on the forums and found a few topics

QVX_UNEXPECTED_END_OF_DATA

These explained our situation. Due to some network issues at the time the store was taking longer than expected so it created issues when it came to drop table.

Re: Access SQL Error Loading Table

Thu, 21 Jul 2016 16:56:05 GMT

What did you do to get it to work? squeakie_pig‌