Concurrent Manager Fails With ORA-25215 APPS.FND_CP_GSM_IPC (Doc ID 808676.1)

Concurrent Manager Fails With ORA-25215 APPS.FND_CP_GSM_IPC (Doc ID 808676.1)

---

---

Applies to:

Oracle Concurrent Processing - Version 11.5.10.2 to 12.0.6 [Release 11.5 to 12]
Information in this document applies to any platform.
***Checked for relevance on 04-Feb-2013***

Symptoms

After successful upgrade from 11.5.8 (Oracle Database 8i) to eBusiness suite 12.0.6 (Oracle Database 10.2.0.4), the following error messages appear in the concurrent manager log and FNDSM.mgr logs every two minutes. Standard concurrent manager is up and running, however, Output Post Processor (FNCPOPP) is down.


Filename= appt_xxx.mgr
See
Messages Repeat Every two (2) Minutes

Process monitor session started : 09-APR-2009 11:46:14
Found dead process: spid=(999999), cpid=(1685722), Service Instance=(1066)
Found dead process: spid=(999999), cpid=(1685724), Service Instance=(1067)
Found dead process: spid=(999999), cpid=(1685723), Service Instance=(1068)
Found dead process: spid=(999999), cpid=(1685721), Service Instance=(1069)

Filename= FNDSMxxxx.mgr

The SQL statement being executed at the time of the error was: begin
FND_CP_GSM_IPC.Cartridge_Init_Service(:h, :p, :d); end; and was executed from the file
&ERRFILE.
09-APR-2009 11:48:15 - ORACLE error 25215 in init_service

Cause: init_service failed due to ORA-25215: user_data type and queue type do not match
ORA-06512: at "APPS.FND_CP_GSM_IPC", line 178
ORA-06512: at line 1.

Changes

Upgraded from 11.5.8 (Oracle DB 8i) to eBusiness suite 12.0.6 (Oracle DB 10.2.0.4)

Cause

Queue 'FND_CP_GSM_IPC_AQTBL' is corrupt in this case, but the error could have occurred in any of the queues that are part of the aftcm049.sql - which creates all Advanced Queues with payload structures.

Solution

To implement the solution, please execute the following steps on TEST environment:

1) Need to recreate the queue as follows

1.1 Backup the database.
1.2 Bring down the concurrent manager.
1.3 Log into SQLPLUS as APPLSYS user and execute the following:


2) exec DBMS_AQADM.STOP_QUEUE('FND_CP_GSM_IPC_AQ');

3) exec DBMS_AQADM.DROP_QUEUE('FND_CP_GSM_IPC_AQ');

4) exec DBMS_AQADM.DROP_QUEUE_TABLE('FND_CP_GSM_IPC_AQTBL');

Note:- Ignore if there is a error while dropping the queues.

5) exec DBMS_AQADM.CREATE_QUEUE_TABLE(queue_table => 'FND_CP_GSM_IPC_AQTBL', -
queue_payload_type => 'SYSTEM.FND_CP_GSM_IPQ_AQ_PAYLOAD', -
sort_list => 'priority,enq_time', -
multiple_consumers => TRUE, -
comment => 'IPC for GSM Generic Cartridge', -
compatible => '8.1');

6) exec DBMS_AQADM.CREATE_QUEUE ('FND_CP_GSM_IPC_AQ', FND_CP_GSM_IPC_AQTBL');

7) exec DBMS_AQADM.START_QUEUE ('FND_CP_GSM_IPC_AQ');

8) Retest the issue and let us know the feedback.
If it still errors out , run aftcm049.sql  which creates all Advanced Queues with payload structures.
1.Bring down all concurrent managers.
2.Login to sqlplus:
  2.1 sqlplus apps/
  2.2 @ $FND_TOP/patch/115/sql/aftcm049.sql
  2.3 when prompted for 1: and 2: provide applsys and applsys's password.
3. Restart the concurrent managers.
4. Retest the issue and let us know the feedback.