Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
- Qlik Community
- :
- All Forums
- :
- QlikView App Dev
- :
- Log Issues
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Log Issues
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
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',2)
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',2)
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\2.QVD') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',3)
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',3)
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\3.Include') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0075 SET vG.SharedIncludePath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\'
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0078 elseif FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',4)
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',4)
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\4.Mart') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',5)
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',5)
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\5.Config') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',6)
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',6)
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\6.Script') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',7)
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',7)
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\7.Export') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',8)
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',8)
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\8.Import') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0075 SET vG.SharedImportPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\8.Import\'
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0078 elseif FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\8.Import') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',9)
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',9)
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\3.Include\1.BaseVariable') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0075 SET vG.SharedBaseVariablePath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\1.BaseVariable\'
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0078 elseif FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\1.BaseVariable') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',10)
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',10)
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\3.Include\2.Locale') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0075 SET vG.SharedLocalePath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\2.Locale\'
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0078 elseif FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\2.Locale') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',11)
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',11)
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\3.Include\3.ConnString') > 0 then
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0075 SET vG.SharedConnStringPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\3.ConnString\'
8/3/2017 10:42:23.9889253 Information 2017-08-03 10:42:23: 0078 elseif FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\3.ConnString') > 0 then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',12)
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',12)
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0074 if ''='' and FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\4.Sub') > 0 then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0075 SET vG.SharedSubPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\4.Sub\'
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0078 elseif FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\4.Sub') > 0 then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',13)
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',13)
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0074 if ''='' and FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\5.ColorScheme') > 0 then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0075 SET vG.SharedColorSchemePath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\5.ColorScheme\'
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0078 elseif FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\5.ColorScheme') > 0 then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',14)
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',14)
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0074 if ''='' and FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\6.Custom') > 0 then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0075 SET vG.SharedCustomPath='D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\6.Custom\'
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0078 elseif FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\6.Custom') > 0 then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0070 let vL.PhysicalFolderName = fieldvalue('PhysicalFolderName',15)
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0071 let vL.VariablePrefix = fieldvalue('VariablePrefix',15)
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0074 if ''='' and FileTime('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\0.Template') > 0 then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0087 Next vL.VariableLoop
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0090 drop table vL.ContainerStructure
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0093 if not ''='' then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0098 trace '### DF 3000.shared_folders Finished'
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0098 '### DF 3000.shared_folders Finished'
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0100 else
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0103 else
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0111 SET vL.ContainerFolderName=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0112 SET vL.PhysicalFolderName=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0113 SET vL.VariablePrefix=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0114 SET vL.VariableLoop=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0115 SET vL.Path=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0116 set vL.VariableLoop=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0117 set vL.GetContainerStructure=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0118 SET vL.ContainerMapPath =
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0119 SET vL.ContainerPathName=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0120 SET vL.RootPath=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0121 SET vL.FileExist=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0122 SET vL.ContanerName=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0123 SET vL.Comment =
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0124 SET vL.ContainerIdentification=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0125 SET vL.SingleFolder=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0126 SET vL.SubStringSplitt=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0127 SET vL.SubString=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0128 end sub
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0135 endif
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0138 if not trim('CustomVariables.csv') = '' then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0139 SUB LoadVariableCSV(vL.CVSTableName,vL.SpecificVariable,vL.ContainerMapMode,vL.CommentsAsVariables2)
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0141 call LoadVariableCSV('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\1.BaseVariable\\CustomVariables.csv')
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0017 sub vL.FileExist (vL._Root)
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0018 call vL.FileExist ('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\1.BaseVariable\\CustomVariables.csv')
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0012 do while right( 'D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\1.BaseVariable\\CustomVariables.csv' , 1 ) ='\'
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0017 if FindOneOf('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\1.BaseVariable\\CustomVariables.csv','*') >0 then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0021 if IsNull(filesize('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\3000.shared_folders\3.Include\1.BaseVariable\\CustomVariables.csv')) = -1 then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0024 SET vL.FileExist='true'
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0025 endif
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0026 set vL._Root=
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0027 end sub
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0020 if vL.FileExist = 'false' then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0025 if vL.FileExist = 'false' then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0030 if not vL.FileExist = 'false' then
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0032 trace '### DF Starting LoadVariableCSV'
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0032 '### DF Starting LoadVariableCSV'
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0034 [vL.temp_table]:
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0035
8/3/2017 10:42:24.0045253 Information 2017-08-03 10:42:23: 0036 REPLACE LOAD *
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0037 FROM
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0038
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0039 (txt, utf8, embedded labels, delimiter is ',', msq)
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: | 4 fields found: VariableName, VariableValue, Comments, Priority, 18 lines fetched
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0042 let vL.xxxx = NoOfRows('vL.temp_table')
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0044 for vL.tttt = 0 to vL.xxxx-1
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),0,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),0,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),0,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0059 if not ''='' then
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0119 next
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:23: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),1,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),1,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),1,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),2,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),2,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),2,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),3,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),3,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),3,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),4,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),4,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),4,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),5,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),5,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),5,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),6,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.0201253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),6,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),6,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),7,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),7,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),7,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),8,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),8,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),8,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.0357253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),9,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),9,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),9,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),10,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),10,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),10,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),11,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),11,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),11,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),12,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),12,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),12,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),13,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),13,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),13,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),14,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),14,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),14,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),15,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),15,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1449253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),15,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),16,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),16,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),16,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),17,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),17,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),17,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0120 drop table 'vL.temp_table'
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0124 LET vL.tttt =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0125 LET vL.xxxx =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0126 LET vL.Tag =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0127 LET vL.VariableField=
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0128 LET vL.Variable =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0129 LET vL.Valuefield =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0130 LET vL.Commentfield =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0131 LET vL.AltRootFolderPath =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0132 LET vL.CVSTableName =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0133 LET vL.SpecificVariable =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0134 LET vL.ContainerMapMode =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0135 SET vL.CommentsAsVariables2 =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0139 trace '### DF Ending LoadVariableCSV'
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0139 '### DF Ending LoadVariableCSV'
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0140 else
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0143 SET vL.FileExist =
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0144 end sub
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0142 endif
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0145 if not trim('CustomVariables.csv') = '' then
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0146 SUB LoadVariableCSV(vL.CVSTableName,vL.SpecificVariable,vL.ContainerMapMode,vL.CommentsAsVariables2)
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0148 call LoadVariableCSV('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\1.BaseVariable\\CustomVariables.csv')
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0017 sub vL.FileExist (vL._Root)
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0018 call vL.FileExist ('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\1.BaseVariable\\CustomVariables.csv')
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0012 do while right( 'D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\1.BaseVariable\\CustomVariables.csv' , 1 ) ='\'
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0017 if FindOneOf('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\1.BaseVariable\\CustomVariables.csv','*') >0 then
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0021 if IsNull(filesize('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\3.Include\1.BaseVariable\\CustomVariables.csv')) = -1 then
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0024 SET vL.FileExist='true'
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0025 endif
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0026 set vL._Root=
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0027 end sub
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0020 if vL.FileExist = 'false' then
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0025 if vL.FileExist = 'false' then
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0030 if not vL.FileExist = 'false' then
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0032 trace '### DF Starting LoadVariableCSV'
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0032 '### DF Starting LoadVariableCSV'
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0034 [vL.temp_table]:
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0035
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0036 REPLACE LOAD *
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0037 FROM
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0038
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0039 (txt, utf8, embedded labels, delimiter is ',', msq)
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: | 4 fields found: VariableName, VariableValue, Comments, Priority, 18 lines fetched
8/3/2017 10:42:24.1605253 Information 2017-08-03 10:42:24: 0042 let vL.xxxx = NoOfRows('vL.temp_table')
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0044 for vL.tttt = 0 to vL.xxxx-1
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),0,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),0,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),0,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),1,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),1,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),1,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),2,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),2,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),2,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),3,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),3,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),3,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),4,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),4,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),4,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),5,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),5,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),5,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),6,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),6,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),6,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1761253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),7,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),7,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),7,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),8,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),8,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),8,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),9,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),9,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),9,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),10,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),10,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),10,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),11,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),11,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),11,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),12,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),12,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),12,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),13,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.1917253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),13,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),13,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),14,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),14,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),14,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),15,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),15,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),15,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),16,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),16,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),16,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0046 LET vL.VariableField = PurgeChar(trim(peek(FieldName(1,'vL.temp_table'),17,'vL.temp_table')),'=;,-"'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0047 LET vL.TableUpper = upper(trim(left('',4)))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0048 LET vL.Variable = PurgeChar(subfield(trim(''), ' ' ,2),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0049 LET vL.Commentfield = PurgeChar(peek(FieldName(3,'vL.temp_table'),17,'vL.temp_table'),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0050 LET vL.Tag = PurgeChar(trim(peek(FieldName(4,'vL.temp_table'),17,'vL.temp_table')),';,'&chr(39))
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0053 if not '' = '' and not trim('')='' then |
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0059 if not ''='' then
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0116 LET vL.TableUpper =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0117 LET vL.Commentfield =''
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0119 next
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0120 drop table 'vL.temp_table'
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0124 LET vL.tttt =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0125 LET vL.xxxx =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0126 LET vL.Tag =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0127 LET vL.VariableField=
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0128 LET vL.Variable =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0129 LET vL.Valuefield =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0130 LET vL.Commentfield =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0131 LET vL.AltRootFolderPath =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0132 LET vL.CVSTableName =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0133 LET vL.SpecificVariable =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0134 LET vL.ContainerMapMode =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0135 SET vL.CommentsAsVariables2 =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0139 trace '### DF Ending LoadVariableCSV'
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0139 '### DF Ending LoadVariableCSV'
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0140 else
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0143 SET vL.FileExist =
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0144 end sub
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0149 endif
8/3/2017 10:42:24.2073253 Information 2017-08-03 10:42:24: 0151 else
8/3/2017 10:42:24.2229253 Information 2017-08-03 10:42:24: 0156 trace '### DF 4.Custom.qvs Started'
8/3/2017 10:42:24.2229253 Information 2017-08-03 10:42:24: 0156 '### DF 4.Custom.qvs Started'
8/3/2017 10:42:24.2229253 Information 2017-08-03 10:42:24: 0017 sub vL.FileExist (vL._Root)
8/3/2017 10:42:24.2229253 Information 2017-08-03 10:42:24: 0007 SUB LoadVariableCSV(vL.CVSTableName,vL.SpecificVariable,vL.ContainerMapMode,vL.CommentsAsVariables2)
8/3/2017 10:42:24.2229253 Information 2017-08-03 10:42:24: 0008 SUB LoadContainerMap(vL.CVSTableName,vL.SpecificVariable,vL.GetRootPath)
8/3/2017 10:42:24.3321253 Information 2017-08-03 10:42:24: 0009 SUB LoadContainerGlobalVariables(vL.ContanerName,vL.SingleFolder,vL.ContainerMapPath)
8/3/2017 10:42:24.3321253 Information 2017-08-03 10:42:24: 0130 SUB LCGV(vL.ContanerName_tmp,vL.SingleFolder_tmp,vL.ContainerMapPath_tmp)
8/3/2017 10:42:24.3321253 Information 2017-08-03 10:42:24: 0010 sub DoDir (vL.DoDirRoot,vL.DoDirTableName,vL._FoldersOnly,vL._SingleFolder,vL._QualifyFelds,vL.QDF_Template_Exeptions)
8/3/2017 10:42:24.3321253 Information 2017-08-03 10:42:24: 0011 SUB CreateFolder (vL.FolderName_1)
8/3/2017 10:42:24.3321253 Information 2017-08-03 10:42:24: 0012 SUB CalendarGen(vL.DateFieldLinkName,vL.CalendarTableName,vL.MonthsLeftFiscalDates,vL.CalendarGenMinDate,vL.CalendarGenMaxDate,vL.FindFieldTableName)
8/3/2017 10:42:24.3321253 Information 2017-08-03 10:42:24: 0013 SUB QVFileInfo(vL.QVFile_tmp,vL.QVTableName_tmp)
8/3/2017 10:42:24.3321253 Information 2017-08-03 10:42:24: 0014 sub QVDMigration (vL.MigrationSource,vL.MigrationDestination,vL.Store_Select_tmp,vL.Scramble_fields,vL.Tmp_QVTableName_Suffix,vL._IncludeSubFolders,vL._FormatSpec)
8/3/2017 10:42:24.3321253 Information 2017-08-03 10:42:24: 0015 sub QVDLoad(vL.MigrationSource,vL.Store_Select_tmp,vL.Scramble_fields,vL.Tmp_QVTableName_Suffix,vL._IncludeSubFolders)
8/3/2017 10:42:24.3321253 Information 2017-08-03 10:42:24: 0016 SUB DynamicContainerGlobalVariables(vL.ContanerName,vL.SingleFolder,vL.OverridePrefix,vL.ContainerMapPath)
8/3/2017 10:42:24.3321253 Information 2017-08-03 10:42:24: 0131 SUB DCGV(vL.ContanerName_tmp,vL.SingleFolder_tmp,vL.ContainerMapPath_tmp)
8/3/2017 10:42:24.3321253 Information 2017-08-03 10:42:24: 0031 trace '### DF 4.Custom.qvs Finished'
8/3/2017 10:42:24.3321253 Information 2017-08-03 10:42:24: 0031 '### DF 4.Custom.qvs Finished'
8/3/2017 10:42:24.3321253 Information 2017-08-03 10:42:24: 0157 trace '### DF 4.Custom.qvs Started'
8/3/2017 10:42:24.4413253 Information 2017-08-03 10:42:24: 0157 '### DF 4.Custom.qvs Started'
8/3/2017 10:42:24.4413253 Information 2017-08-03 10:42:24: 0017 sub vL.FileExist (vL._Root)
8/3/2017 10:42:24.4413253 Information 2017-08-03 10:42:24: 0007 SUB LoadVariableCSV(vL.CVSTableName,vL.SpecificVariable,vL.ContainerMapMode,vL.CommentsAsVariables2)
8/3/2017 10:42:24.4413253 Information 2017-08-03 10:42:24: 0008 SUB LoadContainerMap(vL.CVSTableName,vL.SpecificVariable,vL.GetRootPath)
8/3/2017 10:42:24.4413253 Information 2017-08-03 10:42:24: 0009 SUB LoadContainerGlobalVariables(vL.ContanerName,vL.SingleFolder,vL.ContainerMapPath)
8/3/2017 10:42:24.4413253 Information 2017-08-03 10:42:24: 0130 SUB LCGV(vL.ContanerName_tmp,vL.SingleFolder_tmp,vL.ContainerMapPath_tmp)
8/3/2017 10:42:24.4413253 Information 2017-08-03 10:42:24: 0010 sub DoDir (vL.DoDirRoot,vL.DoDirTableName,vL._FoldersOnly,vL._SingleFolder,vL._QualifyFelds,vL.QDF_Template_Exeptions)
8/3/2017 10:42:24.4413253 Information 2017-08-03 10:42:24: 0011 SUB CreateFolder (vL.FolderName_1)
8/3/2017 10:42:24.4413253 Information 2017-08-03 10:42:24: 0012 SUB CalendarGen(vL.DateFieldLinkName,vL.CalendarTableName,vL.MonthsLeftFiscalDates,vL.CalendarGenMinDate,vL.CalendarGenMaxDate,vL.FindFieldTableName)
8/3/2017 10:42:24.4413253 Information 2017-08-03 10:42:24: 0013 SUB QVFileInfo(vL.QVFile_tmp,vL.QVTableName_tmp)
8/3/2017 10:42:24.4413253 Information 2017-08-03 10:42:24: 0014 sub QVDMigration (vL.MigrationSource,vL.MigrationDestination,vL.Store_Select_tmp,vL.Scramble_fields,vL.Tmp_QVTableName_Suffix,vL._IncludeSubFolders,vL._FormatSpec)
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0015 sub QVDLoad(vL.MigrationSource,vL.Store_Select_tmp,vL.Scramble_fields,vL.Tmp_QVTableName_Suffix,vL._IncludeSubFolders)
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0016 SUB DynamicContainerGlobalVariables(vL.ContanerName,vL.SingleFolder,vL.OverridePrefix,vL.ContainerMapPath)
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0131 SUB DCGV(vL.ContanerName_tmp,vL.SingleFolder_tmp,vL.ContainerMapPath_tmp)
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0031 trace '### DF 4.Custom.qvs Finished'
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0031 '### DF 4.Custom.qvs Finished'
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0162 SUB LoadContainerGlobalVariables(vL.ContanerName,vL.SingleFolder,vL.ContainerMapPath)
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0130 SUB LCGV(vL.ContanerName_tmp,vL.SingleFolder_tmp,vL.ContainerMapPath_tmp)
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0167 SET vL.PhysicalFolderName=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0168 SET vL.VariablePrefix=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0169 SET vL.VariableLoop=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0170 SET vL.FileExist=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0171 SET vL.InitLinkPath=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0172 SET vL.LinkShared_Folders=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0173 set vL.VariableLoop=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0174 set vL.GetContainerStructure=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0175 Set vL.y1=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0176 set vL.y2=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0177 set vL.y3=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0178 set vL.y4=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0179 set vL.y5=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0180 set vL.y6=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0181 set vL.y7=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0182 set vL.y8=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0183 set vL.y9=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0184 set vL.LoadCustomVG=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0185 set vL.LoadCustomVU=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0186 set vL.Administraton=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0187 set vL.TemplateName=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0188 set vL.Load4Custom=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0189 set vL.ContainerName=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0190 set vL.Root=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0191 set vG.SkipInit=
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0194 trace '### DF 1.Init.qvs Finished'
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0194 '### DF 1.Init.qvs Finished'
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0047 IF lower(Subfield('D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\', '\', -3)) = lower('QlikViewSourceProd') THEN
8/3/2017 10:42:24.5505253 Information 2017-08-03 10:42:24: 0048 SET vLogSys= QTQVCEXTRP
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:24: 0049 CUSTOM CONNECT*Provider*QvSAPEXTRConnector.dll*XUserId*XPassword*
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0050 ELSE
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0055 SET QVDDir = D:\QLIKVIEWSOURCEPROD\UNIPER_FINANCE\1000.DATA_SOURCE\02.SAP_BW\7.Export\
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0061 [8D6COB001]:
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0062 LOAD
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0063 [/BIC/D0ACDOCTY] as [/BIC/D0ACDOCTY.Document type],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0064 [/BIC/D0ACTTYPC] as [/BIC/D0ACTTYPC.Activity Type (compounded)],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0065 [/BIC/D0ACTTYPE] as [/BIC/D0ACTTYPE.Activity Type],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0066 [/BIC/D0AMOUNT] as [/BIC/D0AMOUNT.Amount],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0067 [/BIC/D0BEKNZ] as [/BIC/D0BEKNZ.Debit/credit indicator],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0068 [/BIC/D0BUSENT] as [/BIC/D0BUSENT.Business Entity],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0069 [/BIC/D0CHRT_AC] as [/BIC/D0CHRT_AC.Chart of accounts],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0070 [/BIC/D0CO_AREA] as [/BIC/D0CO_AREA.Controlling Area],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0071 [/BIC/D0COMP_CO] as [/BIC/D0COMP_CO.Company code],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0072 [/BIC/D0COORDER] as [/BIC/D0COORDER.Order Number],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0073 [/BIC/D0COSTCEN] as [/BIC/D0COSTCEN.Cost Center],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0074 [/BIC/D0COSTELM] as [/BIC/D0COSTELM.Cost Element],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0075 [/BIC/D0CREDITO] as [/BIC/D0CREDITO.Account number of supplier/vendor],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0076 [/BIC/D0CURTYPE] as [/BIC/D0CURTYPE.Currency Type],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0077 [/BIC/D0DATATYP] as [/BIC/D0DATATYP.CO Data Type],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0078 [/BIC/D0DB_CR_I] as [/BIC/D0DB_CR_I.Sender/Receiver Indicator],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0079 [/BIC/D0DEBITO2] as [/BIC/D0DEBITO2.Debitor number],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0080 [/BIC/D0DEBITOR] as [/BIC/D0DEBITOR.Customer number],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0081 [/BIC/D0FIRACTI] as [/BIC/D0FIRACTI.Business Transaction],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0082 [/BIC/D0GL_ACCO] as [/BIC/D0GL_ACCO.G/L account],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0083 [/BIC/D0METYPE] as [/BIC/D0METYPE.Key Figure Type],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0084 [/BIC/D0PIOBJSV] as [/BIC/D0PIOBJSV.Partner Object Type],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0085 [/BIC/D0PIOVALU] as [/BIC/D0PIOVALU.Partner object],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0086 [/BIC/D0PNR_TXT] as [/BIC/D0PNR_TXT.Given-/ Surname],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0087 [/BIC/D0PO_CDF] as [/BIC/D0PO_CDF.Partner object (with CDF)],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0088 [/BIC/D0QUANTIT] as [/BIC/D0QUANTIT.Quantity],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0089 [/BIC/D0QUANTTO] as [/BIC/D0QUANTTO.Total Quantity],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0090 [/BIC/D0RECONTR] as [/BIC/D0RECONTR.Contract],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0091 [/BIC/D0RENTOBJ] as [/BIC/D0RENTOBJ.Rental Object],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0092 [/BIC/D0RESP_CC] as [/BIC/D0RESP_CC.Responsible cost center],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0093 [/BIC/D0SGTXT] as [/BIC/D0SGTXT.Invoice Line (Text)],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0094 [/BIC/D0SRVCHRG] as [/BIC/D0SRVCHRG.Service Charge Key],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0095 [/BIC/D0STTLUN] as [/BIC/D0STTLUN.Settlement Unit],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0096 [/BIC/D0USNAM] as [/BIC/D0USNAM.User name],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0097 [/BIC/D0VALUATI] as [/BIC/D0VALUATI.Valuation View],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0098 [/BIC/D0VBUND] as [/BIC/D0VBUND.Trading Partner (PGN)],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0099 [/BIC/D0VERS2] as [/BIC/D0VERS2.Version (harmonized)],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0100 [/BIC/D0VERSION] as [/BIC/D0VERSION.Version],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0101 [/BIC/D0VTDETAI] as [/BIC/D0VTDETAI.Detailing the value type],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0102 [/BIC/D0VTSTAT] as [/BIC/D0VTSTAT.Statistics indicator for value type],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0103 [/BIC/D0VTYPE] as [/BIC/D0VTYPE.Value Type for Reporting],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0104 [CURRENCY] as [CURRENCY.Currency key],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0105 [FISCPER] as [FISCPER.Fiscal year / period],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0106 [FISCPER3] as [FISCPER3.Posting period],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0107 [FISCVARNT] as [FISCVARNT.Fiscal year variant],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0108 [FISCYEAR] as [FISCYEAR.Fiscal year],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0109 [LOGSYS] as [LOGSYS.Source System],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0110 [SOURSYSTEM] as [SOURSYSTEM.Source system ID],
8/3/2017 10:42:25.8553253 Information 2017-08-03 10:42:25: 0111 [UNIT] as [UNIT.Unit of measure]
8/3/2017 10:42:30.3350253 Information 2017-08-03 10:42:25: 0112 SQL EXTRACTOR 8D3COB001
8/3/2017 10:42:30.3350253 Information 2017-08-03 10:42:25: 0113 TFRMETHOD T
8/3/2017 10:42:30.3350253 Information 2017-08-03 10:42:25: 0114 UPDMODE F
8/3/2017 10:42:30.3350253 Information 2017-08-03 10:42:25: 0115
8/3/2017 10:42:30.3350253 Information 2017-08-03 10:42:25: 0116
8/3/2017 10:42:30.3350253 Information 2017-08-03 10:42:25: 0117
8/3/2017 10:42:30.3350253 Information 2017-08-03 10:42:25: 0118
8/3/2017 10:42:30.3350253 Information 2017-08-03 10:42:25: 0119 EXTRLANGUAGE E
8/3/2017 10:42:30.3350253 Information 2017-08-03 10:42:25: 0120 LOGSYS QTQVCEXTRP
8/3/2017 10:42:30.3350253 Information 2017-08-03 10:42:25: 0121 WHERE
8/3/2017 10:42:30.3350253 Information 2017-08-03 10:42:25: 0122 /BIC/D0COMP_CO I EQ 0203, /BIC/D0COMP_CO I EQ 0204, /BIC/D0COMP_CO I EQ 0214, /BIC/D0COMP_CO I EQ 0216, /BIC/D0COMP_CO I EQ 0222, /BIC/D0COMP_CO I EQ 0224, /BIC/D0COMP_CO I EQ 0229, /BIC/D0COMP_CO I EQ 0235, /BIC/D0COMP_CO I EQ 0240
8/3/2017 10:42:30.3350253 Information 2017-08-03 10:42:30: | 49 fields found: /BIC/D0ACDOCTY.Document type, /BIC/D0ACTTYPC.Activity Type (compounded), /BIC/D0ACTTYPE.Activity Type, /BIC/D0AMOUNT.Amount, /BIC/D0BEKNZ.Debit/credit indicator, /BIC/D0BUSENT.Business Entity, /BIC/D0CHRT_AC.Chart of accounts, /BIC/D0CO_AREA.Controlling Area, /BIC/D0COMP_CO.Company code, /BIC/D0COORDER.Order Number, /BIC/D0COSTCEN.Cost Center, /BIC/D0COSTELM.Cost Element, /BIC/D0CREDITO.Account number of supplier/vendor, /BIC/D0CURTYPE.Currency Type, /BIC/D0DATATYP.CO Data Type, /BIC/D0DB_CR_I.Sender/Receiver Indicator, /BIC/D0DEBITO2.Debitor number, /BIC/D0DEBITOR.Customer number, /BIC/D0FIRACTI.Business Transaction, /BIC/D0GL_ACCO.G/L account, /BIC/D0METYPE.Key Figure Type, /BIC/D0PIOBJSV.Partner Object Type, /BIC/D0PIOVALU.Partner object, /BIC/D0PNR_TXT.Given-/ Surname, /BIC/D0PO_CDF.Partner object (with CDF), /BIC/D0QUANTIT.Quantity, /BIC/D0QUANTTO.Total Quantity, /BIC/D0RECONTR.Contract, /BIC/D0RENTOBJ.Rental Object, /BIC/D0RESP_CC.Responsible cost center, /BIC/D0SGTXT.Invoice Line (Text), /BIC/D0SRVCHRG.Service Charge Key, /BIC/D0STTLUN.Settlement Unit, /BIC/D0USNAM.User name, /BIC/D0VALUATI.Valuation View, /BIC/D0VBUND.Trading Partner (PGN), /BIC/D0VERS2.Version (harmonized), /BIC/D0VERSION.Version, /BIC/D0VTDETAI.Detailing the value type, /BIC/D0VTSTAT.Statistics indicator for value type, /BIC/D0VTYPE.Value Type for Reporting, CURRENCY.Currency key, FISCPER.Fiscal year / period, FISCPER3.Posting period, FISCVARNT.Fiscal year variant, FISCYEAR.Fiscal year, LOGSYS.Source System, SOURSYSTEM.Source system ID,
8/3/2017 10:42:30.5534253 Information UNIT.Unit of measure, |
8/3/2017 10:42:30.5534253 Information 2017-08-03 10:42:30: QVX_UNEXPECTED_END_OF_DATA: FAILED 8D3COB001 Error: Job already running (Please update the job using dialog "Status Table over Running Jobs")
8/3/2017 10:42:30.5534253 Information 2017-08-03 10:42:30: Error: Custom read failed
8/3/2017 10:42:30.5534253 Information 2017-08-03 10:42:30: General Script Error
8/3/2017 10:42:30.5534253 Information 2017-08-03 10:42:30: Execution Failed
8/3/2017 10:42:30.5534253 Information 2017-08-03 10:42:30: Execution finished.
arvind_patil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Adarsh,
Try to recreate same app and reload.Other wise reopen same app reload and save.
some time it happen.
Thanks,
Arvind Patil
ramasaisaksoft
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
please check the below Red colored code for Error issue.
8/3/2017 10:42:30.5534253 Information 2017-08-03 10:42:30: QVX_UNEXPECTED_END_OF_DATA: FAILED 8D3COB001 Error: Job already running (Please update the job using dialog "Status Table over Running Jobs")
8/3/2017 10:42:30.5534253 Information 2017-08-03 10:42:30: Error: Custom read failed
8/3/2017 10:42:30.5534253 Information 2017-08-03 10:42:30: General Script Error
8/3/2017 10:42:30.5534253 Information 2017-08-03 10:42:30: Execution Failed
sasiparupudi1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try running the extractor code alone
SQL EXTRACTOR 8D3COB001
and see if you get the same error?