Skip to Content

Hi,

DSiM has five instance tables which need to cleansed to reflect new data deliveries in the system

/DDF/D_DDEL_INS -Data delivery instance table

/DDF/D_STEP_INS – Step instance table

/DDF/D_PROC_INS -Process instance table

/DDF/D_DSET_INS – Data set instance table

/DDF/D_FILE_INS -File Instance table

Schedular daemon program (SE38) – /DDF/ADU_DAEMON_SCHEDULAR, this program will initiate all jobs in the background with scheduled date and time

This program has various variants to run the jobs

/DDF/PFC_ALL – This process chain will load all SPRO settings data into SAP BW objects

Thanks

Madhu

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Erik Hamann

    Hi,

    When we read this, we thought of simply deleting all entries in these tables i.e. via transaction se14. What we did on last Monday. But this caused serious problems in our system:

    • LOAD_PROGRAM_CLASS_MISMATCH errors which were caused by mismatching timestamps of class interfaces
    • Background jobs weren’t working any longer or doesn’t stopped running (for example I executed the Process Chain /DDF/PFC_ALL in background)
    • and some other problems which seem to be caused by (not stopping) sql statements or errors while executing sql statements

    The first point could be resolved by executing the report “RSGENDUMP”. This report regenerates the programs and classes/interfaces mentioned in log entries in st22.

    Finally we decided to restore the complete HANA database from a backup of past Wednesday. Now the system seems to work again but all the changes we made during the past days are gone.

    Which ways are there to cleanse these tables? Is there a report etc.?

    Best regards,

    Erik

    (0) 
  2. Patrick Gross

    Hi Erik,

    please have a look at DSiM application help. In chapter Process Flow Control -> Job Monitor -> Clean Archived Instances Job you find info how to delete entries from the instance tables.

    Regards,

       Patrick

    (0) 

Leave a Reply