Skip to Content
Author's profile photo Madhu k
Madhu k
Posted on June 7, 2013 Less than a 1 minute read

Instance tables in SAP DSiM

Follow RSS feed
1 Like 906 Views 2 Comments

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

Related Blog Posts

    Related Questions

      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 Former Member
        Former Member

        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