Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Dears,
I have been trying to interface with SAP BW.
But I didn't succeed in connecting to SAP BW so far
So I really need your help.
[ Environments ]
Followings are images that I captured the process of connection.
I welcome any comments.
Thank you for your help.
WanKi,
Have you looked at the log file (C:\ProgramData\QlikTech\Custom Data\QvSAPConnector\Log)?
Yes, I got a log file.
Contents are below.
--------------------------------------------------------------------------------------------------------------------------------------
2014-09-25 PM 6:12:03: Execution started.
2014-09-25 PM 6:12:03: QlikView Version:11.20.12577.0
2014-09-25 PM 6:12:03: CPU Target x64
2014-09-25 PM 6:12:03: Operating System Windows 7 Professional Service Pack 1 (64 bit edition)
2014-09-25 PM 6:12:03: Wow64 mode Not using Wow64
2014-09-25 PM 6:12:03: MDAC Version 6.1.7601.17514
2014-09-25 PM 6:12:03: MDAC Full Install Version 6.1.7601.17514
2014-09-25 PM 6:12:03: PreferredCompression 2
2014-09-25 PM 6:12:03: EnableParallelReload 1
2014-09-25 PM 6:12:03: ParallelizeQvdLoads 1
2014-09-25 PM 6:12:03: AutoSaveAfterReload 0
2014-09-25 PM 6:12:03: BackupBeforeReload 0
2014-09-25 PM 6:12:03: EnableFlushLog 0
2014-09-25 PM 6:12:03: SaveInfoWhenSavingFile 0
2014-09-25 PM 6:12:03: UserLogfileCharset 1200
2014-09-25 PM 6:12:03: OdbcLoginTimeout -1
2014-09-25 PM 6:12:03: OdbcConnectionTimeout -1
2014-09-25 PM 6:12:03: ScriptWantsDbWrite false
2014-09-25 PM 6:12:03: ScriptWantsExe false
2014-09-25 PM 6:12:03: LogFile CodePage Used: 1200
2014-09-25 PM 6:12:03: Reload Executed By QLIKVIEW-WKJEON\Administrator
2014-09-25 PM 6:12:03: Process Executing: QlikView Desktop
2014-09-25 PM 6:12:03: Process ID: 1568
2014-09-25 PM 6:12:03: 0002 SET ThousandSep=','
2014-09-25 PM 6:12:03: 0003 SET DecimalSep='.'
2014-09-25 PM 6:12:03: 0004 SET MoneyThousandSep=','
2014-09-25 PM 6:12:03: 0005 SET MoneyDecimalSep='.'
2014-09-25 PM 6:12:03: 0006 SET MoneyFormat='₩#,##0;-₩#,##0'
2014-09-25 PM 6:12:03: 0007 SET TimeFormat='TT h:mm:ss'
2014-09-25 PM 6:12:03: 0008 SET DateFormat='YYYY-MM-DD'
2014-09-25 PM 6:12:03: 0009 SET TimestampFormat='YYYY-MM-DD TT h:mm:ss[.fff]'
2014-09-25 PM 6:12:03: 0010 SET MonthNames='1;2;3;4;5;6;7;8;9;10;11;12'
2014-09-25 PM 6:12:03: 0011 SET DayNames='월;화;수;목;금;토;일'
2014-09-25 PM 6:12:03: 0014 CUSTOM CONNECT*Provider*QvSAPOLAPConnector.dll*XUserId*XPassword*
2014-09-25 PM 6:12:09: 0016 [ZMSDSALE1/ZMSDSALE1_Q0005]:
2014-09-25 PM 6:12:09: 0017 Load *
2014-09-25 PM 6:12:09: 0018 Select PseudoMDX D (
2014-09-25 PM 6:12:09: 0019 Dimensions (
2014-09-25 PM 6:12:09: 0020 [ZSITE__ZREGION] ()),
2014-09-25 PM 6:12:09: 0021 Measures (
2014-09-25 PM 6:12:09: 0022 [7MSFRJRYOEINYZYMUR9W4MW9X].[7MSFRJRYOEINYZYMUR9W4N2LH]),
2014-09-25 PM 6:12:09: 0023 Slices (
2014-09-25 PM 6:12:09: 0024 [ZSITE__ZREGION].[05]),
2014-09-25 PM 6:12:09: 0025 From (ZMSDSALE1/ZMSDSALE1_Q0005))
2014-09-25 PM 6:16:15: 4 fields found: 지역(N) - 지역(N) Level 01 (Key), 지역(N) - 지역(N) Level 01 (Text), 판매수량, 판매수량 - Unit,
2014-09-25 PM 6:16:16: QVX_UNEXPECTED_END_OF_DATA: (1)
2014-09-25 PM 6:16:16: FROM [ZMSDSALE1/ZMSDSALE1_Q0005]
2014-09-25 PM 6:16:16:
2014-09-25 PM 6:16:16: resulted in the ErrorMessage:
2014-09-25 PM 6:16:16: Error occurred when starting the parser: timeout during allocate / CPIC-CALL: 'ThSAPCMRCV'
2014-09-25 PM 6:16:16: Error: Custom read failed
2014-09-25 PM 6:16:27: 0026 Store * from [ZMSDSALE1/ZMSDSALE1_Q0005] into ZMSDSALE1-ZMSDSALE1_Q0005.QVD
2014-09-25 PM 6:16:27: 0027 Drop table [ZMSDSALE1/ZMSDSALE1_Q0005]
2014-09-25 PM 6:16:27: Execution finished.
--------------------------------------------------------------------------------------------------------------------------------------
Thank you for your reply.
WanKi,
Hi Wanki
Did you check whether the connector user in BW has the proper authorizations ? (for infoprovider ZMSDSALE1 )
Thanks
Yaniv
Hi Yaniv,
Yes, I confirmed that the user have the right authorization , admin, with a BW consultant.
He also didn't know the reason.
So I didn't find the way.
Thank you for your reply.
WanKi,
Hi
Please see QLIKVIEW SAP BW CUSTOM READ FAILURE
Thank you so much.
I will try to set in SAP BW Trans sm59.
Thank you,
WanKi,