Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Store *
from MyTable into
Drop table MyTable;
Debug reports: Error: File .\extdata.cpp, Line 1826 MyTable: LOAD * FROM
The Store statement looks incorrect. Change it to this:
. Also, what is this C++ file (extdata.cpp) that is being referenced in the debug report? Is this from SAP?Store MyTable into;
Regards,
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
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,
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.
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
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 ?