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: 
01Nikita
Partner - Contributor III
Partner - Contributor III

Tasks Reload Issue

Hi All,

I have Task reload for stage 1 that is extraction which was getting reload in 50mins but from last 2 days suddenly it is taking 3hrs or more than 3hrs for reload have checked RAM and CPU consumption it is not High no change in script.  attaching the log file.

Also checked same Qvd on test server with same configuration and same qlik environment it is getting reload in 50mins

 

log for task 

11/08/2021 01:22:42: Execution started.
11/08/2021 01:22:42: QlikView Version:11.20.12852.0
11/08/2021 01:22:42: CPU Target x64
11/08/2021 01:22:42: Operating System Windows Server 2016 Standard (64 bit edition)
11/08/2021 01:22:42: Wow64 mode Not using Wow64
11/08/2021 01:22:42: MDAC Version 6.3.9600.16384
11/08/2021 01:22:42: MDAC Full Install Version 6.3.9600.16384
11/08/2021 01:22:42: PreferredCompression 2
11/08/2021 01:22:42: EnableParallelReload 1
11/08/2021 01:22:42: ParallelizeQvdLoads 1
11/08/2021 01:22:42: AutoSaveAfterReload 0
11/08/2021 01:22:42: BackupBeforeReload 0
11/08/2021 01:22:42: EnableFlushLog 0
11/08/2021 01:22:42: SaveInfoWhenSavingFile 0
11/08/2021 01:22:42: UserLogfileCharset 1200
11/08/2021 01:22:42: OdbcLoginTimeout -1
11/08/2021 01:22:42: OdbcConnectionTimeout -1
11/08/2021 01:22:42: ScriptWantsDbWrite false
11/08/2021 01:22:42: ScriptWantsExe false
11/08/2021 01:22:42: LogFile CodePage Used: 1200
11/08/2021 01:22:42: Reload Executed By LALPATHLABS\Qlikview.reports
11/08/2021 01:22:42: Process Executing: QlikView Desktop
11/08/2021 01:22:42: Process ID: 25052
11/08/2021 01:22:42: 0002 SET ThousandSep=','
11/08/2021 01:22:42: 0003 SET DecimalSep='.'
11/08/2021 01:22:42: 0004 SET MoneyThousandSep=','
11/08/2021 01:22:42: 0005 SET MoneyDecimalSep='.'
11/08/2021 01:22:42: 0006 SET MoneyFormat='Rs.#,##0.00;(Rs.#,##0.00)'
11/08/2021 01:22:42: 0007 SET TimeFormat='hh:mm:ss'
11/08/2021 01:22:42: 0008 SET DateFormat='DD/MM/YYYY'
11/08/2021 01:22:42: 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'
11/08/2021 01:22:42: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
11/08/2021 01:22:42: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
11/08/2021 01:22:42: 0014 OLEDB CONNECT*Provider*
11/08/2021 01:22:42: 0003 SET vDBName='AX2012'
11/08/2021 01:22:42: 0015 SET Root = 'D:\DrLalPathLabs_QlikView_AX2012\'
11/08/2021 01:22:42: 0004 SET OfflineData = 'D:\DrLalPathLabs_QlikView_AX2012\OfflineData\'
11/08/2021 01:22:42: 0007 SET DatabaseInstances='LPL_Live','PDPL','SCPL'
11/08/2021 01:22:42: 0008 SET DataAreaIDLPL_Live='live','LIVE'
11/08/2021 01:22:42: 0009 SET DataAreaIDPDPL='pdpl','pmpl','PDPL','PMPL','apl','APL','plu','PLU','NEP','nep','CPL','cpl','BANG','bang','aprl','APRL','DLVP','dlvp','CLPL','clpl'
11/08/2021 01:22:42: 0010 SET DataAreaIDSCPL='amol','med','scpl','hlm','AMOL','MED','SCPL','HLM'
11/08/2021 01:22:42: 0012 SET FilterOut='L66','L68','PSC142','PSC143','PSC144','I01','Z01','S32','B03','M14','M07','M17','M18','V01','M23','M21'
11/08/2021 01:22:42: 0014 SET FilterOut_PDPL = 'LPL','N98'
11/08/2021 01:22:42: 0016 SET Stage1SalesQVDMakers = 'D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDMaker\Sales\'
11/08/2021 01:22:42: 0017 SET Stage1PurchaseQVDMakers = 'D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDMaker\Purchase\'
11/08/2021 01:22:42: 0019 SET Stage1QVDMakers = 'D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDMaker\'
11/08/2021 01:22:42: 0020 SET Stage1QVDs = 'D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDs\'
11/08/2021 01:22:42: 0022 SET Stage2QVDMakers = 'D:\DrLalPathLabs_QlikView_AX2012\Stage2\QVDMaker\'
11/08/2021 01:22:42: 0023 SET Stage2QVDs = 'D:\DrLalPathLabs_QlikView_AX2012\Stage2\QVDs\'
11/08/2021 01:22:42: 0025 REM SET Stage1SalesQVDs = 'D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDs\Sales\'
11/08/2021 01:22:42: 0026 REM SET Stage1PurchaseQVDs = 'D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDs\Purchase\'
11/08/2021 01:22:42: 0028 SET vModule='Sales'
11/08/2021 01:22:42: 0030 SET Application = 'D:\DrLalPathLabs_QlikView_AX2012\Application\'
11/08/2021 01:22:42: 0031 SET DataModel = 'D:\DrLalPathLabs_QlikView_AX2012\Stage3\'
11/08/2021 01:22:42: 0034 SET FileTracker_Stage1 = 'D:\DrLalPathLabs_QlikView_AX2012\FileTracker\Stage1\'
11/08/2021 01:22:42: 0035 SET FileTracker_Stage2 = 'D:\DrLalPathLabs_QlikView_AX2012\FileTracker\Stage2\'
11/08/2021 01:22:42: 0038 SET vBridge = 'D:\DrLalPathLabs_QlikView_AX2012\DrLalPathLabs_Qlikview_Ax2012_Bridge_Qvds\'
11/08/2021 01:22:42: 0017 SET vDB='LPL_Live'
11/08/2021 01:22:42: 0018 SET vStage='Stage1'
11/08/2021 01:22:42: 0019 SET vRawTableName='CustInvoiceTrans'
11/08/2021 01:22:42: 0020 SET vModule='Sales'
11/08/2021 01:22:42: 0024 LET vStartTime = Null()
11/08/2021 01:22:42: 0025 LET vEndTime = Null()
11/08/2021 01:22:42: 0026 LET vNoOfRows = Null()
11/08/2021 01:22:42: 0027 LET vFileSize = Null()
11/08/2021 01:22:42: 0028 LET vFileTime = Null()
11/08/2021 01:22:42: 0029 LET vFileTracker_TableName = Null()
11/08/2021 01:22:42: 0030 LET vTableName = Null()
11/08/2021 01:22:42: 0031 LET vFileTrackerPath = Null()
11/08/2021 01:22:42: 0034 LET vTableName = 'Stage1 CustInvoiceTrans LPL_Live'
11/08/2021 01:22:42: 0035 LET vFileTracker_TableName = 'FileTracker_Stage1 CustInvoiceTrans LPL_Live'
11/08/2021 01:22:42: 0036 LET vFileTrackerPath = FileTracker_Stage1
11/08/2021 01:22:42: 0037 LET vQVDPath='D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDs\Sales\LPL_Live\'
11/08/2021 01:22:42: 0039 LET vStartTime=Now()
11/08/2021 01:22:42: 0041 LET vQvdFile='D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDs\Sales\LPL_Live\Stage1 CustInvoiceTrans LPL_Live.qvd'
11/08/2021 01:22:42: 0042 SET vPK='RECID'
11/08/2021 01:22:42: 0043 SET vModField='MODIFIEDDATETIME'
11/08/2021 01:22:42: 0045 LET vQvdExists = if(FileSize('D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDs\Sales\LPL_Live\Stage1 CustInvoiceTrans LPL_Live.qvd') > 0, -1, 0)
11/08/2021 01:22:42: 0046 LET vToday = Date(Today()-1,'YYYY-MM-DD')&' 18:29:59.998'
11/08/2021 01:22:42: 0048 IF -1 THEN
11/08/2021 01:22:42: 0050 maxdateTab:
11/08/2021 01:22:42: 0051 LOAD MODIFIEDDATETIME
11/08/2021 01:22:42: 0052 FROM
11/08/2021 01:22:42: 0053 D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDs\Sales\LPL_Live\Stage1 CustInvoiceTrans LPL_Live.qvd (qvd)
11/08/2021 01:22:42: 1 fields found: MODIFIEDDATETIME, 188,884,759 lines fetched
11/08/2021 01:25:58: 0054 LOAD Floor(max(FieldValue('MODIFIEDDATETIME', recno()))) as MaxDate
11/08/2021 01:25:58: 0055 AUTOGENERATE FieldValueCount('MODIFIEDDATETIME')
11/08/2021 01:26:49: 1 fields found: MaxDate, 1 lines fetched
11/08/2021 01:26:49: 0056 LET vLastModifiedDate = Date(peek('MaxDate',0,maxdateTab),'YYYY-MM-DD hh:mm:ss')
11/08/2021 01:26:49: 0057 LET vIncrementalExpression = 'WHERE MODIFIEDDATETIME > '& chr(39) & '2021-08-09 00:00:00' & chr(39)&' AND MODIFIEDDATETIME <= '& chr(39) & '2021-08-10 18:29:59.998' & chr(39)&
11/08/2021 01:26:49: 0058 ' AND INVOICEDATE < '& chr(39) &Date(Today(),'YYYY-MM-DD')& chr(39)
11/08/2021 01:26:49: 0059 DROP table maxdateTab
11/08/2021 01:26:49: 0061 ELSE
11/08/2021 01:26:49: 0069 [Stage1 CustInvoiceTrans LPL_Live]:
11/08/2021 01:26:49: 0070 LOAD
11/08/2021 01:26:49: 0071 SALESPRICE*QTY as SALESPRICE,
11/08/2021 01:26:49: 0072 ASSETBOOKID,
11/08/2021 01:26:49: 0073 ASSETID,
11/08/2021 01:26:49: 0074 COMMISSAMOUNTCUR,
11/08/2021 01:26:49: 0075 COMMISSAMOUNTMST,
11/08/2021 01:26:49: 0076 COMMISSCALC,
11/08/2021 01:26:49: 0077 COUNTRYREGIONOFSHIPMENT,
11/08/2021 01:26:49: 0078 CREATEDBY,
11/08/2021 01:26:49: 0079 CREATEDDATETIME,
11/08/2021 01:26:49: 0080 CURRENCYCODE,
11/08/2021 01:26:49: 0081 CUSTOMERLINENUM,
11/08/2021 01:26:49: 0082 DATAAREAID,
11/08/2021 01:26:49: 0083 DELIVERYTYPE,
11/08/2021 01:26:49: 0084 DISCAMOUNT,
11/08/2021 01:26:49: 0085 DISCPERCENT,
11/08/2021 01:26:49: 0086 DLVDATE,
11/08/2021 01:26:49: 0087 EINVOICEACCOUNTCODE,
11/08/2021 01:26:49: 0088 EXTERNALITEMID,
11/08/2021 01:26:49: 0089 INTERCOMPANYINVENTTRANSID,
11/08/2021 01:26:49: 0090 INTRASTATDISPATCHID,
11/08/2021 01:26:49: 0091 INVENTDIMID,
11/08/2021 01:26:49: 0092 INVENTQTY,
11/08/2021 01:26:49: 0093 INVENTREFID,
11/08/2021 01:26:49: 0094 INVENTREFTRANSID,
11/08/2021 01:26:49: 0095 INVENTREFTYPE,
11/08/2021 01:26:49: 0096 INVENTTRANSID,
11/08/2021 01:26:49: 0097 INVOICEDATE,
11/08/2021 01:26:49: 0098 INVOICEID,
11/08/2021 01:26:49: 0099 ITEMCODEID,
11/08/2021 01:26:49: 0100 ITEMID,
11/08/2021 01:26:49: 0101 "ITL_CARDNUM",
11/08/2021 01:26:49: 0102 "ITL_COMMISSION",
11/08/2021 01:26:49: 0103 "ITL_EARNPOINT",
11/08/2021 01:26:49: 0104 "ITL_LABNUM",
11/08/2021 01:26:49: 0105 "ITL_LABPREFIX",
11/08/2021 01:26:49: 0106 "ITL_LOCALINVENTLOCATIONID",
11/08/2021 01:26:49: 0107 "ITL_MANDATORYDATE",
11/08/2021 01:26:49: 0108 "ITL_PATIENTID",
11/08/2021 01:26:49: 0109 "ITL_PRICETYPE",
11/08/2021 01:26:49: 0110 "ITL_PROCESSINGLAB",
11/08/2021 01:26:49: 0111 "ITL_REGISTRATIONLAB",
11/08/2021 01:26:49: 0112 "ITL_REPORTINGDATE",
11/08/2021 01:26:49: 0113 "ITL_TRANSACTIONTYPE",
11/08/2021 01:26:49: 0114 "ITL_TRANSFERPRICE",
11/08/2021 01:26:49: 0115 LINEAMOUNT,
11/08/2021 01:26:49: 0116 LINEAMOUNTMST,
11/08/2021 01:26:49: 0117 LINEAMOUNTTAX,
11/08/2021 01:26:49: 0118 LINEAMOUNTTAXMST,
11/08/2021 01:26:49: 0119 LINEDISC,
11/08/2021 01:26:49: 0120 LINEHEADER,
11/08/2021 01:26:49: 0121 LINENUM,
11/08/2021 01:26:49: 0122 LINEPERCENT,
11/08/2021 01:26:49: 0123 MODIFIEDDATETIME,
11/08/2021 01:26:49: 0124 MULTILNDISC,
11/08/2021 01:26:49: 0125 MULTILNPERCENT,
11/08/2021 01:26:49: 0126 NAME,
11/08/2021 01:26:49: 0127 NUMBERSEQUENCEGROUP,
11/08/2021 01:26:49: 0128 OLAPCOSTVALUE,
11/08/2021 01:26:49: 0129 ORIGCOUNTRYREGIONID,
11/08/2021 01:26:49: 0130 ORIGSALESID,
11/08/2021 01:26:49: 0131 ORIGSTATE,
11/08/2021 01:26:49: 0132 PARTDELIVERY,
11/08/2021 01:26:49: 0133 PORT,
11/08/2021 01:26:49: 0134 PRICEUNIT,
11/08/2021 01:26:49: 0135 QTY,
11/08/2021 01:26:49: 0136 QTYPHYSICAL,
11/08/2021 01:26:49: 0137 REASONREFRECID,
11/08/2021 01:26:49: 0138 RECID,
11/08/2021 01:26:49: 0139 RECVERSION,
11/08/2021 01:26:49: 0140 REMAIN,
11/08/2021 01:26:49: 0141 RETURNARRIVALDATE,
11/08/2021 01:26:49: 0142 RETURNCLOSEDDATE,
11/08/2021 01:26:49: 0143 RETURNDISPOSITIONCODEID,
11/08/2021 01:26:49: 0144 SALESGROUP,
11/08/2021 01:26:49: 0145 SALESID,
11/08/2021 01:26:49: 0146 SALESMARKUP,
11/08/2021 01:26:49: 0147 SALESUNIT,
11/08/2021 01:26:49: 0148 STATLINEAMOUNTMST,
11/08/2021 01:26:49: 0149 STATPROCID,
11/08/2021 01:26:49: 0150 SUMLINEDISC,
11/08/2021 01:26:49: 0151 SUMLINEDISCMST,
11/08/2021 01:26:49: 0152 TAXAMOUNT,
11/08/2021 01:26:49: 0153 TAXAMOUNTMST,
11/08/2021 01:26:49: 0154 TAXAUTOGENERATED,
11/08/2021 01:26:49: 0155 TAXGROUP,
11/08/2021 01:26:49: 0156 TAXITEMGROUP,
11/08/2021 01:26:49: 0157 TAXWRITECODE,
11/08/2021 01:26:49: 0158 TRANSACTIONCODE,
11/08/2021 01:26:49: 0159 TRANSPORT,
11/08/2021 01:26:49: 0160 WEIGHT,
11/08/2021 01:26:49: 0161 LEDGERDIMENSION as LEDGERACCOUNT,
11/08/2021 01:26:49: 0162 ITL_SUPPLEMENATRYITEM as ITL_SUPPLEMENTARYITEM
11/08/2021 01:26:49: 0163 Where Match(DATAAREAID,'live','LIVE')
11/08/2021 01:26:49: 0164 SQL SELECT *
11/08/2021 01:26:49: 0165 FROM AX2012.dbo.CUSTINVOICETRANS
11/08/2021 01:26:49: 0166 WHERE MODIFIEDDATETIME > '2021-08-09 00:00:00' AND MODIFIEDDATETIME <= '2021-08-10 18:29:59.998' AND INVOICEDATE < '2021-08-11'
11/08/2021 01:26:49: 0167
11/08/2021 01:26:49: 0168

11/08/2021 01:41:55: 92 fields found: SALESPRICE, ASSETBOOKID, ASSETID, COMMISSAMOUNTCUR, COMMISSAMOUNTMST, COMMISSCALC, COUNTRYREGIONOFSHIPMENT, CREATEDBY, CREATEDDATETIME, CURRENCYCODE, CUSTOMERLINENUM, DATAAREAID, DELIVERYTYPE, DISCAMOUNT, DISCPERCENT, DLVDATE, EINVOICEACCOUNTCODE, EXTERNALITEMID, INTERCOMPANYINVENTTRANSID, INTRASTATDISPATCHID, INVENTDIMID, INVENTQTY, INVENTREFID, INVENTREFTRANSID, INVENTREFTYPE, INVENTTRANSID, INVOICEDATE, INVOICEID, ITEMCODEID, ITEMID, ITL_CARDNUM, ITL_COMMISSION, ITL_EARNPOINT, ITL_LABNUM, ITL_LABPREFIX, ITL_LOCALINVENTLOCATIONID, ITL_MANDATORYDATE, ITL_PATIENTID, ITL_PRICETYPE, ITL_PROCESSINGLAB, ITL_REGISTRATIONLAB, ITL_REPORTINGDATE, ITL_TRANSACTIONTYPE, ITL_TRANSFERPRICE, LINEAMOUNT, LINEAMOUNTMST, LINEAMOUNTTAX, LINEAMOUNTTAXMST, LINEDISC, LINEHEADER, LINENUM, LINEPERCENT, MODIFIEDDATETIME, MULTILNDISC, MULTILNPERCENT, NAME, NUMBERSEQUENCEGROUP, OLAPCOSTVALUE, ORIGCOUNTRYREGIONID, ORIGSALESID, ORIGSTATE, PARTDELIVERY, PORT, PRICEUNIT, QTY, QTYPHYSICAL, REASONREFRECID, RECID, RECVERSION, REMAIN, RETURNARRIVALDATE, RETURNCLOSEDDATE, RETURNDISPOSITIONCODEID, SALESGROUP, SALESID, SALESMARKUP, SALESUNIT, STATLINEAMOUNTMST, STATPROCID, SUMLINEDISC, SUMLINEDISCMST, TAXAMOUNT, TAXAMOUNTMST, TAXAUTOGENERATED, TAXGROUP, TAXITEMGROUP, TAXWRITECODE, TRANSACTIONCODE, TRANSPORT, WEIGHT, LEDGERACCOUNT, ITL_SUPPLEMENTARYITEM, 384,837 lines fetched
11/08/2021 01:42:15: 0180 IF -1 THEN
11/08/2021 01:42:15: 0182 IF NoOfRows('Stage1 CustInvoiceTrans LPL_Live')>0 THEN
11/08/2021 01:42:15: 0183 CONCATENATE ([Stage1 CustInvoiceTrans LPL_Live]) LOAD * FROM D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDs\Sales\LPL_Live\Stage1 CustInvoiceTrans LPL_Live.qvd (qvd)
11/08/2021 01:42:15: 0184 WHERE NOT exists(RECID)
11/08/2021 01:42:15: 0185
11/08/2021 01:42:15: 92 fields found: SALESPRICE, ASSETBOOKID, ASSETID, COMMISSAMOUNTCUR, COMMISSAMOUNTMST, COMMISSCALC, COUNTRYREGIONOFSHIPMENT, CREATEDBY, CREATEDDATETIME, CURRENCYCODE, CUSTOMERLINENUM, DATAAREAID, DELIVERYTYPE, DISCAMOUNT, DISCPERCENT, DLVDATE, EINVOICEACCOUNTCODE, EXTERNALITEMID, INTERCOMPANYINVENTTRANSID, INTRASTATDISPATCHID, INVENTDIMID, INVENTQTY, INVENTREFID, INVENTREFTRANSID, INVENTREFTYPE, INVENTTRANSID, INVOICEDATE, INVOICEID, ITEMCODEID, ITEMID, ITL_CARDNUM, ITL_COMMISSION, ITL_EARNPOINT, ITL_LABNUM, ITL_LABPREFIX, ITL_LOCALINVENTLOCATIONID, ITL_MANDATORYDATE, ITL_PATIENTID, ITL_PRICETYPE, ITL_PROCESSINGLAB, ITL_REGISTRATIONLAB, ITL_REPORTINGDATE, ITL_TRANSACTIONTYPE, ITL_TRANSFERPRICE, LINEAMOUNT, LINEAMOUNTMST, LINEAMOUNTTAX, LINEAMOUNTTAXMST, LINEDISC, LINEHEADER, LINENUM, LINEPERCENT, MODIFIEDDATETIME, MULTILNDISC, MULTILNPERCENT, NAME, NUMBERSEQUENCEGROUP, OLAPCOSTVALUE, ORIGCOUNTRYREGIONID, ORIGSALESID, ORIGSTATE, PARTDELIVERY, PORT, PRICEUNIT, QTY, QTYPHYSICAL, REASONREFRECID, RECID, RECVERSION, REMAIN, RETURNARRIVALDATE, RETURNCLOSEDDATE, RETURNDISPOSITIONCODEID, SALESGROUP, SALESID, SALESMARKUP, SALESUNIT, STATLINEAMOUNTMST, STATPROCID, SUMLINEDISC, SUMLINEDISCMST, TAXAMOUNT, TAXAMOUNTMST, TAXAUTOGENERATED, TAXGROUP, TAXITEMGROUP, TAXWRITECODE, TRANSACTIONCODE, TRANSPORT, WEIGHT, LEDGERACCOUNT, ITL_SUPPLEMENTARYITEM, 189,079,339 lines fetched
11/08/2021 03:00:11: 0186 END IF
11/08/2021 03:00:11: 0187 END IF
11/08/2021 03:00:11: 0189 STORE [Stage1 CustInvoiceTrans LPL_Live] INTO D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDs\Sales\LPL_Live\Stage1 CustInvoiceTrans LPL_Live.qvd
11/08/2021 04:32:56: 0191 LET vEndTime=Now()
11/08/2021 04:32:56: 0192 LET vNoOfRows=NoOfRows('Stage1 CustInvoiceTrans LPL_Live')
11/08/2021 04:32:56: 0194 DROP TABLE [Stage1 CustInvoiceTrans LPL_Live]
11/08/2021 04:59:49: 0196 LET vFileSize = ROUND(FileSize('D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDs\Sales\LPL_Live\Stage1 CustInvoiceTrans LPL_Live.qvd')/1024) & ' KB'
11/08/2021 04:59:49: 0197 LET vFileTime = FileTime('D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDs\Sales\LPL_Live\Stage1 CustInvoiceTrans LPL_Live.qvd')
11/08/2021 04:59:49: 0198 LET vScriptErrorCount= ScriptErrorCount
11/08/2021 04:59:49: 0201 [FileTracker_Stage1 CustInvoiceTrans LPL_Live]:
11/08/2021 04:59:49: 0202 LOAD * Inline
11/08/2021 04:59:49: 0203 [
11/08/2021 04:59:49: 0204 RAW_TableName,StartTime,EndTime,NoofRows, FileSize, QVDName, FileTime,FilePath,ErrorCount,DBInstance
11/08/2021 04:59:49: 0205 'CustInvoiceTrans','11/08/2021 01:22:42','11/08/2021 04:32:56','189079339','32084170 KB', 'Stage1 CustInvoiceTrans LPL_Live','11/08/2021 04:32:56','D:\DrLalPathLabs_QlikView_AX2012\Stage1\QVDs\Sales\LPL_Live\','0','LPL_Live']
11/08/2021 04:59:49: 10 fields found: RAW_TableName, StartTime, EndTime, NoofRows, FileSize, QVDName, FileTime, FilePath, ErrorCount, DBInstance, 1 lines fetched
11/08/2021 04:59:49: 0208 Recursive:
11/08/2021 04:59:49: 0209 NOCONCATENATE
11/08/2021 04:59:49: 0210 LOAD
11/08/2021 04:59:49: 0211 RAW_TableName,
11/08/2021 04:59:49: 0212 StartTime,
11/08/2021 04:59:49: 0213 EndTime,
11/08/2021 04:59:49: 0214 TIMESTAMP(EndTime - StartTime,'hh:mm:ss') AS [Time Taken],
11/08/2021 04:59:49: 0215 NoofRows,
11/08/2021 04:59:49: 0216 FileSize,
11/08/2021 04:59:49: 0217 QVDName,
11/08/2021 04:59:49: 0218 FileTime,
11/08/2021 04:59:49: 0219 FilePath,
11/08/2021 04:59:49: 0220 ErrorCount,
11/08/2021 04:59:49: 0221 DBInstance
11/08/2021 04:59:49: 0222 RESIDENT [FileTracker_Stage1 CustInvoiceTrans LPL_Live]
11/08/2021 04:59:49: 11 fields found: RAW_TableName, StartTime, EndTime, Time Taken, NoofRows, FileSize, QVDName, FileTime, FilePath, ErrorCount, DBInstance, 1 lines fetched
11/08/2021 04:59:49: 0223 DROP TABLE [FileTracker_Stage1 CustInvoiceTrans LPL_Live]
11/08/2021 04:59:49: 0226 LET vFileTrackerExists = if(FileSize('D:\DrLalPathLabs_QlikView_AX2012\FileTracker\Stage1\FileTracker_Stage1 CustInvoiceTrans LPL_Live.qvd') > 0, -1, 0)
11/08/2021 04:59:49: 0228 IF vFileTrackerExists THEN
11/08/2021 04:59:49: 0230 CONCATENATE
11/08/2021 04:59:49: 0231 LOAD RAW_TableName,
11/08/2021 04:59:49: 0232 StartTime,
11/08/2021 04:59:49: 0233 EndTime,
11/08/2021 04:59:49: 0234 [Time Taken],
11/08/2021 04:59:49: 0235 NoofRows,
11/08/2021 04:59:49: 0236 FileSize,
11/08/2021 04:59:49: 0237 QVDName,
11/08/2021 04:59:49: 0238 FileTime,
11/08/2021 04:59:49: 0239 FilePath,
11/08/2021 04:59:49: 0240 ErrorCount,
11/08/2021 04:59:49: 0241 DBInstance
11/08/2021 04:59:49: 0242 FROM
11/08/2021 04:59:49: 0243 D:\DrLalPathLabs_QlikView_AX2012\FileTracker\Stage1\FileTracker_Stage1 CustInvoiceTrans LPL_Live.qvd(qvd)
11/08/2021 04:59:49: 11 fields found: RAW_TableName, StartTime, EndTime, Time Taken, NoofRows, FileSize, QVDName, FileTime, FilePath, ErrorCount, DBInstance, 1,585 lines fetched
11/08/2021 04:59:49: 0245 END IF
11/08/2021 04:59:49: 0247 STORE Recursive INTO D:\DrLalPathLabs_QlikView_AX2012\FileTracker\Stage1\FileTracker_Stage1 CustInvoiceTrans LPL_Live.qvd
11/08/2021 04:59:49: 0249 EXIT Script
11/08/2021 04:59:49: Execution finished.

please help

1 Solution

Accepted Solutions
Chip_Matejowsky
Support
Support

Hi @01Nikita,

Try comparing the task and document logs of the long running task versus the task and document logs of the normal running tasks to see where the slowdown(s) is occurring.

 

Best Regards

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

1 Reply
Chip_Matejowsky
Support
Support

Hi @01Nikita,

Try comparing the task and document logs of the long running task versus the task and document logs of the normal running tasks to see where the slowdown(s) is occurring.

 

Best Regards

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!