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

[RQM 2.0 Ifix01] Problem creating tables

Questions
Tags
Users
Badges
Simone Sabatini
(11●2) Oct 22 '09, 9:24 a.m.
Hello everyone, I have QM 2.0 on Linux RHEL 5U3 and a blank DB on DB2 9.5 Fix pack 4 on a windows machine. I'm trying to create tables but he script repotools.sh fails with the following output 

[root@qmserver01 server]# ./repotools.sh -createTables

Repo Tools

  Rational Quality Manager, Version 2.0 (I20090713_1659)

  Jazz Foundation Server, Version 1.0 (I20090618-1753)



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: //172.16.46.210:50000/PICORAQM:user=xxxxxxxx;password=xxxxxxxx;

CRJAZ1364I Initial database connection successful

  Db Product Name: DB2/NT

  Db Product Version: SQL09054

  Db URL: jdbc:db2://172.16.46.210:50000/PICORAQM

  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture

  Jdbc Driver Version: 3.53.70

CRJAZ8192E: Fulltext Index Location: workitemindex/fulltext_index/

Creating the tables for the database "//172.16.46.210:50000/PICORAQM:user=xxxxxxxx;password=xxxxxxxx;" with indices.

com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => ALTER TABLE REPOSITORY.CONTEXT_URL_MAPPING ADD CONSTRAINT CONTXT_RL_MPPNG_PK PRIMARY KEY (CONTEXT_URL, CONTEXT_UUID)

com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => ALTER TABLE REPOSITORY.CONTEXT_URL_MAPPING ADD CONSTRAINT CONTXT_RL_MPPNG_PK PRIMARY KEY (CONTEXT_URL, CONTEXT_UUID)

CRJAZ0487I An exception occurred while creating the database schema for the package "com.ibm.team.repository".

The database tables were not created.


and this is repotools_createTables.log 

root@qmserver01 server]# more repotools_createTables.log

2009-10-22 12:34:30,953 repotools -createTables 

2009-10-22 12:34:30,968 java.version=1.5.0

2009-10-22 12:34:30,968 java.runtime.version=pxi32devifx-20090505 (SR9-0 +IZ45776+IZ49644+IZ49635)

2009-10-22 12:34:30,968 Repo Tools

2009-10-22 12:34:30,969   Rational Quality Manager, Version 2.0 (I20090713_1659)

  Jazz Foundation Server, Version 1.0 (I20090618-1753)



2009-10-22 12:34:30,979 Provisioning using "./conf/jazz/provision_profiles".

2009-10-22 12:34:43,244 Rational Jazz Team Server (RQM) - Enterprise

2009-10-22 12:34:43,500 CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".

2009-10-22 12:34:48,395 CRJAZ1365I Attempting Initial Database Connection Using

  Db Name/Location: //172.16.46.210:50000/PICORAQM:user=xxxxxxxx;password=xxxxxxxx;

2009-10-22 12:34:49,095 CRJAZ1364I Initial database connection successful

  Db Product Name: DB2/NT

  Db Product Version: SQL09054

  Db URL: jdbc:db2://172.16.46.210:50000/PICORAQM

  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture

  Jdbc Driver Version: 3.53.70

2009-10-22 12:34:49,760 CRJAZ8192E: Fulltext Index Location: workitemindex/fulltext_index/

2009-10-22 12:34:50,539 Creating the tables for the database "//172.16.46.210:50000/PICORAQM:user=xxxxxxxx;password=xxxxxxxx;" with indices.

2009-10-22 12:35:19,543 com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => ALTER

 TABLE REPOSITORY.CONTEXT_URL_MAPPING ADD CONSTRAINT CONTXT_RL_MPPNG_PK PRIMARY KEY (CONTEXT_URL, CONTEXT_UUID)

2009-10-22 12:35:20,431 com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => ALTER

 TABLE REPOSITORY.CONTEXT_URL_MAPPING ADD CONSTRAINT CONTXT_RL_MPPNG_PK PRIMARY KEY (CONTEXT_URL, CONTEXT_UUID)

2009-10-22 12:35:22,951 CRJAZ0487I An exception occurred while creating the database schema for the package "com.ibm.team.repository".

com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0487I An exception occurred while creating the database schema for the package "

com.ibm.team.repository".

        at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAndSaveSchema(AbstractDatabaseService.java:327)

        at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateSchemaForPackage(AbstractDatabaseService.java:1

91)

        at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreatePackageSchemas(AbstractDatabaseService.java:178

)

        at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAllSchemas(AbstractDatabaseService.java:171)

        at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:115)

        at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:110)

        at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:100)

        at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.run(ConnectionRunnable.java:34)

        at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:466)

        at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:292)

        at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:328)

        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(ExportProxyServiceRecor

d.java:56)

        at $Proxy20.withCurrentConnection(Unknown Source)

        at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:288)

        at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:267)

        at com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.java:84)

        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(ExportProxyServiceRecor

d.java:56)

        at $Proxy44.runExclusive(Unknown Source)

        at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:96)

        at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:87)

        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(ExportProxyServiceRecor

d.java:56)

        at $Proxy58.rebuildAllSchemas(Unknown Source)

        at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:67)

        at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:115)

        at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:161)

        at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:671)

        at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:702)

        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)

        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)

        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)

        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.equinox.launcher.Main.invokeFramework(Main.java:549)

        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)

        at org.eclipse.equinox.launcher.Main.run(Main.java:1236)

        at org.eclipse.equinox.launcher.Main.main(Main.java:1212)

Caused by: 

com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => ALTER TABLE REPOSITORY.CONTEX

T_URL_MAPPING ADD CONSTRAINT CONTXT_RL_MPPNG_PK PRIMARY KEY (CONTEXT_URL, CONTEXT_UUID)

        at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQuery(JdbcDB.java:237)

        at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQuery(JdbcDB.java:114)

        at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQueryOn(JdbcDB.java:103)

        at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.executeStatement(JdbcDBBuilder.java:147)

        at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.executeStatements(JdbcDBBuilder.java:193)

        at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.buildArtifactsFromCreateStatements(JdbcDBBuilder.java:198)

        at com.ibm.team.repository.service.internal.rdb.PluggableJdbcDbBuilder.buildArtifactsFromCreateStatements(PluggableJdbcDbBuilder.java

:90)

        at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateSchema(AbstractDatabaseService.java:388)

        at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAndSaveSchema(AbstractDatabaseService.java:321)

        ... 57 more

Caused by: 

com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-613, SQLSTATE=54008, SQLERRMC=CONTXT_RL_MPPNG_PK, DRIVER=3.53.70

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

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

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

        at com.ibm.db2.jcc.b.fm.b(fm.java:2132)

        at com.ibm.db2.jcc.b.fm.c(fm.java:2115)

        at com.ibm.db2.jcc.t4.db.k(db.java:353)

        at com.ibm.db2.jcc.t4.db.a(db.java:59)

        at com.ibm.db2.jcc.t4.t.a(t.java:50)

        at com.ibm.db2.jcc.t4.tb.b(tb.java:200)

        at com.ibm.db2.jcc.b.gm.Zb(gm.java:2445)

        at com.ibm.db2.jcc.b.gm.e(gm.java:3287)

        at com.ibm.db2.jcc.b.gm.Tb(gm.java:1901)

        at com.ibm.db2.jcc.b.gm.execute(gm.java:1885)

        at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.ja

va:51)

        at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrap

per.java:65)

        at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.ja

va:50)

        at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQuery(JdbcDB.java:226)

        ... 65 more

2009-10-22 12:35:22,955 The database tables were not created.


any suggestion ?

thanks in advance

0 votes

1 answer
5,438 views
0 votes

One answer

Permanent link
Simone Sabatini
(11●2) Oct 22 '09, 12:07 p.m.
--- update ---

problem fixed, dropping and creating DB everything works fine.

thanks

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: Oct 22 '09, 9:24 a.m.

Question was seen: 5,438 times

Last updated: Oct 22 '09, 9:24 a.m.

Confirmation Cancel Confirm