Forum Discussion

Ali_Ammar's avatar
Ali_Ammar
Level 2
12 years ago

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

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

Agents
ApplicationHA
business continuity
Solaris
  • Satish_K__Pagar's avatar
    Satish_K__Pagar
    Level 5
    12 years ago

    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__Pagar's avatar
    Satish_K__Pagar
    Level 5
    12 years ago

    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 avatar
    Ali_Ammar
    Level 2
    12 years ago

    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__Pagar's avatar
    Satish_K__Pagar
    Level 5
    12 years ago

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

  • Ali_Ammar's avatar
    Ali_Ammar
    Level 2
    12 years ago

    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__Pagar's avatar
    Satish_K__Pagar
    Level 5
    12 years ago

    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.