web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

management reporter 2012 "Operation could not be completed...bad reference" error

(0) ShareShare
ReportReport
Posted on by 30

I've tried several MR 2012 installs.  I tried upgrading our MR 2.0 installation and even tried a fresh install having MR2012 create a new database.  When I try to run a basic report I receive an error stating "Operation could not be completed because doing so would create a bad reference".  I looked in the Windows Event Viewer and found the following error:

Excerpt from Windows Event Viewer

Microsoft.Dynamics.Performance.Reporting.Common.ReportingReferenceException: The operation could not be completed because doing so would create a bad reference. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "Task_TaskType_Id". The conflict occurred in database "ManagementReporter2010", table "Scheduling.TaskType", column 'Id'.

The statement has been terminated.

I don't receive any errors during the install of MR 2012.  Any ideas?  I will keep "tinkering" on my own to see if I can get things working.  Thanks for any information.

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Steve Crandall Profile Picture
    30 on at

    I discovered the problem.  I had forgotten to install the Management Reporter Process Service during the initial install.  Sorry for asking the question before I tried all the obvious solutions.  Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans