Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have an issue where the Binary load is not fetching all the data from the datamodel when loaded via QMC. But when it is loaded manually in the application, everything seems to be fetched. Can anyone help me in finding the issue source.
Thanks in advance.
Please attach your application log
Hi Clever,
Below is the application log.
29.07.2016 12:58:05: Execution started.
29.07.2016 12:58:05: QlikView Version:11.20.12928.0
29.07.2016 12:58:05: CPU Target x64
29.07.2016 12:58:05: Operating System Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)
29.07.2016 12:58:05: Wow64 mode Not using Wow64
29.07.2016 12:58:05: MDAC Version 6.1.7601.17514
29.07.2016 12:58:05: MDAC Full Install Version 6.1.7601.17514
29.07.2016 12:58:05: PreferredCompression 2
29.07.2016 12:58:05: EnableParallelReload 1
29.07.2016 12:58:05: ParallelizeQvdLoads 1
29.07.2016 12:58:05: AutoSaveAfterReload 0
29.07.2016 12:58:05: BackupBeforeReload 0
29.07.2016 12:58:05: EnableFlushLog 0
29.07.2016 12:58:05: SaveInfoWhenSavingFile 0
29.07.2016 12:58:05: UserLogfileCharset 1200
29.07.2016 12:58:05: OdbcLoginTimeout -1
29.07.2016 12:58:05: OdbcConnectionTimeout -1
29.07.2016 12:58:05: ScriptWantsDbWrite false
29.07.2016 12:58:05: ScriptWantsExe false
29.07.2016 12:58:05: LogFile CodePage Used: 1200
29.07.2016 12:58:05: Reload Executed By EU-AD-VWR\qlikview
29.07.2016 12:58:05: Process Executing: QVB
29.07.2016 12:58:05: Process ID: 10368
29.07.2016 12:58:05: 0002 Binary [..\..\Datamodel\Master Data\datamodel_customer_pricing_tool.qvw]
29.07.2016 13:02:15: 0010 Directory [..\..\QVD\Master data]
29.07.2016 13:02:15: 0005 SECTION ACCESS
29.07.2016 13:02:15: 0007 LOAD
29.07.2016 13:02:15: 0008 ZQVACCESS as ACCESS,
29.07.2016 13:02:15: 0009 upper(ZQVNTNAME) as NTNAME,
29.07.2016 13:02:15: 0010 ZQVGROUP as GROUP,
29.07.2016 13:02:15: 0011 PERNR as %PE_EMP_NO
29.07.2016 13:02:15: 0012
29.07.2016 13:02:15: 0013 FROM ZQV_AUTH_USER.qvd (qvd)
29.07.2016 13:02:15: 4 fields found: ACCESS, NTNAME, GROUP, %PE_EMP_NO, 6.770 lines fetched
29.07.2016 13:02:15: 0015 SECTION APPLICATION
29.07.2016 13:02:15: 0016 STAR IS *
29.07.2016 13:02:15: 0013 Auth_SalesOrg:
29.07.2016 13:02:15: 0014 LOAD
29.07.2016 13:02:15: 0015 VKORG as Select_Customer.Select_SalesOrg,
29.07.2016 13:02:15: 0016 ZQVGROUP as GROUP
29.07.2016 13:02:15: 0017
29.07.2016 13:02:15: 0018 FROM ZQV_AUTH_GROUP.qvd (qvd)
29.07.2016 13:02:15: 0019 WHERE VKORG <> ' '
29.07.2016 13:02:15: 2 fields found: Select_Customer.Select_SalesOrg, GROUP, 364 lines fetched
29.07.2016 13:02:15: 0018 set sDimensionsDirectory=..\..\Layout\ZProfessionalUser\Pricing\AccessPoint\Flex\
29.07.2016 13:02:15: 0034 SET ThousandSep='.'
29.07.2016 13:02:15: 0035 SET DecimalSep=','
29.07.2016 13:02:15: 0036 SET MoneyThousandSep='.'
29.07.2016 13:02:15: 0037 SET MoneyDecimalSep=','
29.07.2016 13:02:15: 0038 SET MoneyFormat='#.##0,00 €;-#.##0,00 €'
29.07.2016 13:02:15: 0039 SET TimeFormat='hh:mm:ss'
29.07.2016 13:02:15: 0040 SET DateFormat='DD.MM.YYYY'
29.07.2016 13:02:15: 0041 SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]'
29.07.2016 13:02:15: 0042 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
29.07.2016 13:02:15: 0043 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
29.07.2016 13:02:15: 0068 QUALIFY *
29.07.2016 13:02:15: 0069 UNQUALIFY '%*'
29.07.2016 13:02:15: 0075 if (not isnull(TableNumber('Download_ConditionDevelopment'))) then
29.07.2016 13:02:15: 0079 if (not isnull(TableNumber('Download_ConditionRenewal'))) then
29.07.2016 13:02:15: 0083 if (not isnull(TableNumber('Download_CustomerAnalysis'))) then
29.07.2016 13:02:15: 0087 if (not isnull(TableNumber('Select_Country'))) then
29.07.2016 13:02:15: 0091 if (not isnull(TableNumber('Select_Date'))) then
29.07.2016 13:02:16: 0096 if (not isnull(TableNumber('Select_Customer'))) then
29.07.2016 13:02:16: 0101 if (not isnull(TableNumber('MassInput'))) then
29.07.2016 13:02:16: 0105 if (not isnull(TableNumber('Select_Condition'))) then
29.07.2016 13:02:16: 0109 if (not isnull(TableNumber('Select_ConditionTable'))) then
29.07.2016 13:02:16: 0114 if (not isnull(TableNumber('Select_ConditionEndDate'))) then
29.07.2016 13:02:16: 0118 if (not isnull(TableNumber('Select_PSP_Switch'))) then
29.07.2016 13:02:16: 0123 if (not isnull(TableNumber('LANGUAGES2'))) then
29.07.2016 13:02:16: 0128 if (not isnull(TableNumber('Select_EU_HIERARCHY'))) then
29.07.2016 13:02:16: 0133 if (not isnull(TableNumber('ZQLExpression'))) then
29.07.2016 13:02:16: 0137 if (not isnull(TableNumber('ZQLUpload'))) then
29.07.2016 13:02:16: 0141 if (not isnull(TableNumber('ZQLDimension1'))) then
29.07.2016 13:02:16: 0145 if (not isnull(TableNumber('ZQLDimension2'))) then
29.07.2016 13:02:16: 0149 if (not isnull(TableNumber('ZQLDimension3'))) then
29.07.2016 13:02:16: 0153 if (not isnull(TableNumber('ZQLDimension4'))) then
29.07.2016 13:02:16: 0157 if (not isnull(TableNumber('ZQLDimension5'))) then
29.07.2016 13:02:16: 0161 if (not isnull(TableNumber('ZQLDimension6'))) then
29.07.2016 13:02:16: 0166 if (not isnull(TableNumber('ZQLDimension7'))) then
29.07.2016 13:02:16: 0171 Download_CustomerAnalysis:
29.07.2016 13:02:16: 0172 add load * inline [
29.07.2016 13:02:16: 0173 Text, ChartID, BinaryID
29.07.2016 13:02:16: 0174 Customer Details,CH19,1
29.07.2016 13:02:16: 0175 Conditions (Full Customer),CH45,2
29.07.2016 13:02:16: 0176 Sales Details (Full Customer),CH13,4
29.07.2016 13:02:16: 0177 Margin Sheet (Full Customer),CH57,8
29.07.2016 13:02:16: 0178 Conditions (Item Based),CH46,16
29.07.2016 13:02:16: 0179 Sales Details (Item Based),CH48,32
29.07.2016 13:02:16: 0180 Margin Sheet (Item Based),CH56,64
29.07.2016 13:02:16: 0181 ]
29.07.2016 13:02:16: 3 fields found: Download_CustomerAnalysis.Text, Download_CustomerAnalysis.ChartID, Download_CustomerAnalysis.BinaryID, 7 lines fetched
29.07.2016 13:02:16: 0184 Download_ConditionRenewal:
29.07.2016 13:02:16: 0185 add NoConcatenate load * inline [
29.07.2016 13:02:16: 0186 Text, ChartID, BinaryID
29.07.2016 13:02:16: 0187 Condition Renewal, CH146,1
29.07.2016 13:02:16: 0188 Detailed Sales, CH94,2
29.07.2016 13:02:16: 0189 Basic Sales, CH95,4
29.07.2016 13:02:16: 0190 ]
29.07.2016 13:02:17: 3 fields found: Download_ConditionRenewal.Text, Download_ConditionRenewal.ChartID, Download_ConditionRenewal.BinaryID, 3 lines fetched
29.07.2016 13:02:17: 0201 MassInput:
29.07.2016 13:02:17: 0202 add load * inline [
29.07.2016 13:02:17: 0203 InputField, Title
29.07.2016 13:02:17: 0204 MVKE.ECNnumber, ECN-Number
29.07.2016 13:02:17: 0205 PRICING.KNUMH, Condition Record No
29.07.2016 13:02:17: 0206 MARA_ENHANCED.NORMT, MEL Number (Key)
29.07.2016 13:02:17: 0207 MARA_ENHANCED.PRDHA, Product Hierarchy
29.07.2016 13:02:17: 0208 MARA_ENHANCED.PREFIX, Prefix (Key)
29.07.2016 13:02:17: 0209 MARA_ENHANCED.WRKST, Pricing ID
29.07.2016 13:02:17: 0210 ]
29.07.2016 13:02:17: 2 fields found: MassInput.InputField, MassInput.Title, 6 lines fetched
29.07.2016 13:02:17: 0212 Select_Country:
29.07.2016 13:02:17: 0213 add load distinct
29.07.2016 13:02:17: 0214 HierarchyTable.SALESORG as Select_Country
29.07.2016 13:02:17: 0215 resident HierarchyTable
29.07.2016 13:02:17: 1 fields found: Select_Country.Select_Country, 36 lines fetched
29.07.2016 13:02:18: 0218 Select_Date:
29.07.2016 13:02:18: 0219 add load distinct
29.07.2016 13:02:18: 0220 PRICING.DATEBIYearMonth as Select_Date
29.07.2016 13:02:18: 0221 resident PRICING
29.07.2016 13:02:18: 1 fields found: Select_Date.Select_Date, 339 lines fetched
29.07.2016 13:03:51: 0224 Select_ConditionTable:
29.07.2016 13:03:51: 0225 add load distinct
29.07.2016 13:03:51: 0226 PRICING.KOTABNR as Select_Table
29.07.2016 13:03:51: 0227 resident PRICING
29.07.2016 13:03:51: 1 fields found: Select_ConditionTable.Select_Table, 22 lines fetched
29.07.2016 13:05:24: 0229 UNQUALIFY '%*'
29.07.2016 13:05:24: 0230 Select_Customer:
29.07.2016 13:05:24: 0231 add load distinct
29.07.2016 13:05:24: 0232 HierarchyTable.KUNNR as Select_Customer,
29.07.2016 13:05:24: 0233 HierarchyTable.SALESORG as Select_SalesOrg
29.07.2016 13:05:24: 0234 resident HierarchyTable
29.07.2016 13:05:24: 2 fields found: Select_Customer.Select_Customer, Select_Customer.Select_SalesOrg, 597.622 lines fetched
29.07.2016 13:05:26: 0236 Select_Condition:
29.07.2016 13:05:26: 0237 add load distinct
29.07.2016 13:05:26: 0238 ZFIX_ZDIL_ADDON.KSCHL as Select_Condition
29.07.2016 13:05:26: 0239 resident ZFIX_ZDIL_ADDON where (ZFIX_ZDIL_ADDON.KSCHL<>'ZPSP')
29.07.2016 13:05:26: 1 fields found: Select_Condition.Select_Condition, 2 lines fetched
29.07.2016 13:05:26: 0241 Select_ConditionEndDate:
29.07.2016 13:05:26: 0242 add load distinct
29.07.2016 13:05:26: 0243 ZFIX_ZDIL_ADDON.DATEBIYearMonth as Select_ConditionEndDate
29.07.2016 13:05:26: 0244 resident ZFIX_ZDIL_ADDON
29.07.2016 13:05:26: 1 fields found: Select_ConditionEndDate.Select_ConditionEndDate, 5 lines fetched
29.07.2016 13:05:26: 0246 Select_PSP_Switch:
29.07.2016 13:05:26: 0247 add load * inline [
29.07.2016 13:05:26: 0248 SelectPSP
29.07.2016 13:05:26: 0249 ZPSP
29.07.2016 13:05:26: 0250 ]
29.07.2016 13:05:26: 1 fields found: Select_PSP_Switch.SelectPSP, 1 lines fetched
29.07.2016 13:05:26: 0252 LANGUAGES2:
29.07.2016 13:05:26: 0253 add noconcatenate load
29.07.2016 13:05:26: 0254 LANGUAGES.Languages as Languages
29.07.2016 13:05:26: 0255 resident LANGUAGES
29.07.2016 13:05:26: 1 fields found: LANGUAGES2.Languages, 6 lines fetched
29.07.2016 13:05:26: 0257 Select_EU_HIERARCHY:
29.07.2016 13:05:26: 0258 add load * inline [
29.07.2016 13:05:26: 0259 Exclude_EU_Hierarchy
29.07.2016 13:05:26: 0260 Exclude
29.07.2016 13:05:26: 0261 Include
29.07.2016 13:05:26: 0262 ]
29.07.2016 13:05:26: 1 fields found: Select_EU_HIERARCHY.Exclude_EU_Hierarchy, 2 lines fetched
29.07.2016 13:05:26: 0270 ZQLExpression:
29.07.2016 13:05:26: 0271 ADD LOAD
29.07.2016 13:05:26: 0272 Title,
29.07.2016 13:05:26: 0273 BinaryCode,
29.07.2016 13:05:26: 0274 Position
29.07.2016 13:05:26: 0275 FROM
29.07.2016 13:05:26: 0276 ..\..\Layout\ZProfessionalUser\Pricing\AccessPoint\Flex\Dimensions_CP.xlsx
29.07.2016 13:05:26: 0277 (ooxml, embedded labels, table is Expr)
29.07.2016 13:05:26: 3 fields found: ZQLExpression.Title, ZQLExpression.BinaryCode, ZQLExpression.Position, 9 lines fetched
29.07.2016 13:05:26: 0279 ZQLDimension1:
29.07.2016 13:05:26: 0280 ADD LOAD
29.07.2016 13:05:26: 0281 Field,
29.07.2016 13:05:26: 0282 Title
29.07.2016 13:05:26: 0283 FROM
29.07.2016 13:05:26: 0284 ..\..\Layout\ZProfessionalUser\Pricing\AccessPoint\Flex\Dimensions_CP.xlsx
29.07.2016 13:05:26: 0285 (ooxml, embedded labels, table is Dimension)
29.07.2016 13:05:26: 2 fields found: ZQLDimension1.Field, ZQLDimension1.Title, 6 lines fetched
29.07.2016 13:05:26: 0287 ZQLDimension2:
29.07.2016 13:05:26: 0288 ADD LOAD
29.07.2016 13:05:26: 0289 Field,
29.07.2016 13:05:26: 0290 Title
29.07.2016 13:05:26: 0291 FROM
29.07.2016 13:05:26: 0292 ..\..\Layout\ZProfessionalUser\Pricing\AccessPoint\Flex\Dimensions_CP.xlsx
29.07.2016 13:05:26: 0293 (ooxml, embedded labels, table is Dimension)
29.07.2016 13:05:26: 2 fields found: ZQLDimension2.Field, ZQLDimension2.Title, 6 lines fetched
29.07.2016 13:05:26: 0295 ZQLDimension3:
29.07.2016 13:05:26: 0296 ADD LOAD
29.07.2016 13:05:26: 0297 Field,
29.07.2016 13:05:26: 0298 Title
29.07.2016 13:05:26: 0299 FROM
29.07.2016 13:05:26: 0300 ..\..\Layout\ZProfessionalUser\Pricing\AccessPoint\Flex\Dimensions_CP.xlsx
29.07.2016 13:05:26: 0301 (ooxml, embedded labels, table is Dimension)
29.07.2016 13:05:26: 2 fields found: ZQLDimension3.Field, ZQLDimension3.Title, 6 lines fetched
29.07.2016 13:05:26: 0303 ZQLDimension4:
29.07.2016 13:05:26: 0304 ADD LOAD
29.07.2016 13:05:26: 0305 Field,
29.07.2016 13:05:26: 0306 Title
29.07.2016 13:05:26: 0307 FROM
29.07.2016 13:05:26: 0308 ..\..\Layout\ZProfessionalUser\Pricing\AccessPoint\Flex\Dimensions_CP.xlsx
29.07.2016 13:05:26: 0309 (ooxml, embedded labels, table is Dimension)
29.07.2016 13:05:26: 2 fields found: ZQLDimension4.Field, ZQLDimension4.Title, 6 lines fetched
29.07.2016 13:05:26: 0311 ZQLDimension5:
29.07.2016 13:05:26: 0312 ADD LOAD
29.07.2016 13:05:26: 0313 Field,
29.07.2016 13:05:26: 0314 Title
29.07.2016 13:05:26: 0315 FROM
29.07.2016 13:05:26: 0316 ..\..\Layout\ZProfessionalUser\Pricing\AccessPoint\Flex\Dimensions_CP.xlsx
29.07.2016 13:05:26: 0317 (ooxml, embedded labels, table is Dimension)
29.07.2016 13:05:26: 2 fields found: ZQLDimension5.Field, ZQLDimension5.Title, 6 lines fetched
29.07.2016 13:05:26: 0319 ZQLDimension6:
29.07.2016 13:05:26: 0320 ADD LOAD
29.07.2016 13:05:26: 0321 Field,
29.07.2016 13:05:26: 0322 Title
29.07.2016 13:05:26: 0323 FROM
29.07.2016 13:05:26: 0324 ..\..\Layout\ZProfessionalUser\Pricing\AccessPoint\Flex\Dimensions_CP.xlsx
29.07.2016 13:05:26: 0325 (ooxml, embedded labels, table is Dimension)
29.07.2016 13:05:26: 2 fields found: ZQLDimension6.Field, ZQLDimension6.Title, 6 lines fetched
29.07.2016 13:05:26: 0327 Exit Script
29.07.2016 13:05:52: Execution finished.
You have a section access with data restriction right?
"loaded manually in the application," are you using a admin?
" not fetching all the data from the datamodel when loaded via QMC" which user does the reload? which user is opening the app?
I would bet my 2cents into section access issue
Your document is using section access. Has the login account for the Distribution Service (QDS) been added as a user in your section access list with access to all data?
For loading manually in the application, we have the developer access
For not fetching all the data from datamodel when loaded via QMC, we have the admin access
and some of the users who access the application has ADMIN and the rest have USER
The login account for QDS is added as ADMIN in my section access list.
Can you logon to the server using the QDS login and open the app using QlikView desktop to see if all the data is present? This will show if the app is loading all data when refreshing on the server.
Check the Binary Load file personally, Then try to load again if that file is ok.
I did check the Binary Load file and it is fine.