My Oracle Support Banner

Studio application refused to after manual deletion of data (Doc ID 2733149.1)

Last updated on DECEMBER 07, 2020

Applies to:

Oracle Financial Services Crime and Compliance Management Studio - Version 8.0.7 and later
Information in this document applies to any platform.

Symptoms

Application refused to start even after increasing the web socket memory to 100mb

Steps to reproduce : 

Step 1 : Delete the disabled interpreter_variant id entry from below table

Table : DS_TASK

Step 2 : Restart the servers 

Step 3 : login to studio application.

Expected behavior : 

Application should be up and running without issues.

Actual behavior : 

Application refused to start and encountered below error.

13:40:38.965 [ main] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ORA-02292: integrity constraint (FCCSTUDIO_SCHEMA.FK_TASK_INTRP_VAR) violated - child record found

Changes

Manual deletion done in DS_TASK table.

Delete from ds_task where interpreter_variant_id =61;

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.