Cannot import Custom Quesion Anserting (Knowledge base) project in Language Studio - ValidationFailure: ID validation failed for PreserveID option.

Rodrigo Liberoff Vázquez 31 Reputation points MVP
2022-11-23T14:15:38.103+00:00

Hello,

When importing a Custom Question Answering (or Knowledge Base) into Language Studio, it fails with the following error message: "Import project failed - Invalid input. See details. - ValidationFailure: ID validation failed for PreserveID option.". You can see the screenshot below:

263511-image.png

The project We are importing is actually a .zip file containing an Excel file with the questions and answers, synonyms and CQA project parameters which We get from exporting the project from a different resource.

We have found that editing the Excel file and removing the QnAId column's content allows us to import the project, but the number of questions-answers pairs is affected because pairs that We have separated are now considered by Language Studio as the same pair, which is a problem for us.

Please help!

Thank you.

Azure AI Language
Azure AI Language
An Azure service that provides natural language capabilities including sentiment analysis, entity extraction, and automated question answering.
354 questions
Azure AI services
Azure AI services
A group of Azure services, SDKs, and APIs designed to make apps more intelligent, engaging, and discoverable.
2,368 questions
{count} vote

1 answer

Sort by: Most helpful
  1. Rodrigo Liberoff Vázquez 31 Reputation points MVP
    2022-11-25T12:03:16.347+00:00

    Hi,

    Yes, We were able to fix it. The issue was in the Excel that We had exported from Language Studio. It is weird that Language Studio has produced or allowed an invalid confoiguration of the knowledge base that eventually lead to an error.

    The exported Excel was huge, and in one of the records (rows) We had the following configuration in the "Prompts" column:

    [  
        {  
            "DisplayOrder": 0,  
            "DisplayText": "La nota de un examen",  
            "QnaId": 660  
        },  
        {  
            "DisplayOrder": 1,  
            "DisplayText": "La nota de la defensa",  
            "QnaId": 734  
        },  
        {  
            "DisplayOrder": 2,  
            "DisplayText": "La nota de una actividad",  
            "QnaId": 1290  
        }  
    ]  
    

    So, the issue was on line 10. The QnAId 734 did not exists as a valid ID for a questions-answer pair. In fact, the right ID was 735. Changing the value, saving the Excel and re-importing it fixed the issue.

    Nevertheless, that change was done by our team directly in Language Studio and it was allowed, then the export produced and invalid Excel file which was not able to import until the error was identified and fixed.

    Searching and fixing this issue is a time consuming tasks. Our KB in CQA was huge, so the effor was significant.

    Hope this helps you.

    1 person found this answer helpful.