Error Creating Lifecycle Tables
![](http://jazz.net/_images/myphoto/04582ce0c528e6c4902aa9d53128492e.jpg)
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,
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,
One answer
![](http://jazz.net/_images/myphoto/04582ce0c528e6c4902aa9d53128492e.jpg)
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.
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.