SAP Knowledge Base Article - Public

3041976 - Error While Migrating Balances of Bank Accounts: 'PAF ShortDump: An exception of the type 'CX_SY_OPEN_SQL_DB'

Symptom

You are migrating Balances of Bank Accounts and receive some error messages, such as

'Error detected in source record XXX, YYY, ZZZ'

'PAF ShortDump: An exception of the type 'CX_SY_OPEN_SQL_DB' occurred that was not caught anywhere along the call hierarchy. It was neither handled locally nor declared with a RAISING clause'.

XXX - Bank Account Number

YYY - National Bank Code

ZZZ - IBAN

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Configuration work center.
  2. Go to the Overview view.
  3. Open the Migration of Accounting Transaction Data activity.
  4. Press Migrate accounting transaction data using the migration tool.
  5. Select the relevant Migration Unit.
  6. Click Execute Migration.
  7. Select the Migration Object Balances of Bank Accounts.
  8. Click Process File.

The error messages appear as above (Symptom).

Cause

The system identified two or more entries in the Migration File with the same Bank Account Number, IBAN or Currency.

In SAP Business ByDesign it is not possible to create multiple Bank Accounts for a Company with the same Currency, the same IBAN or Bank Account.

Resolution

To proceed with the migration of Balances of Bank Accounts, adjust the file in a way that there are no duplicate records, for example, an IBAN can only be assigned to one Bank Account.

System is working as designed.

Keywords

Migration, Balances, Bank Accounts, IBAN, Currency, Bank Account Number , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To

Product

SAP Business ByDesign all versions