It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,944

question asked: Oct 22 '09, 9:24 a.m.
question was seen: 5,191 times
last updated: Oct 22 '09, 9:24 a.m.

Related questions

[RQM 2.0 Ifix01] Problem creating tables

0
Simone Sabatini (11●2) | asked 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

One answer

Most liked answers ↑|Newest answers|Oldest answers

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

problem fixed, dropping and creating DB everything works fine.

thanks

Your answer

Register or 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.