14 Replies Latest reply: Apr 26, 2012 2:03 AM by Hussein Sawwan-Oracle RSS

    An unexpected error has been detected by HotSpot Virtual Machine:

    User332967
      Hi there,
      One of our custome report completed with error its included barcode.jar. this report runing localy on server but through ebs r12 we are getting following error.

      ---------------------------------------------------------------------------
      Human Resources: Version : 12.0.0

      Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

      FTIEMPBARCODECARD module: FTIL Employee Card
      ---------------------------------------------------------------------------

      Current system time is 16-APR-2012 15:57:46

      ---------------------------------------------------------------------------


      +-----------------------------
      | Starting concurrent program execution...
      +-----------------------------

      Arguments
      ------------
      EMPLOYEE='''5197'''
      ------------

      APPLLCSP Environment Variable set to :

      Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
      American_America.UTF8

      '.,'

      stat_low = 6
      stat_high = 0
      emsg:was terminated by signal 6
      Enter Password:
      #
      # An unexpected error has been detected by HotSpot Virtual Machine:
      #
      # SIGSEGV (0xb) at pc=0xf70305e9, pid=21552, tid=3456461712
      #
      # Java VM: Java HotSpot(TM) Server VM (1.4.2_14-b05 mixed mode)
      # Problematic frame:
      # C [librw.so+0x35a5e9] rwtimri+0x45
      #
      # An error report file with more information is saved as hs_err_pid21552.log
      #
      # If you would like to submit a bug report, please visit:
      # http://java.sun.com/webapps/bugreport/crash.jsp
      #

      Report Builder: Release 10.1.2.3.0 - Production on Mon Apr 16 15:57:47 2012

      Copyright (c) 1982, 2005, Oracle. All rights reserved.


      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------
      Program was terminated by signal 6
      Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 1790641.

      Review your concurrent request log and/or report output file for more detailed information.


      please help me out inthis regards.

      Regards,
      Mohsin
        • 1. Re: An unexpected error has been detected by HotSpot Virtual Machine:
          Hussein Sawwan-Oracle
          Please post the details of the application release, database version and OS.

          What is the type of the report?

          How did you build barcode.jar file?

          Do you get the same error if you remove the barcode.jar file?

          Reports Builder Crashing With "An Unexpected Error Has Been Detected By Hotspot Virtual Machine" [ID 1161803.1]
          PDF Reports Fail with Signal 6 *** glibc detected *** ora_rw20_run: free(): invalid pointer [ID 1295724.1]

          Thanks,
          Hussein
          • 2. Re: An unexpected error has been detected by HotSpot Virtual Machine:
            User332967
            Dear Hussein
            thanks a lot for prompt response. Hussein please find below requierd info.

            1) Please post the details of the application release, database version and OS.
            Oracle ebs R12(12.1.2), 11.1.0.7, linux 5.

            2) What is the type of the report?
            It’s a barcode generating report for employee card.

            3) How did you build barcode.jar file?
            Barcode.jar file download from IDautomation official website.

            4) Do you get the same error if you remove the barcode.jar file?
            When I initially run report it gave me the same error as mention but as u said remove barcode and when I generate same error occur so when I remove image of employee report working fine and after when I add barcode its also working fine now the summary is report is not working when I use employee image on report.

            Waiting for your valuable response.

            Regards,
            Mohsin
            • 3. Re: An unexpected error has been detected by HotSpot Virtual Machine:
              Hussein Sawwan-Oracle
              Can you find any errors in the CM/OPP log files?

              Thanks,
              Hussein
              • 4. Re: An unexpected error has been detected by HotSpot Virtual Machine:
                User332967
                Dear Hussein
                please find output of some log files.

                aferror.log
                -----------
                The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.
                =================STARTUP TIME= 2012/04/03 15:50:10=================
                PROCEDURE fnd.src.osd.affile.affcuspath.start: Constructing filepath. Appl=FND, name=US, type_name=MESG, write_flag=0
                PROCEDURE fnd.src.osd.affile.affcuspath.end: /orahome/PROD/apps/apps_st/appl/fnd/12.0.0/mesg/US.msb
                =================STARTUP TIME= 2012/04/11 11:56:07=================
                PROCEDURE fnd.src.osd.affile.affcuspath.start: Constructing filepath. Appl=FND, name=US, type_name=MESG, write_flag=0
                PROCEDURE fnd.src.osd.affile.affcuspath.end: /orahome/PROD/apps/apps_st/appl/fnd/12.0.0/mesg/US.msb
                =================STARTUP TIME= 2012/04/11 11:58:27=================
                PROCEDURE fnd.src.osd.affile.affcuspath.start: Constructing filepath. Appl=FND, name=US, type_name=MESG, write_flag=0
                PROCEDURE fnd.src.osd.affile.affcuspath.end: /orahome/PROD/apps/apps_st/appl/fnd/12.0.0/mesg/US.msb




                FNDOPP168507.txt
                ----------------
                [4/16/12 5:02:03 AM] [main] Starting GSF service with concurrent process id = 168507.
                [4/16/12 5:02:03 AM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
                [4/16/12 5:02:03 AM] [Thread-24] Service thread starting up.
                [4/16/12 5:02:03 AM] [Thread-25] Service thread starting up.
                [4/16/12 9:34:04 AM] [OPPServiceThread1] Post-processing request 1788096.
                [4/16/12 9:35:16 AM] [OPPServiceThread1] Post-processing request 1788121.
                [4/16/12 9:35:16 AM] [168507:RT1788121] Executing post-processing actions for request 1788121.
                [4/16/12 9:35:17 AM] [168507:RT1788121] Starting XML Publisher post-processing action.
                [4/16/12 9:35:17 AM] [168507:RT1788121]
                Template code: XLAAAR01
                Template app: XLA
                Language: en
                Territory: US
                Output type: EXCEL
                [041612_093517094][][EXCEPTION] [DEBUG] ------- Preferences defined PreferenceStore -------
                [041612_093517094][][EXCEPTION] [DEBUG] ------- Environment variables stored in EnvironmentStore -------
                [041612_093517094][][EXCEPTION] [DEBUG] [FND_JDBC_IDLE_THRESHOLD.LOW]:[-1]
                [041612_093517094][][EXCEPTION] [DEBUG] [SECURITY_GROUP_ID]:[0]
                [041612_093517095][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_DECAY_INTERVAL]:[300]
                [041612_093517095][][EXCEPTION] [DEBUG] [NLS_CHARACTERSET]:[UTF8]
                [041612_093517095][][EXCEPTION] [DEBUG] [RESP_APPL_ID]:[-1]
                [041612_093517095][][EXCEPTION] [DEBUG] [NLS_LANGUAGE]:[AMERICAN]
                [041612_093517095][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MIN]:[1]
                [041612_093517095][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MAX]:[2]
                [041612_093517095][][EXCEPTION] [DEBUG] [NLS_NUMERIC_CHARACTERS]:[.,]
                [041612_093517095][][EXCEPTION] [DEBUG]

                [APPS_JDBC_URL]:[jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp
                )(HOST=oraprd.fti-nbil.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD)))]
                [041612_093517095][][EXCEPTION] [DEBUG] [RESP_ID]:[-1]
                [041612_093517095][][EXCEPTION] [DEBUG] [FND_MAX_JDBC_CONNECTIONS]:[500]
                [041612_093517095][][EXCEPTION] [DEBUG] [FND_JDBC_USABLE_CHECK]:[false]
                [041612_093517095][][EXCEPTION] [DEBUG] [USER_ID]:[-1]
                [041612_093517095][][EXCEPTION] [DEBUG] [NLS_TERRITORY]:[AMERICA]
                [041612_093517096][][EXCEPTION] [DEBUG] [FND_JDBC_PLSQL_RESET]:[false]
                [041612_093517096][][EXCEPTION] [DEBUG] [FND_JDBC_CONTEXT_CHECK]:[true]
                [041612_093517096][][EXCEPTION] [DEBUG] [NLS_DATE_FORMAT]:[DD-MON-RR]
                [041612_093517096][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_DECAY_SIZE]:[5]
                [041612_093517096][][EXCEPTION] [DEBUG] [FND_JDBC_IDLE_THRESHOLD.HIGH]:[-1]
                [041612_093517096][][EXCEPTION] [DEBUG] [NLS_SORT]:[BINARY]
                [041612_093517096][][EXCEPTION] [DEBUG] [NLS_DATE_LANGUAGE]:[AMERICAN]
                [041612_093517096][][EXCEPTION] [DEBUG] [LOGIN_ID]:[-1]
                4/17/12 8:48:45 AM] [OPPServiceThread1] Post-processing request 1792114.
                [4/17/12 9:16:54 AM] [OPPServiceThread0] Post-processing request 1792288.
                [4/17/12 9:31:40 AM] [OPPServiceThread1] Post-processing request 1792372.
                [4/17/12 9:31:40 AM] [168507:RT1792372] Executing post-processing actions for request 1792372.
                [4/17/12 9:31:40 AM] [168507:RT1792372] Starting XML Publisher post-processing action.
                [4/17/12 9:31:40 AM] [168507:RT1792372]
                Template code: XLAACCPB01
                Template app: XLA
                Language: en
                Territory: US
                Output type: RTF
                [4/17/12 9:31:50 AM] [168507:RT1792372] XML Publisher post-processing action complete.
                [4/17/12 9:31:50 AM] [168507:RT1792372] Completed post-processing actions for request 1792372.
                [4/17/12 9:33:32 AM] [OPPServiceThread1] Post-processing request 1792394.
                [4/17/12 9:38:55 AM] [OPPServiceThread1] Post-processing request 1792454.
                [4/17/12 9:38:55 AM] [168507:RT1792454] Executing post-processing actions for request 1792454.
                [4/17/12 9:38:55 AM] [168507:RT1792454] Starting XML Publisher post-processing action.
                [4/17/12 9:38:55 AM] [168507:RT1792454]
                Template code: XLAAAR01
                Template app: XLA
                Language: en
                Territory: US
                Output type: RTF




                javacache.log
                -------------------

                2012-04-17T11:08:49.533+05:00] [ias] [NOTIFICATION] [] [cache.Lifecycle] [host: oraprd.fti-nbil.com] [nwaddr: 172.20.2.11]

                [tid: 10] [userId: oracle] [ecid: 172.20.2.11:19046:1334642929534:0,0] JOC is initialized. ver=10.1.3, distribute=false,

                vid=0, coordinator=, discover list=[[172.20.2.11:12345, pos=-1, uid=0, name=, pri=0]]
                [2012-04-17T11:09:11.784+05:00] [ias] [NOTIFICATION] [] [cache.Lifecycle] [host: oraprd.fti-nbil.com] [nwaddr: 172.20.2.11]

                [tid: 10] [userId: oracle] [ecid: 172.20.2.11:49113:1334642951785:0,0] JOC is initialized. ver=10.1.3, distribute=false,

                vid=0, coordinator=, discover list=[[172.20.2.11:12345, pos=-1, uid=0, name=, pri=0]]
                [2012-04-17T11:09:39.807+05:00] [ias] [NOTIFICATION] [] [cache.Lifecycle] [host: oraprd.fti-nbil.com] [nwaddr: 172.20.2.11]

                [tid: 10] [userId: oracle] [ecid: 172.20.2.11:23296:1334642979809:0,0] JOC is initialized. ver=10.1.3, distribute=false,

                vid=0, coordinator=, discover list=[[172.20.2.11:12345, pos=-1, uid=0, name=, pri=0]]
                [2012-04-17T11:10:50.381+05:00] [ias] [NOTIFICATION] [] [cache.Lifecycle] [host: oraprd.fti-nbil.com] [nwaddr: 172.20.2.11]

                [tid: 10] [userId: oracle] [ecid: 172.20.2.11:66548:1334643050383:0,0] JOC is initialized. ver=10.1.3, distribute=false,

                vid=0, coordinator=, discover list=[[172.20.2.11:12345, pos=-1, uid=0, name=, pri=0]]
                [2012-04-17T11:10:56.931+05:00] [ias] [NOTIFICATION] [] [cache.Lifecycle] [host: oraprd.fti-nbil.com] [nwaddr: 172.20.2.11]

                [tid: 10] [userId: oracle] [ecid: 172.20.2.11:83052:1334643056933:0,0] JOC is initialized. ver=10.1.3, distribute=false,

                vid=0, coordinator=, discover list=[[172.20.2.11:12345, pos=-1, uid=0, name=, pri=0]]


                Regards,
                mohsin
                • 5. Re: An unexpected error has been detected by HotSpot Virtual Machine:
                  Hussein Sawwan-Oracle
                  Hi Mohsin,

                  I do not see any errors in the logs.
                  now the summary is report is not working when I use employee image on report.
                  Could you please mention the steps you have followed to use an image in your report?

                  What is the type of the report? Is it XML/PDF?

                  Thanks,
                  Hussein
                  • 6. Re: An unexpected error has been detected by HotSpot Virtual Machine:
                    User332967
                    Dear Hussein,
                    Please find below reply form my developer.

                    When I just use oracle EBS table and just use image on
                    Query ---- Select image from per_images
                    In my system its works fine and when I use this in Oracle ebs with Format ---- PDF its give same error.


                    Regards,
                    Mohsin
                    • 7. Re: An unexpected error has been detected by HotSpot Virtual Machine:
                      Hussein Sawwan-Oracle
                      Mohsin,

                      Please do the following since we could not capture any errors in the OPP log file.

                      - Stop OPP
                      - Rename the OPP log file
                      - Start OPP
                      - Reproduce the issue
                      - Check the contents of the OPP log file then

                      Thanks,
                      Hussein
                      • 8. Re: An unexpected error has been detected by HotSpot Virtual Machine:
                        User332967
                        Hussein
                        One more reply from my developer regarding barcode report. please find below.


                        Sorry for mistake check this output detail
                        1.     When I use simple query for just for check image (select image from per_images) its works fine.


                        2.     When I use this with combination of code like
                        3.     
                        select peo.employee_number empno,
                        peo.full_name,
                        org.name Dept,
                        posd.segment2 Desig,
                        tmp.card_no,
                        pi.image,
                        To_char(add_months(trunc(nvl(:datetrack,sysdate)),12),'Mon rrrr') Valid_date
                        ,asi.grade_id,
                        asi.location_id,
                        asi.payroll_id,
                        asi.organization_id,
                        pi.parent_id

                        from per_all_people_f peo,
                        per_all_assignments_f asi,
                        per_all_organization_units org,
                        per_all_positions pos,
                        per_position_definitions posd,
                        xxfti_tmprofile tmp,
                        per_images pi
                        where peo.person_id = asi.person_id
                        and asi.organization_id = org.organization_id
                        and tmp.person_id = peo.person_id
                        and asi.position_id = pos.position_id
                        and tmp.emp_id=peo.employee_number
                        and pos.position_definition_id=posd.position_definition_id
                        and pi.parent_id = peo.person_id
                        and trunc(nvl(:datetrack,sysdate)) between peo.effective_start_date and peo.effective_end_date
                        and trunc(nvl(:datetrack,sysdate)) between asi.effective_start_date and asi.effective_end_date
                        -- and trunc(nvl(:datetrack,sysdate)) between pos.effective_start_date and pos.effective_end_date
                        and peo.employee_number = nvl(:employee,peo.employee_number)


                        Before Report
                        function BeforeReport return boolean is
                        begin
                        globals.barcode_to_use := BarCodeConstants.BAR_CODE_128;
                        globals.bcobj := barcodemaker.new();

                        return (TRUE);


                        After Parameter Form

                        function AfterPForm return boolean is
                        begin

                        globals.barcode_to_use:=BarCodeConstants.BAR_CODE_128;
                        -- :p_query:='and peo.employee_number in ('||:EMPLOYEE||')';
                        return (TRUE);
                        end;


                        Regards,
                        Mohsin
                        • 9. Re: An unexpected error has been detected by HotSpot Virtual Machine:
                          Hussein Sawwan-Oracle
                          Can you please follow the action plan in my previous reply and update the thread?

                          Thanks,
                          Hussein
                          • 10. Re: An unexpected error has been detected by HotSpot Virtual Machine:
                            User332967
                            Dear Hussein

                            Thanks for reply. Hussein give me some time because its a production system so i'll restart the OPP other than the peak hours then i'll update to u.

                            Thanks & Regards,
                            Mohsin
                            • 11. Re: An unexpected error has been detected by HotSpot Virtual Machine:
                              User332967
                              iissue has been resolved.... thanks for your precious time and assiatnce.

                              Reagrds,
                              Mohsin
                              • 12. Re: An unexpected error has been detected by HotSpot Virtual Machine:
                                Hussein Sawwan-Oracle
                                iissue has been resolved.... thanks for your precious time and assiatnce.
                                It would be great if you could share the solution with us.

                                Thanks,
                                Hussein
                                • 13. Re: An unexpected error has been detected by HotSpot Virtual Machine:
                                  User332967
                                  Hi Hussein
                                  I am realy very sorry for late response...... actualy issue was on environment setting for DISPLAY...

                                  Regards,
                                  Mohsin.
                                  • 14. Re: An unexpected error has been detected by HotSpot Virtual Machine:
                                    Hussein Sawwan-Oracle
                                    Thanks for the update and for sharing the solution with us.