Purge Concurrent Request and/or Manager Data Running long after clone

cause
=======
When the purge program is run it will be executed from one of the concurrent processing nodes, it will try to delete the request log and output files. The complete paths to these files are stored in FND_CONCURRENT_REQUESTS table under columns LOGFILE_NAME and OUTFILE_NAME , the node where they are physically stored will be indicated in columns LOGFILE_NODE_NAME and OUTFILE_NODE_NAME.
The purge program will try to delete these log and output files from the node where it is running, it is mandatory that OS files can be accessed and deleted from the nodes where the concurrent managers are running.
The node retaining the out/log files doesn't exist anymore in the architecture, but the purge program uses this node name to delete the files from your system. If the program can not access these files it will have issues .


Need to check :

1.select count(*) from fnd_concurrent_requests

2.select LOGFILE_NODE_NAME, OUTFILE_NODE_NAME, count(*) from fnd_concurrent_requests
group by LOGFILE_NODE_NAME, OUTFILE_NODE_NAME

3.select node_name , SUPPORT_CP , SUPPORT_FORMS , SUPPORT_WEB,SUPPORT_ADMIN, STATUS
from fnd_nodes

4.select CONCURRENT_QUEUE_NAME , MAX_PROCESSES , RUNNING_PROCESSES ,
TARGET_NODE , NODE_NAME , NODE_NAME2 , ENABLED_FLAG , CONTROL_CODE
from FND_CONCURRENT_QUEUES
/

SELECT trigger_name , status FROM user_triggers WHERE table_name = 'FND_NODES' 

5- What is the result of the unix commands from the concurrent manager node :

uname -a
hostname
domainname

==============SOLUTION ================================

create table FND_RUN_REQUESTS_bk1 as select * from FND_RUN_REQUESTS  126
create table FND_CONCURRENT_REQUESTS_bk1 as select * from FND_CONCURRENT_REQUESTS   (rows =4964  )
create table FND_CONCURRENT_PROCESSES_bk1 as select * from FND_CONCURRENT_PROCESSES  (rows=1073 )


delete  FND_RUN_REQUESTS WHERE parent_request_id
in (select request_id from FND_CONCURRENT_REQUESTS where upper(LOGFILE_NODE_NAME) = 'OLDNODE' or upper(OUTFILE_NODE_NAME) = 'OLDNODE');


delete FND_CONCURRENT_REQUESTS where upper(LOGFILE_NODE_NAME) = 'OLDNODE' or
upper(OUTFILE_NODE_NAME) = 'OLDNODE';