Skip to Content
author's profile photo Former Member
Former Member

Write Optimised DSO Data deleted

Dear Gurus,

we have an with our write optimsed DSO it was holding three years worth data until last week. now it has got only six months data in it. trying to find who and how it has got deleted

all request are still visible in visible in Request tab in DSO

clicked on logs tab in contents and checked for selective deleted logs which is showing some thing happened in 2/05/2012 nothing from last week

so please provide me imputs how else i can check who has deleted data?

Thanks in advance .

Regards,

Shanmugam

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Nov 16, 2015 at 01:44 PM

    Hi Shanmugam

    In few cases, the selective deletion logs gets doesn't get updated at once. I have seen in few scenarios when the selective deletion went well but the logs didn't get updated for few days.

    There is another option to get the information whether a request is selectively deleted or not (until your logs get updated). In your manage screen, if the requests are selectively deleted, a symbol will appear as separate field as below.

    If you click on the symbol, it will give you much more information on how many records are deleted, the job details and the user details as below.

    Hope this helps

    Regards

    Karthik


    Capture.PNG (29.8 kB)
    Capture1.PNG (21.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 16, 2015 at 12:57 PM

    Hi,

    Double click on your DTP. Click on Monitor. Here Select the Free Date as filter and execute.

    It will display both request list. Deleted and Finished/Errors.

    Thanks,

    Bhavin Vyas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 16, 2015 at 01:10 PM

    Hi Shanmugam,

    If all the requests are present in the 'requests' tab and no selective deletion logs are found, in that case, data should be present. If not, there could be a minute possibility of a routine code to delete the data from the write optimized dso. And if you want to see the requests in recent past, you can select the DTP and click on the option 'monitor' and then, you find the requests of data loads.

    Regards,

    Venkatesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 17, 2015 at 11:01 AM

    Hi Shanmugam


    1 right click on your DSO--> go to manage..

    2 content tab-> deletion-> Logs


    PFB...


    when you double click on any entry, you will get detailed info of selective deletion criteria.


    Job which runs for select. deletion have prefix "BI_INDX*" --> execute report RSINDEX1.


    Use below tables for more details:


    RSDRDLOGHEADER Log Delete Actions (Header Table)

    RSDRDLOGPOSITION Log Delete Actions (Positions)


    Regards,

    Hitesh


    Capture.PNG (8.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.