10 Replies Latest reply: Nov 27, 2012 9:39 AM by Soni RSS

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

    Soni
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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