cancel
Showing results for 
Search instead for 
Did you mean: 

Install Java Add-in for ABAP - error

Former Member
0 Kudos

When I try to instal I got this error

WARNING[E] 2010-10-11 13:44:25.906

CJS-30109 <html> <head> </head> <body> The Java load in database ITM/ZEUS has already been configured.<br>SOLUTION: Remove the schema and load it with a new load before you run this installation. </body></html>

Where can remove this shema and how to load new load?

Mirko

Accepted Solutions (1)

Accepted Solutions (1)

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

As per error log, Java schema which you are creating already exits in database. If Java Schema already there then why are you installing Java Add-in again ??

You can delete already existing Java Schema as below:

1. Log on as user ora<dbsid>.

2. Start sqlplus and connect to the database. Enter:

sqlplus /nolog

SQLPLUS>connect / as sysdba

3. Enter the following command to delete the database objects of the database schema:

SQLPLUS> drop user SAP<SCHEMA_ID>DB cascade;

4. Enter the following command to get the file name of the corresponding data file in the file system:

SQLPLUS> select file_name from dba_data_files where \

tablespace_name = 'PSAP<SCHEMA_ID>DB';

5. Enter the following command to delete the tablespace of the database schema:

SQLPLUS> drop tablespace PSAP<SCHEMA_ID>DB including contents;

6. Exit sqlplus:

SQLPLUS> exit

7. Delete the data file of tablespace PSAP<SCHEMA_ID>DB from the file system

Thanks

Sunny

Former Member
0 Kudos

Hello Sunny!

Thank you for helping me,

When I open the MSSQL Server Management Studio, I try to delete this shema ....

But I got this....

Cannot drop schema 'SAPITMDB' because it is being referenced by object 'ADS_LICENSED_FORMS'. (.Net SqlClient Data Provider)

Mirko

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

As your error says it is referenced by ADS_LICENSED_FORMS, please remove this reference then try to drop.

Thanks

Sunny

0 Kudos

Hi, i have dropped the schema and tablespace under that particular schema, but when i run the JAVA CI installation again i hit some error "ORA-01017: invalid username.password", i think its because the secstore.properties that is being used is the one generated using the old schema. how will i solve this issue?

Answers (0)