Cool Solutions

ZCM 10.1.1 Bulk Delete Error Deleting or Adding User Sources


December 12, 2008 1:33 pm





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"
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     300
SQL> "alter system set open_cursors=1000;"
System altered.

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this post.

Categories: Uncategorized


Disclaimer: This content is not supported by Micro Focus. It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test it thoroughly before using it in a production environment.