cancel
Showing results for 
Search instead for 
Did you mean: 

Deleting project from CMC

Former Member
0 Kudos

Hi experts,

We are seeking clarification about what gets deleted when an entire IS project is deleted from the CMC, specifically with regards to the Failed Data Repository (FDR).

Section 6.3.4 of the IS Admin Guide states "When you delete a project, you delete all the contents of the project which include unapproved rules, tasks, scorecards, profile results, sample data, views, and so forth."  However, we know that public rules and connections do not get deleted since these are not unique to the project.  What happens to the Failed Data Repository when an entire project is deleted from the CMC?

This is the situation that prompted this question:

We were having issues with a project so we exported the entire project and then deleted it from the CMC.  We then re-created the project using the same project name, and imported all the views/rules/tasks/etc.  After doing this we were not able to "view more failed data" and were limited to the 100 sample rows of failed data.  After a bit of investigation in the FDR we found that there were multiple FD tables with various aliases - the old FD tables did not get deleted with the project.  Our FDR is SQL Server 2012.

So, can we assume that deleting a project does not delete the related objects from the Failed Data Repository?  What other contents/objects do not get deleted when an entire IS project is deleted from the CMC?

Thanks,
Dan

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

So, can we assume that deleting a project does not delete the related objects from the Failed Data Repository?  What other contents/objects do not get deleted when an entire IS project is deleted from the CMC?

Yes, Deleting a project will not delete the failed data content associated with project, if you are using a separate failed data database per project, then you can drop the Database

if you are using a common FD DB for multiple projects, then it becomes little difficult, you will have to delete the data related to this project from IS_FD_XXXX tables and also drop the views and tables associated with this project. You will also run into issues, if you reuse the same FD DB for the contents of the deleted project by reimporting them in the project with the same name

Rest of the contents from IS Repo/CMS Repo are deleted on deleting a project from CMC

Former Member
0 Kudos

Hi Manoj,

Thank you for your response.  We currently use a common FD DB for multiple IS projects.  Our current solution is similar to what you suggested - we drop the tables and views associated with the deleted project.  We have also been removing the associated records from the IS_FD_Tables_MAP, IS_FD_RUN_HISTORY, and IS_FD_RULES_INFO tables - is this a necessary step?

We hadn't previously considered your other suggestion of creating a separate FD DB per project.  Do you know if SAP recommends one solution over another (separate FD DBs per project or shared FD DB) ?

Kind regards,

Dan

Former Member
0 Kudos

you definitely need to delete obsolete entries from IS_FD_TABLES_MAP, for now I have added a fix to clean only this table before adding a new entry to avoid the issue if incorrect failed data or error in SP05 Patch 2

you can ignore other 2 tables if you are not running into Table space issues

both options are ok, only thing is per project makes is easier to delete if needed else one is fine

Former Member
0 Kudos

Thank you for your help!

Answers (0)