We recently upgraded the databases from 9.2.0.8.0 to 11.2.0.3 by DBUA.
The issue is while opening cursor , It is getting failed. Application is using AQUA Data (3rd party Tool) to connect to db and code was written in informix 4gl.
Error is:
OPEN c_det_cur
IF SQLCA.SQLCODE <> 0
THEN
--- database error
LET m _msg = "sel_det_recs(): OPEN cursor failed. SQLCODE = ",
SQLCA.SQLCODE, " ISAM = ", SQLCA.SQLERRD[2]
LET m_ignore = sh_elog_4gl(m_module_name, 3557, m_msg CLIPPED)
CALL sh_err_msg("S2204")
LET m_ignore = sh_mlog_4gl(g_std_func_chan, m_module_name, 3559,
"EXIT: sel_det_recs")
CALL sf_process_panel("C")
RETURN TRUE, 0
END IF
Please find the attachment which shows complete batch , How that batch will run.
The same program is running fine in Oracle 9i.
Size of the PGA is 7GN and open cursors=300
Query running fine from database end.
- Issue happens while opening the Cursor.
- Same was working fine in 9i.
- Last time when they faced this issue it was due to the Temporary tablesspace not existed as part of DR switchover. After recreating the Temporary Tablespace this issue vanished.
- This time the Temporary tablespace is present and we are not sure why they get this issue.