2 Replies Latest reply: Aug 10, 2017 5:31 AM by Peter Smeets RSS

    Script execution window blank & Unknown error. Any ideas ?

    Peter Smeets

      All,

      Wondering (hoping !) whether anyone has seen this before or maybe even has a solution !

       

      Until recently I had 3 separate databases, all running very well for years. Then last week, without making any changes to the PC or the scripts, the following occurred:

      - When running a script, the window which normally shows the executing of the script remains blank

      - After a few minutes, an 'Unknown Error' was reported on the very first few lines of the script

       

      Of course I have tried various options:

      - Edit out the 'offending' lines in the script. Result: the error simply points to the next lines in the script

      - Tried running scripts in my other databases. They all show the same issue

      - Asked a colleague to run my script. This worked fine, on that PC the script completes without issues

      - Removed & Reinstalled QlickView. Result: No change

       

      I have the Personal Edition.

       

      Any thoughts please ?

        • Re: Script execution window blank & Unknown error. Any ideas ?
          Sunny Talwar

          Can you re-run this after removing the single quotes and see if that makes any difference

           

          Capture.PNG

            • Re: Script execution window blank & Unknown error. Any ideas ?
              Peter Smeets

              Hi Sunny, and thanks for looking into this. I had tried removing the quotes already, and even tried removing the entire lines. The error simply moves to the next line in the script. Only if I remove all of the following will the script work, but of course will fail for the 'Applymap' statements as no re-mapping has been defined. Note the full script worked before without changes .. ?

               

              SET ThousandSep=',';

              SET DecimalSep='.';

              SET MoneyThousandSep=',';

              SET MoneyDecimalSep='.';

              SET MoneyFormat='£#,##0.00;-£#,##0.00';

              SET TimeFormat='hh:mm:ss';

              SET DateFormat='DD/MM/YYYY';

              SET TimestampFormat='MM/DD/YYYY hh:mm:ss[.fff]';

              SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

              SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

               

               

              //MAP ORDER STATUS

              Map_ORDERSTATUS:

              Mapping

              LOAD * INLINE [

                  F1, F2

                  Cancelled, Cancd

                  Customer Action, Blog St3

                  Delivered, Deld

                  Order Processing, Blog St3

                  Order Received, Blog St3

                  Released to Manufacturing, Blog St4

                  Shipped, Shipped

              ];

               

               

              //MAP OVP BRAND TO SIMPLE BRAND

              Map_Branding:

              Mapping

              LOAD * INLINE [

                  F1, F2

                  ThinkPad Classic, 1TPad

                  ideapad, 6Consumer

                  Notebook Classic Accessories, 7Option

                  Notebook Common Accessories, 7Option

                  Workstation Accessories, 7Option

                  Option, 7Option

                  ThinkCentre, 2TCentre

                  Lenovo DT Monitors, 5Monitor

                  Desktop Accessories, 7Option

                  ThinkServer Options, 7Option

                  Desktop Options II, 7Option

                  Tablet Accessories, 7Option

                  Common Accessories, 7Option

                  DCG Server Option, 7Option

                  DCG SERVER OPTIONS PUREFLEX, 7Option

                  DCG SERVER OPTIONS BLADE, 7Option

                  LenovoCare, 8Services

                  STORAGE OPTIONS, 7Option

                  STORAGE, 4Server

                  X SERVER SOFTWARE - LENOVO,9Software

              X Server System, 4Server

              ThinkPlus, 8Services

              Lenovo LCD, 5Monitor

              Small Business BU, 6Consumer

              Notebook SMB Accessories, 7Option

              Common options, 7Option

              ThinkServer, 4Server

              ThinkStation, 3Workstation

              ThinkVision, 5Monitor

              Smart Monitor, 5Monitor

              VLH, 7Option

              VLH NB, 7Option

              VLH - NB, 7Option

              WS Monitor, 5Monitor

              , 7Option

              ];

               

               

              //MAP ORDERING METHODD

              Map_ORDERMETHOD:

              Mapping

              LOAD * INLINE [

                  F1, F2

                  ACSL Order,ACSL

              I2 Large Enterprise,Web

              LI EDI,OV

              LI InteractionCenter,OV

              LI LPOS,LPOS

              Order mass upload,Mass

              US EDI order,EDI

              WE IBM EDI,EDI

              WE Sterling EDI,EDI

              ];