Qlik Community

QlikView Connectors

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

SAP OLAP Data query

Hi Guys,

I am battling to load data from a SAP BW server.  I have loaded the SAPOLAPConnector 5.71 and all users have been set up on the SAP side by their IT guys.  When I connect I can view all cubes and queries in the Infoprovider - and can construct a query to run in the script editor using slicing.  As soon as I load the script it takes a few seconds to get to the Load * and then nothing happens for hours.  If left to it's own time I have received a timeout response after about 9 hours...

Log File:

2013/06/12 10:17:51 AM:      Execution started.

2013/06/12 10:17:51 AM:      QlikView Version:11.00.11282.0

2013/06/12 10:17:51 AM:      CPU Target                    x64

2013/06/12 10:17:51 AM:      Operating System              Windows Server 2008 R2 Standard Service Pack 1 (64 bit edition)

2013/06/12 10:17:51 AM:      Wow64 mode                    Not using Wow64

2013/06/12 10:17:51 AM:      MDAC Version                  6.1.7601.17514

2013/06/12 10:17:51 AM:      MDAC Full Install Version     6.1.7601.17514

2013/06/12 10:17:51 AM:      PreferredCompression          2

2013/06/12 10:17:51 AM:      EnableParallelReload          1

2013/06/12 10:17:51 AM:      ParallelizeQvdLoads           1

2013/06/12 10:17:51 AM:      AutoSaveAfterReload           0

2013/06/12 10:17:51 AM:      BackupBeforeReload            0

2013/06/12 10:17:51 AM:      EnableFlushLog                0

2013/06/12 10:17:51 AM:      SaveInfoWhenSavingFile        0

2013/06/12 10:17:51 AM:      UserLogfileCharset            0

2013/06/12 10:17:51 AM:      OdbcLoginTimeout              -1

2013/06/12 10:17:51 AM:      OdbcConnectionTimeout         -1

2013/06/12 10:17:51 AM:      ScriptWantsDbWrite            false

2013/06/12 10:17:51 AM:      ScriptWantsExe                false

2013/06/12 10:17:51 AM:      LogFile CodePage Used:        1252

2013/06/12 10:17:51 AM: 0002  SET ThousandSep=' '

2013/06/12 10:17:51 AM: 0003  SET DecimalSep='.'

2013/06/12 10:17:51 AM: 0004  SET MoneyThousandSep=' '

2013/06/12 10:17:51 AM: 0005  SET MoneyDecimalSep=','

2013/06/12 10:17:51 AM: 0006  SET MoneyFormat='R # ##0,00;R-# ##0,00'

2013/06/12 10:17:51 AM: 0007  SET TimeFormat='hh:mm:ss TT'

2013/06/12 10:17:51 AM: 0008  SET DateFormat='YYYY/MM/DD'

2013/06/12 10:17:51 AM: 0009  SET TimestampFormat='YYYY/MM/DD hh:mm:ss[.fff] TT'

2013/06/12 10:17:51 AM: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

2013/06/12 10:17:51 AM: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

2013/06/12 10:17:51 AM: 0016  CUSTOM CONNECT*Provider*QvSAPOLAPConnector.dll*XUserId*XPassword*

2013/06/12 10:17:51 AM: 0148  [$0CSAL_C01]:

2013/06/12 10:17:51 AM: 0149  Load *

2013/06/12 10:17:51 AM: 0150  Select PseudoMDX D (

2013/06/12 10:17:51 AM: 0151   Dimensions (

2013/06/12 10:17:51 AM: 0152    [0AUVEHICLE] (),

2013/06/12 10:17:51 AM: 0153    [0BBP_PURGRP] (),

2013/06/12 10:17:51 AM: 0154    [0BBP_PURORG] (),

2013/06/12 10:17:51 AM: 0155    [0BP_ACTIVIT] (),

2013/06/12 10:17:51 AM: 0156    [0BP_CONTPER] (),

2013/06/12 10:17:51 AM: 0157    [0BP_EMPLO] (),

2013/06/12 10:17:51 AM: 0158    [0BP_RESPPER] (),

2013/06/12 10:17:51 AM: 0159    [0CRMPLEAGUI] (),

2013/06/12 10:17:51 AM: 0160    [0CRMPOPPGUI] (),

2013/06/12 10:17:51 AM: 0161    [0CRMPU_OG_R] (),

2013/06/12 10:17:51 AM: 0162    [0CRMSA_OG_R] (),

2013/06/12 10:17:51 AM: 0163    [0CRMSE_OG_R] (),

2013/06/12 10:17:51 AM: 0164    [0CRMSRVTGRP] (),

2013/06/12 10:17:51 AM: 0165    [0CRM_ACFR] (),

2013/06/12 10:17:51 AM: 0166    [0CRM_ACTO] (),

2013/06/12 10:17:51 AM: 0167    [0CRM_AGENT] (),

2013/06/12 10:17:51 AM: 0168    [0CRM_CAGNTB] (),

2013/06/12 10:17:51 AM: 0169    [0CRM_CAT] (),

2013/06/12 10:17:51 AM: 0170    [0CRM_COPRGU] (),

2013/06/12 10:17:51 AM: 0171    [0CRM_COPRID] (),

2013/06/12 10:17:51 AM: 0172    [0CRM_DIRECT] (),

2013/06/12 10:17:51 AM: 0173    [0CRM_EXC_CC] (),

2013/06/12 10:17:51 AM: 0174    [0CRM_IOBJGU] (),

2013/06/12 10:17:51 AM: 0175    [0CRM_IOBJID] (),

2013/06/12 10:17:51 AM: 0176    [0CRM_LEADCR] (),

2013/06/12 10:17:51 AM: 0177    [0CRM_MKTELM] (),

2013/06/12 10:17:51 AM: 0178    [0CRM_OBJECT] (),

2013/06/12 10:17:51 AM: 0179    [0CRM_OBJ_ID] (),

2013/06/12 10:17:51 AM: 0180    [0CRM_OPPCRD] (),

2013/06/12 10:17:51 AM: 0181    [0CRM_OPPGUI] (),

2013/06/12 10:17:51 AM: 0182    [0CRM_PC] (),

2013/06/12 10:17:51 AM: 0183    [0CRM_PCAT] (),

2013/06/12 10:17:51 AM: 0184    [0CRM_PGR] (),

2013/06/12 10:17:51 AM: 0185    [0CRM_PLFR] (),

2013/06/12 10:17:51 AM: 0186    [0CRM_PLTO] (),

2013/06/12 10:17:51 AM: 0187    [0CRM_PRCCAT] (),

2013/06/12 10:17:51 AM: 0188    [0CRM_PRCTYP] (),

2013/06/12 10:17:51 AM: 0189    [0CRM_PRIO_A] (),

2013/06/12 10:17:51 AM: 0190    [0CRM_PROD] (),

2013/06/12 10:17:51 AM: 0191    [0CRM_RCA] (),

2013/06/12 10:17:51 AM: 0192    [0CRM_RCO] (),

2013/06/12 10:17:51 AM: 0193    [0CRM_RG] (),

2013/06/12 10:17:51 AM: 0194    [0CRM_RSN_CO] (),

2013/06/12 10:17:51 AM: 0195    [0CRM_RSN_GR] (),

2013/06/12 10:17:51 AM: 0196    [0CRM_RSN_TY] (),

2013/06/12 10:17:51 AM: 0197    [0CRM_SALGRP] (),

2013/06/12 10:17:51 AM: 0198    [0CRM_SALOFF] (),

2013/06/12 10:17:51 AM: 0199    [0CRM_SALORG] (),

2013/06/12 10:17:51 AM: 0200    [0CRM_SRVORG] (),

2013/06/12 10:17:51 AM: 0201    [0CRM_STSMA] (),

2013/06/12 10:17:51 AM: 0202    [0CRM_SYSTA3] (),

2013/06/12 10:17:51 AM: 0203    [0CRM_TR] (),

2013/06/12 10:17:51 AM: 0204    [0CRM_USSTAT] (),

2013/06/12 10:17:51 AM: 0205    [0DISTR_CHAN] (),

2013/06/12 10:17:51 AM: 0206    [0DIVISION] (),

2013/06/12 10:17:51 AM: 0207    [0PROD_ID] (),

2013/06/12 10:17:51 AM: 0208    [0PROD_OBJFA] (),

2013/06/12 10:17:51 AM: 0209    [0SOURSYSTEM] (),

2013/06/12 10:17:51 AM: 0210    [0STAONESYS0] (),

2013/06/12 10:17:51 AM: 0211    [0STAONESYS1] (),

2013/06/12 10:17:51 AM: 0212    [0STAONESYS8] (),

2013/06/12 10:17:51 AM: 0213    [0STAONEUSS0] (),

2013/06/12 10:17:51 AM: 0214    [0TCTSYSID] (),

2013/06/12 10:17:51 AM: 0215    [0VERSION] (),

2013/06/12 10:17:51 AM: 0216    [0VTYPE] (),

2013/06/12 10:17:51 AM: 0217    [ZASSIGNEE] (),

2013/06/12 10:17:51 AM: 0218    [ZBACKD] (),

2013/06/12 10:17:51 AM: 0219    [ZBSASST] (),

2013/06/12 10:17:51 AM: 0220    [ZCHG_DATE] (),

2013/06/12 10:17:51 AM: 0221    [ZDEALER] (),

2013/06/12 10:17:51 AM: 0222    [ZDLRPR] (),

2013/06/12 10:17:51 AM: 0223    [ZDUEBYTIM] (),

2013/06/12 10:17:51 AM: 0224    [ZESCBP1] (),

2013/06/12 10:17:51 AM: 0225    [ZESCBP2] (),

2013/06/12 10:17:51 AM: 0226    [ZESCBP3] (),

2013/06/12 10:17:51 AM: 0227    [ZESCBP4] (),

2013/06/12 10:17:51 AM: 0228    [ZESCBP5] (),

2013/06/12 10:17:51 AM: 0229    [ZEXT] (),

2013/06/12 10:17:51 AM: 0230    [ZEXTAFDD] (),

2013/06/12 10:17:51 AM: 0231    [ZEXT_BY] (),

2013/06/12 10:17:51 AM: 0232    [ZINFREC] (),

2013/06/12 10:17:51 AM: 0233    [ZISSUE] (),

2013/06/12 10:17:51 AM: 0234    [ZKAEXEC] (),

2013/06/12 10:17:51 AM: 0235    [ZORGDUEDT] (),

2013/06/12 10:17:51 AM: 0236    [ZREASEXT] (),

2013/06/12 10:17:51 AM: 0237    [ZSTARTDT] (),

2013/06/12 10:17:51 AM: 0238    [Z_CLTIME] (),

2013/06/12 10:17:51 AM: 0239    [Z_SHFTIND] (),

2013/06/12 10:17:51 AM: 0240    [0CALDAY] (),

2013/06/12 10:17:51 AM: 0241    [0CALMONTH] (),

2013/06/12 10:17:51 AM: 0242    [0CALQUARTER] (),

2013/06/12 10:17:51 AM: 0243    [0CALWEEK] (),

2013/06/12 10:17:51 AM: 0244    [0CALYEAR] (),

2013/06/12 10:17:51 AM: 0245    [0FISCVARNT] ()),

2013/06/12 10:17:51 AM: 0246   Slices (

2013/06/12 10:17:51 AM: 0247    [0CALDAY].[20130309]),

2013/06/12 10:17:51 AM: 0248   From ($0CSAL_C01))

2013/06/12  7:05:04 PM:                 188 fields found: Vehicle - Vehicle Level 01 (Key), Vehicle - Vehicle Level 01 (Text), Configured Product GUID - Configured Product GUID Level 01 (Key), Configured Product GUID - Configured Product GUID Level 01 (Text), Configured Product ID - Configured Product ID Level 01 (Key), Configured Product ID - Configured Product ID Level 01 (Text), Ind. Object GUID - Ind. Object GUID Level 01 (Key), Ind. Object GUID - Ind. Object GUID Level 01 (Text), Individual Object ID - Individual Object ID Level 01 (Key), Individual Object ID - Individual Object ID Level 01 (Text), Product - Product Level 01 (Key), Product - Product Level 01 (Text), Product ID - Product ID Level 01 (Key), Product ID - Product ID Level 01 (Text), Product: Obj. Family - Product: Obj. Family Level 01 (Key), Product: Obj. Family - Product: Obj. Family Level 01 (Text), BW System - BW System Level 01 (Key), BW System - BW System Level 01 (Text), Respons. Purch. Org. - Respons. Purch. Org. Level 01 (Key), Respons. Purch. Org. - Respons. Purch. Org. Level 01 (Text), Purchasing Group - Purchasing Group Level 01 (Key), Purchasing Group - Purchasing Group Level 01 (Text), Purch. Organization - Purch. Organization Level 01 (Key), Purch. Organization - Purch. Organization Level 01 (Text), Ex. CRM Service Org. - Ex. CRM Service Org. Level 01 (Key), Ex. CRM Service Org. - Ex. CRM Service Org. Level 01 (Text), Resp. Serv. Org. - Resp. Serv. Org. Level 01 (Key), Resp. Serv. Org. - Resp. Serv. Org. Level 01 (Text), Service Org. CRM - Service Org. CRM Level 01 (Key), Service Org. CRM - Service Org. CRM Level 01 (Text), [0CRM_AGENT] - Agent Level 01 (Key), [0CRM_AGENT] - Agent Level 01 (Text), [0CRM_CAGNTB] - Agent Level 01 (Key), [0CRM_CAGNTB] - Agent Level 01 (Text), Employee - Employee Level 01 (Key), Employee - Employee Level 01 (Text), Employee Responsible - Employee Responsible Level 01 (Key), Employee Responsible - Employee Responsible Level 01 (Text), [0CRM_ACFR] - From Level 01 (Key), [0CRM_ACFR] - From Level 01 (Text), [0CRM_PLFR] - From Level 01 (Key), [0CRM_PLFR] - From Level 01 (Text), [0CRM_PLTO] - To Level 01 (Key), [0CRM_PLTO] - To Level 01 (Text), [0CRM_ACTO] - To Level 01 (Key), [0CRM_ACTO] - To Level 01 (Text), Due by Time - Due by Time Level 01 (Key), Due by Time - Due by Time Level 01 (Text), Original Due Date - Original Due Date Level 01 (Key), Original Due Date - Original Due Date Level 01 (Text), Start Date - Start Date Level 01 (Key), Start Date - Start Date Level 01 (Text), Closed time - Closed time Level 01 (Key), Closed time - Closed time Level 01 (Text), Shift Indicator - Shift Indicator Level 01 (Key), Shift Indicator - Shift Indicator Level 01 (Text), Opportunity Created - Opportunity Created Level 01 (Key), Opportunity Created - Opportunity Created Level 01 (Text), Opportunity guid - Opportunity guid Level 01 (Key), Opportunity guid - Opportunity guid Level 01 (Text), GUID: Preceding Lead - GUID: Preceding Lead Level 01 (Key), GUID: Preceding Lead - GUID: Preceding Lead Level 01 (Text), Source system ID - Source system ID Level 01 (Key), Source system ID - Source system ID Level 01 (Text), GUID: Preced.Opport. - GUID: Preced.Opport. Level 01 (Key), GUID: Preced.Opport. - GUID: Preced.Opport. Level 01 (Text), Version - Version Level 01 (Key), Version - Version Level 01 (Text), Value type - Value type Level 01 (Key), Value type - Value type Level 01 (Text), Lead Created on - Lead Created on Level 01 (Key), Lead Created on - Lead Created on Level 01 (Text), CRM Marketing Elem. - CRM Marketing Elem. Level 01 (Key), CRM Marketing Elem. - CRM Marketing Elem. Level 01 (Text), Priority - Priority Level 01 (Key), Priority - Priority Level 01 (Text), Category - Category Level 01 (Key), Category - Category Level 01 (Text), Status Profile - Status Profile Level 01 (Key), Status Profile - Status Profile Level 01 (Text), Move-out: System St. - Move-out: System St. Level 01 (Key), Move-out: System St. - Move-out: System St. Level 01 (Text), User Status - User Status Level 01 (Key), User Status - User Status Level 01 (Text), Direction - Direction Level 01 (Key), Direction - Direction Level 01 (Text), Back Date Indicator - Back Date Indicator Level 01 (Key), Back Date Indicator - Back Date Indicator Level 01 (Text), Changed Date - Changed Date Level 01 (Key), Changed Date - Changed Date Level 01 (Text), Due Date Ext. Ind - Due Date Ext. Ind Level 01 (Key), Due Date Ext. Ind - Due Date Ext. Ind Level 01 (Text), Extension done After - Extension done After Level 01 (Key), Extension done After - Extension done After Level 01 (Text), Issue - Issue Level 01 (Key), Issue - Issue Level 01 (Text), Reason for Extention - Reason for Extention Level 01 (Key), Reason for Extention - Reason for Extention Level 01 (Text), Business Trans. Type - Business Trans. Type Level 01 (Key), Business Trans. Type - Business Trans. Type Level 01 (Text), Target - Target Level 01 (Key), Target - Target Level 01 (Text), Transaction Number - Transaction Number Level 01 (Key), Transaction Number - Transaction Number Level 01 (Text), Curr. Code Group - Curr. Code Group Level 01 (Key), Curr. Code Group - Curr. Code Group Level 01 (Text), Curr. Cat. Reasons - Curr. Cat. Reasons Level 01 (Key), Curr. Cat. Reasons - Curr. Cat. Reasons Level 01 (Text), Reason - Reason Level 01 (Key), Reason - Reason Level 01 (Text), Resp. Sales Org. - Resp. Sales Org. Level 01 (Key), Resp. Sales Org. - Resp. Sales Org. Level 01 (Text), CRM Sales Group - CRM Sales Group Level 01 (Key), CRM Sales Group - CRM Sales Group Level 01 (Text), CRM Sales Office - CRM Sales Office Level 01 (Key), CRM Sales Office - CRM Sales Office Level 01 (Text), CRM Sales Org. - CRM Sales Org. Level 01 (Key), CRM Sales Org. - CRM Sales Org. Level 01 (Text), Distribution Channel - Distribution Channel Level 01 (Key), Distribution Channel - Distribution Channel Level 01 (Text), Division - Division Level 01 (Key), Division - Division Level 01 (Text), Life Cycle Status - Life Cycle Status Level 01 (Key), Life Cycle Status - Life Cycle Status Level 01 (Text), Status - Status Level 01 (Key), Status - Status Level 01 (Text), Status Planned - Status Planned Level 01 (Key), Status Planned - Status Planned Level 01 (Text), Status: Rejected - Status: Rejected Level 01 (Key), Status: Rejected - Status: Rejected Level 01 (Text), Assignee - Assignee Level 01 (Key), Assignee - Assignee Level 01 (Text),  Business Support As -  Business Support As Level 01 (Key),  Business Support As -  Business Support As Level 01 (Text), Dealer - Dealer Level 01 (Key), Dealer - Dealer Level 01 (Text), Dealer Principal - Dealer Principal Level 01 (Key), Dealer Principal - Dealer Principal Level 01 (Text), Contact Persons - Contact Persons Level 01 (Key), Contact Persons - Contact Persons Level 01 (Text), Escalation BP 1 - Escalation BP 1 Level 01 (Key), Escalation BP 1 - Escalation BP 1 Level 01 (Text), Escalation BP 2 - Escalation BP 2 Level 01 (Key), Escalation BP 2 - Escalation BP 2 Level 01 (Text), Escalation BP3 - Escalation BP3 Level 01 (Key), Escalation BP3 - Escalation BP3 Level 01 (Text), Escalation BP 4 - Escalation BP 4 Level 01 (Key), Escalation BP 4 - Escalation BP 4 Level 01 (Text), Escalation BP 5 - Escalation BP 5 Level 01 (Key), Escalation BP 5 - Escalation BP 5 Level 01 (Text), Extended By - Extended By Level 01 (Key), Extended By - Extended By Level 01 (Text), Information Rec. - Information Rec. Level 01 (Key), Information Rec. - Information Rec. Level 01 (Text), Key Account Executiv - Key Account Executiv Level 01 (Key), Key Account Executiv - Key Account Executiv Level 01 (Text), Contact Partner - Contact Partner Level 01 (Key), Contact Partner - Contact Partner Level 01 (Text), Interaction Center - Interaction Center Level 01 (Key), Interaction Center - Interaction Center Level 01 (Text), Territory - Territory Level 01 (Key), Territory - Territory Level 01 (Text), Process Code Group - Process Code Group Level 01 (Key), Process Code Group - Process Code Group Level 01 (Text), Process Code - Process Code Level 01 (Key), Process Code - Process Code Level 01 (Text), Process Category - Process Category Level 01 (Key), Process Category - Process Category Level 01 (Text), Process Catalog - Process Catalog Level 01 (Key), Process Catalog - Process Catalog Level 01 (Text), Reason (Code) - Reason (Code) Level 01 (Key), Reason (Code) - Reason (Code) Level 01 (Text), Reason (Code Group) - Reason (Code Group) Level 01 (Key), Reason (Code Group) - Reason (Code Group) Level 01 (Text), Reason (Catalog) - Reason (Catalog) Level 01 (Key), Reason (Catalog) - Reason (Catalog) Level 01 (Text), Calendar day - Calendar day Level 01 (Key), Calendar day - Calendar day Level 01 (Text), Cal. year / month - Cal. year / month Level 01 (Key), Cal. year / month - Cal. year / month Level 01 (Text), Cal. year / quar - Cal. year / quar Level 01 (Key), Cal. year / quar - Cal. year / quar Level 01 (Text), Calendar year / week - Calendar year / week Level 01 (Key), Calendar year / week - Calendar year / week Level 01 (Text), Calendar year - Calendar year Level 01 (Key), Calendar year - Calendar year Level 01 (Text), Fiscal Year Variant - Fiscal Year Variant Level 01 (Key), Fiscal Year Variant - Fiscal Year Variant Level 01 (Text),

2013/06/12  7:05:05 PM:       QVX_UNEXPECTED_END_OF_DATA: RSR_MDX_CREATE_OBJECT failed after 00:00:00 Key = RFC_COMMUNICATION_FAILURE (

2013/06/12  7:05:05 PM:       LOCATION    CPIC (TCP/IP) on local host with Unicode

2013/06/12  7:05:05 PM:       ERROR       no conversation found with id 01546894

2013/06/12  7:05:05 PM:       TIME        Wed Jun 12 19:05:04 2013

2013/06/12  7:05:05 PM:       RELEASE     720

2013/06/12  7:05:05 PM:       COMPONENT   CPIC (TCP/IP) with Unicode

2013/06/12  7:05:05 PM:       VERSION     3

2013/06/12  7:05:05 PM:       RC          473

2013/06/12  7:05:05 PM:       MODULE      r3cpic.c

2013/06/12  7:05:05 PM:       LINE        9101

2013/06/12  7:05:05 PM:       COUNTER     187

2013/06/12  7:05:05 PM:       )

2013/06/12  7:05:05 PM:       Error: Custom read failed

2013/06/13  8:59:30 AM:      Execution finished.

If we run the query on the BW side it returns within seconds.

Where can we start tracing the problem?

Thanks

Waldo

Tags (1)
1 Reply
Not applicable

Re: SAP OLAP Data query

Hi.

We face the same problem. Did you find the source or the solution?