Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Script execution window blank & Unknown error. Any ideas ?

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 ?

2 Replies

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

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

Capture.PNG

Not applicable

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

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

];

Community Browser