XML Publisher reports completing in error

Posted byIndraneil SealPosted inUncategorized

User reported that there were performance issues for some of the custom programs. In addition, concurrent view output was displaying in XML format.

1. Performance Issue reported for few concurrent programs- XX: AR Arrears Aging Summary Report , XX AR Adjustment ODSP & XX Bank Statement Line Analyzer Report

2. Concurrent->Request->”View Output” is displaying in XML instead of pdf format

Initial investigation showed that all the concurrent jobs in question use XML Publisher.

The OPP log file details the following error:

$ find FNDO* |xargs grep -i 10400888

FNDOPP110027.txt:[2/4/21 11:40:27 AM] [OPPServiceThread0] Post-processing request 10400888. FNDOPP110027.txt:[2/4/21 11:40:27 AM] [UNEXPECTED] [110827:RT10400888] java.io.IOException: No such file or directory FNDOPP110028.txt:[2/4/21 11:40:27 AM] [OPPServiceThread0] Post-processing request 10400888. FNDOPP110028.txt:[2/4/21 11:40:27 AM] [UNEXPECTED] [110028:RT10400888] java.io.IOException: No such file or directory

Root Cause & fix:

1. OPP temporary directory was incorrect – /data1/oracle/UAT/tmp. The  temporary directory path for XML publisher is the cause for performance issue of the below reports. Basically the underlying queries are returning results in expected time, after then it’s waiting on OPP for postprocessing for long time and finally completing in warning.

2. Fix was to set OPP temp directory under: XML Publisher Administrator responsibility. Navigate to menu Administration ->Configuration -> General->Temporary Directory. The directory needs to be read/writable by the applmgr user (owner of the $APPL_TOP file system).

3. We also noticed the variable APPLLKOR was set under $APPL_TOP/admin/adovars*.env file, which was pointing to wrong directory

APPLLKOR=”/data/oracle/PROD/tmp” export APPLLKOR

We commented it out, logged out from the bash shell and logged back in and made sure APPLLKOR is unset.

Finally, restarted the application services & the reports performance issue was resolved.

Published by Indraneil Seal

I originally hail from Kolkata, India, and I've dedicated a significant portion of my professional journey to both India and the United States before relocating to Canada during the pandemic. I’m a member of MongoDB's esteemed Technical Services team. Before joining this exceptional group, I held the role of Senior Apps DBA at the Government of Ontario. Prior to that, I spent many years honing my technical(DBA/Cloud) and soft skills with TCS, KBACE Technologies(which later got acquired by Cognizant Technology Solutions) and Oracle Corporation. Throughout my career, I was deeply immersed in day-to-day operations and spearheaded significant projects, including the modernization of platforms, Oracle application and database upgrades. In my last stint at the Government of Ontario, I was also responsible for overseeing various automation initiatives including out-of-place patching, automated EBS Application patching. Outside of my professional life, I have a strong passion for reading, blogging, spending quality time with my family, and my feline buddies, Smokey & Louis. I also relish solitary walks and jogging as personal interests. As a proponent of open source technologies, I'm looking forward to sharing my knowledge and expertise as well as contribute as much as possible to the success of the IT fraternity thereby perpetually expanding my skillset.

Leave a comment