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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / MR: The name already e...
Microsoft Dynamics GP (Archived)

MR: The name already exists.

(0) ShareShare
ReportReport
Posted on by Community Member

This is the first time we are seeing this error... "The name already exists" - This error happen when we double-click on the MR icon.
We were able to access MR last week !!! Can someone have a clue on this?  If so, please let me know / thanks

*This post is locked for comments

I have the same question (0)
  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Anny,

    Are you trying to launch the MR Designer from the server side or on a workstation ? In the second case, did you try to re-install the MR Designer and Viewer ?

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Does this happen when you double click either on the Report Viewer and Designer ?

    Does it happen on all machines ?

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    There seems to be a sync between our comments Mr. Bucher  !

    At the exact same second

  • Community Member Profile Picture
    Community Member on at

    Good to hear from you Béat,

    This error happen on the workstation and also on the server... again, we were able to access the application last week - I'm wondering what could have changed... the customer says "nothing has been changed"...

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    LoL sorry for stealing the priority :-)

  • Community Member Profile Picture
    Community Member on at

    At this time, yes - The issue happen on all workstations - that's what make me thinking of an Active Directory issue but I cannot find it...

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Anny,

    Nice to see you here again :-)... Have you tried to launch the MR Configuration Console to check if the databases are properly configured to MR ? which CU version is it running on ?

  • Community Member Profile Picture
    Community Member on at

    Let me get the information and I will get back to you

  • Community Member Profile Picture
    Community Member on at

    ok... Now it seems that there was a Server Crash yesterday... since then we found the following error:

    System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.ControlFontStyle' with unique index 'Name'. The duplicate key value is (Default).

    The statement has been terminated.

      at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)

      at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)

      at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)

      at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)

      at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)

      at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.DesignerDataExecution.<>c__DisplayClassa.<Execute>b__8()

      at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.DesignerDataExecution.Execute[T](Func`1 transact, Func`1 initializeConnection, SetConnectionDelegate setConnection, Func`1 execute)

      at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.FRxFontStyle.<>c__DisplayClassf.<GetOrCreateDefaultFontStyle>b__c()

      at Microsoft.Dynamics.Performance.Reporting.DataAccess.DataExecution`1.Execute[T](Func`1 transact, Func`1 connect, Func`1 execute, Boolean retry)

      at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.FRxFontStyle.GetOrCreateDefaultFontStyle(Boolean& wasCreated)

      at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.FontStyleService.<GetDefaultFontStyle>b__8()

      at Microsoft.Dynamics.Performance.Common.Caching.Owner.CacheHelper`1.GetAndRefreshIfExpired(Func`1 refreshFunction)

      at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.SecureExecuteInternal[TResult](Func`1 hasPermission, Func`1 executor)

      at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor)

    ClientConnectionId:a94b332e-e45f-439a-9413-aecce3b353f8

                   Component: Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.FontStyleService

                   User: Customer\admin

    This following error happen also:

    Microsoft.Dynamics.Performance.Reporting.Common.ReportingPermissionException: You don't have permission to perform this operation.

      at Microsoft.Dynamics.Performance.Reporting.Repository.PublicExtensions.AssertView(Permission perm)

      at Microsoft.Dynamics.Performance.Reporting.Repository.Service.RepositoryService.<>c__DisplayClassf.<ListItems>b__b()

      at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.<>c__DisplayClassd`1.<SecureExecute>b__c()

      at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.SecureExecuteInternal[TResult](Func`1 hasPermission, Func`1 executor)

      at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor)

                   Component: Microsoft.Dynamics.Performance.Reporting.Repository.Service.RepositoryService

                   User: Customer\admin

    so... referring to these error, I think we will simply need to uninstall and reinstall... :S

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Anny,

    By default, MR login with domain\windows credentials, that credentials from SecurityPrincipal table. while changing the company, you can use your GP login credentials.

    Please run the SecurityPrincipal, SecurityUser table to ensure all the users and their roles are properly configured.

    Please have the look on the below link related to the error.

    http://community.dynamics.com/gp/f/32/t/84887.aspx

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans