Problem creating database tables
Hello fellows,
I'm trying to set up the RQQM Standard server with Oracle database in backend. Creating the tables via web interface, there is a long error message thrown with a lot of java classes. When I do a repotools createTable, the following is the output: D:\Program Files\IBM\RQM201\server>repotools.bat -createTables Repo Tools Rational Quality Manager, Version 2.0.1 iFix 3 (I20100625_0734) Jazz Foundation - Jazz Team Server, Version 1.0.0.2 iFix 3a (I20100614-2104) Rational Jazz Team Server (RQM) - Enterprise CRJAZ1363I Die Konfiguration aus "file:conf/jazz/teamserver.properties" wird geladen. CRJAZ1365I Erstmaliger Datenbankverbindungsversuch mit Datenbankname/Position: thin:xxxxxxxx/xxxxxxxx@oraserv1.ts.siemens.de:1521:JA ZZ CRJAZ1364I Erstmalige Datenbankverbindung erfolgreich Datenbankproduktname: Oracle Datenbankproduktversion: Oracle Database 10g Enterprise Edition Release 10.2.0 .3.0 - Production With the Partitioning, OLAP and Data Mining options Datenbank-URL: jdbc:oracle:thin:rqm_cargo/XXXXXXXX@oraserv1.ts.siemens.de:152 1:JAZZ JDBC-Treibername: Oracle JDBC driver JDBC-Treiberversion: 10.2.0.3.0 CRJAZ8192I: Position des Volltextindex: D:\RQM\index\fulltext_index Die Tabellen fr die Datenbank "thin:xxxxxxxx/xxxxxxxx@oraserv1.ts.siemens.de:15 21:JAZZ" werden mit Indizes erstellt. com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Fehler bei Vorbereitung oder Ausfhrung der Anweisung => CREATE VIEW COMMON_SNAPSHOT_SMPL_ ITER AS SELECT I.ITERATION_ITEMID AS ITERATION_ITEMID, I.ITERATION_NAME AS ITERA TION_NAME, I.ITERATION_ARCHIVED AS ITERATION_ARCHIVED FROM RQM_CARGO.COMMON_SNAP SHOT_ITERATION I com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Fehler bei Vorbereitung oder Ausfhrung der Anweisung => CREATE VIEW COMMON_SNAPSHOT_SMPL_ ITER AS SELECT I.ITERATION_ITEMID AS ITERATION_ITEMID, I.ITERATION_NAME AS ITERA TION_NAME, I.ITERATION_ARCHIVED AS ITERATION_ARCHIVED FROM RQM_CARGO.COMMON_SNAP SHOT_ITERATION I CRJAZ0489I Das Schema "COMMON_SNAPSHOT", das durch das Paket "com.ibm.team.dataw arehouse.service" hinzugefgt wurde, konnte nicht erstellt werden. CRJAZ0489I Das Schema "COMMON_SNAPSHOT", das durch das Paket "com.ibm.team.dataw arehouse.service" hinzugefgt wurde, konnte nicht erstellt werden. Die Datenbanktabellen wurde nicht erstellt. The connection is fine, but the system fails to create all the tables needed. Tried with RQM 2.0.1 and RQM 2.0.1 iFix3 Any hints regarding this problem? greetings georg. |
One answer
Hello,
I can not read German so I'm having a little trouble following the error, but you're getting a SQL-level error trying to create the DB tables. I'd suggest dropping the DB and recreating it carefully following the instructions found here: http://publib.boulder.ibm.com/infocenter/rqmhelp/v2r0/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_oracle.html Hope that helps. Regards, John Nason RQM Development Hello fellows, |
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.