Cannot open Workbook after data refresh

Question

I have published a PowerPivot Workbook to Sharepoint and scheduled for a automatic "Data Refresh" once a day. After the "Data Refresh" it's not possible to open the Workbook and i get the message that it is corrupted. "The file is corrupt and cannot be opened" is the exactly error. Here is the fun part. The sandbox database is present on my SSAS and I can open it using both SSMS and Excel. Only possible solution (Don't know if it works) is to install a hotfix. Am I the only one facing this unbeliavable problem ???? My experience so far is that Powerpivot works great in Excel but the Sharepoint Integration have a lot of issues.. TIA

Bobby Henningsen

 

---

bobhen

Answer 1

I have some more info about this issue.

 

I have a Workbook called "Sales Focus". On the SSAS instance I have a database called "Sales Focus Sandbox". So far so good. When refreshing (which actually is a processing) I can see a new database created "Sales Focus Process". I guess what it is supposed to happen is that this new database will be processed and it is supposed to replace the old one. Here is what is happening further. The switch seems to happen and I can use my workbook but my powerpivot gallery shows the error in the thumbnail. I guess everthing is cached or ? When I close and then reopen my Powerpivot Gallery the workbook reports the error when trying to open it and on the SSAS instance a database called "Sales Focus Process" suddenly appears again. And this one never dissapears and my Workbook is f... up and I have to publish it again. And my Event log has NO ENTRIES of any error. My "Data Refresh Job" tells me that everything is OK. And it is pretty frustrating that these apparently simple things will not work. Please HELP!!!  

---

bobhen

Answer 2

Looks like I solved the problem somewhat. I took a look at my Unattendeaccounts and changed them to use a "High Privilege" user (Not best practice but...). Does any of this ring a bell ?

BH

 

---

bobhen

Answer 3

Well I take it all back cause hat seemed to be working isn't working at all. All of sudden the only database residing on SSAS is the "Sales focus Process" database. The other one is gone.. Can someone please tell what the h... is happening ? 

---

bobhen

Answer 4

 

 

Hi bobhen,

 

I'm sorry to hear you're having problems with data refresh. I have a couple of questions for you. Can you open the workbook after the data refresh in the browser? And in a Excel Client with PowerPivot? Does it fail on both with the same error? Also, can you give me more details on your farm topology? Is it a single box running everything, or is it a multi-machine farm?

It'd be helpful if you could send me the ULS logs of the server that is refreshing / processing your workbook. If you prefer, you can send me directly your logs. My email is mtn at microsoft.com.

Best,

Mariano

Answer 5

Hi Mariano,

thanks for your reply but it seems like my problems have disappered. Here's what I did :

I installed a hotfix for SQL Server 2008 R2. My version is now 10.50.1720 whick is a cummulative fix (CU2). After that my workbook refresh did the job and my workbooks was still available. Still couldn't open in Excel but that turned out to be the "trust Settings" in Excel so now it seems that everything is OK..

Best Regards

Bobby

 

 

---

bobhen