ownership group populating from the Configuration item.

[JulietChicago]

We have on the articles the Configuration item.

When the user creates the article and selects the Configuration item, we have the ownership group populate with the group from the Configuration item.

The issue we face we save the draft kb article and we get an error “ invalid update”

The log shows “Unique Key violation detected by database ((conn=8104)  Duplicate entry '89a282ab4753d210c1517351e36d4331' for key 'PRIMARY').”

Any ideas on why this happens?

[AshishKM]

Hi @JulietChicago, 

So there are 3 items involved, KB,CI and group.

While saving in draft status, the save process is trying to insert a record in either CI or Group table.

In the error log, seems like this is sys_id "89a282ab4753d210c1517351e36d4331" either belongs to cmdb_ci or sys_user_group table. You can check in both table if there is record exist with this sys_id.

-Thanks,

AshishKM

[James OBrien]

More than likely it's from the sys_user_group table.

A group has to have the system designation "Type" "Knowledge" in order for the group to be an Ownership group.  Groups do not automatically get that Type assigned when they are created. 

It seems the Ownership groups in the CMDB do not have this.  They will need to have the "Knowledge" Type assigned to them.  You'll need to add some logic that allows the sys_user_group table to be written to by the script assigning an ownership group to the articles. 

You'll also either need to add "Knowledge" to all existing Ownership groups or have the logic check for it, add it if it's not assigned using proper credentials, and having whoever creates the groups add that step to their process/procedure.

Like everyone else adds to their response, please mark this response as correct and helpful if it helps you.