Error Invalid object name 'p_PrincipalEntityMapReinitBulk' on CRM 2011 Rollup 7

Question

Hi,

I get this error on several tennants in a large (test) environment

Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'p_PrincipalEntityMapReinitBulk'

Kind Regards

Alexander

Answer 1

Hi,

I get this error on several tennants in a large (test) environment

Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'p_PrincipalEntityMapReinitBulk'

Kind Regards

Alexander

In the rollup procedure log that is ;-)

I just found out that the failing tenants still are on level UR 5.

I therefore de-installed UR7 and tried to upgrade the tenants from UR 5 to UR 6 but that resulted in the same error.

I have installed UR 7 again and dropped and imported a UR 5 tenant. Still same error:

                  System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'p_PrincipalEntityMapReinitBulk'.

Logged MS Support case

Answer 2

Was Microsoft able to provide any support on this? We're also seeing the same problem.

Answer 3

I solved this by scripting the missing procedure from a working organization and importing it onto the organization database that wasn't updating. I don't know if it'll be supported by MS in this way, but it worked. :)