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
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