Friday, September 12, 2014

BI Publisher (formerly XML Publisher) Requests Are Failing With Error "OPP Error Oracle.apps.xdo.XDOException: Error Creating Lock File

BI Publisher (formerly XML Publisher) Requests Are Failing With Error "OPP Error Oracle.apps.xdo.XDOException: Error Creating Lock File

Error

oracle.apps.xdo.XDOException: Error creating lock file
        at oracle.apps.xdo.oa.util.FontCacheManager.createLockFile(FontCacheManager.java:363)
        at oracle.apps.xdo.oa.util.FontCacheManager.getFontFromDB(FontCacheManager.java:412)
        at oracle.apps.xdo.oa.util.FontCacheManager.getFontFilePath(FontCacheManager.java:221)
        at oracle.apps.xdo.oa.util.FontHelper.createFontProperties(FontHelper.java:432)
        at oracle.apps.xdo.oa.util.ConfigHelper.getFontProperties(ConfigHelper.java:166)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5817)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:302)
        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:179)
[9/10/14 4:28:52 AM] [493966:RT178323863] Output file was found but is zero sized - Deleted
[9/10/14 4:28:52 AM] [UNEXPECTED] [493966:RT178323863] oracle.apps.xdo.XDOException: Error creating lock file
        at oracle.apps.xdo.oa.util.FontCacheManager.createLockFile(FontCacheManager.java:363)
        at oracle.apps.xdo.oa.util.FontCacheManager.getFontFromDB(FontCacheManager.java:412)
        at oracle.apps.xdo.oa.util.FontCacheManager.getFontFilePath(FontCacheManager.java:221)
        at oracle.apps.xdo.oa.util.FontHelper.createFontProperties(FontHelper.java:432)
        at oracle.apps.xdo.oa.util.ConfigHelper.getFontProperties(ConfigHelper.java:166)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5817)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:302)
        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:179)

Troubleshooting

1. Check the error in OPP logs. Log file location is

cd $APPLCSF/$APPLLOG
ls --ltr FNDOPP* | tail

Solution

1. Login to Front End, Goto XML Publisher Administrator -> Administration -> General Tab -> Temporary directory

2. Make sure the Temporary directory path is set correctly as mentioned in the above

3. Make sure that this directory can be written to by applmgr from the node that the OPP is running on. You can use the touch command to test this.

4. Set the temporary directory to it's own directory at least 20x larger than the largest data file used by XMLP. Start off with at least 5GB.

5. Try resetting the diretory to a different directory on the same mount as the OPP

6 Bounce Concurrent Manager

7. Retest the issue

Reference: Doc ID 1512691.1

Oracle EBS integration with Oracle IDCS for SSO

Oracle EBS integration with Oracle IDCS for SSO Oracle EBS SSO? Why is it so important? Oracle E-Business Suite is a widely used application...