1 Reply Latest reply: Sep 26, 2013 3:20 AM by Павел Шульгин RSS

    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