It's all about the answers!

Ask a question

RTC - errors on etl logs


Angelo Corna (26358383) | asked Jan 22 '13, 10:03 a.m.
I've configured my RTC data warehouse (Oracle RDBMS) using the internal ETL.
All the ETL jobs end without problems but on jts-etl.log and cc-etl.log I've a lot of the following errors

2013-01-15 14:24:24,706 [ ccm: AsynchronousTaskRunner-3] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Records Updated: 0
2013-01-15 14:24:24,706 [ ccm: AsynchronousTaskRunner-3] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Inserting: 0ms
2013-01-15 14:24:24,706 [ ccm: AsynchronousTaskRunner-3] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Updating: 0ms
2013-01-15 14:24:24,706 [ ccm: AsynchronousTaskRunner-3] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Looking Up: 0ms
2013-01-15 14:24:24,706 [ ccm: AsynchronousTaskRunner-3] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Fetching Data: Less than 1ms
2013-01-15 14:24:24,706 [ ccm: AsynchronousTaskRunner-3] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: Time Running: Less than 1ms
2013-01-15 14:24:24,706 [ ccm: AsynchronousTaskRunner-3] DEBUG e.repository.internal.LicenseRemoteSnapshotService  - ETL: ***Finished Build RangeCounter at 1/15/13 2:24 PM. The build was successful***
2013-01-15 14:24:24,706 [ ccm: AsynchronousTaskRunner-3]  INFO e.repository.internal.LicenseRemoteSnapshotService  - ETL: *****Finished Job License at 1/15/13 2:24 PM. The job was successful.*****
2013-01-15 16:39:30,131 [ ccm: AsynchronousTaskRunner-0]  INFO ervice.internal.common.CommonRemoteSnapshotService  - ETL: *****Started Job Common at 1/15/13 4:39 PM*****
2013-01-15 16:39:30,131 [ ccm: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: ***Started Build ProjectArea at 1/15/13 4:39 PM***
2013-01-15 16:39:31,426 [ ccm: AsynchronousTaskRunner-0] ERROR ervice.internal.common.CommonRemoteSnapshotService  - ORA-01031: insufficient privileges

com.ibm.team.repository.common.TeamRepositoryException: ORA-01031: insufficient privileges

at com.ibm.team.datawarehouse.service.oracle.internal.OracleDataWarehouseDbProvider.updateStatistics(OracleDataWarehouseDbProvider.java:175)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy886.updateStatistics(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.updateStatistics(RemoteDatabaseService.java:267)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy110.updateStatistics(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService.updateStatistics(InternalDataWarehouseService.java:1584)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy369.updateStatistics(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.common.etlbuild.ProjectArea.execute(ProjectArea.java:122)
at com.ibm.team.datawarehouse.service.internal.common.CommonRemoteSnapshotService.updateSnapshot(CommonRemoteSnapshotService.java:145)
at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService$1.run(AbstractRemoteSnapshotService.java:200)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService$5.run(RemoteDatabaseService.java:254)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:381)
at com.ibm.team.datawarehouse.service.internal.RemoteDatabaseService.write(RemoteDatabaseService.java:244)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy110.write(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.RemoteDataWarehouseProvider.write(RemoteDataWarehouseProvider.java:29)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy882.write(Unknown Source)
at com.ibm.team.datawarehouse.service.etl.AbstractRemoteSnapshotService.updateData(AbstractRemoteSnapshotService.java:195)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy371.updateData(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService$7.run(InternalDataWarehouseService.java:834)
at com.ibm.team.repository.service.internal.permission.ImpersonationService.runAs(ImpersonationService.java:75)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy368.runAs(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService.updateRemoteSnapshotDataFromTask(InternalDataWarehouseService.java:814)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy369.updateRemoteSnapshotDataFromTask(Unknown Source)
at com.ibm.team.datawarehouse.service.internal.SnapshotRunnerTask.transactionSucceeded(SnapshotRunnerTask.java:58)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy377.transactionSucceeded(Unknown Source)
at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.transactionSucceeded(AsynchronousTaskSchedulerService.java:972)
at com.ibm.team.repository.service.internal.AsynchronousTaskSchedulerService$4.executeTask(AsynchronousTaskSchedulerService.java:981)
at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.runTask(AsynchronousTaskRunner.java:153)
at com.ibm.team.repository.service.internal.scheduler.AsynchronousTaskRunner.run(AsynchronousTaskRunner.java:116)
at java.lang.Thread.run(Thread.java:772)
Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.StatementStatWrapper.execute(StatementStatWrapper.java:178)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.execute(StatementErrLogWrapper.java:169)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.StatementLeakWrapper.execute(StatementLeakWrapper.java:70)
at com.ibm.team.datawarehouse.service.oracle.internal.OracleDataWarehouseDbProvider.updateStatistics(OracleDataWarehouseDbProvider.java:170)
... 91 more
2013-01-15 16:39:31,426 [ ccm: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Records Selected: 3
2013-01-15 16:39:31,426 [ ccm: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Records Inserted: 1
2013-01-15 16:39:31,426 [ ccm: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Records Updated: 2
2013-01-15 16:39:31,426 [ ccm: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Time Inserting: Less than 1ms
2013-01-15 16:39:31,426 [ ccm: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Time Updating: Less than 1ms
2013-01-15 16:39:31,426 [ ccm: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Time Looking Up: Less than 1ms
2013-01-15 16:39:31,426 [ ccm: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Time Fetching Data: Less than 1ms
2013-01-15 16:39:31,426 [ ccm: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: Time Running: 1 second 
2013-01-15 16:39:31,426 [ ccm: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: ***Finished Build ProjectArea at 1/15/13 4:39 PM. The build was successful***
2013-01-15 16:39:31,426 [ ccm: AsynchronousTaskRunner-0] DEBUG ervice.internal.common.CommonRemoteSnapshotService  - ETL: ***Started Build TeamArea at 1/15/13 4:39 PM*** 


Two questions:
1 - how can I have details (user, table name) regarding the insufficient privileges error?
2 - the timestamp error is different of ETL scheduling. Why?

Thanks in advance.
Bye. 

Accepted answer


permanent link
Nagesh Srinivas (10848) | answered Sep 05 '13, 10:19 a.m.
edited Sep 05 '13, 10:23 a.m.

This will be a very late response but it resolved the issue for me. :)

This happens when DWETLUSER will not be having permissions on all the tables & views of 'RIODS','RIDW','CONFIG','RIASSET','RISCHK','RICALM'

With DBA previleges... execute below Sqls...

Angelo Corna selected this answer as the correct answer

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.