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

Erratic General Script Error when reloading reports with qmc scheduler

Hello Everyone,

I have a nasty problem with some reports that often fail to reload. This mostly occurs during nightly automatic refrehes by the qv scheduler. The reports report failed and the log only shows "General Script Error". Like other users, I have observed the script running without any errors up to the point where the last statement is successfully loaded. Then it says:

11.01.2011 09:55:36: General Script Error
11.01.2011 09:55:36: Execution Failed
11.01.2011 09:55:36: Execution finished.

*please see entire log at the end of this post!

QV Support suggests it has to do with our data but I suspect otherwise because the problem is easily fixed by changing something about the report (almost any change works). For instance reducing data, disabling and re-enabling the reload schedule or resetting the section access username and password will cure the effect. Very strange!

Most of the time, the failed report will also run without errors when it is reloaded in the qv personal edition client (instead of from the qmc). We then save the report and it runs also from qmc but only for some time. after one or two nights it starts to fail again. Any help would be much appreciated!

Here's the entire log of a failed report:

11.01.2011 09:55:32: Execution started.
11.01.2011 09:55:32: QlikView Version:9.00.7502.8
11.01.2011 09:55:32: 0002 SET ThousandSep='.'
11.01.2011 09:55:32: 0003 SET DecimalSep=','
11.01.2011 09:55:32: 0004 SET MoneyThousandSep='.'
11.01.2011 09:55:32: 0005 SET MoneyDecimalSep=','
11.01.2011 09:55:32: 0006 SET MoneyFormat='#.##0,00 €;-#.##0,00 €'
11.01.2011 09:55:32: 0007 SET TimeFormat='hh:mm:ss'
11.01.2011 09:55:32: 0008 SET DateFormat='DD.MM.YYYY'
11.01.2011 09:55:32: 0009 SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]'
11.01.2011 09:55:32: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sept;Oct;Nov;Dec'
11.01.2011 09:55:32: 0011 SET DayNames='Mon;Tues;Wed;Thurs;Fri;Sat;Sun'
11.01.2011 09:55:32: 0014 ODBC CONNECT*XUserId*XPassword*
11.01.2011 09:55:32: 0017 SQL SELECT prd_product_id,
11.01.2011 09:55:32: 0018 prd_product_shop_id,
11.01.2011 09:55:32: 0019 prd_product_base_code,
11.01.2011 09:55:32: 0020 prd_product_base_name as "Product family",
11.01.2011 09:55:32: 0021 prd_product_base_desc,
11.01.2011 09:55:32: 0022 prd_product_base_short_desc,
11.01.2011 09:55:32: 0023 prd_product_variant_code,
11.01.2011 09:55:32: 0024 prd_product_variant_name as "Product name",
11.01.2011 09:55:32: 0025 prd_product_variant_desc,
11.01.2011 09:55:32: 0026 prd_product_variant_unit,
11.01.2011 09:55:32: 0027 prd_product_variant_color,
11.01.2011 09:55:32: 0028 prd_product_variant_ean,
11.01.2011 09:55:32: 0029 prd_product_variant_sap_id as "SAP ID",
11.01.2011 09:55:32: 0030 prd_valid_from,
11.01.2011 09:55:32: 0031 prd_valid_to,
11.01.2011 09:55:32: 0032 prd_load_date,
11.01.2011 09:55:32: 0033 prd_product_saplevel_1_name,
11.01.2011 09:55:32: 0034 prd_product_saplevel_2_name,
11.01.2011 09:55:32: 0035 prd_product_saplevel_3_name as "Product",
11.01.2011 09:55:32: 0036 prd_product_saplevel_4_name as "Product category",
11.01.2011 09:55:32: 0037 prd_product_saplevel_5_name
11.01.2011 09:55:32: 0038 FROM my_dwh.dim_prd_product
11.01.2011 09:55:32: 21 fields found: PRD_PRODUCT_ID, PRD_PRODUCT_SHOP_ID, PRD_PRODUCT_BASE_CODE, Product family, PRD_PRODUCT_BASE_DESC, PRD_PRODUCT_BASE_SHORT_DESC, PRD_PRODUCT_VARIANT_CODE, Product name, PRD_PRODUCT_VARIANT_DESC, PRD_PRODUCT_VARIANT_UNIT, PRD_PRODUCT_VARIANT_COLOR, PRD_PRODUCT_VARIANT_EAN, SAP ID, PRD_VALID_FROM, PRD_VALID_TO, PRD_LOAD_DATE, PRD_PRODUCT_SAPLEVEL_1_NAME, PRD_PRODUCT_SAPLEVEL_2_NAME, Product, Product category, PRD_PRODUCT_SAPLEVEL_5_NAME, 107 lines fetched
11.01.2011 09:55:32: 0040 FCT_ORDER_HEADER_ORDER_ITEMS:
11.01.2011 09:55:32: 0041
11.01.2011 09:55:32: 0042 SELECT
11.01.2011 09:55:32: 0043 f.cst_customer_id,
11.01.2011 09:55:32: 0044 f.orh_order_id, f.orh_order_shop_id,f.ors_order_status_id, f.pyt_payment_type_id, f.pys_payment_status_id, f.dls_delivery_status_id,
11.01.2011 09:55:32: 0045 f.dlt_delivery_type_id,f.cpn_coupon_id, f.adr_payment_id,f.adr_delivery_id, f.orh_payment_date, f.orh_payment_cost_eur_brt,
11.01.2011 09:55:32: 0046 f.orh_delivery_cost_eur_brt, f.orh_coupon_value_eur_brt, f.orh_coupon_value_eur_net, trunc(f.orh_created_date,'dd') as DYS_DATE, f.orh_load_date, f.orh_client_code,
11.01.2011 09:55:32: 0047 f.orh_modified_date, v.Geschlecht as "Gender", v.crg_country_id, v.COUNTRY as "Country_Code", v.Land as "Country", v.Kundenkonto_Shop as "User shop account", v.Kundenkonto_Portal as "User portal account", v.Datenfreigabe as "Email OptIn",
11.01.2011 09:55:32: 0048 v.CSS_Datenfreigabe as "CSS OptIn", v.cst_language_iso_code, v.Sprache as "Language"
11.01.2011 09:55:32: 0049 FROM fct_orh_order_header f, view_Stammdaten v
11.01.2011 09:55:32: 0050 where f.cst_customer_id =v.cst_customer_id
11.01.2011 09:55:32: 0051 order by f.orh_created_date asc
11.01.2011 09:55:34: 30 fields found: CST_CUSTOMER_ID, ORH_ORDER_ID, ORH_ORDER_SHOP_ID, ORS_ORDER_STATUS_ID, PYT_PAYMENT_TYPE_ID, PYS_PAYMENT_STATUS_ID, DLS_DELIVERY_STATUS_ID, DLT_DELIVERY_TYPE_ID, CPN_COUPON_ID, ADR_PAYMENT_ID, ADR_DELIVERY_ID, ORH_PAYMENT_DATE, ORH_PAYMENT_COST_EUR_BRT, ORH_DELIVERY_COST_EUR_BRT, ORH_COUPON_VALUE_EUR_BRT, ORH_COUPON_VALUE_EUR_NET, DYS_DATE, ORH_LOAD_DATE, ORH_CLIENT_CODE, ORH_MODIFIED_DATE, Gender, CRG_COUNTRY_ID, Country_Code, Country, User shop account, User portal account, Email OptIn, CSS OptIn, CST_LANGUAGE_ISO_CODE, Language, 11.217 lines fetched
11.01.2011 09:55:35: 0053 OUTER JOIN
11.01.2011 09:55:35: 0054
11.01.2011 09:55:35: 0055
11.01.2011 09:55:35: 0056 SELECT
11.01.2011 09:55:35: 0057 ori_order_item_shop_id,
11.01.2011 09:55:35: 0058 ois_order_item_status_id,
11.01.2011 09:55:35: 0059 prd_product_id,
11.01.2011 09:55:35: 0060 orh_order_id,
11.01.2011 09:55:35: 0061 ori_modified_date,
11.01.2011 09:55:35: 0062 ori_price_eur_brt,
11.01.2011 09:55:35: 0063 nvl(ori_price_eur_net,100) as ori_price_eur_net,
11.01.2011 09:55:35: 0064 ori_disc_eur_brt,
11.01.2011 09:55:35: 0065 ori_disc_eur_net,
11.01.2011 09:55:35: 0066 trunc(ori_created_date,'dd') as DYS_DATE,
11.01.2011 09:55:35: 0067 cts_cartridge_service_id,
11.01.2011 09:55:35: 0068 ori_load_date,
11.01.2011 09:55:35: 0069 ori_order_item_id,
11.01.2011 09:55:35: 0070 ori_client_code,
11.01.2011 09:55:35: 0071 ori_quantity,
11.01.2011 09:55:35: 0072 ori_base_price,
11.01.2011 09:55:35: 0073 ori_calculated_flag,
11.01.2011 09:55:35: 0074 ori_give_away_flag as Prämieneinlösung
11.01.2011 09:55:35: 0075 FROM my_dwh.fct_ori_order_items
11.01.2011 09:55:35: 0076 order by ori_created_date asc

11.01.2011 09:55:35: 18 fields found: ORI_ORDER_ITEM_SHOP_ID, OIS_ORDER_ITEM_STATUS_ID, PRD_PRODUCT_ID, ORH_ORDER_ID, ORI_MODIFIED_DATE, ORI_PRICE_EUR_BRT, ORI_PRICE_EUR_NET, ORI_DISC_EUR_BRT, ORI_DISC_EUR_NET, DYS_DATE, CTS_CARTRIDGE_SERVICE_ID, ORI_LOAD_DATE, ORI_ORDER_ITEM_ID, ORI_CLIENT_CODE, ORI_QUANTITY, ORI_BASE_PRICE, ORI_CALCULATED_FLAG, PRÄMIENEINLÖSUNG, 15.186 lines fetched
11.01.2011 09:55:36: Joining/Keeping
11.01.2011 09:55:36: 0079 LET varMinDate = Num(Peek('DYS_DATE', 0, 'FCT_order_items'))
11.01.2011 09:55:36: 0081 TIME_DATA:
11.01.2011 09:55:36: 0082 sql select DYS_DATE, DYS_QUARTER
11.01.2011 09:55:36: 0083 from dimn_dys_days
11.01.2011 09:55:36: 0084 where DYS_DATE <= SYSDATE
11.01.2011 09:55:36: 0085 AND DYS_DATE >= to_date('01.01.1996', 'dd.mm.yyyy')
11.01.2011 09:55:36: 2 fields found: DYS_DATE, DYS_QUARTER, 5.490 lines fetched
11.01.2011 09:55:36: 0087 TIME_DIM:
11.01.2011 09:55:36: 0088 Load
11.01.2011 09:55:36: 0089 *,
11.01.2011 09:55:36: 0090 Day(DYS_DATE) as DayName,
11.01.2011 09:55:36: 0091 DayName(DYS_DATE) as [Day],
11.01.2011 09:55:36: 0092 WeekDay(DYS_DATE) as [Day of Week],
11.01.2011 09:55:36: 0093 WeekName(DYS_DATE) as [Week],
11.01.2011 09:55:36: 0094 LunarWeekName(DYS_DATE) as [Lunar Week Name],
11.01.2011 09:55:36: 0095 Month(DYS_DATE) as [MonthName],
11.01.2011 09:55:36: 0096 MonthName(DYS_DATE) as [Month],
11.01.2011 09:55:36: 0097 Year(DYS_DATE)&'/Q'&DYS_QUARTER as [Quarter],
11.01.2011 09:55:36: 0098 Year(DYS_DATE) as [Year],
11.01.2011 09:55:36: 0099 -div((today() -DYS_DATE),7) as Relative_Week_Number,
11.01.2011 09:55:36: 0100 -div((today() -DYS_DATE),28) as Relative_4_Week_Number
11.01.2011 09:55:36: 0101 resident TIME_DATA
11.01.2011 09:55:36: 0102 where DYS_DATE >= Date(40252)

11.01.2011 09:55:36: 13 fields found: DYS_DATE, DYS_QUARTER, DayName, Day, Day of Week, Week, Lunar Week Name, MonthName, Month, Quarter, Year, Relative_Week_Number, Relative_4_Week_Number, 303 lines fetched
11.01.2011 09:55:36: 0105 drop table TIME_DATA
11.01.2011 09:55:36: 0107 Order_Item_Status:
11.01.2011 09:55:36: 0108 SELECT
11.01.2011 09:55:36: 0109 D.OIS_ORDER_ITEM_STATUS_ID, D.OIS_ORDER_ITEM_STATUS_SHOP_ID, D.OIS_ORDER_ITEM_STATUS_DESC as "Order Status",
11.01.2011 09:55:36: 0110 D.OIS_ORDER_ITEM_STATUS_NAME, D.OIS_VALID_FROM, D.OIS_VALID_TO,
11.01.2011 09:55:36: 0111 D.OIS_LOAD_DATE
11.01.2011 09:55:36: 0112 FROM my_DWH.DIM_OIS_ORDER_ITEM_STATUS D
11.01.2011 09:55:36: 7 fields found: OIS_ORDER_ITEM_STATUS_ID, OIS_ORDER_ITEM_STATUS_SHOP_ID, Order Status, OIS_ORDER_ITEM_STATUS_NAME, OIS_VALID_FROM, OIS_VALID_TO, OIS_LOAD_DATE, 5 lines fetched
11.01.2011 09:55:36: 0116 SELECT
11.01.2011 09:55:36: 0117 cpn_coupon_id,
11.01.2011 09:55:36: 0118 cpn_coupon_code as "Coupon code"
11.01.2011 09:55:36: 0119 FROM my_dwh.cpn_coupon
11.01.2011 09:55:36: 2 fields found: CPN_COUPON_ID, Coupon code, 27 lines fetched
11.01.2011 09:55:36: 0121 Order_Status:
11.01.2011 09:55:36: 0122 SQL SELECT *
11.01.2011 09:55:36: 0123 FROM my_dwh.dim_ors_order_status
11.01.2011 09:55:36: 7 fields found: ORS_ORDER_STATUS_ID, ORS_ORDER_STATUS_SHOP_ID, ORS_ORDER_STATUS_CODE, ORS_ORDER_STATUS_NAME, ORS_VALID_FROM, ORS_VALID_TO, ORS_LOAD_DATE, 5 lines fetched
11.01.2011 09:55:36: 0125 SQL SELECT *
11.01.2011 09:55:36: 0126 FROM my_dwh.dim_dlt_delivery_type
11.01.2011 09:55:36: 7 fields found: DLT_DELIVERY_TYPE_ID, DLT_DELIVERY_TYPE_SHOP_ID, DLT_DELIVERY_TYPE_NAME, DLT_DELIVERY_TYPE_DESC, DLT_VALID_FROM, DLT_VALID_TO, DLT_LOAD_DATE, 4 lines fetched
11.01.2011 09:55:36: 0128 SQL SELECT *
11.01.2011 09:55:36: 0129 FROM my_dwh.dim_pyt_payment_type
11.01.2011 09:55:36: 7 fields found: PYT_PAYMENT_TYPE_ID, PYT_PAYMENT_TYPE_SHOP_ID, PYT_PAYMENT_TYPE_NAME, PYT_PAYMENT_TYPE_DESC, PYT_VALID_FROM, PYT_VALID_TO, PYT_LOAD_DATE, 6 lines fetched
11.01.2011 09:55:36: General Script Error
11.01.2011 09:55:36: Execution Failed
11.01.2011 09:55:36: Execution finished.

Thanks in advance, Robert

17 Replies
suniljain
Honored Contributor

Erratic General Script Error when reloading reports with qmc scheduler

pls check store command.

it is unable to save after extraction and thats why it gives general script error.

Not applicable

AW:Re: Erratic General Script Error when reloading reports with qmc scheduler

I'm sorry but I do not understand. What store command? Can you elaborate a little bit please. Thank you

suniljain
Honored Contributor

AW:Re: Erratic General Script Error when reloading reports with qmc scheduler

can you post your extraction script.

Not applicable

AW:Re: AW:Re: Erratic General Script Error when reloading reports with qmc scheduler

Here you go:

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='DD.MM.YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sept;Oct;Nov;Dec';
SET DayNames='Mon;Tues;Wed;Thurs;Fri;Sat;Sun';


ODBC CONNECT TO *information removed*

//Product
SQL SELECT prd_product_id,
prd_product_shop_id,
prd_product_base_code,
prd_product_base_name as "Product family",
prd_product_base_desc,
prd_product_base_short_desc,
prd_product_variant_code,
prd_product_variant_name as "Product name",
prd_product_variant_desc,
prd_product_variant_unit,
prd_product_variant_color,
prd_product_variant_ean,
prd_product_variant_sap_id as "SAP ID",
prd_valid_from,
prd_valid_to,
prd_load_date,
prd_product_saplevel_1_name,
prd_product_saplevel_2_name,
prd_product_saplevel_3_name as "Product",
prd_product_saplevel_4_name as "Product category",
prd_product_saplevel_5_name
FROM my_dwh.dim_prd_product;

FCT_ORDER_HEADER_ORDER_ITEMS:
//Order Header
SELECT
f.cst_customer_id,
f.orh_order_id, f.orh_order_shop_id,f.ors_order_status_id, f.pyt_payment_type_id, f.pys_payment_status_id, f.dls_delivery_status_id,
f.dlt_delivery_type_id,f.cpn_coupon_id, f.adr_payment_id,f.adr_delivery_id, f.orh_payment_date, f.orh_payment_cost_eur_brt,
f.orh_delivery_cost_eur_brt, f.orh_coupon_value_eur_brt, f.orh_coupon_value_eur_net, trunc(f.orh_created_date,'dd') as DYS_DATE, f.orh_load_date, f.orh_client_code,
f.orh_modified_date, v.Geschlecht as "Gender", v.crg_country_id, v.COUNTRY as "Country_Code", v.Land as "Country", v.Kundenkonto_Shop as "User shop account", v.Kundenkonto_Portal as "User portal account", v.Datenfreigabe as "Email OptIn",
v.CSS_Datenfreigabe as "CSS OptIn", v.cst_language_iso_code, v.Sprache as "Language"
FROM fct_orh_order_header f, view_Stammdaten v
where f.cst_customer_id =v.cst_customer_id
order by f.orh_created_date asc;

OUTER JOIN

//Order Items
SELECT
ori_order_item_shop_id,
ois_order_item_status_id,
prd_product_id,
orh_order_id,
ori_modified_date,
ori_price_eur_brt,
nvl(ori_price_eur_net,100) as ori_price_eur_net,
ori_disc_eur_brt,
ori_disc_eur_net,
trunc(ori_created_date,'dd') as DYS_DATE,
cts_cartridge_service_id,
ori_load_date,
ori_order_item_id,
ori_client_code,
ori_quantity,
ori_base_price,
ori_calculated_flag,
ori_give_away_flag as Prämieneinlösung
FROM my_dwh.fct_ori_order_items
order by ori_created_date asc
;

LET varMinDate = Num(Peek('DYS_DATE', 0, 'FCT_order_items'));

TIME_DATA:
sql select DYS_DATE, DYS_QUARTER
from dimn_dys_days
where DYS_DATE <= SYSDATE
AND DYS_DATE >= to_date('01.01.1996', 'dd.mm.yyyy');

TIME_DIM:
Load
*,
Day(DYS_DATE) as DayName,
DayName(DYS_DATE) as [Day],
WeekDay(DYS_DATE) as [Day of Week],
WeekName(DYS_DATE) as [Week],
LunarWeekName(DYS_DATE) as [Lunar Week Name],
Month(DYS_DATE) as [MonthName],
MonthName(DYS_DATE) as [Month],
Year(DYS_DATE)&'/Q'&DYS_QUARTER as [Quarter],
Year(DYS_DATE) as [Year],
-div((today() -DYS_DATE),7) as Relative_Week_Number,
-div((today() -DYS_DATE),28) as Relative_4_Week_Number
resident TIME_DATA
where DYS_DATE >= Date($(varMinDate))
;

drop table TIME_DATA;

Order_Item_Status:
SELECT
D.OIS_ORDER_ITEM_STATUS_ID, D.OIS_ORDER_ITEM_STATUS_SHOP_ID, D.OIS_ORDER_ITEM_STATUS_DESC as "Order Status",
D.OIS_ORDER_ITEM_STATUS_NAME, D.OIS_VALID_FROM, D.OIS_VALID_TO,
D.OIS_LOAD_DATE
FROM my_DWH.DIM_OIS_ORDER_ITEM_STATUS D;

SELECT
cpn_coupon_id,
cpn_coupon_code as "Coupon code"
FROM my_dwh.cpn_coupon;

Order_Status:
SQL SELECT *
FROM my_dwh.dim_ors_order_status;

SQL SELECT *
FROM my_dwh.dim_dlt_delivery_type;

SQL SELECT *
FROM my_dwh.dim_pyt_payment_type;

suniljain
Honored Contributor

AW:Re: AW:Re: Erratic General Script Error when reloading reports with qmc scheduler

Error is in following script.

Order_Item_Status:
SELECT
D.OIS_ORDER_ITEM_STATUS_ID, D.OIS_ORDER_ITEM_STATUS_SHOP_ID, D.OIS_ORDER_ITEM_STATUS_DESC as "Order Status",
D.OIS_ORDER_ITEM_STATUS_NAME, D.OIS_VALID_FROM, D.OIS_VALID_TO,
D.OIS_LOAD_DATE
FROM my_DWH.DIM_OIS_ORDER_ITEM_STATUS D;

suniljain
Honored Contributor

AW:Re: AW:Re: Erratic General Script Error when reloading reports with qmc scheduler

11.01.2011 09:55:36: 0128 SQL SELECT *
11.01.2011 09:55:36: 0129 FROM my_dwh.dim_pyt_payment_type
11.01.2011 09:55:36: 7 fields found: PYT_PAYMENT_TYPE_ID, PYT_PAYMENT_TYPE_SHOP_ID, PYT_PAYMENT_TYPE_NAME, PYT_PAYMENT_TYPE_DESC, PYT_VALID_FROM, PYT_VALID_TO, PYT_LOAD_DATE, 6 lines fetched
11.01.2011 09:55:36: General Script Error
11.01.2011 09:55:36: Execution Failed

Not applicable

AW:Re: AW:Re: AW:Re: Erratic General Script Error when reloading reports with qmc scheduler

I don't understand. Where is the error in either of those scripts? Please make yourself more clear!

Not applicable

Re: AW:Re: Erratic General Script Error when reloading reports with qmc scheduler

Hi,

I faced the similar issue. It seems .qvd gets locked and throws error. I closed the Qlikview Desktop and deleted the .qvd file manually. Then restarted the Qlikview and recreated .qvd. Then this error got resolved. Note that this error was not during publishing. Error was on local machine where I develop my application and executing the script was throwing this error.

Mayank

Luminary
Luminary

Re: AW:Re: Erratic General Script Error when reloading reports with qmc scheduler

Hi,

  Did you solved this problem ?

Regards,

Pablo Labbe

Qlikview Consultant

www.visiongi.com.br

Community Browser