=== modified file 'dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/sqlview/DefaultSqlViewService.java' --- dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/sqlview/DefaultSqlViewService.java 2013-10-02 13:49:44 +0000 +++ dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/sqlview/DefaultSqlViewService.java 2014-01-28 14:18:54 +0000 @@ -73,6 +73,8 @@ @Override public void deleteSqlView( SqlView sqlViewObject ) { + dropViewTable( sqlViewObject.getViewName() ); + sqlViewStore.delete( sqlViewObject ); } === modified file 'dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/sqlview/jdbc/JdbcSqlViewExpandStore.java' --- dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/sqlview/jdbc/JdbcSqlViewExpandStore.java 2013-10-08 17:16:47 +0000 +++ dhis-2/dhis-services/dhis-service-administration/src/main/java/org/hisp/dhis/sqlview/jdbc/JdbcSqlViewExpandStore.java 2014-01-28 14:18:54 +0000 @@ -164,11 +164,15 @@ { try { - jdbcTemplate.update( "DROP VIEW IF EXISTS " + statementBuilder.columnQuote( viewName ) ); + final String sql = "DROP VIEW IF EXISTS " + statementBuilder.columnQuote( viewName ); + + log.info( "Drop view SQL: " + sql ); + + jdbcTemplate.update( sql ); } catch ( BadSqlGrammarException ex ) { - throw new RuntimeException( "Failed to drop view: " + viewName, ex ); + log.warn( "Could not drop view: " + viewName, ex ); } } } \ No newline at end of file