2492026 - Error Message: “Exception occurred. Contact your system administrator.” While Trying to Upload Suppliers Using Microsoft Excel Approach

SAP Knowledge Base Article - Public

2492026 - Error Message: “Exception occurred. Contact your system administrator.” While Trying to Upload Suppliers Using Microsoft Excel Approach

Symptom

Your requirement is to upload Suppliers using Excel Add-in. For example, you want to upload Suppliers for the Country CI - Cote d'Ivoire. During the upload process, you get below mentioned error:

Exception occurred. Contact your system administrator.

Update operation failed: Error during Maintain operation:'/SAP_BYD_CodeList/CodeListItem/DisplayAs[.='CI - Cote d'Ivoire']/../Code' has an invalid token.]]

Reproducing the Issue

  1. Go to Supplier Base workcenter
  2. Go to Suppliers view
  3. Select New -> Suppliers From Microsoft Excel
  4. Download the Suppliers XML template
  5. Fill the details
  6. Upload the file using Excel Add-in
  7. System throws errors

Cause

Some of the characters are not allowed while the data is converted to XML.

The XML mapping property of the Microsoft Excel does not allow the char ( ' ) in the code list. The single quote is also one of such cases.

Resolution

We have found work around where the Country Name which is displayed in the excel would be different (code will be same), however when it is uploaded into the system the Country Name will be stored as expected.

For example, you may use the List Of Suppliers Template.xlsx which is attached to this document.

We have a blog on the reported issue:

https://blogs.sap.com/2017/05/15/office-integration-for-hybris-cloud-for-customers-and-business-bydesign-faqs/

We have added this to our product backlog and will evaluate possible enhancements to address it in one of the future releases.

Keywords

KBA , AP-BP-BPT , Business Partner Template , How To

Product

SAP BUSINESS BYDESIGN 1705 ; SAP Business ByDesign 1702

Attachments

List Of Suppliers Template.xlsx