13 Replies Latest reply: Aug 12, 2015 5:06 AM by KALYAN KRISHNA RSS

    Server reload failure

    Stewart Lancaster

      Hi,

       

      I have written my first few Qlik reports and have hit a roadblock along the way.

       

      Specifically i am running a simple SQL query (works fine) then storing the table into a CSV:

       

      //Variables:

      Let vDate = Date(Now(), 'YYYY.MM.DD');

      let vPath = '\QlikView\2015\';let vPath = '\QlikView\BCP\2015\';

       

      FX:

      SELECT code, fullname, sign, lastbid, lastoffer, pricedate

      FROM SYSTEM.currencies;

      STORE FX into $(vPath)CCY $(vDate).csv (txt);

       

      When I run this via the desktop software it works perfectly, but when i run this via the qmc on the server I get a failure.

       

      I have looked at the log file and get the below generc error message:

       

      10/08/2015 11:26:34: 0027  STORE FX into \QlikView\2015\CCY 2015.08.10.csv

      10/08/2015 11:26:34:       General Script Error

      10/08/2015 11:26:34:       Execution Failed

      10/08/2015 11:26:34:      Execution finished.

       

      Any ideas as to how i c