I just started a job where I'm supporting a SharePoint server with the Datalink Server and Excel Data Services. I don't know a ton about how the server was setup, or its history in general. We just started receiving errors in the excel webpart, in the cells where we would normally see the values returned by datalink:
Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))
This error is repeated in every cell, where we would normally have a value from PI. If I download the excel sheet from the sharepoint site, all the values are returned normally from PI. My question: Does anybody have an idea what is causing this, or a hint on where to look next? I've started looking at the sharepoint and pi server logs, but I haven't seen anything that looks like a smoking gun at this point.
Edit: I also thought it worth mentioning that other PI webparts are able to retrieve PI data without issue. It is just the Excel Data Access part that is having issues.
Many thanks in Advance!