Error while creating Knowledge Article record programmatically

(0) Share

Report

Posted on by Mridula

275

Hello,

I am trying to create Knowledge Article record and getting below error:

{"error":{"code":"0x80040237","message":"A record with matching key values already exists.",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionSourceKey":
"Plugin/Microsoft.Crm.Service.ObjectModel.KnowledgeArticleService",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiStepKey":"2c33e9b7-ac2e-4dcc-8e73-a8cbc0eab812",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiDepthKey":"1",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiActivityIdKey":"5405f633-dc70-4be4-b17e-722a0c777e66",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiPluginSolutionNameKey":"System",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiStepSolutionNameKey":"System",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionCategory":"ClientError",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionMessageName":"DuplicateRecord",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionHttpStatusCode":"412",
"@Microsoft.PowerApps.CDS.ErrorDetails.SqlExceptionMessage":"Violation of UNIQUE KEY constraint 'ndx_KnowledgeArticleBase'.
Cannot insert duplicate key in object 'dbo.KnowledgeArticleBase'. The duplicate key value is <redacted>.",
"@Microsoft.PowerApps.CDS.HelpLink":"go.microsoft.com/.../
Microsoft.Crm.CrmException%3a80040237&client=platform",
"@Microsoft.PowerApps.CDS.InnerError.Message":"Cannot insert duplicate key."}}

Has anyone faced this before?

Thanks,

Mridula

I have the same question (0)

All responses (10)

Answers (0)

Sort by

meelamri 13,218 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please share your code ..

Was this reply helpful? Yes No
Mridula 275 on at

Like (0)

Report
Copy link

Link copied!

hi Mehdi,

var data =

{

"st_products": sessionStorage.getItem("ProductValue"),

"title": sessionStorage.getItem("Title"),

"content": content

}

// create account record

Xrm.WebApi.createRecord("knowledgearticle", data).then(

function success(result) {

},

function (error) {

}

);

st_products is a custom multi select optionset value.

The above error which I am getting is random, if I run the same set of records again and again, it creates KA's and sometimes(randomly) throw error.

I have 50+ KA's with same title and content.

Thanks,

Mridula

Was this reply helpful? Yes No
meelamri 13,218 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Do you have any alternate keys for the entity Knowledge Article?

Was this reply helpful? Yes No
Mridula 275 on at

Like (1)

Report
Copy link

Link copied!

No.

Was this reply helpful? Yes No
meelamri 13,218 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

I can't reproduce this issue on my environment. Could you test the same code without the "st_products" attribute ?

Was this reply helpful? Yes No
Mridula 275 on at

Like (0)

Report
Copy link

Link copied!

Hi Mehdi,

Are you trying to create multiple KA's and running the code again to create same ones?

Thanks,

Mridula

Was this reply helpful? Yes No
Mridula 275 on at

Like (0)

Report
Copy link

Link copied!

Hi Mehdi,

I tried commenting st_products custom field. Still facing same issue.

Was this reply helpful? Yes No
meelamri 13,218 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Are you trying to create multiple KA's and running the code again to create same ones?

--> No, How do you create multiple KA ?

Was this reply helpful? Yes No
Mridula 275 on at

Like (0)

Report
Copy link

Link copied!

calling createKnowledgeArticles function with same title and content again and again.

While doing so, its throwing error. But not sure which is the field considered as duplicate by KA.

P.S. I have 50+ KA's with same title and content. So considering this, thinking title and content cannot be unique fields.

Was this reply helpful? Yes No
Amit Katariya007 10,409 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you check the duplicate detection rules. Because when you create anything manually and if it is a duplicate then you can ignore the warning manually but when you try same thing with code/customization, then probablu system will not allow this creation.

Was this reply helpful? Yes No