Re: SAP OLAP Data query - Qlik Community

Report Inappropriate Content · ‎2013-06-13

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

Report Inappropriate Content · ‎2013-09-26

Hi.

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