Error: Error: File .\extdata.cpp, Line 1826 when using QEMC

[#1]

Hi,

I'd this simple script and was able to run successfully using Qlikview on my desktop.

LOAD *;
SQL SELECT *
FROM ProdSite.dbo.EmployeeVw;
STORE KPMGEmployeeVw into \\sgsgaapp18\C$\Data\Test\EmployeeVw.qvd;

However, when I tried to scheduled the same script using QlikView Enterprise Management Console and I got the following error message. This error only happened to this particular table, I tried using another table & it ran through successfully.

06/12/2010 11:17:02 AM: 0016 LOAD *
06/12/2010 11:17:02 AM: 0017 SQL SELECT *
06/12/2010 11:17:02 AM: 0018 FROM ProdSite.dbo.EmployeeVw
06/12/2010 11:17:03 AM: Error: Error: File .\extdata.cpp, Line 1826
06/12/2010 11:17:03 AM: General Script Error
06/12/2010 11:17:03 AM: Execution Failed
06/12/2010 11:17:03 AM: Execution finished.

Anyone had similar encounter ? Pls advise what could have cause this error ?

Thank you.

Sharon

[#2]

I also have this problem with just one table. All others load just fine.

[#3]

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.

[hschultz]

I had the same error with an .xlsx file. Simply removing the "Sheet is xxx" at the end made it work fine.

Don't know if it's useful, but that's how I got to this question in the first place

[#5]

It worked. Thank you.