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
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