Delta is not pulling records after manual delete DSO request

[pablo_leonel]

Hi all,

As the subject says, I followed this procedure in a few DSO

is true that the request is deleted after delete entry in RSICCONT, but I Noticed that delta is not working  when data transfer process is executed again for the same information that the request contained.

for example:

3records in PSA ---> Moved to DSO ----> 0 Records Moved to the cube.

The requests in the cube were deleted by managing so, I Guess that some garbage in any table or DSO is making this possible. I have deleted the entries from the following tables whit no sucess:

RSREQDONE
RSICCONT
RSMONICDP
RSODSACTUPDTYPE
RSODSACTREQ
RSREQICODS

any information is preciated.

thanks in advance.

[jay_reddy1 · Accepted solution]

try below steps:

1.right click on DSO and delete all table contents from DSO.

2. Run DTP to DSO.

3.Activate request.

4.right click on cube and delete all data.(including dimension tables)

5.run dtp from DSO to cube.( select extraction from active data table)

[pablo_leonel · Accepted solution]

surelly it will work, but is not an option. Because I'm using a Z deployment with daily execution

[pablo_leonel]

This a Z development where flat files are located to several DSO and then they are sumarized into a CUBE.

Daily process, that's is why the procedure above, help us to process a particular day in the past, due to is not possible to delete a request in a DSO without delete the lastone.

the problem here, is when the process chain runs again, the DTP not pulling records to the next level.

I have discovered a partial solution, by doing a selective delete into DSO and pull Delta again.

[RamanKorrapati]

if you you have flat file(xyz) which is not loaded to cube/dso then you can do reinit of dtp(which puling 0 data).

PSA-->DSO-->Cube, delete xyz file data from whole data flow.

Later you can reload it by manual, delta pointer may work.

[pablo_leonel]

When flat file is used, you cannot perform an Init. Only delta or full DTP is allowed

[RamanKorrapati]

have you tried or have any reason to say?

init mean just we are setting delta pointer at dtp. after that  we can reload same file from  file location to psa, then to targets. thru delta only we will load latest file into targets.

reinit- just we are initialing. because previous delta was pulling 0. so thought to go with reinit of dtp.

[pablo_leonel]

there is no option to init when use flat file.

when you put delta based on this kind of extraction only new records are pulled to upper level.

how can I re init if I cant delete the current pointer?

eventhough my problem is not in PSA, is at DSO level.

When values of tables RSICCONT where deleted, request in ODS does not appear anymore, but data is inside.

that is why selective deletion helps me to clear all the garbage records in DSO

[former_member186445]

you should contact the person that wrote the blog.

M.

[RamanKorrapati]

Hi Leo,

After deleting the request from Cube, at DSO are you able to see no data mart symbol for related request which you deleted from cube?

if yes then you delta dtp will pull those 3 records other wise you may lose those 3 records.

is there any reason to delete a request from cube?

please share dso request tab and cube request tab screens from manager.

Thanks.