Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
udaykiran
Contributor

Binary Load data issues in QMC

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.

13 Replies
Employee
Employee

Re: Binary Load data issues in QMC

Please attach your application log

udaykiran
Contributor

Re: Binary Load data issues in QMC

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.

Employee
Employee

Re: Binary Load data issues in QMC

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

Re: Binary Load data issues in QMC

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?

udaykiran
Contributor

Re: Binary Load data issues in QMC

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

udaykiran
Contributor

Re: Binary Load data issues in QMC

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

Re: Binary Load data issues in QMC

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.

Re: Binary Load data issues in QMC

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

Life is so rich, and we need to respect to the life !!!
udaykiran
Contributor

Re: Binary Load data issues in QMC

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

Community Browser