topic Re: Error: File extdata.cpp, Line 2903. in QlikView

Error: File extdata.cpp, Line 2903.

Pulkit_Thukral — Fri, 05 Feb 2016 10:52:58 GMT

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)]);

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

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

Colin-Albert — Fri, 05 Feb 2016 17:49:22 GMT

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.

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

Peter_Cammaert — Fri, 05 Feb 2016 17:51:54 GMT

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