Database exception when running jazz/setup from WAS (beta 2)
Steps
1. created a db2 database with paging 8 K 2. ran repoTools.bat -createTables with success 3. Create JAZZ_HOME variable on WAS 4. Security is enabled and working, Made sure Security > Web Security > General > Make authentication... Unprotected URI is checked. 4. Deploy jazz war 5. Created a data source on WAS to point to the database 6. Made sure teamserver.properties has the following com.ibm.team.repository.db.type=J2EE com.ibm.team.repository.db.j2ee.dataSource=jdbc/RTC_Con com.ibm.team.repository.ws.allow.admin.access=false com.ibm.team.repository.user.registry.type=UNSUPPORTED com.ibm.team.repository.server.repourl.port.http=9085 com.ibm.team.repository.server.repourl.port.https=9448 7. Restart WAS 8. Go to localhost:9448/jazz/setup 9. Get empty page 10. Exception in jazz.log (see below) I opened the table REPOSITORY.CONTRIBUTOR in db2 It does not have a column called NAME Caused by: com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0447I SQL statement execution failed.Syntax error or access rule violation SQL: INSERT INTO REPOSITORY.CONTRIBUTOR (STATE_ID, ITEM_ID, CONTEXT_ID, MODIFIED, MODIFIED_BY_ITEM_ID, EMAIL_ADDRESS, USER_ID, NAME, DETAILS_ITEM_ID, ARCHIVED) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SQL Exception #1 SQL Message: "NAME" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.50.152 SQL State: 42703 Error Code: -206 SQL Exception #2 SQL Message: An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-206", SQLSTATE "42703" and message tokens "NAME".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.50.152 SQL State: 56098 Error Code: -727 Exception Details: Vendor specific exception SQL Exception #3 SQL Message: An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-206", SQLSTATE "42703" and message tokens "NAME".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.50.152 SQL State: 56098 Error Code: -727 Exception Details: Vendor specific exception Class: com.ibm.team.repository.service.internal.dataaccess.write2.Row Item Handle: com.ibm.team.repository.common.model.impl.ContributorImpl@21022102 (stateId: , itemId: , origin: <unset>, immutable: true) (contextId: , modified: 2009-05-27 13:39:36.437, workingCopy: <unset>) (mergePredecessor: null, workingCopyPredecessor: <unset>, workingCopyMergePredecessor: <unset>, predecessor: null) (emailAddress: unassigned, userId: unassigned, name: Unassigned, archived: false) at com.ibm.team.repository.service.internal.dataaccess.BatchingRowReceiver.createIRE(BatchingRowReceiver.java:417) at com.ibm.team.repository.service.internal.dataaccess.BatchingRowReceiver.createIRE(BatchingRowReceiver.java:426) at com.ibm.team.repository.service.internal.dataaccess.write2.Row.handleExecuteException(Row.java:96) at com.ibm.team.repository.service.internal.dataaccess.BatchingRowReceiver.simulatedBatch(BatchingRowReceiver.java:396) at com.ibm.team.repository.service.internal.dataaccess.BatchingRowReceiver.executeBatch(BatchingRowReceiver.java:269) at com.ibm.team.repository.service.internal.dataaccess.BatchingRowReceiver.execute(BatchingRowReceiver.java:196) at com.ibm.team.repository.service.internal.dataaccess.IRowReceiver$IRowReceiverLocator.executePendingChanges(IRowReceiver.java:140) at com.ibm.team.repository.service.internal.dataaccess.FlushingMediatorService.flush(FlushingMediatorService.java:60) at com.ibm.team.repository.service.internal.dataaccess.FlushingMediatorService.saveNew(FlushingMediatorService.java:73) at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.createAuditable(RdbRepositoryDataMediator.java:704) at com.ibm.team.repository.service.internal.RepositoryItemService.doSaveAuditable(RepositoryItemService.java:1441) at com.ibm.team.repository.service.internal.RepositoryItemService.doSaveItem(RepositoryItemService.java:1401) at com.ibm.team.repository.service.internal.RepositoryItemService.access$13(RepositoryItemService.java:1379) at com.ibm.team.repository.service.internal.RepositoryItemService$21.run(RepositoryItemService.java:1373) at com.ibm.team.repository.service.internal.RepositoryItemService$21.run(RepositoryItemService.java:1) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:320) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:244) at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:74) 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:378) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy36.runInTransaction(Unknown Source) at com.ibm.team.repository.service.internal.RepositoryItemService.saveItem(RepositoryItemService.java:1370) at com.ibm.team.repository.service.internal.RepositoryInitalizerContext2.addNewAuditable(RepositoryInitalizerContext2.java:59) at com.ibm.team.workitem.service.internal.model.database.WorkItemRepositoryInitializer.createNullContributor(WorkItemRepositoryInitializer.java:38) at com.ibm.team.workitem.service.internal.model.database.WorkItemRepositoryInitializer.initializeNewRepository(WorkItemRepositoryInitializer.java:26) at com.ibm.team.repository.service.internal.RepositoryItemService$4.run(RepositoryItemService.java:515) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:466) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:292) at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:328) at sun.reflect.GeneratedMethodAccessor60.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:378) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy7.withCurrentConnection(Unknown Source) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:288) at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:244) at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:74) 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:378) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364) at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56) at $Proxy36.runInTransaction(Unknown Source) at com.ibm.team.repository.service.internal.RepositoryItemService.invokeInitializer(RepositoryItemService.java:512) at com.ibm.team.repository.service.internal.RepositoryItemService.invokeInitializers(RepositoryItemService.java:497) ... 96 more Caused by: com.ibm.db2.jcc.b.nm: "NAME" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.50.152 at com.ibm.db2.jcc.b.wc.a(wc.java:579) at com.ibm.db2.jcc.b.wc.a(wc.java:57) at com.ibm.db2.jcc.b.wc.a(wc.java:126) at com.ibm.db2.jcc.b.tk.c(tk.java:1901) at com.ibm.db2.jcc.b.tk.d(tk.java:1889) at com.ibm.db2.jcc.b.tk.a(tk.java:1416) at com.ibm.db2.jcc.t4.db.g(db.java:138) at com.ibm.db2.jcc.t4.db.a(db.java:38) at com.ibm.db2.jcc.t4.t.a(t.java:32) at com.ibm.db2.jcc.t4.sb.h(sb.java:141) at com.ibm.db2.jcc.b.tk.N(tk.java:1387) at com.ibm.db2.jcc.b.uk.Kb(uk.java:2461) at com.ibm.db2.jcc.b.uk.e(uk.java:3101) at com.ibm.db2.jcc.b.uk.zb(uk.java:568) at com.ibm.db2.jcc.b.uk.executeUpdate(uk.java:551) at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:748) at com.ibm.team.repository.service.internal.dataaccess.BatchingRowReceiver.simulatedBatch(BatchingRowReceiver.java:388) ... 146 more |
One answer
This problem was reported and is being discussed in
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/84545 - Matt Lavin Jazz Server Team On Wed, 2009-05-27 at 17:52 +0000, ramanday wrote: > com.ibm.team.repository.db.type=J2EE |
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.