Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Hmmmmm, 'Execution of Script Failed' - Erm, No, it hasn't!

Hi All,

Have a dead simple script:

Daybooks_Jan_14_to_Nov_14:

LOAD Company,

    Ledger,

    AC1,

    [Area Code] as Region,

    AC2,

    Controller,

    AC3,

    [Service Centre] as [SC/NAM],

    AC4,

    [Credit Cycle] as [Grp A/C / Cycle],

    [Legacy Account],

    Customer,

    Name,

    Status,

    [Credit Control Status],

    [Doc Type],

    [Doc ID] as [DOC ID],

    [Doc Number],

    Reference,

    [Document Date],

    [Due Date],

    [Update Date],

    Value,

    [VAT Code],

    VAT,

    Goods,

    'ME1401' as [Month End],

    left(AC2,2) as Tier

FROM

(txt, utf8, embedded labels, delimiter is ',', msq, header is 3 lines);

Concatenate


LOAD Company & upper(left([Legacy Account],1)) as Company,

    Ledger,

    AC1,

    Region,

    AC2,

    Controller,

    AC3,

    [SC/NAM],

    AC4,

    [Grp A/C / Cycle],

    [Legacy Account],

    Customer,

    Name,

    Status,

    [Credit Control Status],

    [Doc Type],

    [Doc ID] as [DOC ID],

    [Doc Number],

    Reference,

    [Document Date],

    [Due Date],

    [Update Date],

    Value,

    [VAT Code],

    VAT,

    Goods,

    'ME1401' as [Month End],

    left(AC2,2) as Tier    

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq, header is 3 lines);

store Daybooks_Jan_14_to_Nov_14 into Daybook_ME1401.qvd (QVD);

DROP TABLE Daybooks_Jan_14_to_Nov_14;

Runs through the script, and presents the 'Script Execution Progress' window, and the 'Close' button becomes available, EXCEPT, when i click on the 'Close' button, I get the message:

'Execution of Script Failed. Reload old data?'

Why?! I know its worked as I can see my QVD file.

I'm confused! Is it something in the script?

Thanks

Di

9 Replies
Highlighted
Creator II
Creator II

1. Test the Script without Concatenate.

If not works RUN ONLY First LOAD.

If not works RUN ONLY Second LOAD.

If still not work's verify CSV files. Run Only with the 10 first lines of both files.

Highlighted

I have seen that when there is a phantom qv.exe process running that has the qvd file locked.

Close your QV Desktop session and with Task Manager look for any phantom qv.exe processes still running and if there are any kill them.  Or a more blunt way to do this is reboot whatever you are running your QV Desktop on.

Highlighted
Master
Master

Hi,

Have you checked log files.

does log file indicates script execution finished.

Regards

Neetha

Highlighted
Creator II
Creator II

Hi All,

When I remove the 'Drop Table' part, it runs through no problems, with it, the script error.

Have attached the log files, there doesn't seem to be a difference to me, and its says the one that's failing run through fine!

Argh!!!!

I have a variable set, that, having looked around on here might have something to do with it. How do I set a reset a variable to null? Heres the variable:

Let vFileDate = Date(Today(),'DD_MM_YYYY');

and the statement at the end of my load where I'm using the variable. This in itself though doesn't seem to be causing the problem:

store Daybooks into Daybooks_ME1401_to_$(vFileDate).qvd (QVD);

DROP Tables Daybooks;

Have edited the post to add logs.

Thank all!

Di

Highlighted
Master
Master

Hi,

Please can you post your script

Highlighted
Master
Master

use this code :

DROP Table Daybooks;

Highlighted
Creator II
Creator II

Hi All,

After some investigation, it actually appears to be a problem with this:

Let vFileDate = Date(Today(),'DD_MM_YYYY');

I have created another file, similar to the above, and the drop table works fine, BUT it does the above when I add in the date to a QVD store, the end of my script:

Store Combined_ADT_LDM_Due into [Cash & Debt Data ]$(vFileDate).qvd (QVD);

I'm going to have a look and see if I can add the date to my file in a different way.

I'll let you know!

Di

Highlighted
Master
Master

use  below variable in store

vFileName= [Cash & Debt Data ] &'-'&Date(Today(),'DD_MM_YYYY');

Highlighted
MVP & Luminary
MVP & Luminary

I think you have your right brack in the wrong location.

Store Combined_ADT_LDM_Due into [Cash & Debt Data ]$(vFileDate).qvd (QVD);


should be


Store Combined_ADT_LDM_Due into [Cash & Debt Data $(vFileDate)].qvd (QVD);


-Rob