Duplicate alias and network domain for the user.

(0) Share

Report

Posted on by E. R.

739

Dears,

when trying to change the preferred time zone (tools -->options) the following error appear (Duplicate alias and network domain for the user).

Please advise how to avoid such error and how to change the Time zone from coordinated universal time to another one.

Thanks in advance.

Regards

Elie

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Martin Dráb 237,904 Most Valuable Professional on at

Like (0)

Report

Please look at UserInfo table and check if there is another user with the same alias and domain. It's an invalid setup and you'll have to fix. If one domain user have two accounts to AX, how would AX know which one to use?

Was this reply helpful? Yes No
E. R. 739 on at

Like (0)

Report

Dear Martin,

I am using admin user. and it is available in user info table. all users use the same network domain but different ID and network Alias.

Please advise.

Was this reply helpful? Yes No
Martin Dráb 237,904 Most Valuable Professional on at

Like (0)

Report

Ensure yourself that you don't have both the admin and a normal user pointed to the same domain account. If you're 100% sure that you're setup is correct, you can use the debugger to see why the error is thrown or to create a support ticket with Microsoft.

Was this reply helpful? Yes No
E. R. 739 on at

Like (0)

Report

If I change the preferred time zone in userinfo table using update sql querry. will not work?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

It will work, but it doesn't fix the error.

Your user will have a new timezone. But the error with double allias and domain isn't gone.

Was this reply helpful? Yes No
E. R. 739 on at

Like (0)

Report

I found this error in the event viewer when trying to change the preferred time zone in AX.

Cannot insert duplicate key row in object '[Reporting].[SecurityPrincipal]' due to trigger '[Reporting].[SecurityPrincipal_Insert_UniqueName]'.

The transaction ended in the trigger. The batch has been aborted.

--- Exception Dump ---

Caught Exception: [System.Data.SqlClient.SqlException] Cannot insert duplicate key row in object '[Reporting].[SecurityPrincipal]' due to trigger '[Reporting].[SecurityPrincipal_Insert_UniqueName]'.

The transaction ended in the trigger. The batch has been aborted.

Stack trace:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.Dynamics.Performance.Integration.Reporting.Adapter.CompanyProvider.Finish()

at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.CommitBulkWriter()

at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.GetTaskExecutionResult(Task`1 processRecordsTask)

at Microsoft.Dynamics.Integration.Service.Tasks.MapWork.Run()

at Microsoft.Dynamics.Integration.Service.Tasks.MapTask.RunImplementation()

Component: Microsoft.Dynamics.Integration.Common.TraceLog

User: Indevcoplastics\MR

Machine: AOSPROSRV-1

is it related to the previous error "Duplicate alias and network domain for the user"

Can anyone help?

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

Hi All,

I resolved this error by setting the actual SID ID in Userinfo table. That's mean i found Duplicate SID ID of two users in Userinfo table. As i remove duplicate SID ID the issue was solved.

Best Regards

Shabir Ahmad

Was this reply helpful? Yes No