ORA-01795 getAssignmentChains for patch policy bundle

  • 7016928
  • 20-Oct-2015
  • 14-Dec-2015

Environment

Novell ZENworks Configuration Management 11.3

Situation

Error when using bundles with more than 1000 child actions on Oracle database.  Agent devices fail to apply patch policy or bundle when the number of actions is > 1000.

ERROR:

[com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.SQLGrammarException: ORA-01795: maximum number of expressions in a list is 1000

Resolution

This is fixed in version 11.4.1 - see KB 7016895 "ZENworks Configuration Management 11.4.1 - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7016895

Workaround:  Break up patch policies or bundles to have fewer than 1000 install actions.