It's all about the answers!

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

×42,882

question asked: Oct 13 '10, 2:11 p.m.
question was seen: 5,234 times
last updated: Oct 13 '10, 2:11 p.m.

Related questions

ldap sync error message

0
James Yannotta (11●2●1) | asked Oct 13 '10, 2:11 p.m.
I am using RTC with MSAD and WAS 7. I am getting an oracle error with the ldap sync.
Do I need to do something to add the table or view?

Installed Products
Jazz Foundation - Jazz Team Server 1.0.0.2 iFix 3 (I20100602-1000)
Rational Team Concert 2.0.0.2 iFix 3 (I20100602-1000) 


Location



com.ibm.team.repository.service.internal.userregistry.ldap.LDAPNightlySyncService.synchronizeUsers(LDAPNightlySyncService.java:146)

ERROR - ORA-00942: table or view does not exist

Wednesday, October 13, 2010 12:14 AM

ORA-00942: table or view does not exist



Throwable



com.ibm.team.repository.common.TeamRepositoryException: ORA-00942: table or view does not exist

	at com.ibm.team.datawarehouse.service.AbstractSnapshotService$5.run(AbstractSnapshotService.java:643)

	at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$5.run(InternalDataWarehouseService.java:509)

	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:331)

	at sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

	at java.lang.reflect.Method.invoke(Method.java:600)

	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 $Proxy25.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.runInReadUncommittedTransaction(RepositoryDatabase.java:255)

	at com.ibm.team.repository.service.internal.TransactionService.runReadUncommittedTransaction(TransactionService.java:84)

	at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

	at java.lang.reflect.Method.invoke(Method.java:600)

	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 $Proxy68.runReadUncommittedTransaction(Unknown Source)

	at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService.read(InternalDataWarehouseService.java:504)

	at sun.reflect.GeneratedMethodAccessor229.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

	at java.lang.reflect.Method.invoke(Method.java:600)

	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 $Proxy115.read(Unknown Source)

	at com.ibm.team.datawarehouse.service.AbstractSnapshotService.read(AbstractSnapshotService.java:300)

	at com.ibm.team.datawarehouse.service.AbstractSnapshotService.getLastSnapshotTime(AbstractSnapshotService.java:615)

	at com.ibm.team.datawarehouse.service.apt.internal.AptSnapshotService.populateContributorAssignmentTable(AptSnapshotService.java:100)

	at com.ibm.team.datawarehouse.service.apt.internal.AptSnapshotService.updateSnapshot(AptSnapshotService.java:74)

	at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateData(AbstractSnapshotService.java:130)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

	at java.lang.reflect.Method.invoke(Method.java:600)

	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 $Proxy269.updateData(Unknown Source)

	at com.ibm.team.datawarehouse.service.AbstractSnapshotTask.run(AbstractSnapshotTask.java:79)

	at com.ibm.team.datawarehouse.service.AbstractExclusiveTask.runTask(AbstractExclusiveTask.java:38)

	at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.executeTask(AbstractAutoScheduledTask.java:88)

	at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

	at java.lang.reflect.Method.invoke(Method.java:600)

	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 $Proxy270.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:736)

Caused by: 

java.sql.SQLException: ORA-00942: table or view does not exist

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)

	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:801)

	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)

	at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:841)

	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)

	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1274)

	at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.executeQuery(StatementStatWrapper.java:199)

	at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.executeQuery(StatementErrLogWrapper.java:191)

	at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.StatementLeakWrapper.executeQuery(StatementLeakWrapper.java:78)

	at com.ibm.team.datawarehouse.service.AbstractSnapshotService$5.run(AbstractSnapshotService.java:623)

	... 55 more

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
James Yannotta (11●2●1) | answered Oct 15 '10, 9:25 a.m.
I fixed the oracle error by doing repotools -addtables, but I still am not seeing any new users or updates.
Is there a troubleshooting procedure for this?
0
permanent link
James Yannotta (11●2●1) | answered Oct 15 '10, 5:05 p.m.
I found the problem. The 'Group Member Property' attribute default was set to members (with an s) instead of member (without an s). The sync is working now for users in the JazzUsers group.

But, it is not working for this nested group:

The user "CN=MYUsers,OU=KLM,OU=GHI,OU=DEF,DC=ABC,DC=AD,DC=ACME,DC=com" is invalid
Friday, October 15, 2010 4:49 PM
CRJAZ1328E The user with "MYUsers" user id, "null" name and "null" email address is invalid. This user must have a name.

Is there a way to fix this?
Or is this the workitem for this issue?

https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=88128

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.