DSO records are not getting updated after request activation

[Former Member]

There is an issue with DSO (BI - 7.4 ),

when we activated a request of DSO the data is not getting updated into Active data tables from the New Data table of the DSO.

Rgds,

Mohan

[former_member183463]

Hi M Reddy,

i also faced recently this issue.,

just  try to change Parallel processing   form default 3 to 5.

then activate it. it will work..

for more inf check the snap shot for settings..

Regards,

Kamal

[former_member183463]

its  worked in BW 7.3,, and BW  7.4 versions also..

regards,

Kamal

[former_member183334]

Hi M Reddy..

1. compare with your source data and target data.

2. check with tranformation mapping.

3. correct with data packets at IP level full or delta update modes.

4. oberve at DTP level Request activation any errors (monitor).

5. finaly check with scheduled back ground running jobs with t-code of SM37, and process overview using t-code SM50.

6. even though data loading problem check with idocs, trfc with BASIS team.

or

any sreen shot for  that please shere it..

Regards

Satish.

[Former Member]

Hi Reddy,

Are you doing delta or full.Please check data recordmode in change-log table by request wise. If no records, then it will not update.

Regards,

Mahesh

[KodandaPani_KV]

Hi,

after activation data move to from new data table to active data table.

after completing the request activation you need to check with the active data table.

Thanks,

Phani.

[Former Member]

hi Pani,

After activation only its not updating the records.

Thanks

[Former Member]

Hello Reddy,

can you check the job in sm37. see if you can find any reason. Also during runtime  try sm50, sm66 to see if there is any write happening on Active table.

Looks like there already exists an entry in DSO against the Primary key.

Regards

AR

[former_member197660]

Hello Mohan

Please provide some further information about the issue like:

1) The number of "Transferred/Added" records for the particular request

2) Any error message

3) Is it with all loaded requests or only one particular request

Ashish

[Former Member]

hi Ashish,

1. I have loaded one record into DSO loaded into successfully into NEWTABLE(not getting updated into Active data tables from the New Data table of the DSO)

2. No error Message

3. for all records.

Thanks,

Mohan

[former_member197660]

Hi Mohan

I feel the record is not visible due to a record already available in DSO with identical key thus instead of adding the record it is overwriting the existing one.

Please check the number of records "Added" column for the request to confirm this fact, if this is "0" then the it confirms the above mentioned fact.

However please mention if you are facing the issue with a log with more than 1 record.

Ashish