Binary Load data issues in QMC - Qlik Community

Anonymous · ‎2016-07-29

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.

Clever_Anjos · ‎2016-07-29

Please attach your application log

Anonymous · ‎2016-07-29

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.

Clever_Anjos · ‎2016-07-29

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

Colin-Albert · ‎2016-07-29

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?

Anonymous · ‎2016-07-29

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

Anonymous · ‎2016-07-29

The login account for QDS is added as ADMIN in my section access list.

Colin-Albert · ‎2016-07-29

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.

Anil_Babu_Samineni · ‎2016-07-29

Check the Binary Load file personally, Then try to load again if that file is ok.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2016-07-29

I did check the Binary Load file and it is fine.