It's all about the answers!

Ask a question

./install fails on Linux. Cannot execute binary file


Thomas Loeber (62237750) | asked Jul 31 '08, 8:10 a.m.
JAZZ DEVELOPER
I've download, from IBM XL the Full Standard Version of RTC 1.0. The RTC-Standard-Full-1.o-Linux-Local.zip expanded without errors. When I attempt to run the ./install executable from /root/rtc/linux I get this error. The permissions are OK.
# ls -l install
-rwxr-xr-x 1 root root 57060 Apr 9 18:01 install
# file install
install: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux
2.2.5, dynamically linked (uses shared libs), for GNU/Linux 2.2.5, not stripped

# ./install -input install-server.xml
-bash: ./install: cannot execute binary file
#

Is this binary file not executable on RHEL 5.1 ?

7 answers



permanent link
Craig Chaney (9212) | answered Jul 31 '08, 3:18 p.m.
JAZZ DEVELOPER
thloeber wrote:
# ./install -input install-server.xml
-bash: ./install: cannot execute binary file
#

Is this binary file not executable on RHEL 5.1 ?

That should definitely work. The only thing that occurs to me that
might cause that error message would be if you're not running on an
Intel architecture. Is that possible?

Thanks,
Craig

permanent link
James Stuckey (63634) | answered Jul 31 '08, 6:15 p.m.
JAZZ DEVELOPER
Craig Chaney wrote:

That should definitely work. The only thing that occurs to me that
might cause that error message would be if you're not running on an
Intel architecture. Is that possible?


I talked to Tom about the details of his environment and your guess is
correct. He was attempting to install on a PPC machine which is why he
received the error.

We need to be more clear in our supported platform documentation for the
server that currently Linux means Linux/x86.

This does not mean that the server won't potentially run on other
architectures. In fact, we run it internally on AIX/PPC, but we don't
currently provide bits that will work on these configurations out of the
box. For example, as Tom noted, the installation manager installer is
an x86 executable and the included jvm is x86. I have opened
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/59420
for the issue of clarifying the architecture support.

-James
Jazz Install Team

permanent link
Thomas Loeber (62237750) | answered Jul 31 '08, 8:33 p.m.
JAZZ DEVELOPER
Thanks all.
As an update, we decided to download the RTC-1.0 Linux Server zip from jazz.net and expand that into /root. After setting up a DB2 DB on a remote server and editing the teamserver.properties file as instructed the ./repotools.sh -createTables had an abend because the sh script was coded to run the java binary from the bundled x86 JRE.
I edited the sh script to pint to our installed PCC JRE and the script at least attempted to run.
The creatTables failed with an error stating the connect id and password did not have permissions to create tables and indexes. Not true. The connect id was granted dbadm on the database. The command that failed was a DB2 UPDATE CFG USING logprimary 20. This command takes more auth then just creating tables and indexes.
Any DB or INSTANCE CFG that needs to be done should be in the db2 setup procedures prior to running ./repotools.sh.
I'll start a separate thread here on this topic.

permanent link
Matt Lavin (2.7k2) | answered Jul 31 '08, 9:36 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
I'm glad to hear that you have made progress.

While we do use the "DB2 UPDATE CFG" command to set some configuration
properties, we do it to reduce the number of manual DB configuration
steps. The code that tries to update the DB config settings will log an
error if the update fails, but it should not stop the creation of the
repository. Perhaps the error should be changed to a warning.

Did the tables get created, even after seeing the error? If not, could
you include the repotools log file so that I can help debug the problem?

thloeber wrote:
Thanks all.
As an update, we decided to download the RTC-1.0 Linux Server zip from
jazz.net and expand that into /root. After setting up a DB2 DB on a
remote server and editing the teamserver.properties file as
instructed the ./repotools.sh -createTables had an abend because the
sh script was coded to run the java binary from the bundled x86 JRE.

I edited the sh script to pint to our installed PCC JRE and the script
at least attempted to run.
The creatTables failed with an error stating the connect id and
password did not have permissions to create tables and indexes. Not
true. The connect id was granted dbadm on the database. The command
that failed was a DB2 UPDATE CFG USING logprimary 20. This command
takes more auth then just creating tables and indexes.
Any DB or INSTANCE CFG that needs to be done should be in the db2
setup procedures prior to running ./repotools.sh.
I'll start a separate thread here on this topic.

permanent link
Thomas Loeber (62237750) | answered Aug 01 '08, 9:10 a.m.
JAZZ DEVELOPER
There were 5 tables created for the LMRTC schema. LMRTC is the connection id used. The 5 tables each end with _DEADLOCKS.
Here is the log file. Notice the last line.
2008-08-01 08:29:49,069 repotools -createTables
2008-08-01 08:29:49,071 Repo Tools, Version 1.0 - I20080618-1642
2008-08-01 08:29:49,072 Provisioning using "./provision_profiles".
2008-08-01 08:30:00,424 Rational Jazz Team Server - Standard (60 day trial)
2008-08-01 08:30:00,432 Loading configuration from "file:teamserver.properties".
2008-08-01 08:30:01,789 Fulltext Index Location: workitemindex/fulltext_index/
2008-08-01 08:30:04,218 Initial database connection successful
Db Product Name: DB2/AIX64
Db Product Version: SQL09015
Db Name/Location: //nsdbcq2.raleigh.ibm.com:60008/LMJAZZ:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;
2008-08-01 08:30:04,309 Creating the tables for the database "//nsdbcq2.raleigh.ibm.com:60008/LMJAZZ:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;" with indices.
2008-08-01 08:30:04,489 CRJAZ1245I The database user does not have the required privileges to perform the specified operation. Check with your database administrator or your database vendor product documentation and ensure the user account has appropriate authority to read, write, and administer tables.
SQL: CALL SYSPROC.ADMIN_CMD ('UPDATE DB CFG USING logprimary 20')
SQL Exception #1
SQL Message: DB2 SQL error: SQLCODE: -1092, SQLSTATE: , SQLERRMC: LMRTC
SQL State:
Error Code: -1092

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1092, SQLSTATE: , SQLERRMC: LMRTC
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.e(db.java:96)
at com.ibm.db2.jcc.b.t.e(t.java:83)
at com.ibm.db2.jcc.b.sb.h(sb.java:167)
at com.ibm.db2.jcc.c.kh.p(kh.java:1327)
at com.ibm.db2.jcc.c.lh.d(lh.java:2473)
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.jdbcdriver.internal.db2.Db2Provider.updateDatabaseConfig(Db2Provider.java:125)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy5.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:101)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:264)
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:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy32.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:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy50.rebuildAllSchemas(Unknown Source)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:56)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:103)
at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:167)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:616)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:673)
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:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
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)
2008-08-01 08:30:04,495 CRJAZ0261I Failed to update DB2 configuration options.
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1092, SQLSTATE: , SQLERRMC: LMRTC
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.e(db.java:96)
at com.ibm.db2.jcc.b.t.e(t.java:83)
at com.ibm.db2.jcc.b.sb.h(sb.java:167)
at com.ibm.db2.jcc.c.kh.p(kh.java:1327)
at com.ibm.db2.jcc.c.lh.d(lh.java:2473)
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.jdbcdriver.internal.db2.Db2Provider.updateDatabaseConfig(Db2Provider.java:125)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy5.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:101)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:264)
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:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy32.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:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy50.rebuildAllSchemas(Unknown Source)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:56)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:103)
at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:167)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:616)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:673)
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:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
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)
2008-08-01 08:30:04,518 Vendor specific exception
SQL: select total_pages from table (snapshot_tbs_cfg ('LMJAZZ', -1)) as snapshot_tbs_cfg where tablespace_name = 'CONTENTTS'
SQL Exception #1
SQL Message: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SNAPSHOT_TBS_CFG;*SHOT_TBS_CFG;SQL1092 Reason code or token: LMRTC
SQL State: 38553
Error Code: -443

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SNAPSHOT_TBS_CFG;*SHOT_TBS_CFG;SQL1092 Reason code or token: LMRTC
at com.ibm.db2.jcc.c.bh.b(bh.java:3046)
at com.ibm.db2.jcc.c.bh.a(bh.java:3029)
at com.ibm.db2.jcc.b.db.a(db.java:728)
at com.ibm.db2.jcc.b.db.m(db.java:717)
at com.ibm.db2.jcc.b.db.i(db.java:244)
at com.ibm.db2.jcc.b.db.c(db.java:53)
at com.ibm.db2.jcc.b.t.c(t.java:46)
at com.ibm.db2.jcc.b.sb.g(sb.java:154)
at com.ibm.db2.jcc.c.kh.o(kh.java:1219)
at com.ibm.db2.jcc.c.lh.d(lh.java:2436)
at com.ibm.db2.jcc.c.lh.S(lh.java:432)
at com.ibm.db2.jcc.c.lh.executeQuery(lh.java:415)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:57)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:75)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:54)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.getContentTablespaceSize(Db2Provider.java:357)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewContentTablespace(Db2Provider.java:247)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:206)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy5.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:101)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:264)
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:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy32.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:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy50.rebuildAllSchemas(Unknown Source)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:56)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:103)
at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:167)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:616)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:673)
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:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
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)
2008-08-01 08:30:04,524 CRJAZ0258I Error querying tablespace size.
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0258I Error querying tablespace size.
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewContentTablespace(Db2Provider.java:259)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:206)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy5.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:101)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:264)
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:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy32.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:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy50.rebuildAllSchemas(Unknown Source)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:56)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:103)
at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:167)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:616)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:673)
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:59)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
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: -443, SQLSTATE: 38553, SQLERRMC: SNAPSHOT_TBS_CFG;*SHOT_TBS_CFG;SQL1092 Reason code or token: LMRTC
at com.ibm.db2.jcc.c.bh.b(bh.java:3046)
at com.ibm.db2.jcc.c.bh.a(bh.java:3029)
at com.ibm.db2.jcc.b.db.a(db.java:728)
at com.ibm.db2.jcc.b.db.m(db.java:717)
at com.ibm.db2.jcc.b.db.i(db.java:244)
at com.ibm.db2.jcc.b.db.c(db.java:53)
at com.ibm.db2.jcc.b.t.c(t.java:46)
at com.ibm.db2.jcc.b.sb.g(sb.java:154)
at com.ibm.db2.jcc.c.kh.o(kh.java:1219)
at com.ibm.db2.jcc.c.lh.d(lh.java:2436)
at com.ibm.db2.jcc.c.lh.S(lh.java:432)
at com.ibm.db2.jcc.c.lh.executeQuery(lh.java:415)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:57)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:75)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:54)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.getContentTablespaceSize(Db2Provider.java:357)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewContentTablespace(Db2Provider.java:247)
... 53 more
2008-08-01 08:30:04,529 The database tables were not created.

permanent link
Matt Lavin (2.7k2) | answered Aug 01 '08, 11:52 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
Looks like the rest of the tables are not being crated because of the
following exception:

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SNAPSHOT_TBS_CFG;*SHOT_TBS_CFG;SQL1092
Reason code or token: LMRTC

That appears to be yet another authorization failure. In this case, the
code is not written to support that failure. Repotools is trying to
determine if the tablespace used to hold the Jazz content is as big as
you requested (through some Jazz config properties).

You could argue that Jazz should not assume that tablespaces can be
queried and created, but unfortunately that's how it is written now. If
you agree that the creation of tablespaces should be assumed, could you
open a bug that describes your environment and how it would/should work?


thloeber wrote:
There were 5 tables created for the LMRTC schema. LMRTC is the
connection id used. The 5 tables each end with _DEADLOCKS.
Here is the log file. Notice the last line.
2008-08-01 08:29:49,069 repotools -createTables
2008-08-01 08:29:49,071 Repo Tools, Version 1.0 - I20080618-1642
2008-08-01 08:29:49,072 Provisioning using
"./provision_profiles".
2008-08-01 08:30:00,424 Rational Jazz Team Server - Standard (60 day
trial)
2008-08-01 08:30:00,432 Loading configuration from
"file:teamserver.properties".
2008-08-01 08:30:01,789 Fulltext Index Location:
workitemindex/fulltext_index/
2008-08-01 08:30:04,218 Initial database connection successful
Db Product Name: DB2/AIX64
Db Product Version: SQL09015
Db Name/Location:
//nsdbcq2.raleigh.ibm.com:60008/LMJAZZ:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;
2008-08-01 08:30:04,309 Creating the tables for the database
"//nsdbcq2.raleigh.ibm.com:60008/LMJAZZ:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;"
with indices.
2008-08-01 08:30:04,489 CRJAZ1245I The database user does not have the
required privileges to perform the specified operation. Check with
your database administrator or your database vendor product
documentation and ensure the user account has appropriate authority
to read, write, and administer tables.
SQL: CALL SYSPROC.ADMIN_CMD ('UPDATE DB CFG USING logprimary 20')
SQL Exception #1
SQL Message: DB2 SQL error: SQLCODE: -1092, SQLSTATE: , SQLERRMC:
LMRTC
SQL State:
Error Code: -1092

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1092,
SQLSTATE: , SQLERRMC: LMRTC
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.e(db.java:96)
at com.ibm.db2.jcc.b.t.e(t.java:83)
at com.ibm.db2.jcc.b.sb.h(sb.java:167)
at com.ibm.db2.jcc.c.kh.p(kh.java:1327)
at com.ibm.db2.jcc.c.lh.d(lh.java:2473)
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.jdbcdriver.internal.db2.Db2Provider.updateDatabaseConfig(Db2Provider.java:125)
at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy5.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:101)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:264)
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:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy32.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:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy50.rebuildAllSchemas(Unknown Source)
at
com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:56)
at
com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:103)
at
com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:167)
at
com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:616)
at
com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:673)
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:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
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)
2008-08-01 08:30:04,495 CRJAZ0261I Failed to update DB2 configuration
options.
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -1092,
SQLSTATE: , SQLERRMC: LMRTC
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.e(db.java:96)
at com.ibm.db2.jcc.b.t.e(t.java:83)
at com.ibm.db2.jcc.b.sb.h(sb.java:167)
at com.ibm.db2.jcc.c.kh.p(kh.java:1327)
at com.ibm.db2.jcc.c.lh.d(lh.java:2473)
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.jdbcdriver.internal.db2.Db2Provider.updateDatabaseConfig(Db2Provider.java:125)
at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy5.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:101)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:264)
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:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy32.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:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy50.rebuildAllSchemas(Unknown Source)
at
com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:56)
at
com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:103)
at
com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:167)
at
com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:616)
at
com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:673)
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:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
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)
2008-08-01 08:30:04,518 Vendor specific exception
SQL: select total_pages from table (snapshot_tbs_cfg ('LMJAZZ', -1))
as snapshot_tbs_cfg where tablespace_name = 'CONTENTTS'
SQL Exception #1
SQL Message: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC:
SNAPSHOT_TBS_CFG;*SHOT_TBS_CFG;SQL1092 Reason code or token: LMRTC

SQL State: 38553
Error Code: -443

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC: SNAPSHOT_TBS_CFG;*SHOT_TBS_CFG;SQL1092
Reason code or token: LMRTC
at com.ibm.db2.jcc.c.bh.b(bh.java:3046)
at com.ibm.db2.jcc.c.bh.a(bh.java:3029)
at com.ibm.db2.jcc.b.db.a(db.java:728)
at com.ibm.db2.jcc.b.db.m(db.java:717)
at com.ibm.db2.jcc.b.db.i(db.java:244)
at com.ibm.db2.jcc.b.db.c(db.java:53)
at com.ibm.db2.jcc.b.t.c(t.java:46)
at com.ibm.db2.jcc.b.sb.g(sb.java:154)
at com.ibm.db2.jcc.c.kh.o(kh.java:1219)
at com.ibm.db2.jcc.c.lh.d(lh.java:2436)
at com.ibm.db2.jcc.c.lh.S(lh.java:432)
at com.ibm.db2.jcc.c.lh.executeQuery(lh.java:415)
at
com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:57)
at
com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:75)
at
com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:54)
at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.getContentTablespaceSize(Db2Provider.java:357)
at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewContentTablespace(Db2Provider.java:247)
at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:206)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy5.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:101)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:264)
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:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy32.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:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy50.rebuildAllSchemas(Unknown Source)
at
com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:56)
at
com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:103)
at
com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:167)
at
com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:616)
at
com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:673)
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:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
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)
2008-08-01 08:30:04,524 CRJAZ0258I Error querying tablespace size.
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0258I
Error querying tablespace size.
at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewContentTablespace(Db2Provider.java:259)
at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:206)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy5.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:101)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:264)
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:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy32.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:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
at $Proxy50.rebuildAllSchemas(Unknown Source)
at
com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:56)
at
com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:103)
at
com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:167)
at
com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:616)
at
com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:673)
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:59)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:39)
at java.lang.reflect.Method.invoke(Method.java:612)
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: -443,
SQLSTATE: 38553, SQLERRMC: SNAPSHOT_TBS_CFG;*SHOT_TBS_CFG;SQL1092
Reason code or token: LMRTC
at com.ibm.db2.jcc.c.bh.b(bh.java:3046)
at com.ibm.db2.jcc.c.bh.a(bh.java:3029)
at com.ibm.db2.jcc.b.db.a(db.java:728)
at com.ibm.db2.jcc.b.db.m(db.java:717)
at com.ibm.db2.jcc.b.db.i(db.java:244)
at com.ibm.db2.jcc.b.db.c(db.java:53)
at com.ibm.db2.jcc.b.t.c(t.java:46)
at com.ibm.db2.jcc.b.sb.g(sb.java:154)
at com.ibm.db2.jcc.c.kh.o(kh.java:1219)
at com.ibm.db2.jcc.c.lh.d(lh.java:2436)
at com.ibm.db2.jcc.c.lh.S(lh.java:432)
at com.ibm.db2.jcc.c.lh.executeQuery(lh.java:415)
at
com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:57)
at
com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:75)
at
com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:54)
at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.getContentTablespaceSize(Db2Provider.java:357)
at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewContentTablespace(Db2Provider.java:247)
... 53 more
2008-08-01 08:30:04,529 The database tables were not created.

permanent link
Thomas Loeber (62237750) | answered Aug 01 '08, 12:55 p.m.
JAZZ DEVELOPER
I've granted the connect id SYSMAINT authority to the database. This has gotten me past this error and on to another one. I'll post a new thread if I cannot figure it out.

Your answer


Register or to post your answer.