This discussion is archived
10 Replies Latest reply: Nov 27, 2012 7:39 AM by Soni RSS

Can not open rdf reports from browser after split configuration of apps11i

Soni Newbie
Currently Being Moderated
Dear All

Recently i have done a split of Apps 11i Cu2 as follows

Database:
Host     Platform     
*<db machine name >     HP/UX -- Non-CPU Specific     *
          
Apps and CONC
*<apps machine name >     LINUX Intel*

All web forms, fmb forms , reports from concurrent programs open correct, BUT CAN NOT open rdf reports. before split config rdf reports from browser were opened successfully.For example:

http://<machine-name>:8000/dev60cgi/rwcgi60?PROD_APPSserver=REP60_PROD+desformat=pdf+destype=cache+paramform=no+report=test.rdf+

When i try to open a reports like above it hangs...
Looking at the status of report server using http://<machine-name>:8000/dev60cgi/rwcgi60/showmyjobs?server=REP60_PROD report stays in status Enqueued

in the server log file REP60_PROD.log i can see some message like below

+2012-11-26 12:46:39 -- Server engine cannot be started. (REP60_PROD)+

Is there any doc specific to split config , to be followed for reports config..

any help it is greatly appreciated

Thanks and regards,
Soni
  • 1. Re: Can not open rdf reports from browser after split configuration of apps11i
    Soni Newbie
    Currently Being Moderated
    Hi All
    Any help or hint it is greatly appriciated because i am stucked at this issue.
    Thanks in advance
    Soni
  • 2. Re: Can not open rdf reports from browser after split configuration of apps11i
    Kashif M Oracle ACE
    Currently Being Moderated
    Did you followed proper cloning and it completed successful ?
    Check log file and paste error log here please
    thanks
  • 3. Re: Can not open rdf reports from browser after split configuration of apps11i
    Soni Newbie
    Currently Being Moderated
    Hi

    I followed the following docs

    Using Oracle EBS with a Split Configuration Database Tier on 11gR2 [Article ID 946413.1]
    Export/import notes on Applications 11i Database 11g [ID 557738.1]

    There is not any cloning procedure there.
    Reports that are run through Requests-> Submit new request open succesfully the problem is with reports opened using the following URL

    http://<machine-name>:8000/dev60cgi/rwcgi60?PROD_APPSserver=REP60_PROD+desformat=pdf+destype=cache+paramform=no+report=test.rdf+

    Thanks and regards,
    Soni
  • 4. Re: Can not open rdf reports from browser after split configuration of apps11i
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Please check the CM and OPP log files for details about the error.

    Thanks,
    Hussein
  • 5. Re: Can not open rdf reports from browser after split configuration of apps11i
    Soni Newbie
    Currently Being Moderated
    Hi Hussein

    please kindly can you address me where to find CM and OPP log...

    thanks and regards

    Soni
  • 6. Re: Can not open rdf reports from browser after split configuration of apps11i
    Soni Newbie
    Currently Being Moderated
    Hi Hussein

    Kindly let me stress the fact that
    Reports that are run through Requests-> Submit new request open successfully.

    The problem is with reports opened using the following URL
    http://<machine-name>:8000/dev60cgi/rwcgi60?PROD_APPS+server=REP60_PROD+desformat=pdf+destype=cache+paramform=no+report=test.rdf+

    thanks and regards

    Soni
  • 7. Re: Can not open rdf reports from browser after split configuration of apps11i
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Soni wrote:
    Hi Hussein

    please kindly can you address me where to find CM and OPP log...

    thanks and regards

    Soni
    OPP log file (FNDOPP* under $APPLCSF/$APPLLOG directory)
    CM log file (SID_*.mgr under $APPLCSF/$APPLLOG directory)

    Thanks,
    Hussein
  • 8. Re: Can not open rdf reports from browser after split configuration of apps11i
    Soni Newbie
    Currently Being Moderated
    Hi HUssein

    in +/oracle/prodcomn/admin/log/PROD_apps11i/rep60_PROD_apps11i.txt+ i can find some error like

    +11/26/12-19:41:51 :: adrepctl.sh version 115.33+


    +11/26/12-19:41:52 :: starting Reports Server for PROD on port 7000.+

    +11/26/12-19:41:52 :: adrepctl.sh: exiting with status 0+

    +================================================================================+

    rwrun60: relocation error: /oracle/prodora/8.0.6/network/jre11/lib/i686/native_threads/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
    rwrun60: relocation error: /oracle/prodora/8.0.6/network/jre11/lib/i686/native_threads/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
    rwrun60: relocation error: /oracle/prodora/8.0.6/network/jre11/lib/i686/native_threads/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference

    +11/26/12-19:52:29 :: adrepctl.sh version 115.33+


    +11/26/12-19:52:30 :: stopping Reports Server for PROD on port 7000.+

    +11/26/12-19:52:30 :: adrepctl.sh: exiting with status 0+



    while in same path as above in life PROD_1126.mgr i can find some error like below

    +========================================================================+
    Starting PROD_1126@PROD Internal Concurrent Manager -- shell process ID 26619

    logfile=/oracle/prodcomn/admin/log/PROD_apps11i/PROD_1126.mgr
    PRINTER=noprint
    mailto=oracle
    restart=N
    diag=N
    sleep=60 (default)
    pmon=20 (default)
    quesiz=1  (default)

    Routine &ROUTINE has attempted to start the internal concurrent manager.  The ICM is already running.  Contact you system administrator for further assistance.afpdlrq received an unsuccessful result from PL/SQL procedure or function FND_DCP.Request_Session_Lock.
    Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request.
    Possible DBMS_LOCK.Request resultCall to establish_icm failed
    The Internal Concurrent Manager has encountered an error.

    Review concurrent manager log file for more detailed information. : 26-NOV-2012 19:41:55 -


    Shutting down Internal Concurrent Manager : 26-NOV-2012 19:41:55

    List of errors encountered:
    +.............................................................................+

    +_ 1 _+
    Routine AFPCSQ encountered an ORACLE error. .

    Review your error messages for the cause of the error. (=<POINTER>)
    +.............................................................................+



    List of errors encountered:
    +.............................................................................+

    +_ 1 _+
    Routine AFPCAL received failure code while parsing or running your
    concurrent program CPMGR

    Review your concurrent request log file for more detailed information.
    Make sure you are passing arguments in the correct format.
    +.............................................................................+

    The PROD_1126@PROD internal concurrent manager has terminated with status 1 - giving up.
    +26-NOV-2012 19:41:57+
    Request  : 342914
    Priority : 0
    Program  : 0/5
    State    : Q

    Process monitor session started : 26-NOV-2012 19:43:12


    Found dead process: spid=(23850), cpid=(4579), ORA pid=(69), manager=(0/4)


    Found dead process: spid=(23854), cpid=(4580), ORA pid=(70), manager=(0/5)

    Process monitor session ended : 26-NOV-2012 19:43:12
    +26-NOV-2012 19:43:12+
    Request  : 342914
    Priority : 0
    Program  : 0/5
    State    : Q

    Shutting down Internal Concurrent Manager : 26-NOV-2012 19:43:12
    The PROD_1126@PROD internal concurrent manager has terminated successfully - exiting.


    thanks and regards

    Soni
  • 9. Re: Can not open rdf reports from browser after split configuration of apps11i
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Please see these docs.

    Running Concurren Request Causes AR60run: relocation error libjava.so: symbol__libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference [ID 404500.1]
    EBS R11i - GLIBC_2.0 not defined in file 'libc.so.6' with link time reference (libzip.so) [ID 806345.1]
    Concurrent Processing - ar60runb: __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference [ID 418856.1]

    Thanks,
    Hussein
  • 10. Re: Can not open rdf reports from browser after split configuration of apps11i
    Soni Newbie
    Currently Being Moderated
    Hi Hussein,

    I reviewed you recommended docs, and after that i did open a SR for this issue

    They said provide the info for ls -l $ORACLE_HOME/bin/rwrun60 and apply Patch 4632932 if it is not been applied.
    I did applied the patch recommended patch
    after that a added the
    LD_PRELOAD="/lib/libcwait.so"
    export LD_PRELOAD
    in the PROD_apps11i.env file.

    After that i am getting the following error when i start the apps tier using ./adstrtall.sh
    ERROR: ld.so: object '/usr/lib/libcwait.so' from LD_PRELOAD cannot be preloaded: ignored.

    the good news is that the reports can now be opened.

    I am working with support related to the new issue ERROR: ld.so: object

    thanks and regards
    Soni

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points