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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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'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

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

      Hi Anonymous,

      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

  • 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.