Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

R12: XML Reports end with WARNING Status, Using Virtual Hostname by Veritas HA

Created: 05 Jun 2013 | 6 comments

Dear Experts,

We are using the Veritas HA cluster to configure our ERP Application on Virtual Hostname. With Release 11i every thing was working fine,

We have upgraded our Application from 11.5.10.2 to R12, 12.1.3. Now in the Upgraded Application we are unable to open/view any of the XML based Concurrent Reports. All the XML Concurrent Reports are ending in Status WARNING.

When we click on the View Out put, we are just getting the XML code and not the XML based reports.

The log file of Out Put Postprocessor shows the following errors:
================================================
5/28/13 12:40:20 PM] [STATEMENT] [960882:RT4152834] Get Output Type
[5/28/13 12:40:20 PM] [STATEMENT] [960882:RT4152834] XML file name: /mnt/oracle/ERPROD/inst/apps/ERPROD_erp-lh-dr/logs/appl/conc/out/o4152834.out
[5/28/13 12:40:20 PM] [STATEMENT] [960882:RT4152834] XML file is on node: ERP-LH-DR
[5/28/13 12:40:20 PM] [UNEXPECTED] [960882:RT4152834] java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1224)
at oracle.apps.fnd.cp.util.CpUtil.getCanonicalLocalNode(CpUtil.java:127)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:244)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)

[5/28/13 12:40:20 PM] [960882:RT4152834] Completed post-processing actions for request 4152834.

And error like below:

The error we are getting from the Application log files are related to Hostname. Following is the abstract from the Output Post Processor log.

[5/29/13 2:56:02 PM] [UNEXPECTED] [960900:RT4155505] java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1224)
at oracle.apps.fnd.cp.util.CpUtil.getCanonicalLocalNode(CpUtil.java:127)
at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:244)
at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176)
===============================================================

Concurrent Manger Log files shows the following error:
===========================================================
---------------------------------------------------------------------------
Executing request completion options...

Output file size:
430455

------------- 1) PUBLISH -------------
Beginning post-processing of request 4158856 on node ERP-LH-DR at 30-MAY-2013 18:53:38.
Post-processing of request 4158856 failed at 30-MAY-2013 18:53:38 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
--------------------------------------

------------- 2) PRINT -------------
Not printing the output of this request because post-processing failed.
--------------------------------------
 

Finished executing request completion options.

---------------------------------------------------------------------------
Concurrent request completed
==========================================================

Please suggests:

1- Is there any way to make these XML reports work with Veritas HA, using Virtual hostname

2- Can we identify or pin point from where the Out Put Postprocessor is setting the Physical Hostname.

Regards
Ali Ammar

Operating Systems:
Discussion Filed Under:

Comments 6 CommentsJump to latest comment

Satish K. Pagare's picture

Ali, are you using the OracleAppsCM (Oracle E-Business Concurrent Manager) agent to cluster the resource under VCS control? Please refer to the agent guide for details about how to setup the virtual hostname. The agent and the documentation is available at: https://sort.symantec.com/agents

Satish K. Pagare's picture

Also please note that this forum is for Application HA product. If your query is pertaining to VCS the more appropriate forum would be "Cluster Server" forum.

Ali Ammar's picture

Hi Satish,

Thanks for the update. We have used the document "Veritas ™ High Availability Agent for Oracle e-Business Concurrent Manager". Moreover the same configuration is working with 11i, but with R12, the only issue is with built in R12 XML reports.

Secondly, can this case be transferred to Cluster Server, or do i have to create a new thread there.

Regards

Ali.

Satish K. Pagare's picture

Ali, what is the version of the agent that you have installed? The package name would be VRTSvcsoc11.

Ali Ammar's picture

Hi Satish,

Following is the agent version:

============================

hasan@marble1: /export/home/hasan $ sudo pkginfo -l VRTSvcsoc11

Password:

   PKGINST:  VRTSvcsoc11

      NAME:  VERITAS VCS Agent 5.0 for Oracle E-Business Suite Concurrent Manager

  CATEGORY:  application

      ARCH:  sparc

   VERSION:  5.0.8.0

   BASEDIR:  /

    VENDOR:  Symantec Corporation

      DESC:  VERITAS VCS Agent 5.0 for Oracle E-Business Suite Concurrent Manager

    PSTAMP:  5.0.8.0 201209201231

  INSTDATE:  May 30 2013 16:12

    STATUS:  completely installed

     FILES:       25 installed pathnames

                  11 shared pathnames

                  13 directories

                   9 executables

                 246 blocks used (approx)

===================================

Regards

Ali.

Satish K. Pagare's picture

Ali, the version looks correct. I am guessing that you have followed the document and correctly setup the LD_PRELOAD settings accordingly. Could you make sure that the virtual hostname that you are using is resolvable on the cluster nodes? You can add it temporarily to /etc/hosts for verification purpose. Let me know if that helps.