topic Saving Excel (xlsx) data to a QVD - Debug reports: Error: File .\extdata.cpp, Line 1826 in QlikView

Saving Excel (xlsx) data to a QVD - Debug reports: Error: File .\extdata.cpp, Line 1826

Thu, 11 Mar 2010 22:03:25 GMT

Hello, We are new to QlikView. Have a very large Microsoft Excel workbook. Tested smaller workbook and it works but fails with a large one. Object: creation of a qvw that created a qvd file as the data source. The statement used in the script's Main tab is below. Do you have a solution for this? Thanks in advance for your feedback.

Ricardo Pous -ricardo.pous@pioneer.com -Pioneer Hi-Bred International Inc. 1.515.270.3543

MyTable:

Load *

from (ooxml, embedded labels, table is Sheet1);

Store *

from MyTable into ;

Drop table MyTable;

Debug reports: Error: File .\extdata.cpp, Line 1826 MyTable: LOAD * FROM (ooxml, embedded labels, table is Sheet1)

Saving Excel (xlsx) data to a QVD - Debug reports: Error: File .\extdata.cpp, Line 1826

vgutkovsky — Thu, 11 Mar 2010 22:08:50 GMT

The Store statement looks incorrect. Change it to this:

Store MyTable into ;

. Also, what is this C++ file (extdata.cpp) that is being referenced in the debug report? Is this from SAP?

Regards,

Saving Excel (xlsx) data to a QVD - Debug reports: Error: File .\extdata.cpp, Line 1826

Thu, 11 Mar 2010 22:46:01 GMT

Hi Vlad and thank you for the reply. I have changed the Store statement as per your suggestion.

The Debug error happens before the Store, it happens at the Load statement and the debugger reports

Error: File .\extdata.cpp, Line 1826
MyTable:
LOAD * FROM

I searched for a cpp file in the QlikView Server & the QlikView Desktop but found nothing.

Best regards -ricardo

Saving Excel (xlsx) data to a QVD - Debug reports: Error: File .\extdata.cpp, Line 1826

vgutkovsky — Thu, 11 Mar 2010 23:36:47 GMT

Hmm, maybe QlikView uses a C++ debugger, I've never really noticed this before. Try deleting your load statement and then recreating it using the wizard--you can then be sure it will be in the right format and without typos.

Regards,

Saving Excel (xlsx) data to a QVD - Debug reports: Error: File .\extdata.cpp, Line 1826

Wed, 05 May 2010 11:58:40 GMT

I encountered the same problem and was able to fix it by changing my STORE syntax to STORE <table> INTO <qvd>.

There seems to be a bug in Qlikview when the STORE <fields> FROM <table> INTO <qvd> syntax is used. If you only want to store a subset of fields, you can drop fields from your table before you store it into the qvd.

Re. :Re: Saving Excel (xlsx) data to a QVD - Debug reports: Error: File .\extdata.cpp, Line 1826

martin59 — Wed, 05 May 2010 12:07:45 GMT

Hello,

It's an issue due to security rights. Have you writing rights on your destination folder?

See that post :

http://community.qlik.com/forums/p/26440/101333.aspx#101333

Martin

Saving Excel (xlsx) data to a QVD - Debug reports: Error: File .\extdata.cpp, Line 1826

Thu, 10 Jun 2010 10:08:43 GMT

I usually get the "Error: File .\extdata.cpp" error when my QVD file is empty and I don't tell in the script to build it from scratch. That might be your case ?