Log Issues

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi anyone,

Pls help me in finding out the real reason for failure.

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: Execution started.

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: QlikView Version:11.20.12913.0

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: CPU Target x64

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: Operating System Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: Wow64 mode Not using Wow64

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: MDAC Version 6.1.7601.17514

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: MDAC Full Install Version 6.1.7601.17514

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: PreferredCompression 2

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: EnableParallelReload 1

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: ParallelizeQvdLoads 1

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: AutoSaveAfterReload 0

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: BackupBeforeReload 0

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: EnableFlushLog 0

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: SaveInfoWhenSavingFile 0

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: UserLogfileCharset 1200

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: OdbcLoginTimeout -1

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: OdbcConnectionTimeout -1

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: ScriptWantsDbWrite false

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: ScriptWantsExe false

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: LogFile CodePage Used: 1200

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: Reload Executed By SE\SRV01684$

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: Process Executing: QVB

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: Process ID: 9724

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0029 SET ThousandSep=' '

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0030 SET DecimalSep=','

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0031 SET MoneyThousandSep=' '

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0032 SET MoneyDecimalSep=','

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0033 SET MoneyFormat='#.##0,00 kr;-#.##0,00 kr'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0034 SET TimeFormat='hh:mm:ss'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0035 SET DateFormat='YYYY-MM-DD'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0036 SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0037 SET MonthNames='jan;feb;mar;apr;maj;jun;jul;aug;sep;okt;nov;dec'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0038 SET DayNames='må;ti;on;to;fr;lö;sö'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0044 trace '### DF 1.Init.qvs Started'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0044 '### DF 1.Init.qvs Started'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0012 SET vL.LinkShared_Folders = 'Shared'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0017 set vL.LoadCustomVG='CustomVariables.csv'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0022 set vL.LoadCustomVU='CustomVariables.csv'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0026 set vL.Load4Custom='4.Custom.qvs'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0035 sub GetContainerStructure (vL.GetContainerStructure)

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0057 if not ''= 'True' then

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0059 SET vG.BasePath =

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0060 SET vG.TemplatePath =

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0068 SET vL.Path_tmp =

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0070 for vL.x_loop =1 to 30-1 | | | |

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0071 LET vL.InitLinkPath_tmp=''

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0072 if FileTime('InitLink.qvs') > 0 then | |

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0076 LET vL.InitLinkPath='..\'&''

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0077 exit for when not ''= ''

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0078 next

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0071 LET vL.InitLinkPath_tmp='..\'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0072 if FileTime('..\InitLink.qvs') > 0 then | |

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0074 LET vG.BasePath=left(DocumentPath(),index(DocumentPath(),'\', -(substringcount( '..\','\' )+1)))

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0075 endif |

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0076 LET vL.InitLinkPath='..\'&'..\'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0077 exit for when not 'D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\'= ''

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0079 SET vL.InitLinkPath =

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0080 SET vL.InitLinkPath_tmp =

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0081 SET vL.x_loop =

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0083 Call GetContainerStructure (vL.GetContainerStructure)

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0036 vL.ContainerStructure:

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0037 | REPLACE LOAD * INLINE [

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0038 | | PhysicalFolderName, VariablePrefix, Comments

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0039 | | '1.Application','Application','QlikView Applications are resided in subfolders under 1.Applications'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0040 | | '2.QVD','QVD','QlikView Data files are stored in subfolders under 2.QVD'

8/3/2017 10:42:23.8953253 Information 2017-08-03 10:42:23: 0041 | | '3.Include','Include','Folder where QlikView Include files are stored. These are script parts that are called from the main QlikView script. '

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0042 | | '4.Mart', 'Mart','Resides QlikView Qvw marts (in subfolders) for data discovery usage, these folders could be shared.'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0043 | | '5.Config','Config','Configuration and language files like Excel and txt. This folders could be shared to make configuration changes easier'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0044 | | '6.Script','Script','Store for special scripts run by the publisher or scheduled tasks'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0045 | | '7.Export','Export','Folder used to store from QlikView exported data, probably txt or qvx'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0046 | | '8.Import','Import','Folder used to store import data from external systems'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0047 | | '3.Include\1.BaseVariable','BaseVariable','Stores all the variables needed to use the framework, like paths inside the container'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0048 | | '3.Include\2.Locale','Locale','Locale for different regions, used for easy migration between regions'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0049 | | '3.Include\3.ConnString','ConnString','Stores connection strings to data sources'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0050 | | '3.Include\4.Sub','Sub','Store for sub routines, this is a way to reuse code between applications '

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0051 | | '3.Include\5.ColorScheme','ColorScheme','Company standard Color Scheme would be placed here'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0052 | | '3.Include\6.Custom','Custom','Store for custom include scripts'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0053 | | '0.Template','Template','Used to identify Admin container and create extra variables used by Variable Editor'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0054 | ]

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: | 3 fields found: PhysicalFolderName, VariablePrefix, Comments, 15 lines fetched

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0055 end sub

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0085 if 'D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\' = '' then

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0102 exit script when 'D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\' = ''

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0105 FOR vL.VariableLoop = 1 to NoOfRows('vL.ContainerStructure')

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',1)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',1)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\1.Application') > 0 then

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0110 SET vG.ApplicationPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\1.Application\'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',2)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',2)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\2.QVD') > 0 then

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0110 SET vG.QVDPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\2.QVD\'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',3)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',3)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include') > 0 then

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0110 SET vG.IncludePath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',4)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',4)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\4.Mart') > 0 then

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0110 SET vG.MartPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\4.Mart\'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',5)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',5)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\5.Config') > 0 then

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0110 SET vG.ConfigPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\5.Config\'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',6)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',6)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\6.Script') > 0 then

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0110 SET vG.ScriptPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\6.Script\'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',7)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',7)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\7.Export') > 0 then

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0110 SET vG.ExportPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\7.Export\'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',8)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',8)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\8.Import') > 0 then

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0110 SET vG.ImportPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\8.Import\'

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',9)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',9)

8/3/2017 10:42:23.9109253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\1.BaseVariable') > 0 then

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0110 SET vG.BaseVariablePath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\1.BaseVariable\'

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',10)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',10)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\2.Locale') > 0 then

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0110 SET vG.LocalePath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\2.Locale\'

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',11)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',11)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\3.ConnString') > 0 then

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0110 SET vG.ConnStringPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\3.ConnString\'

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',12)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',12)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\4.Sub') > 0 then

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0110 SET vG.SubPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\4.Sub\'

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',13)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',13)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\5.ColorScheme') > 0 then

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0110 SET vG.ColorSchemePath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\5.ColorScheme\'

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',14)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',14)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\6.Custom') > 0 then

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0110 SET vG.CustomPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\6.Custom\'

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0111 else

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0106 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',15)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0107 let vL.VariablePrefix = fieldvalue('VariablePrefix',15)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0109 if FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\0.Template') > 0 then

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0113 SET vG.TemplatePath=

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0114 endif

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0115 Next vL.VariableLoop

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0118 drop table vL.ContainerStructure

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0123 SUB LoadContainerMap(vL.CVSTableName,vL.SpecificVariable,vL.GetRootPath)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0124 call LoadContainerMap('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\1.BaseVariable\\ContainerMap.csv','','D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\')

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0011 SET vL.LoadContainerMapCount=

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0015 vL.temp_table_map:

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0016 REPLACE LOAD *

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0017 FROM

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0018 'D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\1.BaseVariable\\ContainerMap.csv'

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0019 (txt, utf8, embedded labels, delimiter is ',', msq)

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: | 4 fields found: ContainerPathName, ContainerFolderName, ContainerComments, RootPath, 7 lines fetched

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0022 REPLACE Left join

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0023 Load ContainerPathName,count(ContainerPathName) as ContainerPathNameCount

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0024 Resident vL.temp_table_map

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0025 group by ContainerPathName

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: | 2 fields found: ContainerPathName, ContainerPathNameCount, 7 lines fetched

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: Joining/Keeping

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0028 let vL.xxx = NoOfRows('vL.temp_table_map')

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0030 for vL.ttt = 0 to vL.xxx-1

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0032 LET vL.Comment =''

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0034 LET vL.ContainerPathName = PurgeChar(trim(peek(FieldName(1,'vL.temp_table_map'),0,'vL.temp_table_map')),'=;,- '&chr(39))

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0035 LET vL.ContainerFolderName = lower(PurgeChar(trim(peek(FieldName(2,'vL.temp_table_map'),0,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0036 LET vL.Comment = PurgeChar(trim(peek(FieldName(3,'vL.temp_table_map'),0,'vL.temp_table_map')),';,'&chr(39))

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0037 LET vL.RootPath = lower(PurgeChar(trim(peek(FieldName(4,'vL.temp_table_map'),0,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0038 LET vL.ContainerPathNameCount = peek(FieldName(5,'vL.temp_table_map'),0,'vL.temp_table_map')

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0041 if not 'Admin' = '' and not '0.administration' = '' then

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0044 if not right( '0.administration' , 1 ) ='\' then

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0045 let vL.ContainerName ='0.administration'&'\'

8/3/2017 10:42:23.9265253 Information 2017-08-03 10:42:23: 0046 else

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0051 if '0.administration\' =right(lower('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\'),len('0.administration\')) and '' = '' then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0074 if (''='Admin' or ''='0.administration') then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0096 exit for when ''='True'

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0097 endif

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0098 next

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0032 LET vL.Comment =''

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0034 LET vL.ContainerPathName = PurgeChar(trim(peek(FieldName(1,'vL.temp_table_map'),1,'vL.temp_table_map')),'=;,- '&chr(39))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0035 LET vL.ContainerFolderName = lower(PurgeChar(trim(peek(FieldName(2,'vL.temp_table_map'),1,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0036 LET vL.Comment = PurgeChar(trim(peek(FieldName(3,'vL.temp_table_map'),1,'vL.temp_table_map')),';,'&chr(39))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0037 LET vL.RootPath = lower(PurgeChar(trim(peek(FieldName(4,'vL.temp_table_map'),1,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0038 LET vL.ContainerPathNameCount = peek(FieldName(5,'vL.temp_table_map'),1,'vL.temp_table_map')

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0041 if not 'Shared' = '' and not '3000.shared_folders' = '' then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0044 if not right( '3000.shared_folders' , 1 ) ='\' then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0045 let vL.ContainerName ='3000.shared_folders'&'\'

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0046 else

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0051 if '3000.shared_folders\' =right(lower('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\'),len('3000.shared_folders\')) and '' = '' then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0074 if (''='Shared' or ''='3000.shared_folders') then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0096 exit for when ''='True'

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0097 endif

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0098 next

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0032 LET vL.Comment =''

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0034 LET vL.ContainerPathName = PurgeChar(trim(peek(FieldName(1,'vL.temp_table_map'),2,'vL.temp_table_map')),'=;,- '&chr(39))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0035 LET vL.ContainerFolderName = lower(PurgeChar(trim(peek(FieldName(2,'vL.temp_table_map'),2,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0036 LET vL.Comment = PurgeChar(trim(peek(FieldName(3,'vL.temp_table_map'),2,'vL.temp_table_map')),';,'&chr(39))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0037 LET vL.RootPath = lower(PurgeChar(trim(peek(FieldName(4,'vL.temp_table_map'),2,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0038 LET vL.ContainerPathNameCount = peek(FieldName(5,'vL.temp_table_map'),2,'vL.temp_table_map')

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0041 if not 'UniperGroupControlling' = '' and not '1000.data_source\01.uniper group controlling' = '' then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0044 if not right( '1000.data_source\01.uniper group controlling' , 1 ) ='\' then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0045 let vL.ContainerName ='1000.data_source\01.uniper group controlling'&'\'

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0046 else

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0051 if '1000.data_source\01.uniper group controlling\' =right(lower('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\'),len('1000.data_source\01.uniper group controlling\')) and '' = '' then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0074 if (''='UniperGroupControlling' or ''='1000.data_source\01.uniper group controlling') then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0096 exit for when ''='True'

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0097 endif

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0098 next

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0032 LET vL.Comment =''

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0034 LET vL.ContainerPathName = PurgeChar(trim(peek(FieldName(1,'vL.temp_table_map'),3,'vL.temp_table_map')),'=;,- '&chr(39))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0035 LET vL.ContainerFolderName = lower(PurgeChar(trim(peek(FieldName(2,'vL.temp_table_map'),3,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0036 LET vL.Comment = PurgeChar(trim(peek(FieldName(3,'vL.temp_table_map'),3,'vL.temp_table_map')),';,'&chr(39))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0037 LET vL.RootPath = lower(PurgeChar(trim(peek(FieldName(4,'vL.temp_table_map'),3,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0038 LET vL.ContainerPathNameCount = peek(FieldName(5,'vL.temp_table_map'),3,'vL.temp_table_map')

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0041 if not 'Economy' = '' and not '0001.economy' = '' then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0044 if not right( '0001.economy' , 1 ) ='\' then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0045 let vL.ContainerName ='0001.economy'&'\'

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0046 else

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0051 if '0001.economy\' =right(lower('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\'),len('0001.economy\')) and '' = '' then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0074 if (''='Economy' or ''='0001.economy') then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0096 exit for when ''='True'

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0097 endif

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0098 next

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0032 LET vL.Comment =''

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0034 LET vL.ContainerPathName = PurgeChar(trim(peek(FieldName(1,'vL.temp_table_map'),4,'vL.temp_table_map')),'=;,- '&chr(39))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0035 LET vL.ContainerFolderName = lower(PurgeChar(trim(peek(FieldName(2,'vL.temp_table_map'),4,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0036 LET vL.Comment = PurgeChar(trim(peek(FieldName(3,'vL.temp_table_map'),4,'vL.temp_table_map')),';,'&chr(39))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0037 LET vL.RootPath = lower(PurgeChar(trim(peek(FieldName(4,'vL.temp_table_map'),4,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0038 LET vL.ContainerPathNameCount = peek(FieldName(5,'vL.temp_table_map'),4,'vL.temp_table_map')

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0041 if not 'Transform' = '' and not '2000.transform' = '' then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0044 if not right( '2000.transform' , 1 ) ='\' then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0045 let vL.ContainerName ='2000.transform'&'\'

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0046 else

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0051 if '2000.transform\' =right(lower('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\'),len('2000.transform\')) and '' = '' then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0074 if (''='Transform' or ''='2000.transform') then

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0096 exit for when ''='True'

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0097 endif

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0098 next

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0032 LET vL.Comment =''

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0034 LET vL.ContainerPathName = PurgeChar(trim(peek(FieldName(1,'vL.temp_table_map'),5,'vL.temp_table_map')),'=;,- '&chr(39))

8/3/2017 10:42:23.9421253 Information 2017-08-03 10:42:23: 0035 LET vL.ContainerFolderName = lower(PurgeChar(trim(peek(FieldName(2,'vL.temp_table_map'),5,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0036 LET vL.Comment = PurgeChar(trim(peek(FieldName(3,'vL.temp_table_map'),5,'vL.temp_table_map')),';,'&chr(39))

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0037 LET vL.RootPath = lower(PurgeChar(trim(peek(FieldName(4,'vL.temp_table_map'),5,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0038 LET vL.ContainerPathNameCount = peek(FieldName(5,'vL.temp_table_map'),5,'vL.temp_table_map')

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0041 if not 'SAP_BW' = '' and not '1000.data_source\02.sap_bw' = '' then

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0044 if not right( '1000.data_source\02.sap_bw' , 1 ) ='\' then

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0045 let vL.ContainerName ='1000.data_source\02.sap_bw'&'\'

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0046 else

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0051 if '1000.data_source\02.sap_bw\' =right(lower('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\'),len('1000.data_source\02.sap_bw\')) and '' = '' then

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0053 LET vL.RootPath= left('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\',len('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\')-(len('1000.data_source\02.sap_bw\')))

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0059 sub vL.FileExist (vL._Root)

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0060 call vL.FileExist (left('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.data_source\02.sap_bw\',len('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.data_source\02.sap_bw\')-1))

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0012 do while right( 'D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.data_source\02.sap_bw' , 1 ) ='\'

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0017 if FindOneOf('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.data_source\02.sap_bw','*') >0 then

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0021 if IsNull(filesize('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.data_source\02.sap_bw')) = -1 then

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0024 SET vL.FileExist='true'

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0025 endif

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0026 set vL._Root=

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0027 end sub

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0061 if vL.FileExist = 'true' then

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0063 LET vG.RootPath= 'D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\'

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0064 Trace '### DF Creating new vG.RootPath based on Container Map'

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0064 '### DF Creating new vG.RootPath based on Container Map'

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0065 endif

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0067 SET vL.Exit='True'

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0068 SET vL.ContainerIdentification=

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0071 endif

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0074 if (''='SAP_BW' or ''='1000.data_source\02.sap_bw') then

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0096 exit for when 'True'='True'

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0100 drop table 'vL.temp_table_map'

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0103 SET vL.ttt =

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0104 SET vL.xxx =

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0105 SET vL.CVSTableName =

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0106 SET vL.SpecificVariable =

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0107 SET vL.GetRootPath =

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0108 SET vL.Exit=

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0109 SET vL.ContainerName=

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0110 SET vL.ContainerPathNameCount=

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0111 end sub

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0129 SUB LoadContainerGlobalVariables(vL.ContanerName,vL.SingleFolder,vL.ContainerMapPath)

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0130 SUB LCGV(vL.ContanerName_tmp,vL.SingleFolder_tmp,vL.ContainerMapPath_tmp)

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0133 if not trim('Shared') = '' then

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0134 CALL LoadContainerGlobalVariables('Shared')

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0014 if '' = '' then

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0015 let vL.ContainerMapPath = 'D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\1.BaseVariable\\ContainerMap.csv'

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0016 else

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0022 trace '### DF 2.GenericContainerLoader.qvs Started'

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0022 '### DF 2.GenericContainerLoader.qvs Started'

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0032 SUB LoadContainerMap(vL.CVSTableName,vL.SpecificVariable,vL.GetRootPath)

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0034 call LoadContainerMap('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\1.BaseVariable\\ContainerMap.csv','Shared')

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0011 SET vL.LoadContainerMapCount=

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0015 vL.temp_table_map:

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0016 REPLACE LOAD *

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0017 FROM

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0018 'D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\1.BaseVariable\\ContainerMap.csv'

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0019 (txt, utf8, embedded labels, delimiter is ',', msq)

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: | 4 fields found: ContainerPathName, ContainerFolderName, ContainerComments, RootPath, 7 lines fetched

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0022 REPLACE Left join

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0023 Load ContainerPathName,count(ContainerPathName) as ContainerPathNameCount

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0024 Resident vL.temp_table_map

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0025 group by ContainerPathName

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: | 2 fields found: ContainerPathName, ContainerPathNameCount, 7 lines fetched

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: Joining/Keeping

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0028 let vL.xxx = NoOfRows('vL.temp_table_map')

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0030 for vL.ttt = 0 to vL.xxx-1

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0032 LET vL.Comment =''

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0034 LET vL.ContainerPathName = PurgeChar(trim(peek(FieldName(1,'vL.temp_table_map'),0,'vL.temp_table_map')),'=;,- '&chr(39))

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0035 LET vL.ContainerFolderName = lower(PurgeChar(trim(peek(FieldName(2,'vL.temp_table_map'),0,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9577253 Information 2017-08-03 10:42:23: 0036 LET vL.Comment = PurgeChar(trim(peek(FieldName(3,'vL.temp_table_map'),0,'vL.temp_table_map')),';,'&chr(39))

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0037 LET vL.RootPath = lower(PurgeChar(trim(peek(FieldName(4,'vL.temp_table_map'),0,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0038 LET vL.ContainerPathNameCount = peek(FieldName(5,'vL.temp_table_map'),0,'vL.temp_table_map')

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0041 if not 'Admin' = '' and not '0.administration' = '' then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0044 if not right( '0.administration' , 1 ) ='\' then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0045 let vL.ContainerName ='0.administration'&'\'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0046 else

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0051 if '0.administration\' =right(lower(''),len('0.administration\')) and '' = '' then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0074 if ('Shared'='Admin' or 'Shared'='0.administration') then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0096 exit for when ''='True'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0097 endif

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0098 next

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0032 LET vL.Comment =''

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0034 LET vL.ContainerPathName = PurgeChar(trim(peek(FieldName(1,'vL.temp_table_map'),1,'vL.temp_table_map')),'=;,- '&chr(39))

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0035 LET vL.ContainerFolderName = lower(PurgeChar(trim(peek(FieldName(2,'vL.temp_table_map'),1,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0036 LET vL.Comment = PurgeChar(trim(peek(FieldName(3,'vL.temp_table_map'),1,'vL.temp_table_map')),';,'&chr(39))

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0037 LET vL.RootPath = lower(PurgeChar(trim(peek(FieldName(4,'vL.temp_table_map'),1,'vL.temp_table_map')),'=;,'&chr(39)))

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0038 LET vL.ContainerPathNameCount = peek(FieldName(5,'vL.temp_table_map'),1,'vL.temp_table_map')

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0041 if not 'Shared' = '' and not '3000.shared_folders' = '' then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0044 if not right( '3000.shared_folders' , 1 ) ='\' then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0045 let vL.ContainerName ='3000.shared_folders'&'\'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0046 else

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0051 if '3000.shared_folders\' =right(lower(''),len('3000.shared_folders\')) and '' = '' then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0074 if ('Shared'='Shared' or 'Shared'='3000.shared_folders') then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0076 if left(trim(''),2) ='\\' or index('', ':')>0 then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0082 let vL.RootPath ='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0083 endif

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0084 if vL.ContainerPathNameCount = 1 then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0085 SET vL.Exit= 'True'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0087 else

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0094 exit for when 'True'='True'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0100 drop table 'vL.temp_table_map'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0103 SET vL.ttt =

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0104 SET vL.xxx =

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0105 SET vL.CVSTableName =

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0106 SET vL.SpecificVariable =

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0107 SET vL.GetRootPath =

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0108 SET vL.Exit=

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0109 SET vL.ContainerName=

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0110 SET vL.ContainerPathNameCount=

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0111 end sub

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0037 SET vL.ContainerFolderName='3000.shared_folders'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0040 SET vL.ContainerPathName='Shared'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0043 SET vL.RootPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0045 if not 'Shared' = '' then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0049 trace '### DF 3000.shared_folders'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0049 '### DF 3000.shared_folders'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0050 trace '### DF Container for Shared resources'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0050 '### DF Container for Shared resources'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0053 SET vG.SharedBasePath = 'D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0057 sub vL.FileExist (vL._Root)

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0058 call vL.FileExist ('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\')

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0012 do while right( 'D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\' , 1 ) ='\'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0013 let vL._Root =left('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\', Len('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\')-1)

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0014 exit do unless right( 'D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders' , 1 ) ='\'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0017 if FindOneOf('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders','*') >0 then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0021 if IsNull(filesize('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders')) = -1 then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0024 SET vL.FileExist='true'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0025 endif

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0026 set vL._Root=

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0027 end sub

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0060 if vL.FileExist = 'false' then

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0067 Call GetContainerStructure (vL.GetContainerStructure)

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0036 vL.ContainerStructure:

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0037 | REPLACE LOAD * INLINE [

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0038 | | PhysicalFolderName, VariablePrefix, Comments

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0039 | | '1.Application','Application','QlikView Applications are resided in subfolders under 1.Applications'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0040 | | '2.QVD','QVD','QlikView Data files are stored in subfolders under 2.QVD'

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0041 | | '3.Include','Include','Folder where QlikView Include files are stored. These are script parts that are called from the main QlikView script. '

8/3/2017 10:42:23.9733253 Information 2017-08-03 10:42:23: 0042 | | '4.Mart', 'Mart','Resides QlikView Qvw marts (in subfolders) for data discovery usage, these folders could be shared.'

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0043 | | '5.Config','Config','Configuration and language files like Excel and txt. This folders could be shared to make configuration changes easier'

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0044 | | '6.Script','Script','Store for special scripts run by the publisher or scheduled tasks'

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0045 | | '7.Export','Export','Folder used to store from QlikView exported data, probably txt or qvx'

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0046 | | '8.Import','Import','Folder used to store import data from external systems'

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0047 | | '3.Include\1.BaseVariable','BaseVariable','Stores all the variables needed to use the framework, like paths inside the container'

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0048 | | '3.Include\2.Locale','Locale','Locale for different regions, used for easy migration between regions'

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0049 | | '3.Include\3.ConnString','ConnString','Stores connection strings to data sources'

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0050 | | '3.Include\4.Sub','Sub','Store for sub routines, this is a way to reuse code between applications '

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0051 | | '3.Include\5.ColorScheme','ColorScheme','Company standard Color Scheme would be placed here'

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0052 | | '3.Include\6.Custom','Custom','Store for custom include scripts'

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0053 | | '0.Template','Template','Used to identify Admin container and create extra variables used by Variable Editor'

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0054 | ]

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: | 3 fields found: PhysicalFolderName, VariablePrefix, Comments, 15 lines fetched

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0055 end sub

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0068 FOR vL.VariableLoop = 1 to NoOfRows('vL.ContainerStructure')

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',1)

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',1)

8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0074 if ''='' and FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\1.Application') > 0 then