Beta3 install: database does not exist -- need to be up Mon!
Millard Ellingsworth (2.5k●1●24●31)
| asked May 16 '08, 9:51 p.m.
FORUM ADMINISTRATOR / JAZZ DEVELOPER
*** FIXED, I think. See new Thread about DB2 setup
Was very excited to snap up Beta 3 and then... Carefully followed (much trickier) setup instructions. Downloaded DB2 per the instructions from the indicated location. On first attempt to run the installer, it choked on something (so I just tried it again) and it ran, seemingly successfully. I can bring up the Control Center, poke around, etc. I got the "success" information including: IBM Data Server Driver for ODBC and CLI name: IBM DB2 ODBC DRIVER - DB2COPY1 OLE DB Provider GUID: {6271A9F4-5BFC-4293-AF1D-80A12D24311F} New instances: Instance name: DB2 Start instance on reboot: Yes TCP/IP configuration: Service name: db2c_DB2 Port number: 50000 Instance user information: User name: db2admin ... Required steps: You have enabled DB2 extended Windows security. You must add DB2 users that need to run DB2 local applications or tools to either the DB2ADMNS or DB2USERS group. You can connect to the DB2 instance "DB2" using the port number "50000". Record it for future reference. Of course, I dutifully complied and created a jazzDBuser user in Windows and added her to the DB2ADMNS group. I fixed up the appropriate lines in teamserver.properties file to say: com.ibm.team.repository.db.vendor = DB2 com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:fullyMaterializeLobData=false;user=jazzDBuser;password={password}; com.ibm.team.repository.db.jdbc.password=xxxxxxxx An attempt to create the tables produced: 2008-05-16 17:50:29,828 repotools -createTables 2008-05-16 17:50:29,828 Repo Tools, Version 1.0 Beta 3 2008-05-16 17:50:29,828 Provisioning using "./provision_profiles". 2008-05-16 17:50:55,953 Rational Jazz Team Server - Standard (Early Access) 2008-05-16 17:50:55,968 Loading configuration from "file:teamserver.properties". 2008-05-16 17:50:57,171 Fulltext Index Location: workitemindex\fulltext_index\ 2008-05-16 17:50:57,640 Initial database connection successful Db Product Name: DB2/NT Db Product Version: SQL09050 Db Name/Location: //localhost:50000/JAZZ:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx; 2008-05-16 17:50:58,265 Creating the tables for the database "//localhost:50000/JAZZ:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;" with indices. 2008-05-16 17:50:58,890 CRJAZ0261I Failed to update DB2 configuration options com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1092, SQLSTATE: , SQLERRMC: JAZZDBUSER ... 2008-05-16 17:50:59,015 CRJAZ0258I Error querying tablespace size com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0258I Error querying tablespace size at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewContentTablespace(Db2Provider.java:259) at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:206) ... Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SNAPSHOT_TBS_CFG;*OT_TBS_CFG;SQL1092 Reason code or token: JAZZDBUSER Something wrong with my user setup? Didn't feel like I missed any steps. When I tried a repotools -verify, it says that the database does not exist: 2008-05-16 18:20:16,125 repotools -verify 2008-05-16 18:20:16,125 Repo Tools, Version 1.0 Beta 3 2008-05-16 18:20:16,125 Provisioning using "./provision_profiles". 2008-05-16 18:20:43,500 Rational Jazz Team Server - Standard (Early Access) 2008-05-16 18:20:43,625 Loading configuration from "file:teamserver.properties". 2008-05-16 18:20:47,640 Fulltext Index Location: workitemindex\fulltext_index\ 2008-05-16 18:20:53,718 Initial database connection successful Db Product Name: DB2/NT Db Product Version: SQL09050 Db Name/Location: //localhost:50000/JAZZ:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx; 2008-05-16 18:20:58,281 CRJAZ1204I The database "//localhost:50000/JAZZ:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;" does not exist. I was so much happier with Derby, but can't live without reports (So I had to go "Standard", which means I have to go DB2). I need to be up and running before Monday morning or I'll have a hard time convincing folks that going to Jazz was a good idea. TIA...Millard |
4 answers
You must create JAZZ database before :
https://jazz.net/jazzdocs/index.jsp?topic=/com.ibm.team.install.doc/topics/t_server_installation_setup_db2.html Sbastien Etter Alcatel-Lucent, R&D Effectiveness |
I haven't done this before but just an idea: try to get into DB2 Control
Center and check that: - User JAZZDBUSER exists. Be careful because perhaps it is case sensitive. - User JAZZDBUSER has rights to query tablespace size. I comment this, because perhaps you installed DB2 with other users. In the doc it says: The default connection spec connects to a DB2 database running on localhost on port 50000. The database is called JAZZ, the user is jazzDBuser and the password is jazzDBpswd. Change this information to match your configuration. Hope it helps, Chemi. |
|
Millard Ellingsworth (2.5k●1●24●31)
| answered May 17 '08, 2:13 p.m.
FORUM ADMINISTRATOR / JAZZ DEVELOPER You must create JAZZ database before : I did that (forgot to mention it) using the db2 command line recommended in the documentation. The database JAZZ exists and the port for DB2 is at 50000. I created the users consistent with the samples to minimize changes to the teamserver.properties. That's why it is weird that it says it does not exist because I can see it in the DB2 control center. And there is a DB2 user on that database named JAZZDBUSER who is also in Windows as JazzDBUser and a member of the DB2ADMNS group. In DB2, JAZZDBUSER has all possible rights (for the moment at least). DB2 did change what I originally entered, JazzDBuser, to JAZZDBUSER, so I'll try changing teamserver.properties to use the all upper case version. |
|
Millard Ellingsworth (2.5k●1●24●31)
| answered May 17 '08, 3:06 p.m.
FORUM ADMINISTRATOR / JAZZ DEVELOPER
I replaced this line:
com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:fullyMaterializeLobData=false;user=JAZZDBUSER;password={password}; with: com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ;user=JAZZDBUSER;password={password}; removing the ":fullyMaterializeLobData=false" -- the second colon seemed odd -- it looks like semicolons are used to separate the items. I get a different error now -- it claims that the userid is null. CRJAZ0503I Failed to connect to database: Null userid is not supported. db Name/Location: //localhost:50000/JAZZ;user=xxxxxx;password=xxxxxx; I tried replacing user= with userid=, similar result. I was willing to work the weekend to be ready to start our next iteration on Monday with Beta3. :( |
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.