David Francis Blog : PerformancePoint CTP1 - Planning Assignment doesn't render issue and solution from Microsoft

 

PerformancePoint CTP1 - Planning Assignment doesn't render issue and solution from Microsoft

Here is a useful bit of info from Mark Yang at Microsoft if you ever get the following issue in the CTP1 build of PerformancePoint Planning.

I had been working/playing with the assignment and workflow functionality of PerformancePoint Planning and had created a number of form templates.

I'd set up a basic assignment using a form to be accessed by only one user and approved by another. The assignment appeared in the list but when the user clicked on the assignment they got the following:

'Error retrieving latest timestamps from Analysis Server'

'Internal Error Message: System.Web.Services.Protocols.SoapException: Failed to retrieve timestamp from workflow data from table Assignments'

at the Caching Assignments stage and the form retrieval stage.

When I ran the scenario with SQL profiler on, it appeared to be running a stored proc called bsp_BizFormGetByFormId with the GUID of the very first form I ever created in the system (different name etc etc).

Apparently according to Mark this is a known issue with CTP1 and is to do with the storing of information about assignments in the Offline Cache.

So here is his solution:

Try manually deleting your assignment cache by deleting the files from \Documents and Setttings\<user_name>\Local Settings\Application Data\Microsoft\PerformancePoint\OfflineCache and restart your Excel Client.

I have to admit I had to actually reboot my server for it to work, but work it did.

Thanks again Mark.

I'd highly recommend if you aren't signed up to the PerformancePoint newsgroups (microsoft.beta.office.performancepoint.planning and microsoft.beta.office.performancepoint.monitoranalyze) that you do so.

Source: David Francis Blog : PerformancePoint CTP1 - Planning Assignment doesn't render issue and solution from Microsoft