2 Replies Latest reply: Dec 3, 2015 6:48 AM by jhonatan ben ami RSS

    Help uploading the script

    jhonatan ben ami

      Hey everyone i am keep getting this error

       

      11.40 03.12.2015.PNG

      i have free space of about 16 GB on the disc that is running the following script:

       

      //שע מטבע לתאריך החשבונית ולמטבע השורה

      Left JOIN (INV_SALES_TEMP)

      LOAD  

      CUR_CURRENCY AS INV_CURRENCY,

      CUR_EXCHANGE

      Resident CURRENCIES;

       

      LEFT JOIN (INV_SALES_TEMP)

      LOAD

      Date ( CURREG_CURDATE/60/24+32143,'DD/MM/YYYY')  AS INV_IVDATE,

      CURREG_CURRENCY  AS INV_CURRENCY,

      CURREG_EXCHANGE

      Resident CURREG;

       

      left JOIN (INV_SALES_TEMP)

      LOAD   /*CUR_CURRENCY AS INV_CURRENCY ,*/

      CUR_EXCHANGE AS CUR_EXCHANGE2

      Resident CURRENCIES Where CUR_CURRENCY = -2;

       

      LEFT JOIN (INV_SALES_TEMP)

      LOAD Date ( CURREG_CURDATE/60/24+32143,'DD/MM/YYYY') AS INV_IVDATE ,

      /*     CURREG_CURRENCY  AS INV_CURRENCY,*/

      CURREG_EXCHANGE AS CURREG_EXCHANGE2

      Resident CURREG Where CURREG_CURRENCY = -2;

       

      Left JOIN (INV_SALES_TEMP)

      LOAD  /* CUR_CURRENCY AS INV_CURRENCY ,*/

      CUR_EXCHANGE AS CUR_EXCHANGE3

      Resident CURRENCIES;

       

       

      left JOIN (INV_SALES_TEMP)

      LOAD

      Date ( CURREG_CURDATE/60/24+32143,'DD/MM/YYYY') AS INV_IVDATE ,

      /*    CURREG_CURRENCY  AS INV_CURRENCY ,*/

      CURREG_EXCHANGE AS CURREG_EXCHANGE3

      Resident CURREG;

       

      // // LINE 183 IN THE SALES CHART//

      LEFT JOIN (INV_SALES_TEMP)

      LOAD

      ACC_COSTFLAG,

      DATE((NUM(MAX(ACC_COSTDATE)))/60/24+32143,'DD/MM/YYYY') AS MAXACC_COSTDATE

      RESIDENT ACCDATES WHERE ACC_COSTDATE<>0

      GROUP BY ACC_COSTFLAG;

       

      DROP TABLE ACCDATES;