Error creating Table Schemas
I could use a hint. I have been given a new V10 DB2 so wanted to install from scrath CLM 4.0. I created the JTS,CCm.... databases. I granted dbadm to my USERID to the DBs, sysadm and sysctl to the USERID ( Sames steps I did installing RTC 3.0 ). When I try and create the JTS tables ( random being first ) I can't create the schemas :
2012-11-12 09:58:51,759 CRJAZ1363I Loading the configuration from "file:/etc/rtcz400/jts/teamserver.properties".
2012-11-12 09:58:51,949 CRJAZ1779I This server is configured as a JTS.
2012-11-12 09:58:54,082 CRJAZ1365I The server is attempting to connect to the following database: "//wtsc47.itso.ibm.com:38400/DB0R:user=xxxxxxxx;password=xxxxxxxx;"
2012-11-12 09:58:55,048 CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2
Db Product Version: DSN10015
Db URL: jdbc:db2://wtsc47.itso.ibm.com:38400/DB0R:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.63.131
2012-11-12 09:58:55,099 CRJAZ1093I The following service class was not activated: "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService"
com.ibm.team.repository.common.transport.TeamServiceRegistryException: CRJAZ1092I The service class "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" failed during activation.
Then a bunch of java traces and then
Caused by: java.lang.RuntimeException: CRJAZ0820I Failed to create the system schema.
at com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.reset(PersistentMappingService.java:125)
at com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.activate(PersistentMappingService.java:91)
at com.ibm.team.repository.service.AbstractService.bindRequiredServices(AbstractService.java:191)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:252)
... 100 more
Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=DB0R.NULLID.SYSSTAT.5359534C564C3031;DISTSERV;04, DRIVER=3.63.131
No one else here in the forum seems to have had a schema problem, anybody have a clue or hint ?
2012-11-12 09:58:51,759 CRJAZ1363I Loading the configuration from "file:/etc/rtcz400/jts/teamserver.properties".
2012-11-12 09:58:51,949 CRJAZ1779I This server is configured as a JTS.
2012-11-12 09:58:54,082 CRJAZ1365I The server is attempting to connect to the following database: "//wtsc47.itso.ibm.com:38400/DB0R:user=xxxxxxxx;password=xxxxxxxx;"
2012-11-12 09:58:55,048 CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2
Db Product Version: DSN10015
Db URL: jdbc:db2://wtsc47.itso.ibm.com:38400/DB0R:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.63.131
2012-11-12 09:58:55,099 CRJAZ1093I The following service class was not activated: "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService"
com.ibm.team.repository.common.transport.TeamServiceRegistryException: CRJAZ1092I The service class "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" failed during activation.
Then a bunch of java traces and then
Caused by: java.lang.RuntimeException: CRJAZ0820I Failed to create the system schema.
at com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.reset(PersistentMappingService.java:125)
at com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.activate(PersistentMappingService.java:91)
at com.ibm.team.repository.service.AbstractService.bindRequiredServices(AbstractService.java:191)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:252)
... 100 more
Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=DB0R.NULLID.SYSSTAT.5359534C564C3031;DISTSERV;04, DRIVER=3.63.131
No one else here in the forum seems to have had a schema problem, anybody have a clue or hint ?