"Index cannot be created on view 'ReportingVirtualDataAreaView1'" error during Management Reporter 2012 CU14 deployment

Symptoms
Error in Management Reporter 2012 integration log:

Index cannot be created on view 'ReportingVirtualDataAreaView1' because the underlying object 'DIRPARTYTABLE' has a different owner.

Cause
This will occur when the Dynamics AX database resides on SQL 2008 R2 and earlier and the Dynamics AX integration account specified in the deployment is different from the account running the AOS.
Resolution
Run the following script on the Dynamics AX database to grant authorization on the ReportingIntegration schema to dbo:

ALTER AUTHORIZATION ON SCHEMA::ReportingIntegration TO dbo


More information
This error only occurs on SQL 2008 R2 and earlier.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 3149466 - Last Review: 03/29/2016 07:02:00 - Revision: 1.0

Microsoft Dynamics AX, Microsoft Dynamics AX 2012, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R3 CU8, Microsoft Management Reporter, Microsoft Management Reporter 2012

  • kbmbsmigrate kbsurveynew KB3149466
Feedback