Valued Contributor.
Valued Contributor.

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?



1 Reply
Micro Focus Expert
Micro Focus Expert

Re: Can't Modify or Delete ZESM Firewall Policies

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.

Please give a hearty thumbs up to any post you find helpful!
To find articles by Craig Wilson simply follow the link: Craig Wilson's Tips!
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.