X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=ecomp-portal-BE-common%2Fsrc%2Fmain%2Fjava%2Forg%2Fopenecomp%2Fportalapp%2Fportal%2Fservice%2FEPAppCommonServiceImpl.java;h=b51ea1a1ed669c3fc3b4d219d5547be3011bb4bd;hb=e43e03d4da9bd760d67d746a949efbb7e5d102a8;hp=6a0da9baed5a6e2c964c300e17304e4964a7eece;hpb=f57e82d8c734e59977c39bc6a0139174cb7f0649;p=portal.git

diff --git a/ecomp-portal-BE-common/src/main/java/org/openecomp/portalapp/portal/service/EPAppCommonServiceImpl.java b/ecomp-portal-BE-common/src/main/java/org/openecomp/portalapp/portal/service/EPAppCommonServiceImpl.java
index 6a0da9ba..b51ea1a1 100644
--- a/ecomp-portal-BE-common/src/main/java/org/openecomp/portalapp/portal/service/EPAppCommonServiceImpl.java
+++ b/ecomp-portal-BE-common/src/main/java/org/openecomp/portalapp/portal/service/EPAppCommonServiceImpl.java
@@ -770,6 +770,21 @@ public class EPAppCommonServiceImpl implements EPAppService {
 			logQuery(sql);
 			query = localSession.createSQLQuery(sql);
 			query.executeUpdate();
+			
+			
+			// Remove all roles, rolefunctions, appid records from ep_app_role_function
+			// that are associated with this app
+		    sql = "DELETE FROM ep_app_role_function WHERE app_id='" + appid + "'";
+			logger.debug(EELFLoggerDelegate.debugLogger, "Executing query: " + sql);
+			 query = localSession.createSQLQuery(sql);
+			query.executeUpdate();
+			
+			//Remove all rolefunctions, appid records from ep_app_function
+			// that are associated with this app
+			sql = "DELETE FROM ep_app_function WHERE app_id='" + appid + "'";
+			logger.debug(EELFLoggerDelegate.debugLogger, "Executing query: " + sql);
+			query = localSession.createSQLQuery(sql);
+			query.executeUpdate();
 
 			// Remove all records from fn_user_role associated with this app
 			sql = "delete from fn_user_role where app_id='" + appid + "'";