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

[#1]

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)

[vgutkovsky]

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,

[#3]

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

[vgutkovsky]

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,

[#5]

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.

[martin59]

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

[#7]

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 ?