Re: Binary Load data issues in QMC

Anonymous — Fri, 29 Jul 2016 12:27:27 GMT

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.

topic Re: Binary Load data issues in QMC in QlikView

Binary Load data issues in QMC

Re: Binary Load data issues in QMC

Re: Binary Load data issues in QMC

Re: Binary Load data issues in QMC

Re: Binary Load data issues in QMC

Re: Binary Load data issues in QMC

Re: Binary Load data issues in QMC

Re: Binary Load data issues in QMC

Re: Binary Load data issues in QMC

Re: Binary Load data issues in QMC

Re: Binary Load data issues in QMC

Re: Binary Load data issues in QMC

Re: Binary Load data issues in QMC

Re: Binary Load data issues in QMC