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.
Below are the different values of Slice and their corresponding meanings
Thanks & Regards
Check this -
CA Clarity PPM Timeslice_Webinar.pdf
Also this -
Document ID: TEC439078Last Modified Date: 9/26/2014
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?
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.
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_STATUSFROM prassignmentWHERE SLICE_STATUS in (1,2,3)GROUP BY SLICE_STATUSUNION SELECT 'Availability' Slice_Object,Count(*), SLICE_STATUSFROM prj_resourcesWHERE SLICE_STATUS in (1,2,3)GROUP BY SLICE_STATUSUNION SELECT 'Allocation' Slice_Object, Count(*), SLICE_STATUSFROM prteamWHERE SLICE_STATUS in (1,2,3)GROUP BY SLICE_STATUSUNION SELECT 'Timeentries' Slice_Object, Count(*), SLICE_STATUSFROM prtimeentryWHERE 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.
Thanks NJ. The pdf helped me get more insight on timeslices.