CA PPM: Time Slicing job fails with generic error

Document ID : KB000097754
Last Modified Date : 23/05/2018
Show Technical Document Details
Issue:

The generic "time slicing job has failed" error appears in the bg-ca logs but contains no additional information.
 

Cause:

The error can be attributed to the following causes:

A. Expired time slices.

B. Multicast issue

C. Network/Database connection issue

 

Resolution:

A. Expired time slices.

 

Make sure there are no fiscal time slices with expiration dates in the past.

Run the following query to find out if there any external time slices that have expired and have not rolled over.

 

select id, request_name, is_synchronous, num_periods, expiration_date, is_dwh_request, request_completed_date
from PRJ_BLB_SLICEREQUESTS
where expiration_date < sysdate

and is_synchronous = 0 

If there are results returned, please open a case to have the update SQL be provided.

For SaaS customers, please refer to internal document PPM-0024


B. Multicast issue

Once the logging levels are set for the blobcrack component, run the job to see if it completes in the bg-ca logs.
If the job completes in the bg-ca logs but fails in the app, the multicast issue will need to be resolved.

Confirm the multicast address is set along with all bind addresses in the CSA.

Stagger restart the services: beacon,app,bg

C. Network/Database connection issue

Please configure the BG-ca log logging levels to produce additional information on why the job fails.

Common error is:

com.niku.union.persistence.DBConnectionException: com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver]No more data available to read.

Please reach out to the network/DBA team to resolve.

Additional Information:

https://comm.support.ca.com/kb/best-practice-how-to-set-the-logging-levels-in-the-csa/kb000009555