Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
autopilot
Creator III
Creator III

Reload Failed after months working

I have a script that has been working as intended for months that started throwing an error as of today which is causing the reload to fail. I have no idea why and there is no documentation on the error type that was provided after debugging and using the error variables to get more clarity.

Can anyone provide insight on this issue?

Script below. Image of error attached.

Product_WarehouseInventory:

Load *,

Company &'/'&Warehouse&'/'&Product as %Inventory,

Date(Today()) as Date;

Select * from database.dbo.Product_Warehouse;

Store Product_WarehouseInventory into DATA\Product_WarehouseInventory.qvd(qvd);

Drop Table Product_WarehouseInventory;

Product_Warehouse_Inventory:

Load *

from

DATA\Product_Warehouse_Inventory.qvd(qvd);

Concatenate

Load *

from

DATA\Product_WarehouseInventory.qvd(qvd);

/* get last date from QVD */

Let varMinDate = num(Peek('Date',-1,'ProductWarehouse_Inventory')) + 1;

Let varMaxDate = Num(Today());

/* get rates from last date to today */

FOR i = varMinDate to varMaxDate

          LET varDate = text(Date(i,'YYYY-MM-DD'));

 

          ProductWarehouse_Inventory:

          LOAD

                     '$(i)' as Date,

                     *;

NEXT

STORE Product_Warehouse_Inventory into DATA\Product_Warehouse_Inventory.qvd (qvd);

DROP TABLE Product_Warehouse_Inventory;

1 Solution

Accepted Solutions
autopilot
Creator III
Creator III
Author

I've identified the problem.

The file being added to incrementally was corrupted or over-written with no data which was the root of the error because it was trying to load nothing and then concatenate to it.

Still would like to have more clarity on a way to lookup these error codes........

View solution in original post

5 Replies
mov
Champion III
Champion III

It is not a good idea to use "load * from" - you cannot see what is behind this star.  I recommend to replcae it everywhere in your script with the explicit list of fields.  At least you'll be able to see why the load fails.

Regards,

Michael

autopilot
Creator III
Creator III
Author

Michael,

Thanks for your insight. I agree that * can be the source of unneccessary headache at times in hiding what it represents.

In this case, however, I know what the error is....but I don't know what that error means. Unless you are suggesting that by listing all the fields on load will produce a different error, do you have another insight that could help resolve this issue?

Thanks for you help.

mov
Champion III
Champion III

Exactly - I hope (no guarantee though) that if you had a more explicit script, there could be a more explicit error message.

autopilot
Creator III
Creator III
Author

I've identified the problem.

The file being added to incrementally was corrupted or over-written with no data which was the root of the error because it was trying to load nothing and then concatenate to it.

Still would like to have more clarity on a way to lookup these error codes........

View solution in original post

mov
Champion III
Champion III

Good to know, thanks.

As for the errors, you can try using Error variables.  For example, ScriptError returns numbers that can help.  See QV "help" on this.

Regards,

Michael