ZCM 10.1.1 Bulk Delete Error Deleting or Adding User Sources


Cannot create Administrator users or delete a user source... resulting in a "bulk delete error".

Issue: Unable to create groups, folders, admin (from user sources or in zcc)

Platform: Windows 2003 R2 SP3 Enterprise 32-bit

ZENworks Version: 10.1.1

Database: Oracle 10g database on separate server

ZCC LOG: Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded

Need to configure the oracle database setting. It should be larger than the default of 300:

View cursor setting:

show parameter open_cursors

Modify cursors setting:

alter system set open_cursors=1000

--------------------  view of parameters and results -----------------
SQL*Plus: Release - Production on Tue Nov 18 13:56:14 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release - 64bit
Production With the Partitioning, OLAP and Data Mining options
SQL> "show parameter open_cursors"
------------------------------------ ----------- ------------------------------
open_cursors integer 300
SQL> "alter system set open_cursors=1000;"
System altered.

Paul Pedron

Micro Focus Product Manager


How To-Best Practice
Comment List
Related Discussions