Forum Discussion
SAP BW connectivity issue
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
22 Replies
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?
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.
We have a BW connector in preview.
What does your query look like?
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.
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
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
Hi,
Can you try with the latest Power BI Desktop release and see if the issue still reproduces?
Thanks!
Tristan St-Cyr
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
Hello everybody,
I'm facing exactly the same issue. I get list of SAP BW dimensions and facts, but when I try to query cube I ALWAYS get this error:
DataSource.Error: SAP Business Warehouse: Error occurred when starting the parser: timeout during allocate / CPIC-CALL: 'ThSAPCMRCV'
Thanks for the help,
Zilvinas
Hi Zilvakas,
Have you already found solution?
I also met this case and solved this with below way.
1. See OSS Note 1995588 . It descrives cause of error. ( But it's not intuitive rather confusing).
2. Place appropriate version of librfc32.dll on bin directory of BW server.(not client side)
Above note claims required dll shoud be 32bit but in my case we needed 64bit version.
3. After placement , you maybe come across with another timeout error coming from ABAP program compilation.
If so , after a second, you can try again and finally get data from BW.
Hope this helps,
Was there ever a resolution to this?
