Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Failed to import with a solution

Posted on 23 Nov 2024 07:12:50 by
Hello,
I am not able to import a solution. The problem seems to be an instance n the AI-Model. This is the error message: Failed to import with AIModel import: FAILURE: Cannot insert duplicate key exception when executing non-query: System.Data.SqlClient.SqlCommand Exception: System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_msdyn_AIModelBase'. Cannot insert duplicate key in object 'dbo.msdyn_AIModelBase'. The duplicate key value is (11111111-2222-3333-4444-555555555555, 0, Jan  1 1900 12:00AM). A collegue is able to import this solution(other company, other domain, other enviroment). Can anybody give me an hint?
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 1,216 on 25 Nov 2024 at 16:28:12
    Failed to import with a solution
    pls try the following:
     
    1. Go to Advanced Find in Power Apps.  Select AI Models (msdyn_ai_model table). Search for records with the following filter: AI Model ID (GUID) equals 11111111-2222-3333-4444-555555555555.   Verify the record details to confirm the conflict.
     
    2. If the model already exists, investigate its configuration: Compare the existing AI Model with the one in the solution to identify differences (e.g., model type, version, or associated data).
     
    3. Backup the Existing Model.
    4. Delete the Conflicting Model.
    5. Modify the Solution Before Import
     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,246

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,884

Leaderboard