Agile Application Server Does Not Start Up with Error List XXXXX Does Not Exist in the Cache. It May Have Been Deleted Already.

(Doc ID 805443.1)

Last updated on OCTOBER 06, 2015

Applies to:

Oracle Agile PLM Framework - Version 9.2.2.4 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:
Application server cannot be started.
Below error is logged in OC4J log:
Error: List XXXXX does not exist in the cache. It may have been deleted already

Fact:
Running below sql does not return result. XXXXXX to be replaced by List ID reported in OC4J log:
sql> select * from listentry where parentid = XXXXXX;
sql> select * from listname where id = XXXXXX;
Note: If running above sql return result, refer to <NOTE:779243.1>  for solution.

Running below sql returns result.
sql> select * from listname where parent_list=XXXXXX;

Changes

Deleted Cascading list.

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