Exception during repotools.sh -createTables on 1.0M5a
Using DB2: DB2V91 FP 4 for zLINUX 64
The Database created with: db2 "create database JAZZ on /db/db2inst2/db2data/JAZZ While running repotools.sh -createTables the exception below occurs. repotools.log: 2008-03-20 10:27:07,197 Creating tables for database "//localhost:60004/JAZZ:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;" with indices. 2008-03-20 10:27:08,074 Exception occurred creating content tablespace com.ibm.team.repository.common.TeamRepositoryException: Exception occurred creating content tablespace at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.internalCreateContentTablespace(Db2Provider.java:188) at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:168) 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:368) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:353) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:54) at $Proxy4.prepareDbForInitialization(Unknown Source) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:112) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:109) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:99) at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService$ConnectionRunnable.run(AbstractDatabaseService.java:82) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:449) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:263) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:241) at com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.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:368) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:353) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:54) at $Proxy27.runExclusive(Unknown Source) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:95) at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:86) 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:368) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:353) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:54) at $Proxy45.rebuildAllSchemas(Unknown Source) at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:52) at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:86) at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:111) at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:503) at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:560) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) 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:508) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447) at org.eclipse.equinox.launcher.Main.run(Main.java:1173) at org.eclipse.equinox.launcher.Main.main(Main.java:1148) Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -298, SQLSTATE: 428B2, SQLERRMC: null at com.ibm.db2.jcc.c.kh.b(kh.java:1367) at com.ibm.db2.jcc.c.kh.c(kh.java:1354) at com.ibm.db2.jcc.b.db.k(db.java:352) at com.ibm.db2.jcc.b.db.a(db.java:60) at com.ibm.db2.jcc.b.t.a(t.java:52) at com.ibm.db2.jcc.b.tb.b(tb.java:202) at com.ibm.db2.jcc.c.lh.X(lh.java:1842) at com.ibm.db2.jcc.c.lh.d(lh.java:2411) at com.ibm.db2.jcc.c.lh.U(lh.java:1401) at com.ibm.db2.jcc.c.lh.execute(lh.java:1385) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:51) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:65) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:50) at com.ibm.team.repository.service.db.provider.AbstractDbProvider.executeStatement(AbstractDbProvider.java:366) at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.executeStatement(Db2Provider.java:360) at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.createContentTablespace(Db2Provider.java:226) at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.internalCreateContentTablespace(Db2Provider.java:186) ... 53 more The teamserver.properties related to DB2 configuration are: # # DB2 configuration # # Comment out above lines, uncomment the following three lines and customize example location to use DB2 com.ibm.team.repository.db.vendor = DB2 com.ibm.team.repository.db.jdbc.location=//localhost:60004/JAZZ:fullyMaterializeLobData=false;user=db2inst2;password={password}; com.ibm.team.repository.db.jdbc.password=cft65rdx # DB2 requires a path where the content tablespace should be created, examples for Win and Linux follow com.ibm.team.repository.db.db2.content.tablespace.location=/db/db2inst2/db2data/JAZZ |
One answer
I think i found the issue the tablespace location must be in quotes as in:
com.ibm.team.repository.db.db2.content.tablespace.location="/db/db2inst2/db2data/JAZZ" |
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.