ldap sync error message

James Yannotta

(11●2●1) 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&#40;LDAPNightlySyncService.java&#58;146&#41;

ERROR - ORA-00942&#58; table or view does not exist

Wednesday, October 13, 2010 12&#58;14 AM

ORA-00942&#58; table or view does not exist



Throwable



com.ibm.team.repository.common.TeamRepositoryException&#58; ORA-00942&#58; table or view does not exist

	at com.ibm.team.datawarehouse.service.AbstractSnapshotService$5.run&#40;AbstractSnapshotService.java&#58;643&#41;

	at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$5.run&#40;InternalDataWarehouseService.java&#58;509&#41;

	at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run&#40;RepositoryDatabase.java&#58;466&#41;

	at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run&#40;RepositoryDatabase.java&#58;292&#41;

	at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection&#40;ConnectionPoolService.java&#58;331&#41;

	at sun.reflect.GeneratedMethodAccessor48.invoke&#40;Unknown Source&#41;

	at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;37&#41;

	at java.lang.reflect.Method.invoke&#40;Method.java&#58;600&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke&#40;ExportProxyServiceRecord.java&#58;370&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0&#40;ExportProxyServiceRecord.java&#58;356&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke&#40;ExportProxyServiceRecord.java&#58;56&#41;

	at $Proxy25.withCurrentConnection&#40;Unknown Source&#41;

	at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction&#40;RepositoryDatabase.java&#58;288&#41;

	at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInReadUncommittedTransaction&#40;RepositoryDatabase.java&#58;255&#41;

	at com.ibm.team.repository.service.internal.TransactionService.runReadUncommittedTransaction&#40;TransactionService.java&#58;84&#41;

	at sun.reflect.GeneratedMethodAccessor97.invoke&#40;Unknown Source&#41;

	at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;37&#41;

	at java.lang.reflect.Method.invoke&#40;Method.java&#58;600&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke&#40;ExportProxyServiceRecord.java&#58;370&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0&#40;ExportProxyServiceRecord.java&#58;356&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke&#40;ExportProxyServiceRecord.java&#58;56&#41;

	at $Proxy68.runReadUncommittedTransaction&#40;Unknown Source&#41;

	at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService.read&#40;InternalDataWarehouseService.java&#58;504&#41;

	at sun.reflect.GeneratedMethodAccessor229.invoke&#40;Unknown Source&#41;

	at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;37&#41;

	at java.lang.reflect.Method.invoke&#40;Method.java&#58;600&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke&#40;ExportProxyServiceRecord.java&#58;370&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0&#40;ExportProxyServiceRecord.java&#58;356&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke&#40;ExportProxyServiceRecord.java&#58;56&#41;

	at $Proxy115.read&#40;Unknown Source&#41;

	at com.ibm.team.datawarehouse.service.AbstractSnapshotService.read&#40;AbstractSnapshotService.java&#58;300&#41;

	at com.ibm.team.datawarehouse.service.AbstractSnapshotService.getLastSnapshotTime&#40;AbstractSnapshotService.java&#58;615&#41;

	at com.ibm.team.datawarehouse.service.apt.internal.AptSnapshotService.populateContributorAssignmentTable&#40;AptSnapshotService.java&#58;100&#41;

	at com.ibm.team.datawarehouse.service.apt.internal.AptSnapshotService.updateSnapshot&#40;AptSnapshotService.java&#58;74&#41;

	at com.ibm.team.datawarehouse.service.AbstractSnapshotService.updateData&#40;AbstractSnapshotService.java&#58;130&#41;

	at sun.reflect.NativeMethodAccessorImpl.invoke0&#40;Native Method&#41;

	at sun.reflect.NativeMethodAccessorImpl.invoke&#40;NativeMethodAccessorImpl.java&#58;48&#41;

	at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;37&#41;

	at java.lang.reflect.Method.invoke&#40;Method.java&#58;600&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke&#40;ExportProxyServiceRecord.java&#58;370&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0&#40;ExportProxyServiceRecord.java&#58;356&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke&#40;ExportProxyServiceRecord.java&#58;56&#41;

	at $Proxy269.updateData&#40;Unknown Source&#41;

	at com.ibm.team.datawarehouse.service.AbstractSnapshotTask.run&#40;AbstractSnapshotTask.java&#58;79&#41;

	at com.ibm.team.datawarehouse.service.AbstractExclusiveTask.runTask&#40;AbstractExclusiveTask.java&#58;38&#41;

	at com.ibm.team.repository.service.async.AbstractAutoScheduledTask.executeTask&#40;AbstractAutoScheduledTask.java&#58;88&#41;

	at sun.reflect.GeneratedMethodAccessor113.invoke&#40;Unknown Source&#41;

	at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;37&#41;

	at java.lang.reflect.Method.invoke&#40;Method.java&#58;600&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke&#40;ExportProxyServiceRecord.java&#58;370&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0&#40;ExportProxyServiceRecord.java&#58;356&#41;

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke&#40;ExportProxyServiceRecord.java&#58;56&#41;

	at $Proxy270.executeTask&#40;Unknown Source&#41;

	at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.runTask&#40;AsynchronousTaskRunner.java&#58;118&#41;

	at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run&#40;AsynchronousTaskRunner.java&#58;92&#41;

	at java.lang.Thread.run&#40;Thread.java&#58;736&#41;

Caused by&#58; 

java.sql.SQLException&#58; ORA-00942&#58; table or view does not exist

	at oracle.jdbc.driver.DatabaseError.throwSqlException&#40;DatabaseError.java&#58;112&#41;

	at oracle.jdbc.driver.T4CTTIoer.processError&#40;T4CTTIoer.java&#58;331&#41;

	at oracle.jdbc.driver.T4CTTIoer.processError&#40;T4CTTIoer.java&#58;288&#41;

	at oracle.jdbc.driver.T4C8Oall.receive&#40;T4C8Oall.java&#58;745&#41;

	at oracle.jdbc.driver.T4CStatement.doOall8&#40;T4CStatement.java&#58;207&#41;

	at oracle.jdbc.driver.T4CStatement.executeForDescribe&#40;T4CStatement.java&#58;801&#41;

	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe&#40;OracleStatement.java&#58;1039&#41;

	at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe&#40;T4CStatement.java&#58;841&#41;

	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout&#40;OracleStatement.java&#58;1134&#41;

	at oracle.jdbc.driver.OracleStatement.executeQuery&#40;OracleStatement.java&#58;1274&#41;

	at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.executeQuery&#40;StatementStatWrapper.java&#58;199&#41;

	at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.executeQuery&#40;StatementErrLogWrapper.java&#58;191&#41;

	at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.StatementLeakWrapper.executeQuery&#40;StatementLeakWrapper.java&#58;78&#41;

	at com.ibm.team.datawarehouse.service.AbstractSnapshotService$5.run&#40;AbstractSnapshotService.java&#58;623&#41;

	... 55 more

0 votes

2 answers

8,094 views

0 votes

2 answers

Permanent link

James Yannotta

(11●2●1) 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 votes

Permanent link

James Yannotta

(11●2●1) 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

0 votes

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.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

rational-team-concert

× 43,075

Question asked: Oct 13 '10, 2:11 p.m.

Question was seen: 8,094 times

Last updated: Oct 13 '10, 2:11 p.m.

ldap sync error message

James Yannotta

2 answers

8,094 views

0 votes

2 answers

James Yannotta

James Yannotta

Your answer

Follow this question

Question details

Related questions