Urgent: Anyone knows about this error code CRJAZ1728E?
Hi All,
I am migrating the database(CLM 3.0.1) from Derby to DB2 and following the instructions published in IBM website.
Got a error when trying to create warehouse tables.
Error:
C:\Program Files\IBM\JazzTeamServer\server>repotools-jts -createWarehouse
Repo Tools
Provisioning using "C:\Program Files\IBM\JazzTeamServer\server\conf\jts\provisio
n_profiles".
Jazz Foundation - Core Libraries, Version 3.0.1 (RJF-I20110602-0017)
CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".
CRJAZ1779I This server is configured as a JTS.
CRJAZ1971I The server is configured with:
Public URI: "https:</xxxx>:9443/jts"
CRJAZ1365I The server is attempting to connect to the following database: "//LW6
27LX2011957:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/NT
Db Product Version: SQL09072
Db URL: jdbc:db2://xxxx:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
CRJAZ8192I: Fulltext Index Location: C:\Program Files\IBM\JazzTeamServer\server\
conf\jts\indices\workitemindex\fulltext_index
CRJAZ1728E An unexpected error has been detected. See the log file "C:\Program F
iles\IBM\JazzTeamServer\server\repotools-jts_createWarehouse.log" for more detai
ls.
C:\Program Files\IBM\JazzTeamServer\server>
Contents of C:\Program F
iles\IBM\JazzTeamServer\server\repotools-jts_createWarehouse.log:
2011-11-23 16:39:29,700 Repo Tools
2011-11-23 16:39:29,700 java.version=1.5.0
2011-11-23 16:39:29,700 java.runtime.version=pwi32devifx-20110209 (SR11 FP2 +IZ94331)
2011-11-23 16:39:29,700 Provisioning using "C:\Program Files\IBM\JazzTeamServer\server\conf\jts\provision_profiles".
2011-11-23 16:39:29,715 repotools-jts -createWarehouse
2011-11-23 16:39:29,715 Jazz Foundation - Core Libraries, Version 3.0.1 (RJF-I20110602-0017)
2011-11-23 16:39:29,731 CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".
2011-11-23 16:39:30,293 CRJAZ1779I This server is configured as a JTS.
2011-11-23 16:39:30,293 CRJAZ1971I The server is configured with:
Public URI: "https://xxxx:9443/jts"
2011-11-23 16:39:31,340 CRJAZ1365I The server is attempting to connect to the following database: "/:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;"
2011-11-23 16:39:32,153 CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/NT
Db Product Version: SQL09072
Db URL: jdbc:db2://xxxx:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
2011-11-23 16:39:32,668 CRJAZ8192I: Fulltext Index Location: C:\Program Files\IBM\JazzTeamServer\server\conf\jts\indices\workitemindex\fulltext_index
2011-11-23 16:39:37,903 CREATE TEMPORARY TABLESPACE TEMPSPACE32K IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM USING ('C:/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 ('C:/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:128)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$4.run(RemoteDatabaseService.java:214)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:204)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.createRemoteSchemas(RemoteDatabaseService.java:119)
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 16:39:37,903 CRJAZ1728E An unexpected error has been detected. See the log file "C:\Program Files\IBM\JazzTeamServer\server\repotools-jts_createWarehouse.log" for more details.
Thanks in advance.
I am struggling for past one week.
Cheers,
Simon
I am migrating the database(CLM 3.0.1) from Derby to DB2 and following the instructions published in IBM website.
Got a error when trying to create warehouse tables.
Error:
C:\Program Files\IBM\JazzTeamServer\server>repotools-jts -createWarehouse
Repo Tools
Provisioning using "C:\Program Files\IBM\JazzTeamServer\server\conf\jts\provisio
n_profiles".
Jazz Foundation - Core Libraries, Version 3.0.1 (RJF-I20110602-0017)
CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".
CRJAZ1779I This server is configured as a JTS.
CRJAZ1971I The server is configured with:
Public URI: "https:</xxxx>:9443/jts"
CRJAZ1365I The server is attempting to connect to the following database: "//LW6
27LX2011957:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/NT
Db Product Version: SQL09072
Db URL: jdbc:db2://xxxx:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
CRJAZ8192I: Fulltext Index Location: C:\Program Files\IBM\JazzTeamServer\server\
conf\jts\indices\workitemindex\fulltext_index
CRJAZ1728E An unexpected error has been detected. See the log file "C:\Program F
iles\IBM\JazzTeamServer\server\repotools-jts_createWarehouse.log" for more detai
ls.
C:\Program Files\IBM\JazzTeamServer\server>
Contents of C:\Program F
iles\IBM\JazzTeamServer\server\repotools-jts_createWarehouse.log:
2011-11-23 16:39:29,700 Repo Tools
2011-11-23 16:39:29,700 java.version=1.5.0
2011-11-23 16:39:29,700 java.runtime.version=pwi32devifx-20110209 (SR11 FP2 +IZ94331)
2011-11-23 16:39:29,700 Provisioning using "C:\Program Files\IBM\JazzTeamServer\server\conf\jts\provision_profiles".
2011-11-23 16:39:29,715 repotools-jts -createWarehouse
2011-11-23 16:39:29,715 Jazz Foundation - Core Libraries, Version 3.0.1 (RJF-I20110602-0017)
2011-11-23 16:39:29,731 CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".
2011-11-23 16:39:30,293 CRJAZ1779I This server is configured as a JTS.
2011-11-23 16:39:30,293 CRJAZ1971I The server is configured with:
Public URI: "https://xxxx:9443/jts"
2011-11-23 16:39:31,340 CRJAZ1365I The server is attempting to connect to the following database: "/:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;"
2011-11-23 16:39:32,153 CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/NT
Db Product Version: SQL09072
Db URL: jdbc:db2://xxxx:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
2011-11-23 16:39:32,668 CRJAZ8192I: Fulltext Index Location: C:\Program Files\IBM\JazzTeamServer\server\conf\jts\indices\workitemindex\fulltext_index
2011-11-23 16:39:37,903 CREATE TEMPORARY TABLESPACE TEMPSPACE32K IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 32768 MANAGED BY SYSTEM USING ('C:/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 ('C:/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:128)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$4.run(RemoteDatabaseService.java:214)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:204)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.createRemoteSchemas(RemoteDatabaseService.java:119)
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 16:39:37,903 CRJAZ1728E An unexpected error has been detected. See the log file "C:\Program Files\IBM\JazzTeamServer\server\repotools-jts_createWarehouse.log" for more details.
Thanks in advance.
I am struggling for past one week.
Cheers,
Simon