Tuesday, July 28, 2009

Purge Concurrent Request FNDCPPUR program deletes files from database but not from the file system

Purge Concurrent Request and/or Manager Data (FNDCPPUR) program completes and it deletes concurrent request information from database but relevant files are not removed from the operating system (OS) file system. Concurrent request Log file shows file deletion failed as below.
For example
..
..
* 545345 - /../../w545345.mgr
* 545346 - /../../w545346.mgr

* denotes file deletion failed.

Cause:
The cause of this problem has been identified in Bug 6451570. It is caused by the domain name entry. The system manager_node entry contains the domain also. Therefore comparison between manager_node and node_name fails causing the files not to delete from OS (Unix,Windows,..) file system.

Solution
To implement the solution, Please execute the following steps if you are on 11i

1) Please download and review the readme for Patch 7210178
2) Please apply Patch 7210178 in a test environment.
3) Please confirm the following file versions: afppur.lpc 115.35 You can use the commands like the following: strings -a $FND_TOP/bin/FNDCPPUR grep afppur
4) Please retest the issue.
5) If the issue is resolved, please migrate the solution as appropriate to other environments.
(OR)
Please execute the following steps if you are on R12


1) Please download and review the readme for Patch 7530490
2) Please apply Patch 7530490 in a test environment.
3) Please confirm the following file versions: afppur.lpc 120.4.12000000.4 You can use the commands like the following: strings -a $FND_TOP/bin/FNDCPPUR grep afppur
4) Please retest the issue.
5) If the issue is resolved, please migrate the solution as appropriate to other environments.

Note: In this fix, the domain name is removed from the manager node if it exists and compared to node name. After the fix , It should delete relevant files from the file system.

1 comment:

Anonymous said...

you can quickly reproduce the sql server 2005 repair process with another utility for data recovery