I'm having some issues modifying my ZESM Firewall Policies.
If I try to make changes and apply to make a sandbox I get: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
ZCC.log shows: Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "fk_FWPolPortR_FirewallPo_26". The conflict occurred in database "ZCMDB", table "dbo.FWPolPortRule", column 'FirewallPolicyID'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:592)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2935)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:471)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:410)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
... 77 more
The sandbox is created, however, it's stuck in limbo. Clicking on revert does nothing.
If I try to publish the bundle I get: Unable to complete your request due to the following reason: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: Unable to delete location reference
zcc.log shows:Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
I've even created new policies for testing purposes and those are able to be published initially. However when you modify them and try to publish again the same errors are thrown. Any ideas on where to start?