Time Slicing Job Failed Due To Database Connection Issue
search cancel

Time Slicing Job Failed Due To Database Connection Issue

book

Article ID: 97754

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

The generic "time slicing job has failed" error appears in the BG logs, but contains no additional information.

Environment

Release: Any

Cause

The error can be attributed to the following causes:

A. Expired time slices.

B. Network/Database connection issue

 

Resolution

Find out the reason by setting the Time Slicing component in the CSA as described in article:
Set/Reset logging levels in Clarity

Based on the error, check if it falls into one or more of the following categories.

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. Network/Database connection 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 a unique bind address in the CSA for each server.

Stagger restart the services: beacon,app,bg

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.

For GCP SaaS customers, please reach out to Support team to review to confirm if it is related to a database issue, e.g.
ERROR 2023-03-14 10:36:24,550 [Dispatch Time Slicing : bg@<host>(tenant=clarity)] persistence.PersistenceController (clarity:user:session:Time Slicing) Exception due to DB Connection failure