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

[dinicholls]

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

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

Hi,

Have you checked log files.

does log file indicates script execution finished.

Regards

Neetha

[dinicholls]

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

[Anonymous]

Hi,

Please can you post your script

[Anonymous]

use this code :

DROP Table Daybooks;

[dinicholls]

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

[Anonymous]

use  below variable in store

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

[rwunderlich]

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