Issue
Installing the Knowledge Management Advanced plugin fails if a unique index on an article number field already exists.
Release
This issue has been identified in all currently supported releases
Resolution
The following corrective steps need to be taken as corrective action:-
Step 1. Execute the below script to remove the Unique index created on table "kb_Knowledge" for field "number":-
var tableName = "kb_knowledge";
var isUniqueIndex = true;
var columnsInIndex = ["number"];
var util = new GlideIndexUtils();
var count = util. dropByExactElementSequence(tableName, isUniqueIndex, columnsInIndex);
gs.info(count + " index dropped.");
Step 2:- Uncheck the "unique" field for table kb_knowledge in sys_dictionary
- Navigate to System Definition > Dictionary
- Search for Table = kb_knowledge and Column name = number
- Open the record and uncheck Unique field
Only If Unique field is not available:
-
- Right click on Form Header > Configure > Form Layout
- Move the entry Unique from the Available to Selected list.
- Save changes. The Unique field is now visible.
Step 3:- Now retry activating the plugin.