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 ? |
One answer
It turns out that the DB2 System on z had not run the jdbc Binder Utility when set up.
|
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.