Tauf,
Is there an option on the conversion tool to overwrite the existing article? I am asking this because I see unique index errors in the log file. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Tauf Chowdhury Sent: Saturday, January 28, 2012 9:22 AM To: [email protected] Subject: Re: Knowledge Management ** You shouldn't have to delete the articles. The conversion tool will overwrite/add to the existing entry within AR. There is a field on the article manager form which holds the DOC ID from the previous version. To troubleshoot this issue yourself, you will need to go into the RKM settings and start logging the conversion tool. This can be done from the Admin Console>custom>Knowledge Management section. You can then go into the log and see specifically what action is triggering the failure for that specific article. BMC support should be able to help with this as well. It may be beneficial to contact support anyway because there are so many hotfixes for RKM that you may be troubleshooting something they already have a workaround for. The only other thing with attachments that you can check, make sure that the attachments that are failing for some of those articles aren't global attachments in the old system. This may be your issue there. Each article needs to have a corresponding folder with that article ID as the title of that folder within the Attachments folder in the old RKM system. On Sat, Jan 28, 2012 at 10:13 AM, Venkat Arcot <[email protected]> wrote: ** Tauf, Out of 3949 articles only 2382 got imported successfully but some of the articles that got imported successfully failed to import the attachments. I was thinking if we could delete all the articles and re try the tool again These are the errors I see when I try to re import the articles ERROR: File \\arserverq\BMC Software\BMC Remedy Knowledge Management\data\kms_data\versions\110.xml.20100510_000 / Status KMSPublish / Type HowTo_Template - Set data to KAM for file \\arserverq\BMC Software\BMC Remedy Knowledge Management\data\kms_data\versions\110.xml.20100510_000 has failed: java.lang.RuntimeException: Failed to update new entry (110) in [RKM:KnowledgeArticleManager] form:ERROR (382): The value(s) for this entry violate a unique index that has been defined for this form; schema: RKM:KnowledgeArticleManager, entry: KBA000000006714, 3 unique index(es), field(s): 302301020 179 302301021 302300505 WARNING (52): The field is a core system field and cannot be changed; 3 WARNING (52): The field is a core system field and cannot be changed; 6 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Tauf Chowdhury Sent: Saturday, January 28, 2012 9:03 AM To: [email protected] Subject: Re: Knowledge Management ** Venkat, One thing you want to stay away from is deleting stuff in RKM 7.6.x. That path leads you nowhere good. You should be able to tell why those articles failed to import from looking at the details of the conversion tool job. Have you found anything specific? When you say the bulk of the articles failed to import, how many made it over? There were MANY bugs the last time I worked with the conversion tool and Carrie R from BMC and I spent many quality hours together figuring a lot of them out. I haven't used the patch 2 version but maybe there are still some bugs that weren't addressed. It could be that there's something in the XML that is throwing off the parsing such as something like this in the title: "How to open MS Word.doc" Notice the .doc in the title. There was a bug where that would screw up the entire article conversion. Another thing is to confirm that the articles actually didn't import. Sometimes the visibility groups don't get added or are missed and this causes you to think that the articles failed to import but they are there. I guess the best thing to do is to look at the details of your conversion log. Hope this helps... keep us updated. -Tauf On Sat, Jan 28, 2012 at 9:50 AM, Venkat Arcot <[email protected]> wrote: ** Hello Listeners, Need help on Knowledge Management. We imported knowledge articles from 7.5 to 7.6.04 sp2 using the conversion utility but bulk of the articles failed to import and now when we try to rerun the conversion the tool errors out with unique index error. Is there an easier way to delete all the articles and re-import the articles, possibly deleting them using the database scripts? I granted myself Knowledge admin role still delete button is disabled on the mid tier Delete button is disabled and I granted myself KB Admin, KB config roles This electronic message and any attached documents are intended only for the named addressee(s). This communication from TransCanada may contain information that is privileged, confidential or otherwise protected from disclosure and it must not be disclosed, copied, forwarded or distributed without authorization. If you have received this message in error, please notify the sender immediately and delete the original message. Thank you. _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ -- Tauf Chowdhury _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ This electronic message and any attached documents are intended only for the named addressee(s). This communication from TransCanada may contain information that is privileged, confidential or otherwise protected from disclosure and it must not be disclosed, copied, forwarded or distributed without authorization. If you have received this message in error, please notify the sender immediately and delete the original message. Thank you. _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ -- Tauf Chowdhury _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ This electronic message and any attached documents are intended only for the named addressee(s). This communication from TransCanada may contain information that is privileged, confidential or otherwise protected from disclosure and it must not be disclosed, copied, forwarded or distributed without authorization. If you have received this message in error, please notify the sender immediately and delete the original message. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
