Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Import db from derby to oracle fail

RTC Express-C 2.0.0.1/2.0.0.02
Oracle 10.2.0.4

User get error when running repotools -import command to import exported tar to oracle:

# ./repotools.sh --import fromFile=temp.tar teamserver.properties=conf/jazz/teamserver.oracle.properties
Repo Tools
Rational Team Concert, Version 2.0.0.2 (I20091211-0451)
Jazz Foundation - Jazz Team Server, Version 1.0.0.2 (I20091211-0451)
Rational Jazz Team Server - Express-C
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.oracle.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: thin:xxxxxxxx/xxxxxxxx@10.10.71.92:1521/ORCL
CRJAZ1364I Initial database connection successful
Db Product Name: Oracle
Db Product Version: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Db URL: jdbc:oracle:thin:fi_107/123456@10.10.71.92:1521/ORCL
Jdbc Driver Name: Oracle JDBC driver
Jdbc Driver Version: 10.2.0.4.0
CRJAZ8192I: Fulltext Index Location: /home/jazz/server/workitemindex/fulltext_index
CRJAZ8190E: The fulltext index location property (indexLocation) should point to an absolute directory but is currently set to 'workitemindex'
WARNING: You are about to drop and recreate the tables for the database "thin:xxxxxxxx/xxxxxxxx@10.10.71.92:1521/ORCL".
Do you wish to continue? Enter Y to confirm.
y
Creating the tables for the database "thin:xxxxxxxx/xxxxxxxx@10.10.71.92:1521/ORCL" without indices.
The user "ADMIN" has logged in to the database "thin:xxxxxxxx/xxxxxxxx@10.10.71.92:1521/ORCL".
The user "ADMIN" has logged out of the database "thin:xxxxxxxx/xxxxxxxx@10.10.71.92:1521/ORCL".
Running post create tables for "resetIndexes" component...
Post create tables for resetIndexes took 58 ms.
The database tables were created successfully.
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: thin:xxxxxxxx/xxxxxxxx@10.10.71.92:1521/ORCL
CRJAZ1364I Initial database connection successful
Db Product Name: Oracle
Db Product Version: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Db URL: jdbc:oracle:thin:fi_107/123456@10.10.71.92:1521/ORCL
Jdbc Driver Name: Oracle JDBC driver
Jdbc Driver Version: 10.2.0.4.0
The user "ADMIN" has logged in to the database "thin:xxxxxxxx/xxxxxxxx@10.10.71.92:1521/ORCL".
Importing the data from the file "temp.tar" into the database "thin:xxxxxxxx/xxxxxxxx@10.10.71.92:1521/ORCL".
Using encoding "UTF-8"
Reading the TAR file temp.tar...
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => DROP INDEX BLACKBOARD_UNKNOWN_ITEMID
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => DROP INDEX BLACKBOARD_UNKNOWN_ITEMID
Imported 0 items, 0 item states in 241 ms. 0 item states skipped. Error importing 0 elements.
##############################################################################################
****** Migration Errors ******
CRJAZ0656I **ERROR** Migration completed with errors. The imported database is in an inconsistent state and should not be used without further analysis.
Check the migration log "/home/jazz/server/repotools_import.log" for details.
##############################################################################################
The user "ADMIN" has logged out of the database "thin:xxxxxxxx/xxxxxxxx@10.10.71.92:1521/ORCL".
CRJAZ0530I Exception occurred creating indices for the schema "BLACKBOARD".

Any idea? Thanks

0 votes



One answer

Permanent link
I have the same error when using repotools to import database from one machine to another, but, i am using RRC 2.0.0.1, not RTC.

Anderson E Santo

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jan 22 '10, 5:51 a.m.

Question was seen: 5,591 times

Last updated: Jan 22 '10, 5:51 a.m.

Confirmation Cancel Confirm