Clarity

 View Only
  • 1.  prassignment.slice_status = Values?

    Posted Nov 23, 2014 03:53 PM

      Hi All,

    Can any onle please tell me that what are the different status values of this slice table?

     

    e.g - status = 1 ---- > Data yet to be sliced

     

    What are the other status values of this table?

     

    Request your assistance at the earliest.

     

    Thanks

    sid



  • 2.  Re: prassignment.slice_status = Values?
    Best Answer

    Posted Nov 23, 2014 10:42 PM

    Hi Sid,

     

    Below are the different values of Slice and their corresponding meanings

     

    What Slice Status
    TO PROCESS1
    IN PROGRESS2
    TO ROLLOVER3
    WAITING TO BE SLICED4

     

    Thanks & Regards

    Viraj Khara



  • 3.  Re: prassignment.slice_status = Values?

    Posted Nov 24, 2014 12:23 AM


  • 4.  Re: prassignment.slice_status = Values?

    Posted Nov 24, 2014 12:23 AM


  • 5.  Re: prassignment.slice_status = Values?

    Posted Nov 24, 2014 12:25 AM

    How do I completely check the status of the Time Slicing job? How long will it take my Time Slicing job to complete?

    Document ID:  TEC439078
    Last Modified Date:  9/26/2014

    Description:

    Our Time Slicing job has been processing for some time. How can I monitor or check the status of the records being processed? How can we estimate the amount of time it will take to complete?

    Solution:

    There is no one query that will give you the complete status of the Time Slicing job. You'll need to do 3 things to get a complete picture of the status.

    1. Look at Scheduled Time Slicing Job to see the status of the Job itself.
    2. Look at the Time Slices Management page and determine if any slice requests are expired or have older last run dates. This will give you an idea of what timeslice is supposed to be doing. If the expiration date for a slice request is less than today, the slice request needs to be rolled over. If the slice request has an older Last Run date then it needs to catch-up.
    3. Run a query on the object records to check the slice_status column.

    Values for slice status are.

    1 = Needs to be Processed.
    2 = Currently being Processed.
    3 = Needs to be roll over.
    NULL = Record has been processed.

     

    In the query below I omitted the count of records that have a slice status of Null, because we can't reliability assume they are processed. It processes the Slice objects one at a time. For example, if it's on Assignments and if availability, allocations or time entries need to be rolled over, many of these records will have status of null because timeslice just hasn't gotten to them yet. The same is true for a modified or new request slice request.

     

    SELECT 'Assignment' Slice_Object, Count(*), SLICE_STATUS
    FROM prassignment
    WHERE SLICE_STATUS in (1,2,3)
    GROUP BY SLICE_STATUS
    UNION SELECT 'Availability' Slice_Object,Count(*), SLICE_STATUS
    FROM prj_resources
    WHERE SLICE_STATUS in (1,2,3)
    GROUP BY SLICE_STATUS
    UNION SELECT 'Allocation' Slice_Object, Count(*), SLICE_STATUS
    FROM prteam
    WHERE SLICE_STATUS in (1,2,3)
    GROUP BY SLICE_STATUS
    UNION SELECT 'Timeentries' Slice_Object, Count(*), SLICE_STATUS
    FROM prtimeentry
    WHERE SLICE_STATUS in (1,2,3)
    GROUP BY SLICE_STATUS

     

    It will go table by table in the order above and process 1000 rows at a time. You'll see the status go from 1 (needs to be sliced) or status 3 (needs to roll-over) to status 2 (processing) then to NULL (completed).

     

    By running the query in timed intervals, you can estimate how long the process will take to complete. Note: Objects will process at different speeds based on the slice request configuration, amount of records, and size of the slice objects.

     

    http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec439078.aspx

     

     

    NJ



  • 6.  Re: prassignment.slice_status = Values?

    Posted Dec 01, 2014 09:36 AM

    Thanks NJ. The pdf helped me get more insight on timeslices.



  • 7.  Re: prassignment.slice_status = Values?

    Posted Dec 02, 2014 04:58 AM

    You're welcome

     

    NJ