cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DN Member
Member

SAP BW timeout option, runtime errorcode 2147467259

I can connect to my SAP Business Warehouse server.

I used this tutorial, setting Environment Variables:  https://wiki.scn.sap.com/wiki/display/ABAPConn/Download+and+Installation+of+NW+RFC+SDK

 

When I load only one month of data, the query is ok. Power BI is ok.

But when I load a larger period, 6 months or more, I get the error below after 9-10 minutes.

Is this a timeout error? (that 10min limit error?)

Or another kind of error? The ErrorCode does not help me to find out what´s wrong...

 

DataSource.Error: SAP Business Warehouse: RfcInvoke failed(RFC_ABAP_RUNTIME_FAILURE): TSV_TNEW_PAGE_ALLOC_FAILED

Detalhes:

    DataSourceKind=SapBusinessWarehouse

    DataSourcePath=**MyServer**

    ErrorCode=-2147467259

 

 

When I load Web pages, I can set a timeout limit.

When will this option be available for SAP BW cubes?

 

SAP options:

sap.png

 

 

WEB options:

web.png

 

15 REPLIES 15
DN Member
Member

Re: SAP BW timeout option, runtime errorcode 2147467259

I retested some queries (cubes) in SAP BW...

It seems that this runtime error actually is the limit of 750k cells from SAP BW.

SAP BW returns a maximum of 750.000 cells. If Power BI tries to read a cube bigger than 750k cells, SAP BW locks up and the error comes in on Power BI.

Can someone please confirm this?

 

Some people have suggested to change SAP BW to SAP HANA, is it worth it?
Does SAP HANA have a cell limit like SAP BW?

DN Member
Member

Re: SAP BW timeout option, runtime errorcode 2147467259

One more test:

I loaded 5 months worth of data from my SAP BW server, total of 2.047.072 cells.

Way more cells than the 750.000 original limit from SAP BW.

Average of 409k cells per month.
I cannot load 6 months of data. Using the average, it should get a total of 2.456.486 cells.
So I think this limit if from Power BI itself, not from SAP BW...

v-huizhn-msft Super Contributor
Super Contributor

Re: SAP BW timeout option, runtime errorcode 2147467259

Hi @DN,

Please enable the Power BI desktop trace log, then repeat the steps to connect to SAP BW, share the trace file with us. You can upload files to OneDrive and share the link here.
 
Best Regards,
Angelia

DN Member
Member

Re: SAP BW timeout option, runtime errorcode 2147467259

Ok, understood. But I am no longer with access to SAP BW server. I asked my coworker to try and enable trace log while performing the data load. As soon as I have the trace log file, I will share it here.

 

About the timeout option, there is an option to set timeout command, according to this March update.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-update-feature-summary/
But where should I use this command? Inside the MDX box?
What are the correct syntax and parameters?

Could someone please provide an example of this command?

v-huizhn-msft Super Contributor
Super Contributor

Re: SAP BW timeout option, runtime errorcode 2147467259

Hi @DN,

In the blog, it said you get data from SQL Server database. We can add T-SQL command under the “Advanced options” section in data source dialogs. For example, we can use T-SQL @@LOCK_TIMEOUT function to set the timeout.

Best Regards,
Angelia

DN Member
Member

Re: SAP BW timeout option, runtime errorcode 2147467259

Hi Angelia. Please, where or what should I look for in the trace log?

any error code, script sequence?

there is a lot of empty files as well...

 

What kind of private information if there inside the trace log? I am not sure I am allowed to shared it...

v-huizhn-msft Super Contributor
Super Contributor

Re: SAP BW timeout option, runtime errorcode 2147467259

Hi @DN,

For looking for trace log, please review and follow this blog.

If there is private information you're worried about. You can create a support ticket on the right bottom to check your issue, which is safe.

Best Regards,
Angelia

DN Member
Member

Re: SAP BW timeout option, runtime errorcode 2147467259

thanks for the blog, but the attached pbix file does not work. I get a lot of errors inside the query.
I will try to get a support ticket.

DN Member
Member

Re: SAP BW timeout option, runtime errorcode 2147467259

I opened a support ticket, this is the answer I got:

 

Contacted the Product team and below is the update form the Product team

 

In the case posted to the forums, this means that their server ran out of memory while running the query. That’s a limitation on the server side. They may be able to overcome this by running more and then combining the data locally.

 

DataSource.Error: SAP Business Warehouse: RfcInvoke failed(RFC_ABAP_RUNTIME_FAILURE): TSV_TNEW_PAGE_ALLOC_FAILED

 

But I don´t think this is correct...

When I loaded the cube using another BI program, it loads the whole cube.

If I use Direct Query, Power BI is able to load the whole cube, but than the user interface is a lot more limited (cannot view data, relationships, cannot load more data on the same project).

Power BI somehow can only import 5 months of data (not direct query, import mode).

I know Power BI will convert the cube view to tabular view, but will this occur inside the SAP BW server? Is this the reason for the error?

This simple question was not answered by the ticket guy.