7 Replies Latest reply: Sep 15, 2016 3:43 AM by Shraddha Gajare RSS

    Reload app failed in QMC task when creating once-only trigger

    geerutsing govind

      Hello,

       

      Reload app failed in QMC task when creating once-only trigger

        • Re: Reload app failed in QMC task when creating once-only trigger
          Andres Prado

          Hi Skyler, could you please have a look or attach here the log file to see the error.

           

          Best regards,

          Andrés

            • Re: Reload app failed in QMC task when creating once-only trigger
              geerutsing govind

              2016-09-14 15:31:49      Execution started.

              2016-09-14 15:31:49      Qlik Sense Server Version     3.0.1+Build:62.release/ms17

              2016-09-14 15:31:49      CPU Target                    x64

              2016-09-14 15:31:49      Operating System              Windows Server 2012 R2 Standard  (64 bit edition)

              2016-09-14 15:31:49      Wow64 mode                    Not using Wow64

              2016-09-14 15:31:49      Language                      0409 English (United States) English

              2016-09-14 15:31:49      Country                       1 United States United States

              2016-09-14 15:31:49      MDAC Version                  6.3.9600.16384

              2016-09-14 15:31:49      MDAC Full Install Version     6.3.9600.16384

              2016-09-14 15:31:49      PreferredCompression          2

              2016-09-14 15:31:49      EnableParallelReload          1

              2016-09-14 15:31:49      ParallelizeQvdLoads           1

              2016-09-14 15:31:49      EnableFlushLog                0

              2016-09-14 15:31:49      UserLogfileCharset            65001

              2016-09-14 15:31:49      OdbcLoginTimeout              -1

              2016-09-14 15:31:49      OdbcConnectionTimeout         -1

              2016-09-14 15:31:49      LongestPossibleLine           1048576

              2016-09-14 15:31:49      ScriptWantsDbWrite            false

              2016-09-14 15:31:49      ScriptWantsExe                false

              2016-09-14 15:31:49      LogFile CodePage Used:        65001

              2016-09-14 15:31:49      UseMemoryFillPattern          1

              2016-09-14 15:31:49      ScriptMode                    Standard (limits system access)

              2016-09-14 15:31:49      ReloadCodebase                Classic

              2016-09-14 15:31:50      Reload Executed By            UserDirectory=INTERNAL; UserId=sa_scheduler

              2016-09-14 15:31:50      Process Executing             Qlik Sense Server

              2016-09-14 15:31:50      Process ID                    2856

              2016-09-14 15:31:50 0002 SET ThousandSep=','

              2016-09-14 15:31:50 0003 SET DecimalSep='.'

              2016-09-14 15:31:50 0004 SET MoneyThousandSep=','

              2016-09-14 15:31:50 0005 SET MoneyDecimalSep='.'

              2016-09-14 15:31:50 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'

              2016-09-14 15:31:50 0007 SET TimeFormat='h:mm:ss TT'

              2016-09-14 15:31:50 0008 SET DateFormat='DD/MM/YYYY'

              2016-09-14 15:31:50 0009 SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT'

              2016-09-14 15:31:50 0010 SET FirstWeekDay=6

              2016-09-14 15:31:50 0011 SET BrokenWeeks=1

              2016-09-14 15:31:50 0012 SET ReferenceDay=0

              2016-09-14 15:31:50 0013 SET FirstMonthOfYear=1

              2016-09-14 15:31:50 0014 SET CollationLocale='en-US'

              2016-09-14 15:31:50 0015 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

              2016-09-14 15:31:50 0016 SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'

              2016-09-14 15:31:50 0017 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

              2016-09-14 15:31:50 0018 SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'

              2016-09-14 15:31:50 0021 *** CONNECT TO ***

              2016-09-14 15:31:50 0024 SELECT CHARM.ITMMVT.ITMREF_0 as [Item Reference],

              2016-09-14 15:31:50 0025 ITMDES1_0 as [Item Description],

              2016-09-14 15:31:50 0026 STOFCY_0 as Company,

              2016-09-14 15:31:50 0027 convert(DOUBLE PRECISION,PHYSTO_0) as [Total Stock],

              2016-09-14 15:31:50 0028 convert(DOUBLE PRECISION,PHYALL_0) as [Allocated Stock],

              2016-09-14 15:31:50 0029 convert(DOUBLE PRECISION,AVC_0) as [Average Cost],

              2016-09-14 15:31:50 0030 convert(DOUBLE PRECISION,ORDSTO_0) as [Quantity on Order],

              2016-09-14 15:31:50 0031 (convert(DOUBLE PRECISION,PHYSTO_0)- convert(DOUBLE PRECISION,PHYALL_0)) as [Quantity  Available]

              2016-09-14 15:31:50 0032 FROM CHARM.ITMMVT  , CHARM.ITMMASTER

              2016-09-14 15:31:50 0033 WHERE STOFCY_0 = 'MCFI'

              2016-09-14 15:31:50 0034 AND CHARM.ITMMVT.ITMREF_0 in ('RM030','RM045','RM085','RM116C','SB100')

              2016-09-14 15:31:50 0035 AND CHARM.ITMMVT.ITMREF_0 = CHARM.ITMMASTER.ITMREF_0

              2016-09-14 15:31:50       8 fields found: Item Reference, Item Description, Company, Total Stock, Allocated Stock, Average Cost, Quantity on Order, Quantity  Available,

              2016-09-14 15:31:50      5 lines fetched

              2016-09-14 15:31:50 0042 SELECT CHARM.PORDER.POHNUM_0 as PO, CHARM.PORDER.POHFCY_0 as Company1,

              2016-09-14 15:31:50 0043  convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103) as [Order Date1], CHARM.PORDER.BPSNUM_0 as [Supplier Code1],

              2016-09-14 15:31:50 0044 BPRNAM_0 as [Supplier Name1],

              2016-09-14 15:31:50 0045

              2016-09-14 15:31:50 0046  case

              2016-09-14 15:31:50 0047      when CHARM.PORDER.ZETADAT_0 < '1900/01/01' then

              2016-09-14 15:31:50 0048        convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103)

              2016-09-14 15:31:50 0049      ELSE

              2016-09-14 15:31:50 0050      convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103)

              2016-09-14 15:31:50 0051      END AS ETA1,

              2016-09-14 15:31:50 0052     

              2016-09-14 15:31:50 0053      --convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) as ETA,

              2016-09-14 15:31:50 0054    CASE

              2016-09-14 15:31:50 0055         WHEN CHARM.PORDER.RCPFLG_0 = '1' THEN 'NOT YET RECEIVED'

              2016-09-14 15:31:50 0056         WHEN CHARM.PORDER.RCPFLG_0 = '2' THEN 'PARTLY RECEIVED'

              2016-09-14 15:31:50 0057         WHEN CHARM.PORDER.RCPFLG_0 = '3' THEN 'FULLY RECEIVED'

              2016-09-14 15:31:50 0058         ELSE NULL        

              2016-09-14 15:31:50 0059     END AS 'Status1',

              2016-09-14 15:31:50 0060 CUR_0 as Currency1,

              2016-09-14 15:31:50 0061 --CSORS_0,

              2016-09-14 15:31:50 0062 CHGCOE_0 as [Exchange Rate1],

              2016-09-14 15:31:50 0063 CHARM.PORDERQ.ITMREF_0 as [Order Item Reference1],

              2016-09-14 15:31:50 0064 convert(DOUBLE PRECISION,CHARM.PORDERQ.QTYPUU_0) as [Purchase Quantity1],

              2016-09-14 15:31:50 0065 convert(DOUBLE PRECISION,CHARM.PORDERQ.RCPQTYPUU_0)  as [Receipt Quantity1],

              2016-09-14 15:31:50 0066 convert(DOUBLE PRECISION,CHARM.PORDERQ.LINAMT_0) as [Line Amount1],

              2016-09-14 15:31:50 0067 CHARM.PORDER.CLEFLG_0 as CloseFlag,ITMDES1_0 as StockDesc1

              2016-09-14 15:31:50 0068 FROM CHARM.PORDER, CHARM.PORDERQ, CHARM.ITMMASTER

              2016-09-14 15:31:50 0069 WHERE CHARM.PORDER.POHNUM_0 = CHARM.PORDERQ.POHNUM_0

              2016-09-14 15:31:50 0070 AND CHARM.PORDER.POHFCY_0 ='MCFI'

              2016-09-14 15:31:50 0071 and CHARM.PORDER.CLEFLG_0  = 1

              2016-09-14 15:31:50 0072 AND CHARM.ITMMASTER.ITMREF_0 = CHARM.PORDERQ.ITMREF_0

              2016-09-14 15:31:50 0073 AND  CHARM.PORDERQ.ITMREF_0 in ('RM030','RM045','RM085','RM116C','SB100')

              2016-09-14 15:31:50 0074 order by convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) desc

              2016-09-14 15:31:50 0075

              2016-09-14 15:31:50       15 fields found: PO, Company1, Order Date1, Supplier Code1, Supplier Name1, ETA1, Status1, Currency1, Exchange Rate1, Order Item Reference1, Purchase Quantity1, Receipt Quantity1, Line Amount1, CloseFlag, StockDesc1,

              2016-09-14 15:31:50      18 lines fetched

              2016-09-14 15:31:50 0077 SELECT CHARM.PORDER.POHNUM_0 as [Purchase Order],

              2016-09-14 15:31:50 0078 CHARM.PORDER.POHFCY_0 as Company,

              2016-09-14 15:31:50 0079  convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103) as [Order Date],

              2016-09-14 15:31:50 0080  CHARM.PORDER.BPSNUM_0 as [Supplier Code],

              2016-09-14 15:31:50 0081 BPRNAM_0 as [Supplier Name],

              2016-09-14 15:31:50 0082

              2016-09-14 15:31:50 0083  case

              2016-09-14 15:31:50 0084      when CHARM.PORDER.ZETADAT_0 < '1900/01/01' then

              2016-09-14 15:31:50 0085        convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103)

              2016-09-14 15:31:50 0086      ELSE

              2016-09-14 15:31:50 0087      convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103)

              2016-09-14 15:31:50 0088      END AS ETA,

              2016-09-14 15:31:50 0089     

              2016-09-14 15:31:50 0090      --convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) as ETA,

              2016-09-14 15:31:50 0091    CASE

              2016-09-14 15:31:50 0092         WHEN CHARM.PORDER.RCPFLG_0 = '1' THEN 'NOT YET RECEIVED'

              2016-09-14 15:31:50 0093         WHEN CHARM.PORDER.RCPFLG_0 = '2' THEN 'PARTLY RECEIVED'

              2016-09-14 15:31:50 0094         WHEN CHARM.PORDER.RCPFLG_0 = '3' THEN 'FULLY RECEIVED'

              2016-09-14 15:31:50 0095         ELSE NULL        

              2016-09-14 15:31:50 0096     END AS 'Status',

              2016-09-14 15:31:50 0097 CHARM.PORDER.CUR_0 as Currency,

              2016-09-14 15:31:50 0098 CHGCOE_0 as [Exchange Rate],

              2016-09-14 15:31:50 0099 CHARM.PORDERQ.ITMREF_0 as [Order Item Reference],

              2016-09-14 15:31:50 0100 convert(DOUBLE PRECISION,CHARM.PORDERQ.QTYPUU_0) as [Purchase Quantity],

              2016-09-14 15:31:50 0101 convert(DOUBLE PRECISION,CHARM.PORDERQ.RCPQTYPUU_0)  as [Receipt Quantity],

              2016-09-14 15:31:50 0102 convert(DOUBLE PRECISION,CHARM.PORDERQ.LINAMT_0) as [Line Amount],

              2016-09-14 15:31:50 0103 CHARM.PORDER.CLEFLG_0,ITMDES1_0 as StockDesc,

              2016-09-14 15:31:50 0104 CHARM.PORDER.EECICT_0 as Incoterm,

              2016-09-14 15:31:50 0105 BPSUPPLIER.ACCCOD_0  as Type,

              2016-09-14 15:31:50 0106  CASE

              2016-09-14 15:31:50 0107     WHEN  BPSUPPLIER.ACCCOD_0  = 'SLNG' then

              2016-09-14 15:31:50 0108           'Supplier Local Non Group'

              2016-09-14 15:31:50 0109      WHEN  BPSUPPLIER.ACCCOD_0  = 'SLGP' THEN

              2016-09-14 15:31:50 0110       'Supplier Local Group'

              2016-09-14 15:31:50 0111  WHEN  BPSUPPLIER.ACCCOD_0  = 'SFGP' THEN

              2016-09-14 15:31:50 0112    'Supplier Foreign Group'

              2016-09-14 15:31:50 0113   WHEN  BPSUPPLIER.ACCCOD_0  = 'SFNG' THEN

              2016-09-14 15:31:50 0114      'Supplier Foreign Non Group'

              2016-09-14 15:31:50 0115 

              2016-09-14 15:31:50 0116   END AS Foreign_Local,

              2016-09-14 15:31:50 0117  

              2016-09-14 15:31:50 0118   CHARM.PORDERQ.STU_0 as ORD_UOM

              2016-09-14 15:31:50 0119

              2016-09-14 15:31:50 0120 FROM CHARM.PORDER, CHARM.PORDERQ, CHARM.ITMMASTER,CHARM.BPSUPPLIER BPSUPPLIER

              2016-09-14 15:31:50 0121 WHERE CHARM.PORDER.POHNUM_0 = CHARM.PORDERQ.POHNUM_0

              2016-09-14 15:31:50 0122 --AND CHARM.PORDER.POHFCY_0 ='MCFI'

              2016-09-14 15:31:50 0123 AND CHARM.ITMMASTER.ITMREF_0 = CHARM.PORDERQ.ITMREF_0

              2016-09-14 15:31:50 0124 --AND  CHARM.PORDERQ.ITMREF_0 in ('RM030','RM045','RM085','RM116C','SB100')

              2016-09-14 15:31:50 0125 AND BPSUPPLIER.BPSNUM_0 = CHARM.PORDER.BPSNUM_0

              2016-09-14 15:31:50 0126 order by convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) desc

              2016-09-14 15:31:51       19 fields found: Purchase Order, Company, Order Date, Supplier Code, Supplier Name, ETA, Status, Currency, Exchange Rate, Order Item Reference, Purchase Quantity, Receipt Quantity, Line Amount, CLEFLG_0, StockDesc, Incoterm, Type, Foreign_Local, ORD_UOM,

              2016-09-14 15:31:51      12,103 lines fetched

              2016-09-14 15:31:51 0130 SELECT MFGHEAD.MFGNUM_0 as [Works Order], MFGHEAD.ROUNUM_0 as[Finished Good Code],

              2016-09-14 15:31:51 0131 convert(varchar(10),MFGHEAD.STRDAT_0, 103)  as [Start Date],

              2016-09-14 15:31:51 0132 YEAR(MFGHEAD.STRDAT_0) as [WIP Yearly],

              2016-09-14 15:31:51 0133 --QuarterName(MFGHEAD.STRDAT_0) as [WIP Quarter],

              2016-09-14 15:31:51 0134 left(datename(month, STRDAT_0 ),3) as [WIP Monthly],

              2016-09-14 15:31:51 0135 Day(MFGHEAD.STRDAT_0)as [WIP Day],

              2016-09-14 15:31:51 0136 MFGHEAD.ROUALT_0 as [Route Code] ,

              2016-09-14 15:31:51 0137  CASE

              2016-09-14 15:31:51 0138         WHEN MFGHEAD.STU_0 = 'T' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1000)

              2016-09-14 15:31:51 0139         WHEN MFGHEAD.STU_0 = 'L' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1.15) --1.15kg  

              2016-09-14 15:31:51 0140         ELSE convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0)        

              2016-09-14 15:31:51 0141  END AS  [Expected Qty],

              2016-09-14 15:31:51 0142 --convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0) * 1000 as [Expected Qty],

              2016-09-14 15:31:51 0143 MFGHEAD.STU_0 as UOM,

              2016-09-14 15:31:51 0144 WIPCOST.ITMREF_0  as [WIP Item Reference],

              2016-09-14 15:31:51 0145 convert(DOUBLE PRECISION,WIPCOST.QTY_0) as [BOM QTY], WIPCOST.WIPSEQ_0 as [Sequence],

              2016-09-14 15:31:51 0146 --convert(DOUBLE PRECISION,WIPCOST.QTYACT_0)  as [Actual Qty],

              2016-09-14 15:31:51 0147

              2016-09-14 15:31:51 0148 CASE

              2016-09-14 15:31:51 0149         WHEN WIPCOST.STU_0 = 'T' THEN convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1000)

              2016-09-14 15:31:51 0150         WHEN WIPCOST.STU_0 = 'L' THEN convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1.15)  --1.15kg  

              2016-09-14 15:31:51 0151         ELSE convert(DOUBLE PRECISION,WIPCOST.QTYACT_0)        

              2016-09-14 15:31:51 0152  END AS  [Actual Qty],

              2016-09-14 15:31:51 0153 

              2016-09-14 15:31:51 0154 convert(DOUBLE PRECISION,WIPCOST.REJQTY_0)  as [Rejected Qty],

              2016-09-14 15:31:51 0155 convert(DOUBLE PRECISION,WIPCOST.UNTCST_0)  as [Unit Cost],

              2016-09-14 15:31:51 0156 convert(DOUBLE PRECISION,WIPCOST.AMOUNT_0)  as [Total Cost],

              2016-09-14 15:31:51 0157 WIPCOST.MATGRP_0 as [MAT Group],

              2016-09-14 15:31:51 0158 WIPCOST.OVENAT_0 as [Overhead Code],

              2016-09-14 15:31:51 0159

              2016-09-14 15:31:51 0160 CASE

              2016-09-14 15:31:51 0161         WHEN WIPCOST.STU_0 = 'T' THEN 'KG'

              2016-09-14 15:31:51 0162         WHEN WIPCOST.STU_0 = 'L' THEN 'KG'

              2016-09-14 15:31:51 0163      

              2016-09-14 15:31:51 0164         ELSE WIPCOST.STU_0        

              2016-09-14 15:31:51 0165     END AS [UOM Raw Mat],

              2016-09-14 15:31:51 0166    

              2016-09-14 15:31:51 0167 --WIPCOST.STU_0 as [UOM Raw Mat],

              2016-09-14 15:31:51 0168 MFGHEAD.MFGFCY_0 as [Site Code], MFGHEAD.MFGSTA_0 as [Status],

              2016-09-14 15:31:51 0169 CHARM.ITMMASTER.TSICOD_0 as Category0,CHARM.ITMMASTER.TSICOD_1 as Category1

              2016-09-14 15:31:51 0170 FROM   CHARM.ITMMASTER , x3data.CHARM.MFGHEAD MFGHEAD

              2016-09-14 15:31:51 0171 LEFT OUTER JOIN x3data.CHARM.WIPCOST WIPCOST ON MFGHEAD.MFGNUM_0=WIPCOST.VCRNUM_0

              2016-09-14 15:31:51 0172 WHERE  WIPCOST.MATGRP_0=1

              2016-09-14 15:31:51 0173 AND CHARM.ITMMASTER.ITMREF_0 = MFGHEAD.ROUNUM_0

              2016-09-14 15:31:51 0174 AND MFGHEAD.MFGFCY_0=N'MCFI'

              2016-09-14 15:31:51 0175 --AND MFGHEAD.ROUNUM_0=N'A5/50/30'

              2016-09-14 15:31:51 0176

              2016-09-14 15:31:51 0177 and MFGHEAD.ROUNUM_0 <> WIPCOST.ITMREF_0

              2016-09-14 15:31:51 0178 ORDER BY MFGHEAD.MFGNUM_0, WIPCOST.WIPSEQ_0

              2016-09-14 15:31:51 0179 '

              2016-09-14 15:31:51 0180

              2016-09-14 15:31:51       23 fields found: Works Order, Finished Good Code, Start Date, WIP Yearly, WIP Monthly, WIP Day, Route Code, Expected Qty, UOM, WIP Item Reference, BOM QTY, Sequence, Actual Qty, Rejected Qty, Unit Cost, Total Cost, MAT Group, Overhead Code, UOM Raw Mat, Site Code, Status, Category0, Category1,

              2016-09-14 15:31:51      5,994 lines fetched

              2016-09-14 15:31:51 0191 select MFGHEAD.MFGNUM_0 as [RMUE Works Order] ,

              2016-09-14 15:31:51 0192 YEAR(MFGHEAD.STRDAT_0) as [RMUE WIP Yearly],

              2016-09-14 15:31:51 0193 convert(varchar(10),MFGHEAD.STRDAT_0, 103)  as [RMUE Start Date],

              2016-09-14 15:31:51 0194  Month(STRDAT_0) as [RMUE WIP Monthly],

              2016-09-14 15:31:51 0195

              2016-09-14 15:31:51 0196  CASE WHEN MFGHEAD.ROUNUM_0 = WIPCOST.ITMREF_0 then

              2016-09-14 15:31:51 0197 

              2016-09-14 15:31:51 0198  CASE

              2016-09-14 15:31:51 0199         WHEN MFGHEAD.STU_0 = 'T' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1000)

              2016-09-14 15:31:51 0200         WHEN MFGHEAD.STU_0 = 'L' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1.15) --1.15kg  

              2016-09-14 15:31:51 0201         ELSE convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0)        

              2016-09-14 15:31:51 0202  END

              2016-09-14 15:31:51 0203  else 0

              2016-09-14 15:31:51 0204  END AS   [RMUE Expected Qty],

              2016-09-14 15:31:51 0205  MFGHEAD.STU_0 as RMUE_UOM,

              2016-09-14 15:31:51 0206  CASE WHEN MFGHEAD.ROUNUM_0 <> WIPCOST.ITMREF_0 then

              2016-09-14 15:31:51 0207 

              2016-09-14 15:31:51 0208  CASE

              2016-09-14 15:31:51 0209         WHEN WIPCOST.STU_0 = 'T' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1000 ))

              2016-09-14 15:31:51 0210         WHEN WIPCOST.STU_0 = 'L' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1.15))  --1.15kg  

              2016-09-14 15:31:51 0211         ELSE sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0))        

              2016-09-14 15:31:51 0212  END

              2016-09-14 15:31:51 0213  else 0

              2016-09-14 15:31:51 0214  END AS   [RMUE Actual Qty],

              2016-09-14 15:31:51 0215 

              2016-09-14 15:31:51 0216  CASE

              2016-09-14 15:31:51 0217         WHEN WIPCOST.STU_0 = 'T' THEN 'KG'

              2016-09-14 15:31:51 0218         WHEN WIPCOST.STU_0 = 'L' THEN 'KG'

              2016-09-14 15:31:51 0219         ELSE WIPCOST.STU_0        

              2016-09-14 15:31:51 0220     END AS [RMUE UOM Raw Mat]

              2016-09-14 15:31:51 0221    

              2016-09-14 15:31:51 0222    

              2016-09-14 15:31:51 0223     FROM    x3data.CHARM.MFGHEAD MFGHEAD

              2016-09-14 15:31:51 0224 LEFT OUTER JOIN x3data.CHARM.WIPCOST WIPCOST ON MFGHEAD.MFGNUM_0=WIPCOST.VCRNUM_0

              2016-09-14 15:31:51 0225 WHERE  WIPCOST.MATGRP_0=1

              2016-09-14 15:31:51 0226 AND MFGHEAD.MFGFCY_0=N'MCFI'

              2016-09-14 15:31:51 0227 --AND MFGHEAD.ROUNUM_0=N'A5/50/30'

              2016-09-14 15:31:51 0228 --AND MFGHEAD.MFGNUM_0 ='MCFI1501MFG00000004'

              2016-09-14 15:31:51 0229 group by MFGHEAD.ROUNUM_0,WIPCOST.ITMREF_0,MFGHEAD.MFGNUM_0,MFGHEAD.STRDAT_0,

              2016-09-14 15:31:51 0230 MFGHEAD.STU_0,MFGHEAD.EXTQTY_0,WIPCOST.STU_0

              2016-09-14 15:31:51 0231 order by MFGHEAD.MFGNUM_0

              2016-09-14 15:31:52       8 fields found: RMUE Works Order, RMUE WIP Yearly, RMUE Start Date, RMUE WIP Monthly, RMUE Expected Qty, RMUE_UOM, RMUE Actual Qty, RMUE UOM Raw Mat,

              2016-09-14 15:31:52      7,721 lines fetched

              2016-09-14 15:31:52 0234 TranDet:

              2016-09-14 15:31:52 0235

              2016-09-14 15:31:52 0236 select MFGHEAD.ROUNUM_0,WIPCOST.ITMREF_0  as [RMUE2 WIP Item Reference],MFGHEAD.MFGNUM_0 as [RMUE2 Works Order] ,

              2016-09-14 15:31:52 0237 YEAR(MFGHEAD.STRDAT_0) as [RMUE2 WIP Yearly],

              2016-09-14 15:31:52 0238 convert(varchar(10),MFGHEAD.STRDAT_0, 103)  as [RMUE2 Start Date],

              2016-09-14 15:31:52 0239 left(datename(month, STRDAT_0 ),3) as [RMUE2 WIP Monthly],

              2016-09-14 15:31:52 0240

              2016-09-14 15:31:52 0241  CASE WHEN MFGHEAD.ROUNUM_0 = WIPCOST.ITMREF_0 then

              2016-09-14 15:31:52 0242 

              2016-09-14 15:31:52 0243  CASE

              2016-09-14 15:31:52 0244         WHEN MFGHEAD.STU_0 = 'T' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1000)

              2016-09-14 15:31:52 0245         WHEN MFGHEAD.STU_0 = 'L' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1.15) --1.15kg  

              2016-09-14 15:31:52 0246         ELSE convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0)        

              2016-09-14 15:31:52 0247  END

              2016-09-14 15:31:52 0248  else 0

              2016-09-14 15:31:52 0249  END AS  [RMUE2 Expected Qty],

              2016-09-14 15:31:52 0250   MFGHEAD.STU_0 as RMUE2_UOM,

              2016-09-14 15:31:52 0251  CASE WHEN MFGHEAD.ROUNUM_0 <> WIPCOST.ITMREF_0 then

              2016-09-14 15:31:52 0252 

              2016-09-14 15:31:52 0253  CASE

              2016-09-14 15:31:52 0254         WHEN WIPCOST.STU_0 = 'T' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1000 ))

              2016-09-14 15:31:52 0255         WHEN WIPCOST.STU_0 = 'L' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1.15))  --1.15kg  

              2016-09-14 15:31:52 0256         ELSE sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0))        

              2016-09-14 15:31:52 0257  END

              2016-09-14 15:31:52 0258  else 0

              2016-09-14 15:31:52 0259  END AS  [RMUE2 Actual Qty],

              2016-09-14 15:31:52 0260  CASE

              2016-09-14 15:31:52 0261         WHEN WIPCOST.STU_0 = 'T' THEN 'KG'

              2016-09-14 15:31:52 0262         WHEN WIPCOST.STU_0 = 'L' THEN 'KG'

              2016-09-14 15:31:52 0263         ELSE WIPCOST.STU_0        

              2016-09-14 15:31:52 0264     END AS [RMUE2 UOM Raw Mat]

              2016-09-14 15:31:52 0265    

              2016-09-14 15:31:52 0266    

              2016-09-14 15:31:52 0267     FROM    x3data.CHARM.MFGHEAD MFGHEAD

              2016-09-14 15:31:52 0268 LEFT OUTER JOIN x3data.CHARM.WIPCOST WIPCOST ON MFGHEAD.MFGNUM_0=WIPCOST.VCRNUM_0

              2016-09-14 15:31:52 0269 WHERE  WIPCOST.MATGRP_0=1

              2016-09-14 15:31:52 0270 AND MFGHEAD.MFGFCY_0=N'MCFI'

              2016-09-14 15:31:52 0271 --AND MFGHEAD.ROUNUM_0=N'A5/50/30'

              2016-09-14 15:31:52 0272 --AND MFGHEAD.MFGNUM_0 ='MCFI1501MFG00000004'

              2016-09-14 15:31:52 0273 group by MFGHEAD.ROUNUM_0,WIPCOST.ITMREF_0,MFGHEAD.MFGNUM_0,MFGHEAD.STRDAT_0,

              2016-09-14 15:31:52 0274 MFGHEAD.STU_0,MFGHEAD.EXTQTY_0,WIPCOST.STU_0

              2016-09-14 15:31:52 0275

              2016-09-14 15:31:52       10 fields found: ROUNUM_0, RMUE2 WIP Item Reference, RMUE2 Works Order, RMUE2 WIP Yearly, RMUE2 Start Date, RMUE2 WIP Monthly, RMUE2 Expected Qty, RMUE2_UOM, RMUE2 Actual Qty, RMUE2 UOM Raw Mat,

              2016-09-14 15:31:52      7,721 lines fetched

              2016-09-14 15:31:52 0276 Final:

              2016-09-14 15:31:52 0277 Load

              2016-09-14 15:31:52 0278 [RMUE2 Works Order] as WIPWO,

              2016-09-14 15:31:52 0279 Sum([RMUE2 Expected Qty]) AS [RMUE2 Expected Qty2],

              2016-09-14 15:31:52 0280 Sum([RMUE2 Actual Qty]) AS [RMUE2 Actual Qty2],

              2016-09-14 15:31:52 0281 (1-Sum([RMUE2 Actual Qty])/Sum([RMUE2 Expected Qty])) * 100 as RMUEE

              2016-09-14 15:31:52 0282

              2016-09-14 15:31:52 0283 Resident TranDet Group By [RMUE2 Works Order]

              2016-09-14 15:31:52       4 fields found: WIPWO, RMUE2 Expected Qty2, RMUE2 Actual Qty2, RMUEE,

              2016-09-14 15:31:52      1,848 lines fetched

              2016-09-14 15:31:52 0286 STOJOU:

              2016-09-14 15:31:52 0287 SELECT CHARM.STOJOU.ITMREF_0 as [STOJOU Item Reference],

              2016-09-14 15:31:52 0288 ITMDES1_0 as [STOJOU Item Description],

              2016-09-14 15:31:52 0289 STOFCY_0 as STOJOUCompan,

              2016-09-14 15:31:52 0290 --convert(varchar(10),IPTDAT_0, 103) as [TransactionDate],

              2016-09-14 15:31:52 0291 IPTDAT_0 as TransactionDate,

              2016-09-14 15:31:52 0292 --convert(varchar(4),year(IPTDAT_0)) as STOJOUYEAR,

              2016-09-14 15:31:52 0293 sum(convert(DOUBLE PRECISION,QTYSTU_0)) as Quantit,

              2016-09-14 15:31:52 0294 sum(convert(DOUBLE PRECISION,VARVAL_0)) as Valu

              2016-09-14 15:31:52 0295 FROM CHARM.STOJOU, CHARM.ITMMASTER

              2016-09-14 15:31:52 0296 WHERE STOFCY_0 = 'MCFI'

              2016-09-14 15:31:52 0297

              2016-09-14 15:31:52 0298

              2016-09-14 15:31:52 0299 AND CHARM.STOJOU.ITMREF_0 = CHARM.ITMMASTER.ITMREF_0

              2016-09-14 15:31:52 0300 --and IPTDAT_0<= dateadd(dd,-1,dateadd(mm,datediff(mm,0,IPTDAT_0)+1,0))

              2016-09-14 15:31:52 0301 GROUP BY  CHARM.STOJOU.ITMREF_0,ITMDES1_0,STOFCY_0

              2016-09-14 15:31:52 0302 ,IPTDAT_0

              2016-09-14 15:31:52 0303 order by 4

              2016-09-14 15:31:52 0304

                • Re: Reload app failed in QMC task when creating once-only trigger
                  Andres Prado

                  Is that the complete log? Cause it's not showing any error and it seems like something is missing. If that's the complete log I would say that the mistake could be a network shutdown or something external to QS. Could you please verify if the log file that you pasted is complete??

                   

                  Cheers,

                  Andrés

                    • Re: Reload app failed in QMC task when creating once-only trigger
                      geerutsing govind

                      2016-09-15 10:20:13      Execution started.

                      2016-09-15 10:20:13      Qlik Sense Server Version     3.0.1+Build:62.release/ms17

                      2016-09-15 10:20:13      CPU Target                    x64

                      2016-09-15 10:20:13      Operating System              Windows Server 2012 R2 Standard  (64 bit edition)

                      2016-09-15 10:20:13      Wow64 mode                    Not using Wow64

                      2016-09-15 10:20:13      Language                      0409 English (United States) English

                      2016-09-15 10:20:13      Country                       1 United States United States

                      2016-09-15 10:20:13      MDAC Version                  6.3.9600.16384

                      2016-09-15 10:20:13      MDAC Full Install Version     6.3.9600.16384

                      2016-09-15 10:20:13      PreferredCompression          2

                      2016-09-15 10:20:13      EnableParallelReload          1

                      2016-09-15 10:20:13      ParallelizeQvdLoads           1

                      2016-09-15 10:20:13      EnableFlushLog                0

                      2016-09-15 10:20:13      UserLogfileCharset            65001

                      2016-09-15 10:20:13      OdbcLoginTimeout              -1

                      2016-09-15 10:20:13      OdbcConnectionTimeout         -1

                      2016-09-15 10:20:13      LongestPossibleLine           1048576

                      2016-09-15 10:20:13      ScriptWantsDbWrite            false

                      2016-09-15 10:20:13      ScriptWantsExe                false

                      2016-09-15 10:20:13      LogFile CodePage Used:        65001

                      2016-09-15 10:20:13      UseMemoryFillPattern          1

                      2016-09-15 10:20:13      ScriptMode                    Standard (limits system access)

                      2016-09-15 10:20:13      ReloadCodebase                Classic

                      2016-09-15 10:20:13      Reload Executed By            UserDirectory=INTERNAL; UserId=sa_scheduler

                      2016-09-15 10:20:13      Process Executing             Qlik Sense Server

                      2016-09-15 10:20:13      Process ID                    2856

                      2016-09-15 10:20:13 0002 SET ThousandSep=','

                      2016-09-15 10:20:13 0003 SET DecimalSep='.'

                      2016-09-15 10:20:13 0004 SET MoneyThousandSep=','

                      2016-09-15 10:20:13 0005 SET MoneyDecimalSep='.'

                      2016-09-15 10:20:13 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'

                      2016-09-15 10:20:13 0007 SET TimeFormat='h:mm:ss TT'

                      2016-09-15 10:20:13 0008 SET DateFormat='DD/MM/YYYY'

                      2016-09-15 10:20:13 0009 SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT'

                      2016-09-15 10:20:13 0010 SET FirstWeekDay=6

                      2016-09-15 10:20:13 0011 SET BrokenWeeks=1

                      2016-09-15 10:20:13 0012 SET ReferenceDay=0

                      2016-09-15 10:20:13 0013 SET FirstMonthOfYear=1

                      2016-09-15 10:20:13 0014 SET CollationLocale='en-US'

                      2016-09-15 10:20:13 0015 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

                      2016-09-15 10:20:13 0016 SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'

                      2016-09-15 10:20:13 0017 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

                      2016-09-15 10:20:13 0018 SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'

                      2016-09-15 10:20:13 0021 *** CONNECT TO ***

                      2016-09-15 10:20:13 0024 SELECT CHARM.ITMMVT.ITMREF_0 as [Item Reference],

                      2016-09-15 10:20:13 0025 ITMDES1_0 as [Item Description],

                      2016-09-15 10:20:13 0026 STOFCY_0 as Company,

                      2016-09-15 10:20:13 0027 convert(DOUBLE PRECISION,PHYSTO_0) as [Total Stock],

                      2016-09-15 10:20:13 0028 convert(DOUBLE PRECISION,PHYALL_0) as [Allocated Stock],

                      2016-09-15 10:20:13 0029 convert(DOUBLE PRECISION,AVC_0) as [Average Cost],

                      2016-09-15 10:20:13 0030 convert(DOUBLE PRECISION,ORDSTO_0) as [Quantity on Order],

                      2016-09-15 10:20:13 0031 (convert(DOUBLE PRECISION,PHYSTO_0)- convert(DOUBLE PRECISION,PHYALL_0)) as [Quantity  Available]

                      2016-09-15 10:20:13 0032 FROM CHARM.ITMMVT  , CHARM.ITMMASTER

                      2016-09-15 10:20:13 0033 WHERE STOFCY_0 = 'MCFI'

                      2016-09-15 10:20:13 0034 AND CHARM.ITMMVT.ITMREF_0 in ('RM030','RM045','RM085','RM116C','SB100')

                      2016-09-15 10:20:13 0035 AND CHARM.ITMMVT.ITMREF_0 = CHARM.ITMMASTER.ITMREF_0

                      2016-09-15 10:20:13       8 fields found: Item Reference, Item Description, Company, Total Stock, Allocated Stock, Average Cost, Quantity on Order, Quantity  Available,

                      2016-09-15 10:20:13      5 lines fetched

                      2016-09-15 10:20:13 0042 SELECT CHARM.PORDER.POHNUM_0 as PO, CHARM.PORDER.POHFCY_0 as Company1,

                      2016-09-15 10:20:13 0043  convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103) as [Order Date1], CHARM.PORDER.BPSNUM_0 as [Supplier Code1],

                      2016-09-15 10:20:13 0044 BPRNAM_0 as [Supplier Name1],

                      2016-09-15 10:20:13 0045

                      2016-09-15 10:20:13 0046  case

                      2016-09-15 10:20:13 0047      when CHARM.PORDER.ZETADAT_0 < '1900/01/01' then

                      2016-09-15 10:20:13 0048        convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103)

                      2016-09-15 10:20:13 0049      ELSE

                      2016-09-15 10:20:13 0050      convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103)

                      2016-09-15 10:20:13 0051      END AS ETA1,

                      2016-09-15 10:20:13 0052     

                      2016-09-15 10:20:13 0053      --convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) as ETA,

                      2016-09-15 10:20:13 0054    CASE

                      2016-09-15 10:20:13 0055         WHEN CHARM.PORDER.RCPFLG_0 = '1' THEN 'NOT YET RECEIVED'

                      2016-09-15 10:20:13 0056         WHEN CHARM.PORDER.RCPFLG_0 = '2' THEN 'PARTLY RECEIVED'

                      2016-09-15 10:20:13 0057         WHEN CHARM.PORDER.RCPFLG_0 = '3' THEN 'FULLY RECEIVED'

                      2016-09-15 10:20:13 0058         ELSE NULL        

                      2016-09-15 10:20:13 0059     END AS 'Status1',

                      2016-09-15 10:20:13 0060 CUR_0 as Currency1,

                      2016-09-15 10:20:13 0061 --CSORS_0,

                      2016-09-15 10:20:13 0062 CHGCOE_0 as [Exchange Rate1],

                      2016-09-15 10:20:13 0063 CHARM.PORDERQ.ITMREF_0 as [Order Item Reference1],

                      2016-09-15 10:20:13 0064 convert(DOUBLE PRECISION,CHARM.PORDERQ.QTYPUU_0) as [Purchase Quantity1],

                      2016-09-15 10:20:13 0065 convert(DOUBLE PRECISION,CHARM.PORDERQ.RCPQTYPUU_0)  as [Receipt Quantity1],

                      2016-09-15 10:20:13 0066 convert(DOUBLE PRECISION,CHARM.PORDERQ.LINAMT_0) as [Line Amount1],

                      2016-09-15 10:20:13 0067 CHARM.PORDER.CLEFLG_0 as CloseFlag,ITMDES1_0 as StockDesc1

                      2016-09-15 10:20:13 0068 FROM CHARM.PORDER, CHARM.PORDERQ, CHARM.ITMMASTER

                      2016-09-15 10:20:13 0069 WHERE CHARM.PORDER.POHNUM_0 = CHARM.PORDERQ.POHNUM_0

                      2016-09-15 10:20:13 0070 AND CHARM.PORDER.POHFCY_0 ='MCFI'

                      2016-09-15 10:20:13 0071 and CHARM.PORDER.CLEFLG_0  = 1

                      2016-09-15 10:20:13 0072 AND CHARM.ITMMASTER.ITMREF_0 = CHARM.PORDERQ.ITMREF_0

                      2016-09-15 10:20:13 0073 AND  CHARM.PORDERQ.ITMREF_0 in ('RM030','RM045','RM085','RM116C','SB100')

                      2016-09-15 10:20:13 0074 order by convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) desc

                      2016-09-15 10:20:13 0075

                      2016-09-15 10:20:13       15 fields found: PO, Company1, Order Date1, Supplier Code1, Supplier Name1, ETA1, Status1, Currency1, Exchange Rate1, Order Item Reference1, Purchase Quantity1, Receipt Quantity1, Line Amount1, CloseFlag, StockDesc1,

                      2016-09-15 10:20:13      18 lines fetched

                      2016-09-15 10:20:13 0077 SELECT CHARM.PORDER.POHNUM_0 as [Purchase Order],

                      2016-09-15 10:20:13 0078 CHARM.PORDER.POHFCY_0 as Company,

                      2016-09-15 10:20:13 0079  convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103) as [Order Date],

                      2016-09-15 10:20:13 0080  CHARM.PORDER.BPSNUM_0 as [Supplier Code],

                      2016-09-15 10:20:13 0081 BPRNAM_0 as [Supplier Name],

                      2016-09-15 10:20:13 0082

                      2016-09-15 10:20:13 0083  case

                      2016-09-15 10:20:13 0084      when CHARM.PORDER.ZETADAT_0 < '1900/01/01' then

                      2016-09-15 10:20:13 0085        convert(varchar(10),CHARM.PORDER.ORDDAT_0, 103)

                      2016-09-15 10:20:13 0086      ELSE

                      2016-09-15 10:20:13 0087      convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103)

                      2016-09-15 10:20:13 0088      END AS ETA,

                      2016-09-15 10:20:13 0089     

                      2016-09-15 10:20:13 0090      --convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) as ETA,

                      2016-09-15 10:20:13 0091    CASE

                      2016-09-15 10:20:13 0092         WHEN CHARM.PORDER.RCPFLG_0 = '1' THEN 'NOT YET RECEIVED'

                      2016-09-15 10:20:13 0093         WHEN CHARM.PORDER.RCPFLG_0 = '2' THEN 'PARTLY RECEIVED'

                      2016-09-15 10:20:13 0094         WHEN CHARM.PORDER.RCPFLG_0 = '3' THEN 'FULLY RECEIVED'

                      2016-09-15 10:20:13 0095         ELSE NULL        

                      2016-09-15 10:20:13 0096     END AS 'Status',

                      2016-09-15 10:20:13 0097 CHARM.PORDER.CUR_0 as Currency,

                      2016-09-15 10:20:13 0098 CHGCOE_0 as [Exchange Rate],

                      2016-09-15 10:20:13 0099 CHARM.PORDERQ.ITMREF_0 as [Order Item Reference],

                      2016-09-15 10:20:13 0100 convert(DOUBLE PRECISION,CHARM.PORDERQ.QTYPUU_0) as [Purchase Quantity],

                      2016-09-15 10:20:13 0101 convert(DOUBLE PRECISION,CHARM.PORDERQ.RCPQTYPUU_0)  as [Receipt Quantity],

                      2016-09-15 10:20:13 0102 convert(DOUBLE PRECISION,CHARM.PORDERQ.LINAMT_0) as [Line Amount],

                      2016-09-15 10:20:13 0103 CHARM.PORDER.CLEFLG_0,ITMDES1_0 as StockDesc,

                      2016-09-15 10:20:13 0104 CHARM.PORDER.EECICT_0 as Incoterm,

                      2016-09-15 10:20:13 0105 BPSUPPLIER.ACCCOD_0  as Type,

                      2016-09-15 10:20:13 0106  CASE

                      2016-09-15 10:20:13 0107     WHEN  BPSUPPLIER.ACCCOD_0  = 'SLNG' then

                      2016-09-15 10:20:13 0108           'Supplier Local Non Group'

                      2016-09-15 10:20:13 0109      WHEN  BPSUPPLIER.ACCCOD_0  = 'SLGP' THEN

                      2016-09-15 10:20:13 0110       'Supplier Local Group'

                      2016-09-15 10:20:13 0111  WHEN  BPSUPPLIER.ACCCOD_0  = 'SFGP' THEN

                      2016-09-15 10:20:13 0112    'Supplier Foreign Group'

                      2016-09-15 10:20:13 0113   WHEN  BPSUPPLIER.ACCCOD_0  = 'SFNG' THEN

                      2016-09-15 10:20:13 0114      'Supplier Foreign Non Group'

                      2016-09-15 10:20:13 0115 

                      2016-09-15 10:20:13 0116   END AS Foreign_Local,

                      2016-09-15 10:20:13 0117  

                      2016-09-15 10:20:13 0118   CHARM.PORDERQ.STU_0 as ORD_UOM

                      2016-09-15 10:20:13 0119

                      2016-09-15 10:20:13 0120 FROM CHARM.PORDER, CHARM.PORDERQ, CHARM.ITMMASTER,CHARM.BPSUPPLIER BPSUPPLIER

                      2016-09-15 10:20:13 0121 WHERE CHARM.PORDER.POHNUM_0 = CHARM.PORDERQ.POHNUM_0

                      2016-09-15 10:20:13 0122 --AND CHARM.PORDER.POHFCY_0 ='MCFI'

                      2016-09-15 10:20:13 0123 AND CHARM.ITMMASTER.ITMREF_0 = CHARM.PORDERQ.ITMREF_0

                      2016-09-15 10:20:13 0124 --AND  CHARM.PORDERQ.ITMREF_0 in ('RM030','RM045','RM085','RM116C','SB100')

                      2016-09-15 10:20:13 0125 AND BPSUPPLIER.BPSNUM_0 = CHARM.PORDER.BPSNUM_0

                      2016-09-15 10:20:13 0126 order by convert(varchar(10),CHARM.PORDER.ZETADAT_0, 103) desc

                      2016-09-15 10:20:14       19 fields found: Purchase Order, Company, Order Date, Supplier Code, Supplier Name, ETA, Status, Currency, Exchange Rate, Order Item Reference, Purchase Quantity, Receipt Quantity, Line Amount, CLEFLG_0, StockDesc, Incoterm, Type, Foreign_Local, ORD_UOM,

                      2016-09-15 10:20:14      12,120 lines fetched

                      2016-09-15 10:20:14 0130 SELECT MFGHEAD.MFGNUM_0 as [Works Order], MFGHEAD.ROUNUM_0 as[Finished Good Code],

                      2016-09-15 10:20:14 0131 convert(varchar(10),MFGHEAD.STRDAT_0, 103)  as [Start Date],

                      2016-09-15 10:20:14 0132 YEAR(MFGHEAD.STRDAT_0) as [WIP Yearly],

                      2016-09-15 10:20:14 0133 --QuarterName(MFGHEAD.STRDAT_0) as [WIP Quarter],

                      2016-09-15 10:20:14 0134 left(datename(month, STRDAT_0 ),3) as [WIP Monthly],

                      2016-09-15 10:20:14 0135 Day(MFGHEAD.STRDAT_0)as [WIP Day],

                      2016-09-15 10:20:14 0136 MFGHEAD.ROUALT_0 as [Route Code] ,

                      2016-09-15 10:20:14 0137  CASE

                      2016-09-15 10:20:14 0138         WHEN MFGHEAD.STU_0 = 'T' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1000)

                      2016-09-15 10:20:14 0139         WHEN MFGHEAD.STU_0 = 'L' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1.15) --1.15kg  

                      2016-09-15 10:20:14 0140         ELSE convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0)        

                      2016-09-15 10:20:14 0141  END AS  [Expected Qty],

                      2016-09-15 10:20:14 0142 --convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0) * 1000 as [Expected Qty],

                      2016-09-15 10:20:14 0143 MFGHEAD.STU_0 as UOM,

                      2016-09-15 10:20:14 0144 WIPCOST.ITMREF_0  as [WIP Item Reference],

                      2016-09-15 10:20:14 0145 convert(DOUBLE PRECISION,WIPCOST.QTY_0) as [BOM QTY], WIPCOST.WIPSEQ_0 as [Sequence],

                      2016-09-15 10:20:14 0146 --convert(DOUBLE PRECISION,WIPCOST.QTYACT_0)  as [Actual Qty],

                      2016-09-15 10:20:14 0147

                      2016-09-15 10:20:14 0148 CASE

                      2016-09-15 10:20:14 0149         WHEN WIPCOST.STU_0 = 'T' THEN convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1000)

                      2016-09-15 10:20:14 0150         WHEN WIPCOST.STU_0 = 'L' THEN convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1.15)  --1.15kg  

                      2016-09-15 10:20:14 0151         ELSE convert(DOUBLE PRECISION,WIPCOST.QTYACT_0)        

                      2016-09-15 10:20:14 0152  END AS  [Actual Qty],

                      2016-09-15 10:20:14 0153 

                      2016-09-15 10:20:14 0154 convert(DOUBLE PRECISION,WIPCOST.REJQTY_0)  as [Rejected Qty],

                      2016-09-15 10:20:14 0155 convert(DOUBLE PRECISION,WIPCOST.UNTCST_0)  as [Unit Cost],

                      2016-09-15 10:20:14 0156 convert(DOUBLE PRECISION,WIPCOST.AMOUNT_0)  as [Total Cost],

                      2016-09-15 10:20:14 0157 WIPCOST.MATGRP_0 as [MAT Group],

                      2016-09-15 10:20:14 0158 WIPCOST.OVENAT_0 as [Overhead Code],

                      2016-09-15 10:20:14 0159

                      2016-09-15 10:20:14 0160 CASE

                      2016-09-15 10:20:14 0161         WHEN WIPCOST.STU_0 = 'T' THEN 'KG'

                      2016-09-15 10:20:14 0162         WHEN WIPCOST.STU_0 = 'L' THEN 'KG'

                      2016-09-15 10:20:14 0163      

                      2016-09-15 10:20:14 0164         ELSE WIPCOST.STU_0        

                      2016-09-15 10:20:14 0165     END AS [UOM Raw Mat],

                      2016-09-15 10:20:14 0166    

                      2016-09-15 10:20:14 0167 --WIPCOST.STU_0 as [UOM Raw Mat],

                      2016-09-15 10:20:14 0168 MFGHEAD.MFGFCY_0 as [Site Code], MFGHEAD.MFGSTA_0 as [Status],

                      2016-09-15 10:20:14 0169 CHARM.ITMMASTER.TSICOD_0 as Category0,CHARM.ITMMASTER.TSICOD_1 as Category1

                      2016-09-15 10:20:14 0170 FROM   CHARM.ITMMASTER , x3data.CHARM.MFGHEAD MFGHEAD

                      2016-09-15 10:20:14 0171 LEFT OUTER JOIN x3data.CHARM.WIPCOST WIPCOST ON MFGHEAD.MFGNUM_0=WIPCOST.VCRNUM_0

                      2016-09-15 10:20:14 0172 WHERE  WIPCOST.MATGRP_0=1

                      2016-09-15 10:20:14 0173 AND CHARM.ITMMASTER.ITMREF_0 = MFGHEAD.ROUNUM_0

                      2016-09-15 10:20:14 0174 AND MFGHEAD.MFGFCY_0=N'MCFI'

                      2016-09-15 10:20:14 0175 --AND MFGHEAD.ROUNUM_0=N'A5/50/30'

                      2016-09-15 10:20:14 0176

                      2016-09-15 10:20:14 0177 and MFGHEAD.ROUNUM_0 <> WIPCOST.ITMREF_0

                      2016-09-15 10:20:14 0178 ORDER BY MFGHEAD.MFGNUM_0, WIPCOST.WIPSEQ_0

                      2016-09-15 10:20:14 0179 '

                      2016-09-15 10:20:14 0180

                      2016-09-15 10:20:15       23 fields found: Works Order, Finished Good Code, Start Date, WIP Yearly, WIP Monthly, WIP Day, Route Code, Expected Qty, UOM, WIP Item Reference, BOM QTY, Sequence, Actual Qty, Rejected Qty, Unit Cost, Total Cost, MAT Group, Overhead Code, UOM Raw Mat, Site Code, Status, Category0, Category1,

                      2016-09-15 10:20:15      5,994 lines fetched

                      2016-09-15 10:20:15 0191 select MFGHEAD.MFGNUM_0 as [RMUE Works Order] ,

                      2016-09-15 10:20:15 0192 YEAR(MFGHEAD.STRDAT_0) as [RMUE WIP Yearly],

                      2016-09-15 10:20:15 0193 convert(varchar(10),MFGHEAD.STRDAT_0, 103)  as [RMUE Start Date],

                      2016-09-15 10:20:15 0194  Month(STRDAT_0) as [RMUE WIP Monthly],

                      2016-09-15 10:20:15 0195

                      2016-09-15 10:20:15 0196  CASE WHEN MFGHEAD.ROUNUM_0 = WIPCOST.ITMREF_0 then

                      2016-09-15 10:20:15 0197 

                      2016-09-15 10:20:15 0198  CASE

                      2016-09-15 10:20:15 0199         WHEN MFGHEAD.STU_0 = 'T' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1000)

                      2016-09-15 10:20:15 0200         WHEN MFGHEAD.STU_0 = 'L' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1.15) --1.15kg  

                      2016-09-15 10:20:15 0201         ELSE convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0)        

                      2016-09-15 10:20:15 0202  END

                      2016-09-15 10:20:15 0203  else 0

                      2016-09-15 10:20:15 0204  END AS   [RMUE Expected Qty],

                      2016-09-15 10:20:15 0205  MFGHEAD.STU_0 as RMUE_UOM,

                      2016-09-15 10:20:15 0206  CASE WHEN MFGHEAD.ROUNUM_0 <> WIPCOST.ITMREF_0 then

                      2016-09-15 10:20:15 0207 

                      2016-09-15 10:20:15 0208  CASE

                      2016-09-15 10:20:15 0209         WHEN WIPCOST.STU_0 = 'T' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1000 ))

                      2016-09-15 10:20:15 0210         WHEN WIPCOST.STU_0 = 'L' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1.15))  --1.15kg  

                      2016-09-15 10:20:15 0211         ELSE sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0))        

                      2016-09-15 10:20:15 0212  END

                      2016-09-15 10:20:15 0213  else 0

                      2016-09-15 10:20:15 0214  END AS   [RMUE Actual Qty],

                      2016-09-15 10:20:15 0215 

                      2016-09-15 10:20:15 0216  CASE

                      2016-09-15 10:20:15 0217         WHEN WIPCOST.STU_0 = 'T' THEN 'KG'

                      2016-09-15 10:20:15 0218         WHEN WIPCOST.STU_0 = 'L' THEN 'KG'

                      2016-09-15 10:20:15 0219         ELSE WIPCOST.STU_0        

                      2016-09-15 10:20:15 0220     END AS [RMUE UOM Raw Mat]

                      2016-09-15 10:20:15 0221    

                      2016-09-15 10:20:15 0222    

                      2016-09-15 10:20:15 0223     FROM    x3data.CHARM.MFGHEAD MFGHEAD

                      2016-09-15 10:20:15 0224 LEFT OUTER JOIN x3data.CHARM.WIPCOST WIPCOST ON MFGHEAD.MFGNUM_0=WIPCOST.VCRNUM_0

                      2016-09-15 10:20:15 0225 WHERE  WIPCOST.MATGRP_0=1

                      2016-09-15 10:20:15 0226 AND MFGHEAD.MFGFCY_0=N'MCFI'

                      2016-09-15 10:20:15 0227 --AND MFGHEAD.ROUNUM_0=N'A5/50/30'

                      2016-09-15 10:20:15 0228 --AND MFGHEAD.MFGNUM_0 ='MCFI1501MFG00000004'

                      2016-09-15 10:20:15 0229 group by MFGHEAD.ROUNUM_0,WIPCOST.ITMREF_0,MFGHEAD.MFGNUM_0,MFGHEAD.STRDAT_0,

                      2016-09-15 10:20:15 0230 MFGHEAD.STU_0,MFGHEAD.EXTQTY_0,WIPCOST.STU_0

                      2016-09-15 10:20:15 0231 order by MFGHEAD.MFGNUM_0

                      2016-09-15 10:20:16       8 fields found: RMUE Works Order, RMUE WIP Yearly, RMUE Start Date, RMUE WIP Monthly, RMUE Expected Qty, RMUE_UOM, RMUE Actual Qty, RMUE UOM Raw Mat,

                      2016-09-15 10:20:16      7,721 lines fetched

                      2016-09-15 10:20:16 0234 TranDet:

                      2016-09-15 10:20:16 0235

                      2016-09-15 10:20:16 0236 select MFGHEAD.ROUNUM_0,WIPCOST.ITMREF_0  as [RMUE2 WIP Item Reference],MFGHEAD.MFGNUM_0 as [RMUE2 Works Order] ,

                      2016-09-15 10:20:16 0237 YEAR(MFGHEAD.STRDAT_0) as [RMUE2 WIP Yearly],

                      2016-09-15 10:20:16 0238 convert(varchar(10),MFGHEAD.STRDAT_0, 103)  as [RMUE2 Start Date],

                      2016-09-15 10:20:16 0239 left(datename(month, STRDAT_0 ),3) as [RMUE2 WIP Monthly],

                      2016-09-15 10:20:16 0240

                      2016-09-15 10:20:16 0241  CASE WHEN MFGHEAD.ROUNUM_0 = WIPCOST.ITMREF_0 then

                      2016-09-15 10:20:16 0242 

                      2016-09-15 10:20:16 0243  CASE

                      2016-09-15 10:20:16 0244         WHEN MFGHEAD.STU_0 = 'T' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1000)

                      2016-09-15 10:20:16 0245         WHEN MFGHEAD.STU_0 = 'L' THEN convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0 * 1.15) --1.15kg  

                      2016-09-15 10:20:16 0246         ELSE convert(DOUBLE PRECISION,MFGHEAD.EXTQTY_0)        

                      2016-09-15 10:20:16 0247  END

                      2016-09-15 10:20:16 0248  else 0

                      2016-09-15 10:20:16 0249  END AS  [RMUE2 Expected Qty],

                      2016-09-15 10:20:16 0250   MFGHEAD.STU_0 as RMUE2_UOM,

                      2016-09-15 10:20:16 0251  CASE WHEN MFGHEAD.ROUNUM_0 <> WIPCOST.ITMREF_0 then

                      2016-09-15 10:20:16 0252 

                      2016-09-15 10:20:16 0253  CASE

                      2016-09-15 10:20:16 0254         WHEN WIPCOST.STU_0 = 'T' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1000 ))

                      2016-09-15 10:20:16 0255         WHEN WIPCOST.STU_0 = 'L' THEN sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0 * 1.15))  --1.15kg  

                      2016-09-15 10:20:16 0256         ELSE sum(convert(DOUBLE PRECISION,WIPCOST.QTYACT_0))        

                      2016-09-15 10:20:16 0257  END

                      2016-09-15 10:20:16 0258  else 0

                      2016-09-15 10:20:16 0259  END AS  [RMUE2 Actual Qty],

                      2016-09-15 10:20:16 0260  CASE

                      2016-09-15 10:20:16 0261         WHEN WIPCOST.STU_0 = 'T' THEN 'KG'

                      2016-09-15 10:20:16 0262         WHEN WIPCOST.STU_0 = 'L' THEN 'KG'

                      2016-09-15 10:20:16 0263         ELSE WIPCOST.STU_0        

                      2016-09-15 10:20:16 0264     END AS [RMUE2 UOM Raw Mat]

                      2016-09-15 10:20:16 0265    

                      2016-09-15 10:20:16 0266    

                      2016-09-15 10:20:16 0267     FROM    x3data.CHARM.MFGHEAD MFGHEAD

                      2016-09-15 10:20:16 0268 LEFT OUTER JOIN x3data.CHARM.WIPCOST WIPCOST ON MFGHEAD.MFGNUM_0=WIPCOST.VCRNUM_0

                      2016-09-15 10:20:16 0269 WHERE  WIPCOST.MATGRP_0=1

                      2016-09-15 10:20:16 0270 AND MFGHEAD.MFGFCY_0=N'MCFI'

                      2016-09-15 10:20:16 0271 --AND MFGHEAD.ROUNUM_0=N'A5/50/30'

                      2016-09-15 10:20:16 0272 --AND MFGHEAD.MFGNUM_0 ='MCFI1501MFG00000004'

                      2016-09-15 10:20:16 0273 group by MFGHEAD.ROUNUM_0,WIPCOST.ITMREF_0,MFGHEAD.MFGNUM_0,MFGHEAD.STRDAT_0,

                      2016-09-15 10:20:16 0274 MFGHEAD.STU_0,MFGHEAD.EXTQTY_0,WIPCOST.STU_0

                      2016-09-15 10:20:16 0275

                      2016-09-15 10:20:16       10 fields found: ROUNUM_0, RMUE2 WIP Item Reference, RMUE2 Works Order, RMUE2 WIP Yearly, RMUE2 Start Date, RMUE2 WIP Monthly, RMUE2 Expected Qty, RMUE2_UOM, RMUE2 Actual Qty, RMUE2 UOM Raw Mat,

                      2016-09-15 10:20:16      7,721 lines fetched

                      2016-09-15 10:20:16 0276 Final:

                      2016-09-15 10:20:16 0277 Load

                      2016-09-15 10:20:16 0278 [RMUE2 Works Order] as WIPWO,

                      2016-09-15 10:20:16 0279 Sum([RMUE2 Expected Qty]) AS [RMUE2 Expected Qty2],

                      2016-09-15 10:20:16 0280 Sum([RMUE2 Actual Qty]) AS [RMUE2 Actual Qty2],

                      2016-09-15 10:20:16 0281 (1-Sum([RMUE2 Actual Qty])/Sum([RMUE2 Expected Qty])) * 100 as RMUEE

                      2016-09-15 10:20:16 0282

                      2016-09-15 10:20:16 0283 Resident TranDet Group By [RMUE2 Works Order]

                      2016-09-15 10:20:16       4 fields found: WIPWO, RMUE2 Expected Qty2, RMUE2 Actual Qty2, RMUEE,

                      2016-09-15 10:20:16      1,848 lines fetched

                      2016-09-15 10:20:16 0286 STOJOU:

                      2016-09-15 10:20:16 0287 SELECT CHARM.STOJOU.ITMREF_0 as [STOJOU Item Reference],

                      2016-09-15 10:20:16 0288 ITMDES1_0 as [STOJOU Item Description],

                      2016-09-15 10:20:16 0289 STOFCY_0 as STOJOUCompan,

                      2016-09-15 10:20:16 0290 --convert(varchar(10),IPTDAT_0, 103) as [TransactionDate],

                      2016-09-15 10:20:16 0291 IPTDAT_0 as TransactionDate,

                      2016-09-15 10:20:16 0292 --convert(varchar(4),year(IPTDAT_0)) as STOJOUYEAR,

                      2016-09-15 10:20:16 0293 sum(convert(DOUBLE PRECISION,QTYSTU_0)) as Quantit,

                      2016-09-15 10:20:16 0294 sum(convert(DOUBLE PRECISION,VARVAL_0)) as Valu

                      2016-09-15 10:20:16 0295 FROM CHARM.STOJOU, CHARM.ITMMASTER

                      2016-09-15 10:20:16 0296 WHERE STOFCY_0 = 'MCFI'

                      2016-09-15 10:20:16 0297

                      2016-09-15 10:20:16 0298

                      2016-09-15 10:20:16 0299 AND CHARM.STOJOU.ITMREF_0 = CHARM.ITMMASTER.ITMREF_0

                      2016-09-15 10:20:16 0300 --and IPTDAT_0<= dateadd(dd,-1,dateadd(mm,datediff(mm,0,IPTDAT_0)+1,0))

                      2016-09-15 10:20:16 0301 GROUP BY  CHARM.STOJOU.ITMREF_0,ITMDES1_0,STOFCY_0

                      2016-09-15 10:20:16 0302 ,IPTDAT_0

                      2016-09-15 10:20:16 0303 order by 4

                      2016-09-15 10:20:16 0304

                      2016-09-15 10:20:17       6 fields found: STOJOU Item Reference, STOJOU Item Description, STOJOUCompan, TransactionDate, Quantit, Valu,

                      2016-09-15 10:20:17      9,483 lines fetched

                      2016-09-15 10:20:17 0307 load

                      2016-09-15 10:20:17 0308 TransactionDate as  _StockDate,

                      2016-09-15 10:20:17 0309 date(TransactionDate) as  StockDate,

                      2016-09-15 10:20:17 0310 date([TransactionDate],'MMM YYYY') as  StockDateCurMonth,

                      2016-09-15 10:20:17 0311 monthname(TransactionDate) as  stkCurrentMonth,

                      2016-09-15 10:20:17 0312 QuarterName(TransactionDate) as  QTR_StockDate,

                      2016-09-15 10:20:17 0313 num(month(TransactionDate)) as NumMthSCDate,

                      2016-09-15 10:20:17 0314 [STOJOU Item Reference] as stkRef,

                      2016-09-15 10:20:17 0315 [STOJOU Item Description] as stkDescc,

                      2016-09-15 10:20:17 0316 STOJOUCompan as STOJOUCompany,

                      2016-09-15 10:20:17 0317 Quantit as Quantity,

                      2016-09-15 10:20:17 0318 Valu as Value

                      2016-09-15 10:20:17 0319

                      2016-09-15 10:20:17 0320 Resident STOJOU

                      2016-09-15 10:20:17       11 fields found: _StockDate, StockDate, StockDateCurMonth, stkCurrentMonth, QTR_StockDate, NumMthSCDate, stkRef, stkDescc, STOJOUCompany, Quantity, Value,

                      2016-09-15 10:20:17      9,483 lines fetched

                      2016-09-15 10:20:17 0322 *** CONNECT TO ***

                      2016-09-15 10:20:17 0324 SELECT count(*) as No,SRETURN.STOFCY_0 as Company,

                      2016-09-15 10:20:17 0325 SRETURND.SRHNUM_0 ,

                      2016-09-15 10:20:17 0326   SRETURND.SRDLIN_0 ,

                      2016-09-15 10:20:17 0327 SRETURND.SDHNUM_0 ,

                      2016-09-15 10:20:17 0328 BPDNAM_0 as Customer,ITMDES_0 as Item,

                      2016-09-15 10:20:17 0329 SRETURN.RTNDAT_0 as DateReturned,

                      2016-09-15 10:20:17 0330  CASE WHEN

                      2016-09-15 10:20:17 0331         SRETURND.RTNREN_0 <> '' then

                      2016-09-15 10:20:17 0332       (

                      2016-09-15 10:20:17 0333     SELECT distinct ATEXTRA.TEXTE_0

                      2016-09-15 10:20:17 0334     FROM x3data.CHARM.ATEXTRA ATEXTRA

                      2016-09-15 10:20:17 0335     WHERE SRETURND.RTNREN_0 = ATEXTRA.IDENT2_0

                      2016-09-15 10:20:17 0336     AND ATEXTRA.ZONE_0='LNGDES' AND ATEXTRA.LANGUE_0='ENG'

                      2016-09-15 10:20:17 0337     AND ATEXTRA.IDENT1_0 = '7' AND ATEXTRA.IDENT2_0 <>''

                      2016-09-15 10:20:17 0338   )

                      2016-09-15 10:20:17 0339   else 'NoReason'

                      2016-09-15 10:20:17 0340   END AS Reason

                      2016-09-15 10:20:17 0341 FROM CHARM.SRETURND SRETURND, CHARM.SRETURN SRETURN

                      2016-09-15 10:20:17 0342 WHERE SRETURND.SRHNUM_0 = SRETURN.SRHNUM_0

                      2016-09-15 10:20:17 0343 AND SRETURND.CPY_0 = 'MCF'

                      2016-09-15 10:20:17 0344 --and SRETURN.RTNDAT_0 = '2015/10/28'

                      2016-09-15 10:20:17 0345 group by SRETURN.STOFCY_0,SRETURND.SRHNUM_0,SRETURND.SRDLIN_0,SRETURND.SDHNUM_0,

                      2016-09-15 10:20:17 0346 SRETURN.BPDNAM_0,SRETURND.ITMDES_0,SRETURN.RTNDAT_0,SRETURND.RTNREN_0

                      2016-09-15 10:20:17 0347 order by SRETURN.RTNDAT_0 desc

                      2016-09-15 10:20:18       9 fields found: No, Company, SRHNUM_0, SRDLIN_0, SDHNUM_0, Customer, Item, DateReturned, Reason,

                      2016-09-15 10:20:18      367 lines fetched

                      2016-09-15 10:20:18 0349 LOAD

                      2016-09-15 10:20:18 0350     COMPANY,

                      2016-09-15 10:20:18 0351     "ITEM CODE",

                      2016-09-15 10:20:18 0352     DESCRIPTION,

                      2016-09-15 10:20:18 0353     BRAND,

                      2016-09-15 10:20:18 0354     "TYPE",

                      2016-09-15 10:20:18 0355     DES_0,

                      2016-09-15 10:20:18 0356     LOP,

                      2016-09-15 10:20:18 0357     DES_01,

                      2016-09-15 10:20:18 0358     TSICOD_3,

                      2016-09-15 10:20:18 0359     DES_02,

                      2016-09-15 10:20:18 0360     DIM,

                      2016-09-15 10:20:18 0361     LOCATION,

                      2016-09-15 10:20:18 0362     STA_0,

                      2016-09-15 10:20:18 0363     QTY,

                      2016-09-15 10:20:18 0364     "UNIT COST",

                      2016-09-15 10:20:18 0365     "TOTAL VALUE",

                      2016-09-15 10:20:18 0366     "LAST PURCH DATE",

                      2016-09-15 10:20:18 0367     CURRENT,

                      2016-09-15 10:20:18 0368     "1MONTH",

                      2016-09-15 10:20:18 0369     "2MONTH",

                      2016-09-15 10:20:18 0370     "3MONTH",

                      2016-09-15 10:20:18 0371     "4MONTH",

                      2016-09-15 10:20:18 0372     "5MONTH",

                      2016-09-15 10:20:18 0373     "6MONTH",

                      2016-09-15 10:20:18 0374     "7MONTH",

                      2016-09-15 10:20:18 0375     "8MONTH",

                      2016-09-15 10:20:18 0376     "9MONTH",

                      2016-09-15 10:20:18 0377     "10MONTH",

                      2016-09-15 10:20:18 0378     "11MONTH",

                      2016-09-15 10:20:18 0379     OVER1YR

                      2016-09-15 10:20:18 0380 FROM [lib://x/MCFISTOCKAGE.xls]

                      2016-09-15 10:20:18 0381 (biff, embedded labels, table is Sheet1$)

                      2016-09-15 10:20:18      Error: Cannot open file: 'lib://x/MCFISTOCKAGE.xls'

                      2016-09-15 10:20:18      Execution Failed

                      2016-09-15 10:20:18      Execution finished.

                • Re: Reload app failed in QMC task when creating once-only trigger
                  Andres Prado

                  Hi, could you check if you have your.xls file on that path? (lib://x/MCFISTOCKAGE.xls)