Hi Tuan,
when we try to run Time Slice job it processes for a very long time before failing.
Last error message showed:
"
ERROR 2015-05-04 14:18:20,626 [Dispatch pool-5-thread-2 : bg@SERVER (tenant=clarity)] niku.njs (clarity:admin:199480846__8640E4D4-9645-43CE-AD59-FD93651DB333:Time Slicing) Error executing job: 5821997
java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver]Object has been closed."
Looks like the timeslicing job got stuck and the connection got closed due to inactivity.
We are trying to run it again and querying every 30 minutes or so with the below:
SELECT 'Assignment' Slice_Object, Count(*), SLICE_STATUS
FROM prassignment
WHERE SLICE_STATUS in (1,2,3,4)
GROUP BY SLICE_STATUS
UNION SELECT 'Availability' Slice_Object,Count(*), SLICE_STATUS
FROM prj_resources
WHERE SLICE_STATUS in (1,2,3,4)
GROUP BY SLICE_STATUS
UNION SELECT 'Allocation' Slice_Object, Count(*), SLICE_STATUS
FROM prteam
WHERE SLICE_STATUS in (1,2,3,4)
GROUP BY SLICE_STATUS
UNION SELECT 'Allocation' Slice_Object, Count(*), HARD_SLICE_STATUS
FROM prteam
WHERE HARD_SLICE_STATUS in (1,2,3,4)
GROUP BY HARD_SLICE_STATUS
UNION SELECT 'Timeentries' Slice_Object, Count(*), SLICE_STATUS
FROM prtimeentry
WHERE SLICE_STATUS in (1,2,3,4)
GROUP BY SLICE_STATUS
UNION SELECT 'Costplan Units' Slice_Object, Count(*), odf_ss_units as
slice_status
FROM fin_cost_plan_details
WHERE odf_ss_units in (1,2,3,4)
GROUP BY odf_ss_units
UNION SELECT 'Costplan Bill Revenue' Slice_Object, Count(*),
odf_ss_bill_revenue as slice_status
FROM fin_cost_plan_details
WHERE odf_ss_bill_revenue in (1,2,3,4)
GROUP BY odf_ss_bill_revenue
UNION SELECT 'Costplan Bill Cost' Slice_Object, Count(*), odf_ss_bill_cost
as slice_status
FROM fin_cost_plan_details
WHERE odf_ss_bill_cost in (1,2,3,4)
GROUP BY odf_ss_bill_cost
UNION SELECT 'Costplan Revenue' Slice_Object, Count(*), odf_ss_revenue as
slice_status
FROM fin_cost_plan_details
WHERE odf_ss_revenue in (1,2,3,4)
GROUP BY odf_ss_revenue
UNION SELECT 'Costplan Revenue' Slice_Object, Count(*), odf_ss_cost as
slice_status
FROM fin_cost_plan_details
WHERE odf_ss_cost in (1,2,3,4)
GROUP BY odf_ss_cost
UNION SELECT 'Assignment Baselines' Slice_Object, Count(*), slice_status as
slice_status
FROM PRJ_BASELINE_DETAILS
WHERE SLICE_STATUS in (1,2,3,4) and object_type='ASSIGNMENT' and
IS_CURRENT=1
GROUP BY slice_status
So far it looks like it is updating. But from past experience this job will run for a very long time.
I have a case open but so far have not received any answers. Do you have any ideas as to what we could try or why Time Slicing is not completing successfully?