It's all about the answers!

Ask a question

Exception during repotools.sh -createTables on 1.0M5a


Javier Garcia (2643) | asked Mar 20 '08, 11:12 a.m.
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



permanent link
Javier Garcia (2643) | answered Mar 20 '08, 12:30 p.m.
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


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.