This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I am not an administrator, rather a Maximo "power user". Here's my problem.
Database error number 604 has occurred.
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded
This has been occurring since our admins installed a new Oracle server and updated Maximo to version "MAXIMO Application Server 6.2.7 Build 20100824-1415 DB Build V600-768"
This error occurs whenever groups go records (sometimes as small as 6)are modified in any way and while generating PM workorders.
as your DBA to increase the number of open cursor. this require a DB
restart.
This can be caused by 2 main reasons :
* Number of open cursons is inadequate to your environment
* Bad programming (open session and dont close it in the coding)
in your case, it seems to be the first reason
HTH
On Thu, Jun 28, 2012 at 9:26 AM, steve <slsimpson@comcast.net> wrote:
> **
>
>
> I am not an administrator, rather a Maximo "power user". Here's my
> problem.
>
> Database error number 604 has occurred.
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01000: maximum open cursors exceeded
> ORA-01000: maximum open cursors exceeded
>
> This has been occurring since our admins installed a new Oracle server and
> updated Maximo to version "MAXIMO Application Server 6.2.7 Build
> 20100824-1415 DB Build V600-768"
>
> This error occurs whenever groups go records (sometimes as small as 6)are
> modified in any way and while generating PM workorders.
>
>
>
--
Mohamed Skandaji, MBA, PMP