Finance | Project Operations, Human Resources, ...

Error occured during database import process from UAT to DEV Environment

(0) Share

Report

Posted on by Sowmya170106@gmail.com

Hi,

I was trying to import the UAT Database to DEV, while Importing an unexpected error as occurred i.e., *** An unexpected failure occurred: Data plan execution failed with message One or more errors occurred. (One or more errors occurred. (One or more errors occurred. (Violation of PRIMARY KEY constraint 'PK__CLASSIDT__D9C1FA01463E3A33'. Cannot insert duplicate key in object 'dbo.CLASSIDTABLE'. The duplicate key value is (AADAuthenticationMonitoringAndDiagnostics).
The statement has been terminated.))). Needed a solution to this problem.

Quick response is appreciated, Thanks in advance.

I have the same question (0)

All responses (6)

Answers (0)

MuthukumaranAX 2,901 on at

Like (0)

Report

RE: Error occured during database import process from UAT to DEV Environment

please confirm the following steps are performed

learn.microsoft.com/.../dbmovement-scenario-exportuat

Was this reply helpful? Yes No
Sowmya170106@gmail.com 45 on at

Like (0)

Report

RE: Error occured during database import process from UAT to DEV Environment

Hi MuthuKumaranAX,

Thank you for the response,

Yes, All the steps are performed upto importing the database through executing a code in command prompt i.e., SqlPackage.exe /a:import /sf:D:\Exportedbacpac\my.bacpac /tsn:localhost /tdn:<target database name> /p:CommandTimeout=1200

While this was processing it came across the error saying (*** An unexpected failure occurred: Data plan execution failed with message One or more errors occurred. (One or more errors occurred. (One or more errors occurred. (Violation of PRIMARY KEY constraint 'PK__CLASSIDT__D9C1FA01463E3A33'. Cannot insert duplicate key in object 'dbo.CLASSIDTABLE'. The duplicate key value is (AADAuthenticationMonitoringAndDiagnostics).

The statement has been terminated.))). )

Please find the below image of command prompt shows where the error has exactly occured.

Was this reply helpful? Yes No
MuthukumaranAX 2,901 on at

Like (0)

Report

RE: Error occured during database import process from UAT to DEV Environment

Instead of restoring to existing AXDB Database. please try the following approach

1. stop the services

2. Rename AXDB to "AXDb_Old"

3. create new database and name it as AXDb

4. then import the database

Was this reply helpful? Yes No
Dynamics365Admin 212 on at

Like (0)

Report

RE: Error occured during database import process from UAT to DEV Environment

Hi D365 User ,

I am also facing he exact same issue. Were you able to import successfully ? If Yes, Could you please provide the steps you followed(after you encountered this error). Also, if there were any services needed to be stopped or any other things to be done.

Your help will be much appreciated.

Thanks and Regards.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

RE: Error occured during database import process from UAT to DEV Environment

Hi, This error is suggesting that Database is trying to import duplicate record in ClassIdTable table.

I can see a record exist with Name AADAuthenticationMonitoringAndDiagnostics in ClassIdTable table.

To replicate this issue, I tried to import record with same name in this table and sql gave same error. You can check if for any reason there is duplicate records with Name AADAuthenticationMonitoringAndDiagnostics in UAT (source) database.

If not then take a backup of Dev (Target) Database, delete all records from this table and try to import the database.

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,047 Most Valuable Professional on at

Like (0)

Report

RE: Error occured during database import process from UAT to DEV Environment

Hello

You might want to check this thread

Was this reply helpful? Yes No