17 Replies Latest reply: Jul 14, 2015 7:55 AM by Mark Hohlov RSS

    Erratic General Script Error when reloading reports with qmc scheduler

    baallod1

      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