4 Replies Latest reply: Jan 31, 2014 8:12 AM by Martin FAVIER RSS

    I attached my Log file am getting error count = 3

      this is my script :

       

      Binary "\\ukbraa06\Source Documents\QVD\QVD Monitor\QVD_Monitor.qvw";

       

      QVD_legend:

      LOAD

      rowno() as Leg_QvdId,

      QvdShortFileName as Leg_QvdShortFileName,

      QvdDesc as Leg_QvdDesc,

      QvdReloadFreq as Leg_QvdReloadFreq,

      QvdReloadFreq_In_Days as Leg_QvdReloadFreq_In_Days

      RESIDENT Qvd_Params

      WHERE BSC = 'Y';

       

       

      LEFT JOIN(QVD_legend)

       

      LOAD

      QvdShortFileName as Leg_QvdShortFileName,

      QvdCreateDate as Leg_QvdCreateDate

      RESIDENT Qvd_Info;

       

      LEFT JOIN(QVD_legend)

       

      LOAD

      QvdShortFileName as Leg_QvdShortFileName,

      QvdMaxDate as Leg_QvdMaxDate

      RESIDENT QVDmaxdate;

       

      LEFT JOIN(QVD_legend)

       

      LOAD

      Leg_QvdShortFileName,

      Num(Today() - date(Leg_QvdReloadFreq_In_Days + Leg_QvdCreateDate)) as Leg_QvdDelay,

      if(Num(Today() - date(Leg_QvdReloadFreq_In_Days + Leg_QvdCreateDate))<=0,0,1) as Leg_QvdIsLate

      RESIDENT QVD_legend;