It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,789

question asked: Feb 17 '10, 10:47 a.m.
question was seen: 6,132 times
last updated: Feb 17 '10, 10:47 a.m.

Related questions

FAQ - How this Forum works

Migration from Derby: !OracleProvider.NotUTF8CharacterSet!

0
Stuart Bedoll (31●1●3) | asked Feb 17 '10, 10:47 a.m.
I followed the documentation for creating the Oracle databases but it does not mention the character set. The default is Oracle characters set is AL16UTF16. When run the repotool command to migrate from Derby to Oracle i get the !OracleProvider.NotUTF8CharacterSet! error. So should the database be created with UTF8 and shouldn't this be in the documenation ?

3 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Stuart Bedoll (31●1●3) | answered Feb 17 '10, 4:23 p.m.
I changed the Oracle database to UTF8 and I still get the same error:
C:\Program Files\IBM\JazzTeamServer\server>repotools -copy toFile=temp.tar target.teamserver.properties=conf\jazz\teamserver.oracle.fpa.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 - Enterprise
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: repositoryDB
CRJAZ1364I Initial database connection successful
Db Product Name: Apache Derby
Db Product Version: 10.3.3.1 - (677131)
Db URL: jdbc:derby:repositoryDB
Jdbc Driver Name: Apache Derby Embedded JDBC Driver
Jdbc Driver Version: 10.3.3.1 - (677131)
CRJAZ8192I: Fulltext Index Location: C:\Program Files\IBM\JazzTeamServer\server\
workitemindex\fulltext_index
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: thin:xxxxxxxx/xxxxxxxx@//kpnatsp8:1521/rtc
CRJAZ1364I Initial database connection successful
Db Product Name: Oracle
Db Product Version: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
- 64bit Production
With the Partitioning, OLAP and Data Mining options
Db URL: jdbc:oracle:thin:fpajazz/jazz@//kpnatsp8:1521/rtc
Jdbc Driver Name: Oracle JDBC driver
Jdbc Driver Version: 10.2.0.3.0
Creating the tables for the database "thin:xxxxxxxx/xxxxxxxx@//kpnatsp8:1521/rtc
" without indices.
com.ibm.team.repository.common.TeamRepositoryException: !OracleProvider.NotUTF8CharacterSet!
!OracleProvider.NotUTF8CharacterSet!The database tables were not created.


Anybody have and idea of why this is failing?
0
permanent link
Lin Ye (306●3●26●11) | answered Feb 18 '10, 4:17 p.m.
Hi,

Make sure the character set is changed:
select * from nls_database_parameters where parameter like '%CHARACTERSET';

NLS_CHARACTERSET should have some value like "UTF8"

cheers

I changed the Oracle database to UTF8 and I still get the same error:
C:\Program Files\IBM\JazzTeamServer\server>repotools -copy toFile=temp.tar target.teamserver.properties=conf\jazz\teamserver.oracle.fpa.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 - Enterprise
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: repositoryDB
CRJAZ1364I Initial database connection successful
Db Product Name: Apache Derby
Db Product Version: 10.3.3.1 - (677131)
Db URL: jdbc:derby:repositoryDB
Jdbc Driver Name: Apache Derby Embedded JDBC Driver
Jdbc Driver Version: 10.3.3.1 - (677131)
CRJAZ8192I: Fulltext Index Location: C:\Program Files\IBM\JazzTeamServer\server\
workitemindex\fulltext_index
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: thin:xxxxxxxx/xxxxxxxx@//kpnatsp8:1521/rtc
CRJAZ1364I Initial database connection successful
Db Product Name: Oracle
Db Product Version: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
- 64bit Production
With the Partitioning, OLAP and Data Mining options
Db URL: jdbc:oracle:thin:fpajazz/jazz@//kpnatsp8:1521/rtc
Jdbc Driver Name: Oracle JDBC driver
Jdbc Driver Version: 10.2.0.3.0
Creating the tables for the database "thin:xxxxxxxx/xxxxxxxx@//kpnatsp8:1521/rtc
" without indices.
com.ibm.team.repository.common.TeamRepositoryException: !OracleProvider.NotUTF8CharacterSet!
!OracleProvider.NotUTF8CharacterSet!The database tables were not created.


Anybody have and idea of why this is failing?
0
permanent link
Stuart Bedoll (31●1●3) | answered Feb 19 '10, 6:34 a.m.
Ok found the National Character set was still not UTF8. That fixed it.To set the record straight I found UTF-8 was documented in the RTC Oracle section.

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.