All ESS jobs are stuck after Cost Processor errored with error :"ESS Job Result: BP:ERROR: CostProcessor: BackupGt Sql execution threw an exception. Backup package restored to template."

(Doc ID 2381231.1)

Last updated on MAY 14, 2018

Applies to:

Oracle Fusion Cost Management Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run cost processor the following error occurs and subsequently all ESS jobs across the application get stuck in running /ready status and do not complete.

And any subsequent run for Cost processor ends in "Blocked Status"

ERROR
-----------------------
ESS Job Result: BP:ERROR: CostProcessor: BackupGt Sql execution threw an exception. Backup package restored to template.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms