Clarity

  • 1.  Time Slicing Job Frequency

    Posted Sep 11, 2012 09:31 AM
    Hi,

    We are running he Time Slicing Job once in every 30 minutes. Our "Post TimeSheet" job runs once in every 15 minutes.


    1. We want to determine if there would be an improvement in performance of Clarity Application, if we make our Time Slicing Job run more often than once in 30 minutes.
    2. We are unable to see the log details of the Time Slices jobs which runs every 30 mins. It is getting erased from front end, nor it is getting stored in Scheduled Jobs Log table in DB. How do we find this information?
    3. How to find the duration of scheduled Time Slicing Jobs run.
    4. Is there a way to find out optimal scheduling of Time Slicing Job based on other scheduled job and volume of data?

    Please advise

    Regards,
    Mathan


  • 2.  RE: Time Slicing Job Frequency
    Best Answer

    Posted Sep 11, 2012 11:13 AM
    1. How do you establish that there is a performance deterioration in performance due to the time slicing.
    Can establish that the CPU is high while the job is running, but not when other scheduled jobs are running.? Or is the user response time excessive?
    2. As far as I understand it is not logged anymore (something like since vesrion 6.14 - 7.02). The reason being that it is usually run every minute and that creates a lot of log entries in a week.
    3. The way I normally do it, is using something like the queries in
    TIP: ** Bonus Tip** Query: What Jobs/Reports Ran Over the Last n Days
    13788042

    in a query tool. I've tried to create a portlet out that, but it does not display timeslicing.

    The problem is that even with the query it will display in the query results while it is running. After it is completed the entry disappears.
    Therefore the query should calculate the run time and you should rerun the query frequent enough so that you catch the longest runtime.
    4. My person preference is to schedule the job once a minute if it completes in that time. If it does not then extend the interval.
    That is just one job so that alone does not count for all the CPU and memory usage of the bg process.


    Martti K.


  • 3.  RE: Time Slicing Job Frequency

    Posted Sep 12, 2012 05:54 AM
    Thanks Martti,

    I will perform a CPU Usage reading and try increasing the frequency of the job to see any improvement.

    Regards,
    Mathan


  • 4.  RE: Time Slicing Job Frequency

    Posted Sep 11, 2012 11:20 AM
    I would say to a degree that it depends on the volume of data in your system - how many active projects and resources do you have? How many custom time slices do you have and how many periods of data are they processing? Check you don't have duplicate or redundant custom time slices too. There are some guidelines in a TEC Document which are a good starting point, I don't have the reference to hand though.

    We run time slicing every 5 minutes in production (approx 1000 users, 600 active projects or so, probably <10 custom time slices) and it runs quite happily just taking a few seconds each time usually. Remember that time slicing only looks for changed or new slices to process so it very rarely has to process lots of records. Exception would be if we change global calendars to add public holidays (which would update the availability slice for every user) or if for some reason we have to amend a time slice definition. But if you do these out of hours, it should not have an impact.

    I have heard of other sites where it is run every minute.

    You can count the records in prj_blb_slices to check the progress on the Timeslice rebuild. The Last Run date will be populated when the slices are completed.

    You can also use the query below to check the status. The status will go from 1 (needs to be sliced) or status 3 (needs to roll-over) to status 2 (processing) then to NULL (completed). It will go table by table and process 1000 rows at a time. If you get nothing back then time slicing job has finished.
    SELECT 'Assignment' Slice_Object, 
    Count(*), SLICE_STATUS, max(last_updated_date) as lud 
    FROM prassignment WHERE SLICE_STATUS in (1,2,3,4) 
    GROUP BY SLICE_STATUS
    
    UNION 
    SELECT 'Allocation' Slice_Object, 
    Count(*), SLICE_STATUS, max(last_updated_date) as lud 
    FROM prteam WHERE SLICE_STATUS in (1,2,3,4) 
    GROUP BY SLICE_STATUS
    
    UNION 
    SELECT 'Availability' Slice_Object, 
    Count(*), SLICE_STATUS, max(last_updated_date) as lud 
    FROM prj_resources WHERE SLICE_STATUS in (1,2,3,4) 
    GROUP BY SLICE_STATUS
    
    Union
    SELECT 'Timeentries' Slice_Object,
    Count(*), SLICE_STATUS, max(prmodtime) as lud 
    FROM prtimeentry
    WHERE SLICE_STATUS in(1, 2,3,4) 
    GROUP BY SLICE_STATUS
    Not sure about time posting every 15 minutes - we only do posting once a week as timesheeting tends to be done on a Friday and our project managers don't need the actuals to be visible any more often than weekly, but I presume you have different business rules.

    Owen


  • 5.  RE: Time Slicing Job Frequency

    Posted Sep 12, 2012 05:55 AM
    Owen,

    Thanks for the Query, it is very helpful for calculating an approx duration of Time Slice Job runtime for X number of Time Entries.

    Regards,
    Mathan


  • 6.  RE: [CA Clarity General Discussion] Time Slicing Job Frequency

    Posted Sep 11, 2012 05:12 PM
    Hello,



    I tend to run the slicing job very frequently. It’s frustrating to the PMs if their data in OWB, RM, etc.is not in sync.



    · What areas of Clarity are you using?

    · Are you using resource management or other areas of Clarity that rely changing heavily on sliced data?

    · Are your WBS very ‘deep’ with lots of tasks?

    · How often do you post timesheets?



    If you are using Clarity for time and high level planning, you could ‘slow down’ slicing. If you are hoping to use RM or have mature PM practices with a lot of tasks, I would set slicing to run very frequently.



    I cannot think of a negative impact to running slicing frequently. It will simply take smaller ‘bites’ each time runs.



    Steve



    From: CA Clarity Global User Community [mailto:CommunityAdmin@communities-mail.ca.com]
    Sent: Tuesday, September 11, 2012 8:31 AM
    To: mb.2277340.99052735@myca-email.ca.com
    Subject: [CA Clarity General Discussion] Time Slicing Job Frequency



    Hi,

    We are running he Time Slicing Job once in every 30 minutes. Our "Post TimeSheet" job runs once in every 15 minutes.


    1. We want to determine if there would be an improvement in performance of Clarity Application, if we make our Time Slicing Job run more often than once in 30 minutes.
    2. We are unable to see the log details of the Time Slices jobs which runs every 30 mins. It is getting erased from front end, nor it is getting stored in Scheduled Jobs Log table in DB. How do we find this information?
    3. How to find the duration of scheduled Time Slicing Jobs run.
    4. Is there a way to find out optimal scheduling of Time Slicing Job based on other scheduled job and volume of data?

    Please advise

    Regards,
    Mathan
    Posted by:mathan114
    --
    CA Communities Message Boards
    99055275
    mb.2277340.99052735@myca-email.ca.com
    https://communities.ca.com


  • 7.  RE: [CA Clarity General Discussion] Time Slicing Job Frequency

    Posted Sep 12, 2012 05:31 AM
    Agree with both Martti and Steve.... depends on the requirement.

    We run the timeslicing job every min as we use the RM extensively


    NJ


  • 8.  RE: [CA Clarity General Discussion] Time Slicing Job Frequency

    Posted Sep 12, 2012 09:32 PM
    I’m not sure if I’d run it every minute if the job has little hope of finishing in less than a minute. I’d look at the minimum run time….



    Steve



    From: CA Clarity Global User Community [mailto:CommunityAdmin@communities-mail.ca.com]
    Sent: Wednesday, September 12, 2012 4:31 AM
    To: mb.2277340.99063979@myca-email.ca.com
    Subject: RE: [CA Clarity General Discussion] Time Slicing Job Frequency



    Agree with both Martti and Steve.... depends on the requirement.

    We run the timeslicing job every min as we use the RM extensively


    NJ
    Posted by:navzjoshi00
    --
    CA Communities Message Boards
    99066519
    mb.2277340.99063979@myca-email.ca.com
    https://communities.ca.com


  • 9.  RE: [CA Clarity General Discussion] Time Slicing Job Frequency

    Posted Sep 12, 2012 06:01 AM
    Hi Steve,

    We are mainly using Project Management and Resource Management.

    Our WBS structure is a very simple one for all the projects.

    We run Post Timesheet Job every fifteen minutes.

    Regards,
    Mathan


  • 10.  RE: [CA Clarity General Discussion] Time Slicing Job Frequency

    Posted Sep 12, 2012 07:09 AM
    There is a simple tool for calculating the number of slices in the main slice table which might help in deciding how to configure the slices
    Calculator for record count in PRJ_BLB_SLICES



    Martti K: