SAP Knowledge Base Article - Public

3370181 - Technical error occurs in app Upload General Journal Entries.

Symptom

After upgrade to CE2308, when using app Upload General Journal Entries, system prompts error "Sorry, a technical error occurred. Please try again Later. Show Log".

But there is no detailed information in error log.

Environment

SAP S/4HANA Cloud.

Cause

In the past, we only extracted the data we needed from EXCEL, specifically, we only read the data maintained in the first SHEET, and we didn't check other data in the WORKBOOK. In this release, we changed to a central API to parse the excel file, and the check scope has been enlarged. For example, the invalid reference will be checked and blocked.

These invalid elements can not be directly saw in the Excel. You can check them follow:

1.Change the excel file extension to ZIP.

2.Open the ZIP file, open workbook.xml under folder XL. Please check whether exist any ‘defineName’ node with invalid value #REF!.

Resolution

In order to solve the error, there are two options:

  1. Download a new clear template (not ONE-ROW template) and copy the data to this new template. If you want to copy additional sheets, please DO NOT use 'Move to' function. Just copy the whole sheet content and paste to the new template.
  2. If you want to still use the existing excel, you can execute below VBA macro code to remove all named excel ranges, save the template again. Please COPY your original file as backup first before executing below VBA code:

Sub removeAllNames()

'Remove all names in current workbook, no matter if hidden or not

   For Each tempName In ActiveWorkbook.Names

       tempName.Delete

   Next

End Sub

Keywords

Upload General Journal Entries, technical error, "Sorry, a technical error occurred. Please try again Later. Show Log". , KBA , FI-FIO-GL-TRA-2CL , Transaction Apps (Public Cloud) , Problem

Product

SAP S/4HANA Cloud 2308