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.