7 Replies Latest reply: Nov 25, 2012 11:58 PM by 665735 RSS

    Log Files in Apex.

    665735
      Hi All,

      Could you please provide me the steps to create the Log Files in Apex.
      The reason is when ever i am accessing the application in some period of time the page/system got hanged with out any submit process.
      Could any help me out how we can handle log files in o

      Thanks,
      Anoo..
        • 1. Re: Log Files in Apex.
          jariola
          Hi,

          What log files you mean?
          APEX do not generate any log files. Logs are stored to APEX schema table(s).

          Maybe you need check database alert log and web server logs.

          Documentation how debug application might also help
          http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35125/debug.htm#sthref2428

          Regards,
          Jari
          -----
          My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
          Twitter: http://www.twitter.com/jariolai
          • 2. Re: Log Files in Apex.
            Pete Mahon
            Hi Anoo,

            Unless I'm very much mistaken, this sounds like you're having issues in your browser which may indicate a memory leak or some bad javascript.

            Can you please tell us your:

            Apex Version
            Browser Type and Version

            What application are you running when this happens? Builder? Custom app?

            Kind Regards, Pete
            • 3. Re: Log Files in Apex.
              665735
              Hi Jarola/Pete,

              Please find the deatils below.

              The reason i am looking for Log files is that few autocomplete freetext
              Jquery is getting freezed while we are searching with that Key word
              character.

              In order to reproduce this i thought to have log files to debug the issue,
              when i had tested in backend those querires are working fine with out any issues.

              But in front end application some times not regular interval of times
              it is freezed.

              The main reason to have log files is that to track the issue.

              Apex Build: 3.0.1.00.08
              Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
              PL/SQL Release 10.2.0.4.0 -
              CORE 10.2.0.4.0
              TNS for Solaris: Version 10.2.0.4.0
              NLSRTL Version 10.2.0.4.0 -
              Browser- Interent Explorer 7
              Application-Web based application where users create particular form.

              Note: This issue was occuring in Singapore team.


              Thanks,
              Anoo..
              • 4. Re: Log Files in Apex.
                665735
                Hi Jarola,

                Thanks for the below information, coul dyou please provide me the same link related to version 3.0, i hope this is updated version one where i could not abel to find few things.

                Thanks,
                Anoo..
                • 5. Re: Log Files in Apex.
                  jariola
                  Hi,

                  Version 3.0 document is here
                  http://docs.oracle.com/cd/B32472_01/doc/appdev.300/b32471/debug.htm#BCGCIBJA

                  Regards,
                  Jari
                  -----
                  My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
                  Twitter: http://www.twitter.com/jariolai
                  • 6. Re: Log Files in Apex.
                    Jitendra
                    Hi Anoo,

                    See the link given below,
                    It may give you some help.

                    http://www.talkapex.com/2009/05/apex-logs-storing-log-data.html

                    Regards,
                    Jitendra
                    • 7. Re: Log Files in Apex.
                      665735
                      Hi Jitendra, wonderful useful link, i had tried to implment the same but got problem in understanding the point #2, could you please help me to understand the same.

                      Note: You may want to store this in a procedure and run as a nightly scheduled job so you don't forget to update the tables

                      As per my understanding we have to create a Schedule Job to run the same, to update the Job files.

                      Thanks,
                      Anoo..