It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×7,462

question asked: Nov 23 '11, 11:54 a.m.
question was seen: 9,613 times
last updated: Jun 05 '13, 1:22 p.m.

Related questions

Urgent: Anyone knows about this error code CRJAZ1728E?

0
Joseph Simon Arokiaraj (214●1●48●45) | asked Nov 23 '11, 11:54 a.m.
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

4 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Dong Young Kim (193●19●20) | answered Dec 01 '11, 10:50 p.m.
JAZZ DEVELOPER
Hi,

I'm not DB2 expert but
Caused by:
com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-298, SQLSTATE=428B2, SQLERRMC=null, DRIVER=3.57.82
says that there is an SQL error.

The following commands will give you information and what to do.
$db2 ? sql298
$db2 ? sqlstate 428B2
0
permanent link
Geran Smith (6) | answered Jun 26 '12, 5:05 p.m.
JAZZ DEVELOPER
You need to change the Database Table Space Folder. It is currently set to "C:/jazzdw" you need to have it as "C:\jazzdw"
0
permanent link
Karl Weinert (2.0k●5●27●36) | answered Jun 26 '12, 5:17 p.m.
JAZZ DEVELOPER
error = Bad container path.
So it could also be permissions or that the directory doesn't exist.
0
permanent link
Kevin Conway (43●6●8) | answered Jun 05 '13, 1:22 p.m.
I had the same issue - in my case, the data warehouse was set to use Derby but was passing {password} in the connection string.  When I removed that, it worked fine.

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.