5 Replies Latest reply on Jun 18, 2014 6:09 PM by Celvin Kattookaran

    Export Workspace Batch Scheduler




      I was wondering if there is anyway to export the log information from the Workspace Batch Scheduler.  I know you can export batches for command line scheduling, but I'm wondering if there was a way to export the actual information from the batch scheduler itself.  Basically a log file of all of the batches, when they were run, what time did they start, what time did they end, etc.  Anyone know if this is possible?




        • 1. Re: Export Workspace Batch Scheduler
          Krishna Kumar K P-Oracle

          Hi Jeff,


          If you are looking for logging information about batch you could check the FRLogging.log file if this is 11.1.2.x version. You could also make loglevel to TRACE:32 which will give extended information in the log.


          Refer the document : http://docs.oracle.com/cd/E40248_01/epm.1112/epm_troubleshooting.pdf  to get more information on logs.





          • 2. Re: Export Workspace Batch Scheduler



            Unfortunately FR is not designed with more options for logging, as Krishna mentioned FRLogging.log is the only location we can trace some information about FR related activities.


            1. Navigate to MIDDLEWARE_HOME/user_projects/domains/EPMSystem/config/fmwconfig/servers/<Financial Reporting >/logging.xml change the log level to TRACE. (Note: Be sure that you take a backup before modifying the file).

            2. Navigate to MIDDLEWARE_HOME/user_projects/epmsystem1/config/Financial Reporting/logging/logging_ra.xml  change the log level to TRACE. (Note: Be sure that you take a backup before modifying the file).






            • 3. Re: Export Workspace Batch Scheduler

              An automated export of log files after capture is not available,however you can try a couple of things


              1.) Increase logging levels so that the logs capture extensive detailing.



              2.) Create a customized script at an OS level to export these log captures to a predefined destination

              • 4. Re: Export Workspace Batch Scheduler
                Celvin Kattookaran



                Look for a table called FR_SCHEDULER_DATA. It has a column called XML (BLOB) which stores all the information about time, what members were bursted,....


                Start with the first JOBSTATUSMESSAGE


                <JOBSTATUSMESSAGE INDEX="0" KEY="4106" LF="true">

                <PARAMETERS PARAMCOUNT="2">

                <PARAMETER PARAMETERINDEX="0" PARAMTYPE="String" PARAMVALUE="&quot;My Sample Reports/Batches/Management Pack 1&quot;"/>

                <PARAMETER PARAMETERINDEX="1" PARAMTYPE="Date" PARAMVALUE="1402955727248"/>




                PARAMVALUE of Date is epoch date and converts to Monday, June 16, 2014 4:55:27 PM CDT


                If the JOB_STATUS (STATE in the table) is 2 (successful) then you'll find another STATUSMESSAGE with the end time


                <JOBSTATUSMESSAGE INDEX="26" KEY="4123" LF="true">

                <PARAMETERS PARAMCOUNT="2">

                <PARAMETER PARAMETERINDEX="0" PARAMTYPE="String" PARAMVALUE="&quot;Management Pack 1 2nd Run&quot;"/>

                <PARAMETER PARAMETERINDEX="1" PARAMTYPE="Date" PARAMVALUE="1402955744832"/>




                Converts to Monday, June 16, 2014 4:55:44 PM CDT