Reports Failing when OPP and Standard are on Different Nodes
(Doc ID 469081.1)
Last updated on APRIL 07, 2024
Applies to:
Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Symptoms
When submitting report this is causing the concurrent managers to crash with error.
Applied patch 6277553.
ERROR
Cause: afpsmrsc failed due to ORA-01000: maximum open cursors exceeded.
APP-FND-01564: ORACLE error 1000 in afpsmrsc
Cause: afpsmrsc failed due to ORA-01000: maximum open cursors exceeded.
The SQL statement being executed at the time of the error was: Select S.SERVICE_HANDLE,
S.CARTRIDGE_HANDLE, Q.CONTEXT_BUFFER, Q.SERVICE_PARAMETERS, S.DEVELOPER_PARAMETERS, '', '',
S.ENV_FILE_NAME, SMQ.DIAGNOSTIC_LEVEL, Q.DIAGNOSTIC_LEVEL, DECODE(S.ALLOW_RCG, 'Y',
Q.RESOURCE_CONSUMER_GROUP, ''), ALLOW_MULTIPLE_PROC_INSTANCE, ALLOW_MULTIPLE_PROC_NODE,
MIGRATE_ON_FAILURE, SERVER_TYPE, ALLOW_SUSPEND, ALLOW_VERIFY, ALLOW_PARAMETER, ALLOW_START,
ALLOW_RESTART, PARAMETER_CHANGE_ACTION, nvl(q.TARGET_NODE, :icmnode), A.BASEPATH,
NVL(S.CARTRIDGE_APPLICATION_ID, 0),ALLOW_MULTIPLE_PROC_SI From Fnd_Concurrent_Queues Q,
fnd_cp_services S, Fnd_Concurrent_Queues smq, fnd_application A Where to_number(q.manager_type)
>999 and q.enabled_flag = 'Y' and q.manager_type = S.SERVICE_ID and q.APPLICATION_ID =
A.APPLICATION_ID and smq.NODE_NAME = nvl(q.TARGET_NODE, :<NODENAME>) and smq.manager_type = 6
and smq.enabled_flag = 'Y' and Q.concurrent_queue_id = :mgr_id and was executed from the file
&ERRFILE.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |