Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Can you re-run this after removing the single quotes and see if that makes any difference
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
];