5 Replies Latest reply: Apr 3, 2013 5:01 PM by Michael Solomovich RSS

    Reload Failed after months working

    Curt Daughtry

      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;