6 Replies Latest reply: Sep 25, 2014 8:29 AM by Wanki Jeon RSS

    SAP BW OLAP Connector Issue

      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.

      1. SAP-TEST-EditScript.png

      2. SAP-TEST-Connection.png

      2. SAP-TEST-Connection-Success.png

      2. SAP-TEST-BW-OLAP-CUBE.png

      2. SAP-TEST-BW-OLAP-Execution.png

      2. SAP-TEST-BW-OLAP-Error.png

       

      I welcome any comments.

      Thank you for your help.

       

      WanKi,

        • Re: SAP BW OLAP Connector Issue
          Mats Olin

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

            • Re: SAP BW OLAP Connector Issue

              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,