This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Can't Modify or Delete ZESM Firewall Policies

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?

 

 

  • 0  

    Which Version of ZCM?   There were some issues in ZCM 2020 with MS_SQL and with "Constraint" issues with FW Policies.

    If you can open an SR, Reference SR#1159395, and they can get you some SQL Statements to make fix it up.

    If you are an educational institution that  can't open an SR, send me a private message on the forums with your contact info.

    --

    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

    Be sure to "Like" My (and a few others) Cool Solutions below! 

    https://community.microfocus.com/members/craigdwilson/bookmarks