Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

pulkit1611
Contributor 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

Re: Error: File extdata.cpp, Line 2903.

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

Re: Error: File extdata.cpp, Line 2903.

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

Community Browser