PowerPivot and DAX papers,posts,FAQs,webcasts,samples

When I am trying to open previousy saved PowerPivot for Excel file I am getting following error:

In-Proc Engine: Could not load embeded data.

When I click OK, I am getting second time same error message.

After that I am getting message:

"The embedded Gemini data is corrupt. Would you like to delete it and continue using the workbook?"
I have options "Yes" and "No".

I click "No".

Then I am getting next error message:

Unable to load the Gemini in-memory server. Reason: there was a COM exception while loading. Please click 'Details' button for more details.

============================
Error Message:
============================
Exception from HRESULT: 0x800A03EC
============================
Call Stack:
============================
Server stack trace:
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Office.Interop.Excel.OLEDBConnection.Reconnect()
at Microsoft.AnalysisServices.Modeler.FieldList.InProcServer.LoadOLEDBConnection()

============================

Then when I click OK and close workbook.


I tried to extract .abf file from this PowerPivot file as describe here:

powerpivot-info.com/post/92-how-can-i-se...cture-that-is-stored

But when trying to attach this file to Analysis Services database I was getting error message:

Backup file extension can be only .ABF. (Microsoft SQL Server 2008 R2 Analysis Services)

I restored database this way multiple times before, but in this case this file is not recognized.

At the time of file opening there are 6 error generated in the application log:

============================= Error 1
- System
- Provider
[ Name] MSOLAP$LocalCube
- EventID 35
[ Qualifiers] 49441
Level 2
Task 289
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2009-12-04T01:59:16.000000000Z
EventRecordID 4524
Channel Application
Computer Win2008R2-Test1.vd.local
Security
- EventData
\\?\C:\Users\ADMINI~1\AppData\Local\Temp\1\IMBI_DFA2169DACD4EF2BB6C\MS_6d235fed-46ff-4133-af5a-8fe675757ed6.8.db\stocks.0.dim\4.R$stocks$Table1.INDEX.0.idf


================================= Error 2
- System
- Provider
[ Name] MSOLAP$LocalCube
- EventID 19
[ Qualifiers] 49441
Level 2
Task 289
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2009-12-04T01:59:16.000000000Z
EventRecordID 4525
Channel Application
Computer Win2008R2-Test1.vd.local
Security
- EventData
An error occurred when loading the stocks dimension, from the file, '\\?\C:\Users\ADMINI~1\AppData\Local\Temp\1\IMBI_DFA2169DACD4EF2BB6C\MS_6d235fed-46ff-4133-af5a-8fe675757ed6.8.db\stocks.44.dim.xml'.


================================ Error 3
- System
- Provider
[ Name] MSOLAP$LocalCube
- EventID 19
[ Qualifiers] 49441
Level 2
Task 289
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2009-12-04T01:59:16.000000000Z
EventRecordID 4526
Channel Application
Computer Win2008R2-Test1.vd.local
Security
- EventData
An error occurred when loading the Sandbox cube, from the file, '\\?\C:\Users\ADMINI~1\AppData\Local\Temp\1\IMBI_DFA2169DACD4EF2BB6C\MS_6d235fed-46ff-4133-af5a-8fe675757ed6.8.db\Sandbox.188.cub.xml'.


========================= Error 4
- System
- Provider
[ Name] MSOLAP$LocalCube
- EventID 35
[ Qualifiers] 49441
Level 2
Task 289
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2009-12-04T01:59:25.000000000Z
EventRecordID 4527
Channel Application
Computer Win2008R2-Test1.vd.local
Security
- EventData
\\?\C:\Users\ADMINI~1\AppData\Local\Temp\1\IMBI_4AC37470222247ADB430\MS_6d235fed-46ff-4133-af5a-8fe675757ed6.8.db\stocks.0.dim\4.R$stocks$Table1.INDEX.0.idf

=============================== Error 5
- System
- Provider
[ Name] MSOLAP$LocalCube
- EventID 19
[ Qualifiers] 49441
Level 2
Task 289
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2009-12-04T01:59:25.000000000Z
EventRecordID 4528
Channel Application
Computer Win2008R2-Test1.vd.local
Security
- EventData
An error occurred when loading the stocks dimension, from the file, '\\?\C:\Users\ADMINI~1\AppData\Local\Temp\1\IMBI_4AC37470222247ADB430\MS_6d235fed-46ff-4133-af5a-8fe675757ed6.8.db\stocks.44.dim.xml'.

============================ Error 6
- System
- Provider
[ Name] MSOLAP$LocalCube
- EventID 19
[ Qualifiers] 49441
Level 2
Task 289
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2009-12-04T01:59:25.000000000Z
EventRecordID 4529
Channel Application
Computer Win2008R2-Test1.vd.local
Security
- EventData

An error occurred when loading the Sandbox cube, from the file, '\\?\C:\Users\ADMINI~1\AppData\Local\Temp\1\IMBI_4AC37470222247ADB430\MS_6d235fed-46ff-4133-af5a-8fe675757ed6.8.db\Sandbox.188.cub.xml'.


I do not think I did anything to data to corrupt it, so it looks like a bug to me. Anybody else experience this?

Did you ever get a response to this? I am having the exact same problem right now and it's very frustrating!

same issue for several times.
any good new about this topic?

i48.tinypic.com/2mhzmt5.jpg
i46.tinypic.com/sg5mqr.jpg
i50.tinypic.com/ifcqoy.jpg

thx in advance!

regards

Tim, Jason,

Many people reported this issue and it clearly looks like a bug.

Officially there is just one known issue with corruption, but I do not believe that my case matches description.

If you follow this link: http://go.microsoft.com/fwlink/?LinkID=155801

You will see following notes:

---------------------------
PowerPivot for Excel Issues
3.2.1 NEW: Creating a Relationship Can Render a Workbook Unusable
Under certain circumstances, PowerPivot data in a workbook can be irretrievably corrupted.

This problem occurs if all of the following conditions are met:

The user opens a workbook that contains a set of tables, or imports a set of tables, and then saves the workbook.

The user then creates a relationship where one of these saved tables acts as the foreign key table. This relationship can either be created manually through the PowerPivot window or automatically by using the automatic relationship detection functionality from the Gemini Task Pane.

The user saves the workbook without any other change to the foreign key table. This can be an explicit Save by the user or an AutoRecover Save by Excel.

The workbook will now be corrupted and cannot be reopened.

To avoid this issue, make another change on the foreign key table after creating the relationship from it. Changes that avoid this problem include:

Refreshing the contents of the foreign key table. In the case of a table created through copy and paste, data has to be pasted into the table again after the relationship has been created.

Adding/deleting a column in the foreign key table.

Updating the formula of a column in the foreign key table.

Changing the data type of any column in the foreign key table.

Renaming the foreign key table.

Important:
Building or refreshing PivotTables, PivotCharts, or Slicers will not avoid this problem.

----------------------------

At this point I believe we just have to wait for Microsoft to release another build.

Vidas Matelis

In another forum Mark Ayo reported:

I was getting this error all the time in CTP3. After reading Section 3.2.1 in the release notes, rather than trying to interpret the various changes proposed, I just made it a habit to refresh all data sources immediately after creating or changing any relationships. It is particularly important to do this before the workbook is saved, no matter whether it is an explicit save or an AutoRecover save. You don’t have to refresh the data sources after each relationship created, only when you are finished creating all your relationships. If later you add any relationships to your model, again...immediately refresh all data sources.

I have not encountered this error since I adopted this approach...but I can still easily reproduce the error by violating this approach.

Here is link to this original post

Hi All

I am new to powerpivot and have been so frustrated to date wasting time due to this error.

Doesnt matter how I rebuild it the same error occurs.

I will try workaround mentioned by Vidas and see what happens however I first have to rebuild from scratch I think.

I cannot beleive Microsoft have released the product yet they knew the error existed in the beta versions!

Very cranky

Wicksyc,

As I said, please check versions of your Excel and PowerPivot add-in. I have not encounter any problems with powerpivot corrupting excel workbook since RTM release. There is something with your installation that is causing this and it is definatelly not a norm.

Thankyou for your response
Where do I get version information in Excel and powerpivot?
I would like to get to the bottom of this before I continue
Thanks
Colin

Colin,

Follow this link:

powerpivot-info.com/post/89-q-how-can-i-...talled-on-my-machine

At the start of the above post there is info on how to check PowerPivot version and last paragraph explains how to check Excel version.

Thanks again

Powerpivot 10.50.1600.1

Excel via File>Help menu 14.0.4760.1000
Excel via Office14 directory 14.0.4756.1000

Colin