Environment
Novell Vibe 3.3
Situation
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
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
Resolution
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.