Novell is now a part of Micro Focus

My Favorites


Please to see your favorites.

Error seen in catalina.out: Maximum number of expressions in a list is 1000

This document (7012108) is provided subject to the disclaimer at the end of this document.


Novell Vibe 3.3


Vibe sites configured with an Oracle database may experience the following error condition in the catalina.out file IF more than a 1000 workflow-enabled entries were deleted as part of deleting an entire workspace or folder/sub-folders:

2013-03-15 17:24:37,479 WARN  [Sitescape_Worker-9] [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 1795, SQLState: 42000
2013-03-15 17:24:37,480 ERROR [Sitescape_Worker-9] [org.hibernate.util.JDBCExceptionReporter] - ORA-01795: maximum number of expressions in a list is 1000

2013-03-15 17:24:37,480 WARN  [Sitescape_Worker-9] [org.kablink.teaming.module.folder.impl.DefaultFolderCoreProcessor] - Error delete folder /Home Workspace/Team Worksp
Caused by: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000


A patch is available to correct this problem for Novell Vibe 3.3. Please contact Novell Technical Support with reference to this TID and request the patch for your Vibe 3.3 site.


This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7012108
  • Creation Date:09-APR-13
  • Modified Date:10-APR-13
    • NovellVibe

Did this document solve your problem? Provide Feedback