Skip to Content
Author's profile photo Madhu k

Instance tables in SAP DSiM

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

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Patrick Gross
      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