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

[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