Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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   Wh...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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.