topic Re: General script error in QlikView

General script error

Fri, 20 Nov 2020 18:02:30 GMT

Hello,

I have a 'General script error', but I don't know why.

It does not show me any error, just that the reload is finished and it's asking me if I want to reload the old data.

This is the end of the script :

20150805 16:38:32: 1532 LOAD

20150805 16:38:32: 1533 if([Supplier Pyramid ID]=[Supplier Global Ultimate Single ID],[Supplier Total Turnover]) as [Supplier Total Turnover],

20150805 16:38:32: 1534 if([Supplier Pyramid ID]=[Supplier Global Ultimate Single ID],[Supplier TurnOver Declaration Year]) as [Supplier TurnOver Declaration Year],

20150805 16:38:32: 1535

20150805 16:38:32: 1536 [Supplier Pyramid ID] as [GUO Pyramid ID],

20150805 16:38:32: 1537 [Supplier Global Ultimate Single ID]

20150805 16:38:32: 1538 resident SUPPLIER_GROUPS

20150805 16:38:32: 4 fields found: Supplier Total Turnover, Supplier TurnOver Declaration Year, GUO Pyramid ID, Supplier Global Ultimate Single ID, 212.746 lines fetched

20150805 16:38:32: 1539 left join

20150805 16:38:32: 1540 LOAD

20150805 16:38:32: 1541 [Supplier Pyramid ID],

20150805 16:38:32: 1542 SupplierKey

20150805 16:38:32: 1543 resident SUPPLIERS

20150805 16:38:32: 2 fields found: Supplier Pyramid ID, SupplierKey, 353.688 lines fetched

20150805 16:38:33: Joining/Keeping

20150805 17:04:23: General Script Error

20150805 17:08:18: Execution Failed

Do you have any idea why is this happening ?

Thanks!

Re: General script error

sunny_talwar — Thu, 06 Aug 2015 11:45:29 GMT

Can you share your script for the portion near the failure?

Re: General script error

sunny_talwar — Thu, 06 Aug 2015 11:59:05 GMT

May be look at this thread: 'Execution of Script Failed. Reload old data?' error message

Re: General script error

sasiparupudi1 — Thu, 06 Aug 2015 12:01:11 GMT

I think

the line is changing the key fieild to something [Supplier Pyramid ID] as [GUO Pyramid ID] ?

I do not see [Supplier Pyramid ID] in the log

4 fields found: Supplier Total Turnover, Supplier TurnOver Declaration Year, GUO Pyramid ID, Supplier Global Ultimate Single ID, 212.746 lines fetched

HTH

Sasi

Re: General script error

Thu, 06 Aug 2015 12:30:04 GMT

Yes. That was the problem. Thank you very much !