Target node/queue unavailable in R12

Error:

Manager log file shows below error

establish_icm - Unable to insert ICM record
Call to establish_icm failed
The Internal Concurrent Manager has encountered an error.

Review concurrent manager log file for more detailed information. : 12-NOV-2016 22:35:45 -


Shutting down Internal Concurrent Manager : 12-NOV-2016 22:35:45

List of errors encountered:
.............................................................................

_ 1 _
Routine AFPCSQ encountered an ORACLE error. .

Review your error messages for the cause of the error. (=<POINTER>)
.............................................................................


APP-FND-01564: ORACLE error 12899 in insert_icm_record

Cause: insert_icm_record failed due to ORA-12899: value too large for column "APPLSYS"."FND_CONCURRENT_PROCESSES"."NODE_NAME" (actual: 31, maximum: 30).

Solution:

Step 1:

Stop Concurrent managers

Check source node information in refreshed instance.

select CONCURRENT_QUEUE_NAME, CONTROL_CODE , TARGET_NODE, NODE_NAME   from FND_CONCURRENT_QUEUES where concurrent_queue_name like 'PROD%';

update FND_CONCURRENT_QUEUES set TARGET_NODE='TEST' where CONCURRENT_QUEUE_NAME='PROD';

Step 2:

Increase column value

SQL> create table APPLSYS.FND_CONCURRENT_PROCESSES_old as select * from APPLSYS.FND_CONCURRENT_PROCESSES;

Table created.

SQL> ALTER TABLE APPLSYS.FND_CONCURRENT_PROCESSES MODIFY NODE_NAME VARCHAR2(32);

Table altered.

Step 3:

Run cmclean.sql

Start Concurrent services now . It should work.