Re: SAP BW OLAP Connector Issue - Qlik Community

Report Inappropriate Content · ‎2014-09-25

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 ]

Client OS : Windows7 64 Bit
QlikView Version : 11.2 SR8
SAP Connector : 5.80 SR3(QlikViewSAP_x64Setup5.8-SR3.exe)
SAP BASIS : 7.40

Followings are images that I captured the process of connection.

I welcome any comments.

Thank you for your help.

WanKi,

mats_olin · ‎2014-09-25

Have you looked at the log file (C:\ProgramData\QlikTech\Custom Data\QvSAPConnector\Log)?

Report Inappropriate Content · ‎2014-09-25

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,

Anonymous · ‎2014-09-25

Hi Wanki

Did you check whether the connector user in BW has the proper authorizations ? (for infoprovider ZMSDSALE1 )

Thanks

Yaniv

Report Inappropriate Content · ‎2014-09-25

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,

er_mohit · ‎2014-09-25

Hi

Please see QLIKVIEW SAP BW CUSTOM READ FAILURE

Report Inappropriate Content · ‎2014-09-25

Thank you so much.

I will try to set in SAP BW Trans sm59.

Thank you,

WanKi,