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 |
One answer
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
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.