Data Transfer Workbench error

[#1]

Hello experts

When loading Business Partners Bank account information using BPBankAccounts template on Data Transfer Warehouse, I am getting following error:

"Data transfer warehouse transcation commit unsuccessfully "

The thing is that when DTW is loading the records it is counting all records as successfully updated, but when the load ends and I see the log result, all entries are displaying mentioned error. Also this is happening when I try to load over 1000 entries, I have tried to load 10 entries and they all were successfull.

Thanks in advance and regards

[kothandaraman_nagarajan · Accepted solution]

Hi Javier,

Try to follow sample template under,

C:\Program Files (x86)\SAP\Data Transfer Workbench\Templates\Samples\1. Add New Data\Business Partners\Business Partner Master Data

If you get error message, please post your updating template here.

Thanks & Regards,

Nagarajan

[javier_facessantos · Accepted solution]

Hi Nagarajan

Thanks for the reply. No, I am using template under:

C:\Program Files (x86)\SAP\Data Transfer Workbench\Templates\Templates\Business Partners\Business Partner Master Data

Is there any problem by using this template? I have checked the template you mention and I am not really sure about how to use it.

Anyway I am posting my updating template just in case you see anything. The only columns that are filled are "Parent Key", "BP Code" and "IBAN" as the template is intended to update IBAN codes due to the new SEPA legislation. IBAN codes have been deleted from template due to privacity reasons, but all IBAN codes are checked and they are all correct.

Thanks and regards

carga masiva IBAN (SCN).txt.zip

[Former Member · Accepted solution]

Hi Javier,

Nagarajan was asking you to check your template against the samples provided by SAP. Only one template exists and you're using it.

Besides this, when something doesn't work with DTW, the first thing to do is to try is creating the exact same data by hand (with the FAT client).

From what I understand of your process, you're not giving a bank account but only an IBAN, and... The bank account is mandatory. You should split the IBAN in the misc. fields (at list Bank Account) and do a new nest.

Regards,

Eric

[javier_facessantos]

Hello

Thanks for the help. I was selecting "Cancel import and perform roll back when one or more errors occurs" option on "Define Error Handling" step, due to this after load all entries were being displayed as unsuccessful.

By changing error handling option to "Ignore all errors and process valid records", all entries have been loaded but 3 of them. DTW has displayed the errors for these entries and they are all dua to a Transaction Notification control, because those business partners were added before this control was set on TN. I have corrected the errors and now all codes are correctly loaded.

Thanks and regards

[Former Member]

Hi Javier,

Glad you've found I had a similar issue last week with bins and QuickCopy: had to use delete before to make the import working: 4 hours of work trashed on this...

Regards,

Eric

[Former Member]

Hi Javier,

I don't know specifically for this template, but DTW has a hard time if master template and related templates aren't filtered in the same way. In your case, the sort order of the ParentKey (CardCode) of BPBankAccounts should be the same as for the template BusinessPartners.

Regards,

Eric

[javier_facessantos]

Hi Eric

Thanks for the reply. I have check against OCRD table, and the entries on the template are on the same order than they are on the table.

I am loading vendors and clients on the same template. Should I do it in different templates?

Regards