MR: The name already exists.

(0) Share

Report

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

All responses (10)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: MR: The name already exists.

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
Community Member on at

Like (0)

Report

RE: MR: The name already exists.

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
Community Member on at

Like (0)

Report

RE: The name already exists.

Let me get the information and I will get back to you
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: The name already exists.

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 on at

Like (0)

Report

RE: The name already exists.

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 Gee... 28,058 Moderator on at

Like (0)

Report

RE: The name already exists.

LoL sorry for stealing the priority :-)
Community Member on at

Like (0)

Report

RE: The name already exists.

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"...
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: The name already exists.

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

At the exact same second
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: The name already exists.

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

Does it happen on all machines ?
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: The name already exists.

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 ?