13 Replies Latest reply: Aug 1, 2016 7:36 AM by Uday P RSS

    Binary Load data issues in QMC

    Uday P

      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.

        • Re: Binary Load data issues in QMC
          Clever Anjos

          Please attach your application log

            • Re: Binary Load data issues in QMC
              Uday P

              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.

            • Re: Binary Load data issues in QMC
              Clever Anjos

              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
                Anil Babu Samineni

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