SAP Knowledge Base Article - Public

3719642 - 500 SAP Internal Server Error When Uploading Bank Statement Due to Carriage Return And Line Feed Formatting

Symptom

You upload a text-based bank statement (for example MT940). Upon upload a generic exception shows as: 

An error occurred 

Try resuming your work. If you still encounter issues, report a case using Built-In Support.
Details
ClassName
sap.b.controller.event.PostRequest
MethodName
post
Response
<HTML><HEAD>
<TITLE>500 SAP Internal Server Error</TITLE>

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Liquidity Management work center.
  2. Access the Bank Statements view.
  3. Via New choose Bank Statement Upload. 
  4. Provide relevant Company, Bank and Statement Format.
  5. Select Bank Statement File via the Browse function and press Start File Upload.

Cause

When inconsistencies relating to the actual file content can be excluded (for example: special characters or erroneous notations) it can be considered to check the formatting of the file itself. 

A typical error source is the wrong placement of Carriage Returns (CR) and Line Feeds (LF). 

This can create empty characters which are not visible first - but are interpreted by the application. A mismatch of expected values and string length can lead to experienced error. 

Resolution

  1. Open affected text file in a text-formatting program such as Notepad++ or MS Word.
  2. In the editor enable the 'Show All Characters' function. 
  3. You notice that there are additional spaces added before Carriage Return (CR) and Line Feed (LF).
  4. You may want to remove these spaces and attempt a new file upload. 
  5. You may also want to get in contact with the issuing house bank emitting such files alerting them to the formatting error. 

Keywords

bank statement upload error, sap internal server error, MT940 file formatting, CR LF line breaks , KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem

Product

SAP Business ByDesign all versions