It's all about the answers!

Ask a question

Failed when executing "repotools-jts createWarehouse&am


Francine Li (633) | asked Nov 23 '11, 5:53 a.m.
The comond line of "repotools-jts createTables" has worked but it failed to excute the "repotools-jts createdWarehouse".
I tried to find out more but just cann't figure it out.

The operating system is Windows 7. Here is what's there in the log:

2011-11-23 18:45:11,727 Repo Tools
2011-11-23 18:45:11,727 java.version=1.5.0
2011-11-23 18:45:11,727 java.runtime.version=pwi32devifx-20110209 (SR11 FP2 +IZ94331)
2011-11-23 18:45:11,727 C:\Program Files\IBM\JazzTeamServer\server\conf\jts\provision_profiles
2011-11-23 18:45:11,743 repotools-jts -createWarehouse
2011-11-23 18:45:11,743 Jazz Foundation - Core Libraries, Version 3.0.1.1 (RJF-I20111006-0903)

2011-11-23 18:45:11,759 CRJAZ1363I file:conf/jts/teamserver.properties
2011-11-23 18:45:12,211 CRJAZ1779I JTS
2011-11-23 18:45:12,211 CRJAZ1971I
URIhttps://10.1.112.18:9443/jts
2011-11-23 18:45:13,194 CRJAZ1365I //localhost:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;
2011-11-23 18:45:15,113 CRJAZ1364I
DB2/NT
SQL09074
URLjdbc:db2://localhost:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;
JDBC IBM DB2 JDBC Universal Driver Architecture
JDBC 3.57.82
2011-11-23 18:45:16,610 CRJAZ8192I: C:\Program Files\IBM\JazzTeamServer\server\conf\jts\indices\workitemindex\fulltext_index
2011-11-23 18:45:21,602 CREATE TEMPORARY TABLESPACE TEMPSPACE32K IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM USING ('/jazzdw/tempspace32k') BUFFERPOOL BPTEMP32K
com.ibm.team.repository.common.TeamRepositoryException: CREATE TEMPORARY TABLESPACE TEMPSPACE32K IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM USING ('/jazzdw/tempspace32k') BUFFERPOOL BPTEMP32K
at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:229)
at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.executeSql(AbstractDataWarehouseDbProvider.java:93)
at com.ibm.team.datawarehouse.service.db2.internal.DB2DataWarehouseDbProvider.setupDataWarehouse(DB2DataWarehouseDbProvider.java:26)
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:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy358.setupDataWarehouse(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$1.run(RemoteDatabaseService.java:123)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$4.run(RemoteDatabaseService.java:206)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:196)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.createRemoteSchemas(RemoteDatabaseService.java:114)
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:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy46.createRemoteSchemas(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.CreateDataWarehouseCommand.execute(CreateDataWarehouseCommand.java:17)
at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:64)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:736)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:811)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
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:368)
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:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
Caused by:
com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-298, SQLSTATE=428B2, SQLERRMC=null, DRIVER=3.57.82
at com.ibm.db2.jcc.am.bd.a(bd.java:676)
at com.ibm.db2.jcc.am.bd.a(bd.java:60)
at com.ibm.db2.jcc.am.bd.a(bd.java:127)
at com.ibm.db2.jcc.am.km.c(km.java:2506)
at com.ibm.db2.jcc.am.km.d(km.java:2483)
at com.ibm.db2.jcc.am.km.b(km.java:1903)
at com.ibm.db2.jcc.t4.db.h(db.java:220)
at com.ibm.db2.jcc.t4.db.b(db.java:46)
at com.ibm.db2.jcc.t4.t.b(t.java:38)
at com.ibm.db2.jcc.t4.sb.g(sb.java:114)
at com.ibm.db2.jcc.am.km.db(km.java:1898)
at com.ibm.db2.jcc.am.km.a(km.java:2899)
at com.ibm.db2.jcc.am.km.e(km.java:985)
at com.ibm.db2.jcc.am.km.execute(km.java:969)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.execute(StatementStatWrapper.java:178)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.execute(StatementErrLogWrapper.java:169)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.StatementLeakWrapper.execute(StatementLeakWrapper.java:70)
at com.ibm.team.datawarehouse.service.AbstractDataWarehouseDbProvider.internalExecuteSql(AbstractDataWarehouseDbProvider.java:212)
... 40 more
2011-11-23 18:45:21,602 CRJAZ1728E C:\Program Files\IBM\JazzTeamServer\server\repotools-jts_createWarehouse.log :( :(

2 answers



permanent link
Mayank Parikh (6) | answered Dec 16 '11, 12:42 a.m.
Hi,

I got the exact same error.

1. The error occurred because the folder \jazzdw did not exist on my drive and hence I created c:\jazzdw

2. Trying the repotools command again, I got the same error. As the exception occurs at the "CREATE TABLESPACE" command, tried executing that command in db2 and got the error that the tablespace by the same name already exists. So dropped that tablespace. Steps:

a. Open the DB2 command line processor window
b. CONNECT TO JTS
c. DROP TABLESPACE TEMPSPACE32K
d. DISCONNECT JTS
e. QUIT

3. Now the datawarehouse creation goes through properly with:
repotools-jts -createWarehouse

Summarizing, the exception occurs because initially the directory is not specified. But, before this exception, DB2 seems to have created this temporary tablespace, though it failed to allocate space to it and hence the exception. Next time around, if the directory is available, it fails as the tablespace with the same name exists.
Repotools defect: Ideally, repotools should check for the existence of the tablespace before creating one, and drop it if it already exists.

Regards,
Mayank Parikh
----------------------------------------------------------
2011-11-23 18:45:16,610 CRJAZ8192I: C:\Program Files\IBM\JazzTeamServer\server\conf\jts\indices\workitemindex\fulltext_index
2011-11-23 18:45:21,602 CREATE TEMPORARY TABLESPACE TEMPSPACE32K IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM USING ('/jazzdw/tempspace32k') BUFFERPOOL BPTEMP32K
com.ibm.team.repository.common.TeamRepositoryException: CREATE TEMPORARY TABLESPACE TEMPSPACE32K IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM USING ('/jazzdw/tempspace32k') BUFFERPOOL BPTEMP32K

permanent link
Francine Li (633) | answered Jan 02 '12, 5:41 a.m.
Hi,

I got the exact same error.

1. The error occurred because the folder \jazzdw did not exist on my drive and hence I created c:\jazzdw

2. Trying the repotools command again, I got the same error. As the exception occurs at the "CREATE TABLESPACE" command, tried executing that command in db2 and got the error that the tablespace by the same name already exists. So dropped that tablespace. Steps:

a. Open the DB2 command line processor window
b. CONNECT TO JTS
c. DROP TABLESPACE TEMPSPACE32K
d. DISCONNECT JTS
e. QUIT

3. Now the datawarehouse creation goes through properly with:
repotools-jts -createWarehouse

Summarizing, the exception occurs because initially the directory is not specified. But, before this exception, DB2 seems to have created this temporary tablespace, though it failed to allocate space to it and hence the exception. Next time around, if the directory is available, it fails as the tablespace with the same name exists.
Repotools defect: Ideally, repotools should check for the existence of the tablespace before creating one, and drop it if it already exists.

Regards,
Mayank Parikh
----------------------------------------------------------
2011-11-23 18:45:16,610 CRJAZ8192I: C:\Program Files\IBM\JazzTeamServer\server\conf\jts\indices\workitemindex\fulltext_index
2011-11-23 18:45:21,602 CREATE TEMPORARY TABLESPACE TEMPSPACE32K IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM USING ('/jazzdw/tempspace32k') BUFFERPOOL BPTEMP32K
com.ibm.team.repository.common.TeamRepositoryException: CREATE TEMPORARY TABLESPACE TEMPSPACE32K IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM USING ('/jazzdw/tempspace32k') BUFFERPOOL BPTEMP32K


Yup~ The problem has been solved finally, exactly as your statement. I can not thank you too much for your kind reply!

BTW, Happy new year! :D

Francine Li

Your answer


Register or to post your answer.