Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Error Creating Lifecycle Tables

Hello,

I'm getting an exception with RAM 7.5 when configuring the Lifecyle Database (using the ram.setup). The database server is an Oracle 11g.

CRRAM701E: Database - Error - 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 for RAM - Enterprise CRJAZ1363I Loading configuration from "file:D:/WebSphere/AppServer/profiles/RAM/config/cells/XXXXXXX4Node02Cell/RTC/server1/v2002/jazz/server/conf/jazz/teamserver.oracle.properties". CRJAZ1365I Attempting Initial Database Connection Using Db Name/Location: thin:xxxxxxxx/xxxxxxxx@10.152.231.41:1521:oraxxx CRJAZ1364I Initial database connection successful Db Product Name: Oracle Db Product Version: Oracle Database 11g Release 11.1.0.0.0 - Production Db URL: jdbc:oracle:thin:RTCSCHEMA/passwd@10.152.231.41:1521:oraxxx Jdbc Driver Name: Oracle JDBC driver Jdbc Driver Version: 10.1.0.5.0 ////////////////////////////////////////////////////////////////////////////// WARNING: User has choosen to override database version checking and appears to be running with an unsupported version of oracle! ////////////////////////////////////////////////////////////////////////////// CRJAZ8192I: Fulltext Index Location: D:\WebSphere\AppServer\profiles\RAM\config\cells\XXXXXXXNode02Cell\RTC\server1\v2002\jazz\server\workitemindex\fulltext_index CRJAZ8190E: The fulltext index location property (indexLocation) should point to an absolute directory but is currently set to 'workitemindex' Creating the tables for the database "thin:xxxxxxxx/xxxxxxxx@10.152.231.41:1521:oraxxx" with indices. com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => CREATE VIEW COMMON_SNAPSHOT_SMPL_ITER AS SELECT I.ITERATION_ITEMID AS ITERATION_ITEMID, I.ITERATION_NAME AS ITERATION_NAME, I.ITERATION_ARCHIVED AS ITERATION_ARCHIVED FROM COMMON_SNAPSHOT_ITERATION I com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => CREATE VIEW COMMON_SNAPSHOT_SMPL_ITER AS SELECT I.ITERATION_ITEMID AS ITERATION_ITEMID, I.ITERATION_NAME AS ITERATION_NAME, I.ITERATION_ARCHIVED AS ITERATION_ARCHIVED FROM COMMON_SNAPSHOT_ITERATION I CRJAZ0489I Failed to build the schema "COMMON_SNAPSHOT" contributed by bundle "com.ibm.team.datawarehouse.service". CRJAZ0489I Failed to build the schema "COMMON_SNAPSHOT" contributed by bundle "com.ibm.team.datawarehouse.service". The database tables were not created.


Any suggestions ?

Regards,

0 votes



One answer

Permanent link
This step creates a file called
repotools_createTables.log at

'file:D:/WebSphere/AppServer/profiles/RAM/config/cells/XXXXXXX4Node02Cell/RTC/server1/v2002/jazz/server'

This file will contain detailed error messages, it looks like its not a connectivity error, so probably something specific to oracle.

Can you post the error from that file.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: May 13 '11, 12:23 p.m.

Question was seen: 6,272 times

Last updated: May 13 '11, 12:23 p.m.

Confirmation Cancel Confirm