ZCM 10.1.1 Bulk Delete Error Deleting or Adding User Sources

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 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.




DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2008-12-12 21:33
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.