AutoSys Workload Automation

 View Only
Expand all | Collapse all

Job Log error

  • 1.  Job Log error

    Posted May 23, 2020 12:54 AM
    Hi,

    We are seeing job log error for logs older than a certain date. In this case we can view log details from  9th May to till date. Older ones throw the below message:



    But the logs are listed on the server as below:

    Is there any setting that prevents showing of logs older than certain days? Or any other explanation for this behaviour!

    Regards
    Pothen


  • 2.  RE: Job Log error

    Posted May 24, 2020 04:32 AM
    Hi,

    Isn't it defined on $AUTOSYS/bin/DBMaint?

    best regards.
    JR


  • 3.  RE: Job Log error

    Posted May 24, 2020 10:31 PM
    That is set for 45 days. WCC shows the listing of job logs.


  • 4.  RE: Job Log error

    Posted May 25, 2020 04:28 AM
    Hello

    As it is visible in WCC, it seems to be still present in ujo_job_runs table.
    Could you look at the std_out_file records on ujo_job_runs table ?
    select b.job_name, a,startime, a.std_out_file
    from ujo_job_runs a join ujo_job b on a.joid=b.joid
    where
    b.job_name ='CBIN.BANC.D_UNIXCMD.CD'
    and b.is_currver=1
    order by startime

    Do you see the std_out_files ?
    startime is in Epoch format. Yo can convert it with time0 -A <..> command or with a Oracle/MS-SQL statement.


  • 5.  RE: Job Log error

    Posted May 25, 2020 09:27 PM
    Thanks. Ran the query.


    It lists 38 records. Converted the first and last startime.

    [oracle@orasvr19 ~]$ date -d @1586578236
    Sat Apr 11 09:40:36 IST 2020
    [oracle@orasvr19 ~]$ date -d @1590379836
    Mon May 25 09:40:36 IST 2020

    So this too shows all the logs.

    Regards
    Pothen


  • 6.  RE: Job Log error
    Best Answer

    Posted May 28, 2020 09:39 AM
    hello

    The std_out_file column is empty. This explains the problem.

    What the job definition in jil ? Do you use %AUTORUN% to build the std_out_file name ?
    Can you make a test with an other job ?


  • 7.  RE: Job Log error

    Posted May 28, 2020 10:03 AM
    Hi,

    The std_out_file column is empty for all records.  Yes $AUTORUN is used to build the std_out_file.

    The problem is, in WCC we are not able to see out files content for logs before 8th May, even though the files exist in the log directory. But we are able to see the out file content from 8th May onward, even for today in WCC..



  • 8.  RE: Job Log error

    Posted Aug 27, 2020 02:55 PM
    I have the same problem.  Did you ever find solution?


  • 9.  RE: Job Log error

    Posted Aug 28, 2020 12:04 AM
    Are you seeing the current logs and not able to see the older logs from some specific date?


  • 10.  RE: Job Log error

    Posted Aug 28, 2020 06:28 AM
    Seeing entries in "Job Runs" section for all runs of the job, several days worth,  but only the latest 5 days will show the Standard Output/error logs.  Checked that the logs are still available on the agent server where the job is run.


  • 11.  RE: Job Log error

    Posted Aug 28, 2020 09:51 AM
    What was the folder/dir for std out/err 5 days back for this agent machine? Did someone change the folder and jobs are pointing to the new folder?


  • 12.  RE: Job Log error

    Posted Aug 28, 2020 10:00 AM
    Hi Pothen,  Yes,  both agent and folder/dir have been stable for couple months.  No changes.  Logs just dropping after 5 days from WCC. Job Runs details for each run is still showing(status changes) for all days


  • 13.  RE: Job Log error

    Posted Aug 28, 2020 09:50 PM
    In our case it was a one off problem. The reason was change in std out/err folder. All newer logs, as configured under DBMain were visible and viewable from WCC.