Installation of the Knowledge Management Advanced Plugin fails if unique index already exists in article number - Support and Troubleshooting

Installation of the Knowledge Management Advanced Plugin fails if unique index already exists in article number 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.