3 Replies Latest reply: Oct 6, 2014 2:42 AM by Tresesco B RSS

    General Script error Help????

    Amit Saini

      Hi Folks,

       

      This application attached is working from many days , suddenly getting General Script error. Please see the attached log file and kindly help.

       

      Thanks,

      AS

        • Re: General Script error Help????
          Tresesco B

          I would comment out the last reload excel 'Hierarchie.xlsx' and retry. If it goes fine, have a look at that file; refresh it; save it and retry with full script.

            • Re: General Script error Help????
              Amit Saini

              Tresesco,

               

              I found one strange issue , if I use F: drive path to call script below it is showing general script error but If I comment this and run this script from D: drive path it is working fine . Could you please suggest what could be issue here.

               

              //for each file in filelist('D:\QlikView\Development\Finance\#Source\Flatfiles\Sonne\Source\*')

              for each file in filelist('F:\QlikView\Server\SourceDocuments\Finance\#Source\Flatfiles\Sonne\Source\*')

               

              Sales_Data_Temp:

              CrossTable(Sales_Month, Sales_Data,2)

              LOAD

                  subfield(subfield('$(file)', '\' ,10),'.',1) as Sales_Year ,

                  trim(Plant) as %Plant,

                  Jan,

                   Feb,

                   Mar,

                   Apr,

                   May,

                   Jun,

                   Jul,

                   Aug,

                   Sep,

                   Oct,

                   Nov,

                   Dec

                 /*  F14,

                   F15,

                   F16,

                   F17,

                   F18,

                   F19,

                   F20,

                   F21,

                   F22,

                   F23,

                   F24,

                   F25,

                   F26,

                   F27,

                   F28,

                   F29

                   */

              FROM

              [$(file)]

              (ooxml, embedded labels, table is Sales, filters(

              Remove(Row, Pos(Top, 8)),

              Remove(Row, Pos(Top, 7)),

              Remove(Row, Pos(Top, 6)),

              Remove(Row, Pos(Top, 5)),

              Remove(Row, Pos(Top, 4)),

              Remove(Row, Pos(Top, 3)),

              Remove(Row, Pos(Top, 2)),

              Remove(Row, Pos(Top, 1)),

              Remove(Row, Pos(Top, 5)),

              Remove(Row, Pos(Top, 4)),

              Remove(Row, Pos(Top, 3)),

              Remove(Row, Pos(Top, 2)),

              Remove(Col, Pos(Top, 1)),

              Remove(Col, Pos(Top, 3)),

              Remove(Col, Pos(Top, 2)),

              Remove(Col, Pos(Top, 15)),

              Remove(Col, Pos(Top, 14)),

              Remove(Col, Pos(Top, 34)),

              Remove(Col, Pos(Top, 33)),

              Remove(Col, Pos(Top, 32)),

              Remove(Col, Pos(Top, 31)),

              Remove(Col, Pos(Top, 30)),

              Remove(Col, Pos(Top, 29)),

              Remove(Col, Pos(Top, 28)),

              Remove(Col, Pos(Top, 27)),

              Remove(Col, Pos(Top, 26)),

              Remove(Col, Pos(Top, 25)),

              Remove(Col, Pos(Top, 24)),

              Remove(Col, Pos(Top, 23)),

              Remove(Col, Pos(Top, 22)),

              Remove(Col, Pos(Top, 21)),

              Remove(Col, Pos(Top, 20)),

              Remove(Col, Pos(Top, 19)),

              Remove(Col, Pos(Top, 18)),

              Remove(Col, Pos(Top, 17)),

              Remove(Col, Pos(Top, 16)),

              Remove(Col, Pos(Top, 15)),

              Remove(Col, Pos(Top, 14)),

              Top(1, 'Plant')

              ));

               

               

              Thanks,

              AS