topic Re: SAP BW connectivity issue in Power Query

SAP BW connectivity issue

saagarkinja — Mon, 13 Jun 2016 05:48:16 GMT

Dear All,

I am trying to integrate and fetch data from SAP BW using Power BI SAP BW direct connector.

However,after some time it pops up below error message,

-------------

DataSource.Error: SAP Business Warehouse: SYSTEM_FAILURE No more memory available to add rows to an internal table.

Details:

DataSourceKind=SapBusinessWarehouse

DataSourcePath=10.199.4.28/01/921

ErrorCode=-2147467259

----------

I checked and shared with SAP BW Basis team. But they are putting blame on Power BI.

I need help.

If it is SAP BW issue, please let me know expected changes with facts. So, that I can share and take a stand.

If it is on my end, I will decrese the selection of columns.

Please help !

Thanks,
Saagar Kinja

Re: SAP BW connectivity issue

Greg_Deckler — Mon, 13 Jun 2016 13:14:48 GMT

Can you clarify if you are in the Desktop or Service? I am assuming Desktop and are you using the SAP Hana Database connector, I do not see the specific one for SAP Business Warehouse. I guess, how are you connecting to it?

Re: SAP BW connectivity issue

tristanstcyr — Mon, 13 Jun 2016 20:13:26 GMT

We have a BW connector in preview.

What does your query look like?

Re: SAP BW connectivity issue

saagarkinja — Tue, 14 Jun 2016 03:56:37 GMT

Hi Smoupre,

Thanks for your kind revert.

I am using Power BI SAP BW Direct connector (Preview) in Power BI Desktop. I am connected to domain and able to communicate with SAP BW server.

Post selecting desired measures and dimensions ( I selected 2 measures and 4 dimensions), is starts "Loading into Data Model".

After some time, it returns this error mentioned.

Please let me know, if any specifics required.

Re: SAP BW connectivity issue

saagarkinja — Tue, 14 Jun 2016 04:24:03 GMT

HI Tristan,

Thanks for your kind revert.

Yes I am using Power Bi SAP BW direct connector (Preview). I am able to connect and select dimensions and measures.

Please note, I am not using MDX ( I wrote multple MDX referring their Info Cubes but not working). I am selecting it manually.

In advance editor page, it is very simple,

------------------

let
    Source = SapBusinessWarehouse.Cubes("----------", "----", "---"),
    #"$INFOCUBE" = Source{[Name="$INFOCUBE"]}[Data],
    #"$---------" = #"$-----------"{[Id="$------------"]}[Data],
    #"Added Items" = Cube.Transform(#"$-------", {{Cube.AddAndExpandDimensionColumn, "[----]", {"[---].[---]"}, {"--------------------------------------"}}, {Cube.AddAndExpandDimensionColumn, "[----------]", {"[--------].[LEVEL01]"}, {"--------"}}, {Cube.AddAndExpandDimensionColumn, "[---------]", {"[--------].[LEVEL01]"}, {"---------------------"}}, {Cube.AddAndExpandDimensionColumn, "[---------]", {"[------------].[---------]"}, {"------------"}}, {Cube.AddMeasureColumn, "-------------------", "[Measures].[------------]"}, {Cube.AddMeasureColumn, "------", "[Measures].[-------]"}})
in
    #"Added Items"

----------------------------------------------

Please let me know, if any specific details required.

Re: SAP BW connectivity issue

saagarkinja — Mon, 11 Jul 2016 06:49:22 GMT

Hi All,

Thanks for your response.

Please note,

1- As SAP BW is Primary DW for Org., SAP Basis team doesn't want to manipulate Default Table size.

2- I tried minimizing the size of my query, still same issue. So, we shared a Frown to Power BI Desktop Support Team. The issue is under process.

I think, SAP BIW connector should not be used and referred when planned to connect for Stable Solution.

Let us wait for genral availability of preview connector.

Thanks,

Saagar Kinja

Re: SAP BW connectivity issue

manisharora — Tue, 12 Jul 2016 12:04:05 GMT

Hi Team,

I am facing the same issue while extracting fields from Cube(Object).

Connection with BW System has been done. But not able to fetch/extract data from BW system.

PFB the error:-

DataSource.Error: SAP Business Warehouse:

Error occurred when starting the parser: timeout during allocate / CPIC-CALL: 'ThSAPCMRCV' Details: DataSourceKind=SapBusinessWarehouse DataSourcePath=10.40.1.41/00/100

ErrorCode=-2147467259

Please help me to correct this.

Thanks

Manish Arora

Re: SAP BW connectivity issue

tristanstcyr — Thu, 14 Jul 2016 03:54:04 GMT

Hi,

Can you try with the latest Power BI Desktop release and see if the issue still reproduces?

Thanks!

Tristan St-Cyr

Re: SAP BW connectivity issue

saagarkinja — Mon, 01 Aug 2016 05:32:25 GMT

Hi Tristan,

Thanks for your response.

I am getting below error while connecting to SAP BIW,

"Details: "Access to SAP Business Warehouse requires SAP client tools to be installed, including the latest version of SAP Netweaver RFC. See here for more information: https://aka.ms/kgu6rn""

I already downloaded SAP GUI 7.3 with latest patch available. As per SAP Basis team, it is already part of SAP GUI. So, no help.

Request your suggestion.

Thanks,
Saagar Kinja

Re: SAP BW connectivity issue

tristanstcyr — Mon, 01 Aug 2016 15:58:46 GMT

Hi,

Can you make sure that the processor is the same for both installations (32-bit vs 64-bit)? If the architectures don't match, you might be able to find a standalone installer of the Netweaver RFC.

Thanks,

Tristan

Re: SAP BW connectivity issue

saagarkinja — Tue, 02 Aug 2016 04:53:51 GMT

Thanks for your response.

I tried using the 64 bit file and now able to connect to SAP BIW.

This issue remains same, when I increase the period to more than 6 months it returns same error. Already tried filter's and other conditions.

Still no success. Frown is shared.

Please share if you have any suggestions.

Thanks,
Saagar Kinja

Re: SAP BW connectivity issue

tristanstcyr — Sat, 06 Aug 2016 23:59:29 GMT

Aside from adding filters before adding more columns, I don't have a suggestion. Is this a query that you're usually able to fulfill with other tools? If so, can you tell us which ones? Can you check to make sure that the query returns the results in the same way?

Re: SAP BW connectivity issue

saagarkinja — Mon, 08 Aug 2016 05:49:57 GMT

Yes. I tried using SAP Lumira. It shows complete hierarchy structure of Customer information.

Appreciate your help on this.

Thanks,

Saagar Kinja

Re: SAP BW connectivity issue

psakharshete — Wed, 24 Aug 2016 23:46:10 GMT

Hi Sagar,

Could you please provide what exactly you did to resolve this error?

I am also getting this error:

"Access to SAP Business Warehouse requires SAP client tools to be installed, including the latest version of SAP Netweaver RFC. See here for more information: https://aka.ms/kgu6rn"

I have copied librfc32.dll in C:\Windows\System32 folder. I'm on Windows 7.

Appreciate your input.

Regards,

Prasad

Re: SAP BW connectivity issue

psakharshete — Wed, 24 Aug 2016 23:51:06 GMT

Hi Sagar,

"Access to SAP Business Warehouse requires SAP client tools to be installed, including the latest version of SAP Netweaver RFC. See here for more information: https://aka.ms/kgu6rn"

I am getting the same error. Could you provide details of how you resolved this error?

I have copied librfc32.dll in C:\Windows\System32 folder in Windows 7.

Regards,

Prasad

Re: SAP BW connectivity issue

saagarkinja — Mon, 29 Aug 2016 03:33:24 GMT

Dear Psakharshete,

The "Netweaver RFC Library Files" are available on SAP Support Portal. It can be easily downloaded and extracted.

Please note below points,

1-SAP GUI 64-bit is as normally not available. If yes in your organization, you install it and test it the issues will be resolved.

or,

2-Please install 32-bit SAP GUI and download and extract 64 bit Netweaver RFC file to system 32 folder. The issue will resolved.

or,

you send me en email. I will share the .zip file with you.

Thanks,

Saagar Kinja

saagar.kinja@gmail.com

Re: SAP BW connectivity issue

Maring — Sat, 18 Feb 2017 14:24:14 GMT

Hi,

is this has been solved?

I have the same issue and the only thing that helped is to filter the periods of data... which if funny, because it is not enough and SAP BW is running it with no problem.

Why does the PBI cannot load this data size?

Thanks

Marina

Re: SAP BW connectivity issue

eikden — Fri, 12 May 2017 08:16:27 GMT

I have the same issue faced. Anyone already find out the solution to resolve this?

Re: SAP BW connectivity issue

lizaramlee — Mon, 15 May 2017 06:27:44 GMT

hi Manish,

i am now facing same issue..

may i know how u handle to solve it?

Re: SAP BW connectivity issue

KL_SARA — Fri, 07 Jul 2017 15:08:25 GMT

Hello Saagar,

I hope you're doing well.
I am facing the same issue while extracting fields from Cube(Object).

Connection with BW System has been done. But not able to extract data from BW system.

Here is the error message:

DataSource.Error: SAP Business Warehouse:

Error occurred when starting the parser: timeout during allocate / CPIC-CALL: 'ThSAPCMRCV'

Please help me to solve this issue.

Thanks

Best regards,

Sara