Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

Hello,

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

7 Replies
andrespa
Specialist
Specialist

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

Best regards,

Andrés

Not applicable
Author

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

andrespa
Specialist
Specialist

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

Not applicable
Author

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.

andrespa
Specialist
Specialist

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

shraddha_g
Partner - Master III
Partner - Master III

Hi,


Either Excel file is missing or wrong connection is used.


Regards,

Shraddha


Not applicable
Author

Hello, I have my excel sheet at path c:/x/MCFISTOCKAGE.xls and in QMC dataconnection the path is the same.