Issue with DTP loading

[#1]

Hello BW experts,

I'm facing an issue with a DTP in BW while loading data.

This DTP extracts Data from from a datasource into an Infocube.
FYI, this Datasource is built on a table present in BW (not in ECC or external system)

The problem is the following:

If I take the example of the last test request:

The package size is very high (defaut values proposed by BW during DTP building), and the number of inserted values is wrong.

In fact, the DTP takes 306 records from the table present in BW and inserts 536 lines (the difference is wrong data)

Logically, this kind of issues should be provoked by an error in transformation. But there are no errors detected by the system and the transformation is logical.

Does someone has an idea that could help me to resolve this issue.

Thanks for your help.

Amine

[Former Member]

Hi Amine,

I assume 306 records in the PSA table.

How many records were added to the infocube?

Check whether any routines available in the transformation.

Also, ensure that while creating DTP, set a definite package size as 50,000 instead of default values.

This will enable proper data processing.

Br,

H

[Former Member]

Hi Harish,

Absolutely, 306 recrds in the PSA table which is corresponding to the number of data present in my BW Table (SE11/SE16 Table)

There are no routines in my transformation.

Ok, I agree with you. I will change the size into 50.000. The current number is so high (since i wanted to keep as much as possible the default values proposed by BW) --> I will let you know if this changes anything on my issue

Thanks anyway.

Amine