ORA-29532 Exception Generated While Running The TMSJAVA Script To Perform The LSH Database Setup (Doc ID 779140.1)

Last updated on JULY 01, 2016

Applies to:

Oracle Life Sciences Data Hub - Version 2.1.1 and later
Oracle Thesaurus Management System - Version 4.6.0 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Jan-2015***

Symptoms

-- Problem Statement:
On LSH 2.1.1 in Production:
When attempting to load the TMS 4.6 jar file into each Database by running tmsjava.sql script,
the following error occurs:

ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
oracle.aurora.server.tools.loadjava.ToolsError: Error during loadjava: Failures
occurred during processing. Check trace file for details
ORA-06512: at "SYS.DBMS_JAVA", line 222
ORA-06512: at line 2



The database dump file is including the following error message:

C:\opapps46\tms\install/tms_http.jar'
Error while opening file: C:\opapps46\tms\install/tms_http.jar
Exception java.io.FileNotFoundException: No such file or directory
creating : C:\opapps46\tms\install/tms_http.jar
The following operations failed
C:\opapps46\tms\install/tms_http.jar: opening file
exiting : Failures occurred during processing
oracle.aurora.server.tools.loadjava.ToolsError: Error during loadjava: Failures occurred during
processing. Check trace file for details
at oracle.aurora.server.tools.loadjava.LoadJavaMain.serverMain(LoadJavaMain.java)
at oracle.aurora.server.tools.loadjava.LoadJavaMain.serverMain(LoadJavaMain.java)



-- Steps To Reproduce:
The issue can be reproduced with the following steps:
1. For LSH 2.1.1 install, set up a Windows computer for launching TMS 4.6 installation;
2. Install TMS server;
3. Install the TMS Database;
4. Complete the TMS install by loading the TMS jar file into each database:
4.1 Connect to the TMS Web server computer as 'opareps' user;
4.2 Point the environment to each database;
4.3 Change directories to OPA_HOME\tms\install;
4.4 Run the script to perform the database setup necessary to use Java:
      sqlplus sys/password @tmsjava
      When prompted, enter the path for the TMS install directory.


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