Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

PerformancePoint Unexpected Error Occurred 11861

Posted by denglishbi on October 12, 2010

From time-to-time when I am building out a new dashboard with PerformancePoint Services 2010 I will all of a sudden get an unexpected error when I try to create an Analytical Report.  When I create the report and add a measure to the report I simply get the error message “An unexpected error occurred. Error 11861.”

image

An unexpected error occurred. Error 11861. Additional details have been logged for your administrator.
Contact the administrator for more details.

When I try to add items to the report I keep getting a message stating “This data source cannot be used because PerformancePoint Services is not configured correctly. Additional details have been logged for your administrator.”

image

That is a funny message.  Kind of scary as well.  Is my PerformancePoint broken?  Oh no!  Help!  What did someone do to the service?  Wait a second, I just got done setting up KPIs with no problems.  What is going on?

Well the issue is that you have created a data connection that is currently not published (saved) to the server.  KPIs don’t have any issues with this, but the Analytical Reports do.  You will notice other odd things during your PerformancePoint development like this where these two items behave a bit differently.

So if we take a look in the Workspace Browser we will see the pencil on the data source icon in the data connections.  This means that it has been modified and is basically in edit mode.  This could also be the case if it was already saved (published) to the server, but in this case I have not performed an initial save.

image

So if we select the data connection and click the Save icon in the Quick Access Toolbar or do a right-click and select Save then the data connection will end up looking like this:

image

Now if we go back to our Analytical Report we were creating we will see the following message:

image

Drag measures, dimensions, or named sets to Rows and Columns to lay out the report.

Now the designer is happy and we can build out the report and add items to the rows, columns, background, etc.

image

So if you get this message don’t be alarmed and go running off to your SharePoint Farm Administrator, simply take a look at your Workspace Browser and see if you have a connection that needs to be published.

Advertisements

20 Responses to “PerformancePoint Unexpected Error Occurred 11861”

  1. MShoubaki said

    Saved my day…
    Thanks 🙂

  2. Imaan said

    You just saved my day too ! THANK YOU

  3. Liesl said

    Thank you!!!

  4. Ralph Eherts said

    Dan the MAN

  5. ….that saved me hours banging my head against the wall 🙂 thnx

    Martin

  6. Abdul said

    Thanks

  7. Vasu said

    Awesome!! It really saved lot of time for me. Thank you for explaining it so clearly.

  8. vasundra said

    its saved lot of time for me… Thanks a lot….

  9. Bruce Redfern said

    Great tip. Thanks.

    Odd that the icon for other data sources does not appear to change when you save them.

  10. Marco said

    Saved my WEEK!!!!!! a BIG THANKS

  11. Thomas said

    Saved my demo!!! Thanks!

  12. Sam Trna said

    Nice work mate

  13. Sam Trna said

    Actually, just wondering why I didnt see the same thing with the video I saw (the one that came with the book for Knight)

  14. Jon said

    many thanks!

  15. Rich said

    Brilliant – Cheers mate saved a lot of hours hunting :))

  16. […] Reference PerformancePoint Unexpected Error Occurred 11861 Share this:TwitterFacebookLike this:LikeBe the first to like this post. « SQL Saturday Brisbane Event Success […]

  17. Jason Vickers said

    Sir, I’m kind of embarassed that I had to do a search on this error now that I see the fix. Thank you!

  18. Tony Price said

    Awesome – thanks

  19. […] https://denglishbi.wordpress.com/2010/10/12/performancepoint-unexpected-error-occurred-11861/ […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: