Migration from derby to db2 and 1.0.0 -> 1.0.1 at the same t
Hi,
I plan to migrate from derby to db2. Since 1.0.1 has been released we've been thinking to migrate from 1.0.0 at the same time - is it possible or shall we migrate step-by-step (db first, server next). We have 1 server license and bunch of client licenses - do we need to upload it again after the migration? Regards, Roman |
7 answers
I don't see anything wrong with moving from 1.0 to 1.0.1 and from Derby
to DB2 at the same time. After moving from 1.0 to 1.0.1 you will need to re-install the server and CAL keys that you have purchased. - Matt Lavin Jazz Server Team On Fri, 2008-11-07 at 12:06 +0100, Roman Smirak wrote: Hi, |
|
Hi,
to make it clear, does it mean I can use 1.0.1 repo tools to migrate from derby 1.0.0 db to DB2? (note that 1.0.0 and 1.0.1 represent jazz release versions) Next question: should workitemindex remain where it is? ie. full text data will be stored there regardless db instance used? Next I got this error after migrating to DB2 - what's up? 11:50:56,471 INFO uration.OverridablePropertyFileServerConfiguration - Loading configuration from "file:///C:\workbench\rtc1.0\server/teamserver.properties". 11:51:02,350 INFO m.team.fulltext.service.internal.index.IndexConfig - Fulltext Index Location: workitemindex\fulltext_index\ 11:51:04,884 INFO ..repository.service.internal.rdb.ConnectionFactory - Initial database connection successful Db Product Name: DB2/NT Db Product Version: SQL09050 Db Name/Location: //localhost:50000/JAZZ:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx; 11:51:12,034 WARN - CRJAZ0956I The server license will expire on Sun Aug 31 06:05:45 CEST 2008. 11:51:16,640 WARN com.ibm.team.repository.servlet.TeamServerServlet - CRJAZ1181I Security notice during initialization: Allowing ADMIN user access. It is recommended that you disable the ADMIN user and create a real user with administrative rights. 12:01:14,400 WARN - CRRTC0240E: E-mail notification is disabled, see the Server Setup Guide for details on enabling it. 00:00:00,577 WARN - CRJAZ0250I A violation of the constraint imposed by a unique index or a unique constraint occurred. SQL: INSERT INTO COMMON_SNAPSHOT.TABLE_TBL (FACT_ID, SNAPSHOT_ID, TABLE_NAME, TOTAL_SIZE, ROW_COUNT) VALUES (?, ?, ?, ?, ?) SQL Exception #1 SQL Message: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;COMMON_SNAPSHOT.TABLE_TBL SQL State: 23505 Error Code: -803 com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;COMMON_SNAPSHOT.TABLE_TBL at com.ibm.db2.jcc.c.kh.b(kh.java:1367) at com.ibm.db2.jcc.c.kh.c(kh.java:1354) at com.ibm.db2.jcc.b.db.k(db.java:352) at com.ibm.db2.jcc.b.db.a(db.java:60) at com.ibm.db2.jcc.b.t.a(t.java:52) at com.ibm.db2.jcc.b.tb.b(tb.java:202) at com.ibm.db2.jcc.c.lh.X(lh.java:1842) at com.ibm.db2.jcc.c.lh.d(lh.java:2411) at com.ibm.db2.jcc.c.lh.U(lh.java:1401) at com.ibm.db2.jcc.c.lh.execute(lh.java:1385) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:51) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:65) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:50) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.storeTableRecord(AbstractSnapshotService.java:725) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.access$1(AbstractSnapshotService.java:658) at com.ibm.team.datawarehouse.service.AbstractSnapshotService$2.run(AbstractSnapshotService.java:364) at com.ibm.team.datawarehouse.service.internal.DataWarehouseAdminService$6.run(DataWarehouseAdminService.java:435) 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.runInTransaction(RepositoryDatabase.java:241) at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:74) at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source) 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: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 $Proxy31.runInTransaction(Unknown Source) at com.ibm.team.datawarehouse.service.internal.DataWarehouseAdminService.write(DataWarehouseAdminService.java:432) at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source) 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: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 $Proxy143.write(Unknown Source) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.write(AbstractSnapshotService.java:260) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.storeTableRecord(AbstractSnapshotService.java:361) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateStatistics(AbstractSnapshotService.java:1167) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateStatistics(AbstractSnapshotService.java:1151) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateData(AbstractSnapshotService.java:117) 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: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 $Proxy152.updateData(Unknown Source) at com.ibm.team.datawarehouse.service.internal.common.CommonSnapshotTask.run(CommonSnapshotTask.java:29) at com.ibm.team.datawarehouse.service.AbstractScheduledTask.runTask(AbstractScheduledTask.java:66) at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.executeTask(AbstractAutoScheduledTask.java:88) at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) 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: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 $Proxy153.executeTask(Unknown Source) at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.runTask(AsynchronousTaskRunner.java:118) at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run(AsynchronousTaskRunner.java:92) at java.lang.Thread.run(Thread.java:810) 00:00:01,278 ERROR e - Error inserting in table TABLE com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;COMMON_SNAPSHOT.TABLE_TBL at com.ibm.db2.jcc.c.kh.b(kh.java:1367) at com.ibm.db2.jcc.c.kh.c(kh.java:1354) at com.ibm.db2.jcc.b.db.k(db.java:352) at com.ibm.db2.jcc.b.db.a(db.java:60) at com.ibm.db2.jcc.b.t.a(t.java:52) at com.ibm.db2.jcc.b.tb.b(tb.java:202) at com.ibm.db2.jcc.c.lh.X(lh.java:1842) at com.ibm.db2.jcc.c.lh.d(lh.java:2411) at com.ibm.db2.jcc.c.lh.U(lh.java:1401) at com.ibm.db2.jcc.c.lh.execute(lh.java:1385) at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:51) at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:65) at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:50) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.storeTableRecord(AbstractSnapshotService.java:725) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.access$1(AbstractSnapshotService.java:658) at com.ibm.team.datawarehouse.service.AbstractSnapshotService$2.run(AbstractSnapshotService.java:364) at com.ibm.team.datawarehouse.service.internal.DataWarehouseAdminService$6.run(DataWarehouseAdminService.java:435) 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.runInTransaction(RepositoryDatabase.java:241) at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:74) at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source) 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: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 $Proxy31.runInTransaction(Unknown Source) at com.ibm.team.datawarehouse.service.internal.DataWarehouseAdminService.write(DataWarehouseAdminService.java:432) at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source) 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: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 $Proxy143.write(Unknown Source) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.write(AbstractSnapshotService.java:260) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.storeTableRecord(AbstractSnapshotService.java:361) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateStatistics(AbstractSnapshotService.java:1167) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateStatistics(AbstractSnapshotService.java:1151) at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateData(AbstractSnapshotService.java:117) 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: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 $Proxy152.updateData(Unknown Source) at com.ibm.team.datawarehouse.service.internal.common.CommonSnapshotTask.run(CommonSnapshotTask.java:29) at com.ibm.team.datawarehouse.service.AbstractScheduledTask.runTask(AbstractScheduledTask.java:66) at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.executeTask(AbstractAutoScheduledTask.java:88) at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) 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: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 $Proxy153.executeTask(Unknown Source) at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.runTask(AsynchronousTaskRunner.java:118) at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run(AsynchronousTaskRunner.java:92) at java.lang.Thread.run(Thread.java:810) "Matt Lavin" <matt_lavin> wrote in message news:1226064014.25945.13.camel@mdlavin-t60p... I don't see anything wrong with moving from 1.0 to 1.0.1 and from Derby |
The correct approach is to use 1.0.0 repotools to export and 1.0.1 repotools to do the import.
The workitem index location is specified by index location property in teamserver.properties. When you perform the import on to DB2, the indices are recreated in the directory specified by index location. Please try with 1.0 and 1.0.1 repotools to perform the migration and restart the server. If you still see the error, please open a work item. --- Balaji Jazz Server Team Hi, |
|
Hi,
but your documentation https://jazz.net/downloads/rational-team-concert/releases/1.0.1?p=upgrading says "You can re-use your 1.0 database; there is no database migration required." Roman "balajik" <balajik> wrote in message news:gf9e2g$7qr$1@localhost.localdomain... The correct approach is to use 1.0.0 repotools to export and 1.0.1 |
|
Yes, you should be able to use 1.0.1 for export and import because the database table schemas have not changed. I wanted to find out what happens when you use the 1.0 repotools for export and 1.0.1 for import ?
Please open a work item if you still see the problem. I will forward this post to the datawarehouse team to review the exception and provide guidance. --- Balaji Jazz Server Team Hi, The correct approach is to use 1.0.0 repotools to export and 1.0.1 |
Regarding the data warehouse import error. Were you using the 1.0.1 repo tools to do the import?
|
|
No, Rafik, 1.0.0. I first migrated to Db2, run 1.0.0 connected to DB2 and
them run 1.0.1 instance connected to the same Db2 (1.0.0 down, at the time, of course) Roman "rjaouani" <rjaouani> wrote in message news:gfci8l$j6u$1@localhost.localdomain... Regarding the data warehouse import error. Were you using the 1.0.1 |
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.