Saturday, January 4, 2014

An error occurred while attempting to establish an Applications File Server connection OPP Files


I did R12 upgrade recently from 11i and as part of upgrade we had server migration also. So as part this activity we copied all old concurrent log & out files from old 11i server to new R12 server.

After copying all the files we updated fnd_concurrent_requests table to open old log and out files from R12 applications.

Then users are now able to open their 11i standard Log & Out files. But users are not able to open their Concurrent PDF output that is generated by Output post processor. Users when try to launch PDF out files they get below error.



An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_<oldserver>. There may be a network configuration problem, or the TNS listener on node FNDFS_<oldserver> may not be running. Please contact your system administrator.




Solution:

After  investigation I identified that OPP will store file generayion details like file type,nodename, filename in table FND_CONC_REQ_OUTPUTS instead of FND_CONCURRENT REQUESTS. After updating these tables manually as below users are able to open OPP PDF output files.

update FND_CONC_REQ_OUTPUTS set
FILE_NAME=replace(FILE_NAME,'/u01/oracle/testcomn/admin/out/PROD_test','/u01/oracle/test/inst/apps/PROD_test/logs/appl/conc/out/PROD_tes');

 update FND_CONC_REQ_OUTPUTS  set FILE_NODE_NAME='<NewServer>'
 where FILE_NODE_NAME='<OldServer>';

...