lunes, 9 de diciembre de 2013

Cannot create a record in Reporting Services entity cache (SRSModelEntityCache). Entity identifier: XXX, An AX view entity. The record already exists.

Creating a new analysis services project I encountered the following error:
Cannot create a record in Reporting Services entity cache (SRSModelEntityCache). Entity identifier: 7542, An AX view entity. The record already exists.
The message is almost trying to be helpful, providing us the id of the object that is duplicated.
Stepping through my various views associated to the perspectives, I realised that I had done a very silly thing(TM).  I would effectively be adding the same entity to the various cubes twice.  In this case to the shared dimensions perspective.

Perspectives under the microscope

Remember that the wizard for generating cubes adds certain views for us.  The following selection would add the offending BIExchangeRateView.  As you can see from the above image, perhaps I should remove other BI* views as well, although BISampleOrgHierarchyView may be okay.