Article

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 10.1.0.5.0 - 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 10.1.0.5.0 - 64bit 
Production With the Partitioning, OLAP and Data Mining options
SQL> "show parameter open_cursors"
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     300
SQL> "alter system set open_cursors=1000;"
System altered.