Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Pulkit_Thukral
Partner - Creator II
Partner - Creator II

Error: File extdata.cpp, Line 2903.

The following script is throwing error as - Error: File extdata.cpp, Line 2903.

What could be the solution to this.




CONNECT TO [Provider=Microsoft.ACE.OLEDB.12.0;Data Source=open.xlsx;Extended Properties="Excel 8.0;"];

tables:

SQLtables;

DISCONNECT;

FOR i = 0 to NoOfRows('tables')-1

    LET vsheetName = purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39));

Sheets:

LOAD *,

'$(vsheetName)' as Sheet

FROM

[open.xlsx]

(ooxml, embedded labels,Table is [$(vsheetName)]);

NEXT

DROP TABLE tables;  // The table list is no longer needed

2 Replies
Colin-Albert
Partner - Champion
Partner - Champion

Have a look at your document log it should give you more details on the error.

You will need to select Generate Logfile in the Document Properties and then reload again. The logfile is saved the the same folder as your QVW.

GenerateLogfile.JPG

Peter_Cammaert
Partner - Champion III
Partner - Champion III

When does this happen? When you start Load Script execution? When the reload engine executes a specific statement (which statement)? At the end of your script when synthetic keys are being created?

Note that error messages like this point to a bug in the software. You may want to contact Qlik Support for assistance.

Best,

Peter