Filled fields become blank in DSO change log

[former_member39123]

Hi experts,

I find an unusual behavior in DSO activation.

For some records for which I find in PSA, new data table (and in debug also!!!) correct data, when the request is activated I find in change log table all characteristic fields empty; the key fields and key figure fields are ok and correct in all tables.

It happen randomly for some orders and for a few requests.

It happen when I have one storno record, for example:

PSA (order, item, customer, material, storno, quantity)

10000, 10, AAA, YYY, , 25

10000, 10, AAA, YYY, X, -25

DEBUG (order, item, customer, material, storno, quantity)

10000, 10, AAA, YYY, , 25

10000, 10, AAA, YYY, X, -25

CHANGE LOG (order, item, customer, material, storno, quantity)

10000, 10, AAA, YYY, , 25

10000, 10, , , X, -25

ACTIVE DATA (order, item, customer, material, storno, quantity)

10000, 10, AAA, YYY, 25

In some other cases:

ACTIVE DATA (order, item, customer, material, storno, quantity)

10000, 10, , , -25

Have you some ideas? It is very strange.

We are on a 7.0 BW system, but with 3.5 data flow (update rule).

Thanks in advance.

[former_member39123]

Hello, an update.

I see now that in PSA table there is an error: for these documents for which I have the problem, I can see in PSA only after image record.

[Former Member]

Hi Vito,

suppose if you try to load only that particular order,is that updating correctly? just to check whether delta update working correctly or not..

can you try to load single order and confirm?

Regards,

Sakthi.

[former_member39123]

Hi Sakthi,

yes, if I load only one order, the data are correct.

I supposed that the problem maybe the orders splitted in more data packages, but there is always only a package; so the problem is something else.

@ Arun: I did not transport any change. The datastore is the same since some years.

Thanks in advance.

[Former Member]

Is this the single data source load that is coming into the DSO?

Regrads,

Suchitra

[former_member39123]

Yes Suchitra,

this is the only data source which load the datastore.

Thanks.

[Former Member]

Is the storno a key field? Possible reason could be if this is not a key field and rest of the fields are key fields as mentioned above in your thread, then the records are getting overwritten during DSO activation.

Regards,

Suchitra

[mohd_abdullah]

Hi,

Use semantic groups in DTP any try !!

Regards.

[former_member39123]

It is not a key field and it doesn't be a key field.

The other blank fields are not key fields.

@ Moahmmed: I can't do it, it is a 3.x data flow with infopackage and update rule.

Thanks.

[former_member39123]

Any other reply?

Thanks.

[former_member184494]

Vito,

This happens some times...

1. Did you transport any change to this DSO where characteristics were added and are these the ones that are blank...

When this happens - see if you can clear the change log ( if this is an option ) and then reactivate the cube.

Also there is a program to regenerate the activation program, I am not able to locate this - but then usually reactivating the ODS will usually clear this issue because it regenerates the activation program.