Forum Discussion
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:
WEB options:
15 Replies
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?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...Hi Anonymous,
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
