Skip to Content
author's profile photo Former Member
Former Member

Error xls 000009 Create Instance of Provider Failed - while viewing or editing a Dashboard

Hi all,

I'm having a trouble while viewing or editing a dashboard craeted on dashboard design.

The unx is based on a SQL Server 2008 R2 database. One important thing to consider is that when i restart the Dashboard servers it works fine but after some usage the problems come back again.

Above the screenshot of the issue

Thanks in advance.

Best Regards,

Renan Ribeiro

printsuphab12.jpg (39.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 08, 2012 at 08:06 PM

    Hi Renan,

    Refer to the SAP Note-

    1698180 - Error:"Request processing failed. (XLS 000009)" when dashboard created on universe query with OLEDB connectivity in Dashboard Designer 4.0 is previewed, if helpful !!!

    Also, kindly provide detail information if you are trying to connect to ODBC or OLEDB connectivity?

    Regards,

    Namita

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 08, 2012 at 04:23 PM

    Hi

    what version you are using as similar issues was solved by upgrading to the latest version of BI 4.0 currently SP4 patch 4 ?

    Regards

    F.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2013 at 10:55 AM

    After long wait the ADAPT01616267 is still not related on SP5 or any SP5 patch.

    I just found a new ADAPT01673874 ("Dashboard can be viewed and refreshed successfully on BI launch pad and dashboard preview mode. There should not be error Request processing failed (XLS 000009) when view dashboard through BI launch pad or dashboard preview mode.) on the last released SP5 patch 3 - 25/01/13.

    Maybe this ADAPT01673874 is replacing the apparently unsolved ADAPT01616267 mentioned on SAP Note 1698180 or do i have to keep waiting for the resolution of the last one ?

    Thanks again !

    Best Regards,

    Renan Ribeiro

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      We are running into these errors on a daily basis (in the AM), and the only way we know to make them go away for a period of time is to reboot our main Business Objects server. We run a lot of publications over night and I am suspicious of this is related. We are currently running sp05 patch 4 on a Windows 2008 R2 server.

      We have moved some (but not all) of our dashboards to ODBC connections per the reference SAP note, however we are still getting these errors on all of our dashboards.

      1. Has anyone had success with changing the connection type?
      2. Has anyone else had success in a different way to clear this error up?

      Any help would be appreciated. I am planning to apply SP5.5 tonight, which was just released, to see if I have better luck.

      Thank you.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2012 at 05:11 PM

    Hi,

    I think this is exactly what i need cause the universe connection is OLEDB and i'm using the query component of Dashboard Desuign. I'm currently working with SP02 P09 so i need to upgrade according to the sap note reffered.

    Thank you for the very helpful info's!

    I'm coming back soon to provide details of the solution.

    Best Regards,

    Renan Ribeiro

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 18, 2013 at 09:50 AM

    Hello everyone,

    I have the same problem described, but note "1698180 - Error:"Request processing failed. (XLS 000009)" when dashboard created on universe query with OLEDB connectivity in Dashboard Designer 4.0 is previewed " is not usefull for us.

    We have BO 4.0 SP 7 patch 1...


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.