TMS Crashes With "FRM-40512: Oracle Error Unable To Issue Savepoint Command"

(Doc ID 729311.1)

Last updated on OCTOBER 03, 2017

Applies to:

Oracle Thesaurus Management System - Version 4.5.2 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Mar-2010***
***Checked for relevance on 03-Feb-2012***
***Checked for relevance on 13-Feb-2014***

Symptoms


On TMS 4.5.2, when attempting to query for a term in "Classifications" tab from "Classify VT Omissions" screen, the following error occurs:

ERROR
FRM-40512: ORACLE error unable to issue SAVEPOINT command
FRM 92101. A failure occurred on the Server. You will need to reestablish your session



Steps To Reproduce:

  1. From TMS application Navigator screen open "Omission Management"/"Classify VT Omissions";
  2. In "Classify VT Omissions" screen go to "All Verbatim Omissions" tab;
  3. Chose a verbatim for coding;
  4. Enter the "Classifications" tab from the lower part of the screen;
  5. Query for a term using a "forbidden" character (e.g. enter '&tape&' instead of '%tape%');
  6. The System crashes also when using non-forbidden characters, or when applying an action or even in the Browse repository data.

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