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

issue of repotools command on RQM2.0 and DB29.1.8

Questions
Tags
Users
Badges
Dan Dan Wang
(21●3●2) Dec 24 '09, 2:52 a.m.
I'm trying to configure my RQM2.0 with DB29.1(Fix8). But when I run ./repotools.sh -createTables command, I continually encounter following error.

I really create RQM database manually according to the setting says on help.

Is there any idea for this problem? Thanks. 

# ./repotools.sh -createTables

Repo Tools

  Jazz Foundation Server, Version 1.0 (I20090618-1753)

  Rational Quality Manager, Version 2.0 (I20090713_1659)



Provisioning using "./conf/jazz/provision_profiles".

Rational Jazz Team Server (RQM) - Enterprise

CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".

CRJAZ1365I Attempting Initial Database Connection Using

  Db Name/Location: =//localhost:50000/RQM:user=xxxxxxxx;password=xxxxxxxx;

CRJAZ0503I Failed to connect to the database: "[jcc][10165][10038][3.53.70] Invalid database URL synt:50000/RQM:user=xxxxxx;password=xxxxxx;. ERRORCODE=-4461, SQLSTATE=42815"

  Db Name/Location: "=//localhost:50000/RQM:user=xxxxxxxx;password=xxxxxxxx;"

CRJAZ1093I Service failed to activate.

CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateSer

CRJAZ1203I Could not determine the database location.

CRJAZ1306I The service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService" is not a

Creating the tables for the database "=//localhost:50000/RQM:user=xxxxxxxx;password=xxxxxxxx;" with

CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseCreation

CRJAZ1309I The database connectivity service is not ready.

The database tables were not created.


The part of repotools_createTables.log is like below 
Caused by:

java.lang.RuntimeException: CRJAZ0820I Failed to create the system schema.

        at com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.activate(PersistentMappingService.java:92)

        at com.ibm.team.repository.service.AbstractService.bindRequiredServices(AbstractService.java:180)

        at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:211)

        ... 39 more

Caused by:

com.ibm.team.repository.common.TeamRepositoryException: [jcc][10165][10038][3.53.70] Invalid database URL syntax: jdbc:db2:=//localhost:50000/RQM:user=db2bv;password=open1sys;. ERRORCODE=-4461, SQLSTATE=42815

        at com.ibm.team.repository.service.internal.rdb.ConnectionFactory.createConnection(ConnectionFactory.java:142)

        at com.ibm.team.repository.service.internal.rdb.JDBCConnectionPool.createEntry(JDBCConnectionPool.java:58)

        at com.ibm.team.repository.service.internal.rdb.AbstractPool.getEntry(AbstractPool.java:194)

        at com.ibm.team.repository.service.internal.rdb.JDBCConnectionPool.getConnection(JDBCConnectionPool.java:96)

        at com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.activate(PersistentMappingService.java:85)

        ... 41 more

Caused by:

com.ibm.db2.jcc.b.co: [jcc][10165][10038][3.53.70] Invalid database URL syntax: jdbc:db2:=//localhost:50000/RQM:user=db2bv;password=open1sys;. ERRORCODE=-4461, SQLSTATE=42815

        at com.ibm.db2.jcc.b.bd.a(bd.java:676)

        at com.ibm.db2.jcc.b.bd.a(bd.java:60)

        at com.ibm.db2.jcc.b.bd.a(bd.java:103)

        at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:226)

        at com.ibm.team.repository.service.db.provider.AbstractDbProvider.getConnection(AbstractDbProvider.java:115)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:618)

        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:378)

        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)

        at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)

        at $Proxy19.getConnection(Unknown Source)

        at com.ibm.team.repository.service.internal.rdb.ConnectionFactory.createConnection(ConnectionFactory.java:89)

        ... 45 more

2009-12-18 15:57:06,406 CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService".

com.ibm.team.repository.common.transport.TeamServiceRegistryException: CRJAZ1092I The service class "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" failed during activation.

        at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:217)

        at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:543)

        at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.activate(AbstractActivationManagerOwner.java:143)

        at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.activate(BundleActivationManager.java:290)

        at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.performActivation(BundleActivationManager.java:1584)

        at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.access$2(BundleActivationManager.java:1569)

        at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager$3.acquired(BundleActivationManager.java:573)

        at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.serviceAcquired(ImportServiceRecordContainer.java:587)

        at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.access$1(ImportServiceRecordContainer.java:571)

        at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer$5.serviceAcquired(ImportServiceRecordContainer.java:352)

        at org.eclipse.soda.sat.core.internal.record.ImportServiceRecord.acquire(ImportServiceRecord.java:114)

        at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer$1.execute(ImportServiceRecordContainer.java:64)

        at org.eclipse.soda.sat.core.internal.record.container.ServiceRecordContainer.doForService(ServiceRecordContainer.java:352)

        at org.eclipse.soda.sat.core.internal.record.container.ServiceRecordContainer.doForEach(ServiceRecordContainer.java:319)

        at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.acquire(ImportServiceRecordContainer.java:303)

....

0 votes

2 answers
6,143 views
0 votes

2 answers

Permanent link
Dan Dan Wang
(21●3●2) Dec 28 '09, 2:12 a.m.
Any solution on this problem? Thank you all.

0 votes

Permanent link
David Mehaffy
JAZZ DEVELOPER (901●2●33●38) Dec 29 '09, 12:23 p.m.
On 12/28/2009 1:21 AM, ddwang wrote:
Any solution on this problem? Thank you all.

Hi Dan Dan,


Contact me via sametime and I will get you going. I think you also
should upgrade db2 to 9.5 as well

Dave

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.

Ask a question
Guidelines
FAQ
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: Dec 24 '09, 2:52 a.m.

Question was seen: 6,143 times

Last updated: Dec 24 '09, 2:52 a.m.

Confirmation Cancel Confirm