topic Error: File .\extdata.cpp - failure in QlikView

Error: File .\extdata.cpp - failure

Mon, 26 Apr 2010 14:47:53 GMT

Hi,

While reloading one QVD generator doucment which fethces data from DB, it throws the below error:

" Error: Error: File .\extdata.cpp, Line 1828 "

Could any one suggest the root cause and the resolution of this failure?

Error: File .\extdata.cpp - failure

Fri, 24 Sep 2010 14:19:36 GMT

Hi,

I have a similar issue reading from a PostgreSQL database using an ODBC connection.

Normal 0 21 false false false NL X-NONE X-NONE MicrosoftInternetExplorer4

Error: File .\extdata.cpp, Line 1826

SQL SELECT *

FROM <...>

Original script:

Table:

LOAD *;

SQL SELECT *

FROM "database"."public".tabel;

Error: File .\extdata.cpp - failure

suniljain — Fri, 24 Sep 2010 14:31:16 GMT

is this error comes when extractiong data from sap-bw ?.

Error: File .\extdata.cpp - failure

Fri, 24 Sep 2010 15:07:43 GMT

Not mine, but I also seem to have found the solution.

On the server there was only 0.8GB memory free of the 6GB total. Other users are busy doing their things on the server as well.

So I will wait till this evening or lateron this weekend to try again.

I tested it with a much smaller selection of the same source and that works nicely.

Re: Error: File .\extdata.cpp - failure

Tue, 20 Sep 2011 07:57:43 GMT

Hi,

I also had the same problem while loading data from Oracle DB.

What I did is, I splitted up the script into two parts in two QVD generators. One QVD generator with the Query which was getting failed and the other with the rest of the Query.

I made two separate tasks for the two QVD generators making one task dependent of the other.

I ran the splitted up generators at different points of time in a day, and inspite of the huge data volume the tasks ran successfully.
Currently also the tasks are running successfully everyday.

Re: Error: File .\extdata.cpp - failure

crusader_ — Thu, 31 Mar 2016 09:38:26 GMT

Hi, I have this error querying from SAP BW.

Do you have any ideas what could be a reason?

Thanks.

Regards,

Andrei

Re: Error: File .\extdata.cpp - failure

Wed, 08 Mar 2017 16:15:16 GMT

For troubleshooting it is recommended to run the failing query in a third party SQL query tool, with the following considerations.

Use the same ODBC or OLEDB connection
Use the same underlying database driver
Access the same database server
Use the same user credentials, username and password. NOTE: Use the QlikView service user if issue is related to QlikView Server

The third party tool should return an unexpected result. In this context pay extra attention to that the field names are exactly as expected and in readable language without garbage characters.

Common resolution is to correct SQL query so that a valid and expected result is returned by database.

The error message comes from QlikView engine and is related to the database result not having valid fields. Typically this is due to the usage of LOAD * , which means that QlikView will parse the resuls in order to find the returned field names. For some reason the data base has not returned a valid result, most likely due to database driver issues or an invalid SQL query. If this does not resolve your issue, please log a case with Qlik Support. However if it does, please mark this as the correct answer.