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
- Go to the Business Configuration work center.
- Go to the Overview view.
- Open the Migration of Accounting Transaction Data activity.
- Press Migrate accounting transaction data using the migration tool.
- Select the relevant Migration Unit.
- Click Execute Migration.
- Select the Migration Object Balances of Bank Accounts.
- 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