Resolution:
Cursors are work areas in memory where Oracle stores the current database programming. Depending on the size of your assets, there may be times when XCD requires more open cursors than are made available via the standard Oracle Instance initialization. The number of cursors available to XCD is determined by the OPEN_CURSORS initialization parameter. To change the OPEN_CURSORS parameter:

·    from the machine where Oracle is installed, navigate to \Oracle\(either admin or ora81)\(name of instance where Canon in installed)\pfile and edit the file "init.ora".
·    Search for a variable called 'OPEN-CURSORS'
·    XCD requires this parameter to be set to at least 100 (255 is the max).
·    If this variable doesn't exist, you can simply add the line open_cursors=255 to the end of the file and then save and close.
·    Restart the Oracle and XML Canon services.

What causes the runtime exception indicating "maximum open cursors exceeded."

Product: TIBCO XML Canon Version: 1.2 OS: All --------------------