It's all about the answers!

Ask a question

Import db from derby to oracle fail


wang fan (212) | asked Jan 22 '10, 5:51 a.m.
JAZZ DEVELOPER
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

One answer



permanent link
Anderson E Santo (11) | answered Feb 25 '10, 5:18 p.m.
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

Your answer


Register or 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.