Article Original Creation Date: 2013-11-19
Overview
In the sprt_sg_policy table, after trying to manually change the STATUS, ADMINISTRATIVE_STATUS and CSV_CONTENTS columns to be able to delete policies that stay forever in the Going to be stopped state or Building from Active state, policy defintions and policy logging cannot be opened. Moreover, the following exceptions are returned in the server.log:
2013-11-15 09:11:36,385 ERROR [encore.webservice] (http-0.0.0.0-8080-24) RuntimeException; nested exception is: java.lang.IllegalArgumentException: No enum const class com.supportsoft.servicegateway.policy.types.AdministrativeStatusType.STOPPED: java.rmi.ServerException: RuntimeException; nested exception is: java.lang.IllegalArgumentException: No enum const class com.supportsoft.servicegateway.policy.types.AdministrativeStatusType.STOPPED at org.jboss.ejb.plugins.LogInterceptor.handleException(LogInterceptor.java:421)Caused by: java.lang.IllegalArgumentException: No enum const class com.supportsoft.servicegateway.policy.types.AdministrativeStatusType.STOPPED
Environment
ServiceGateway 4.3.1
Linux Redhat 6.1
Apache 7.027
JBoss 6.10 AS
Oracle 11.2 G
Root Cause
The entries for the STATUS and ADMINISTRATIVE_STATUS columns were mixed up causing non-existing entries in these columns, causing the exceptions.
Resolution
This is the right steps to take when trying to delete these policies out of the Policy definitions screen:
- Change directly in the DB table
sprt_sg_policythe STATUS to STOPPED. - Change directly in the DB table
sprt_sg_policythe ADMINISTRATIVE_STATUS to DISABLED. - Delete all csv entries out of the sprt_sg_policy.csv_contents.
- Commit these changes.
- Clear the browser cache on all 3 app-servers.
- Change the policy status in the GUI from STOPPED to PENDING via the Unapprove button.
- Delete the policy in the GUI.
Besides that, the above-mentioned status was solved by manually deleting the complete Policy out of the
sprt_sg_policy table, but changing the STATUS and ADMINISTRATIVE_STATUS columns with the right values would also have solved it.