CLM 4.0.2 - Error seen in CCM-ETL log
Hello. We have CLM 4.0.2 on a Windows 2008 server and using Oracle 11gR2. We recently upgraded from 4.0.0 and Jazz-RTC-RRC are running fine.
However, we are seeing the following error in the ccm-etl log:
2013-12-05 07:33:18,871 [ccm: AsynchronousTaskRunner-14] ERROR ouse.service.scm.internal.ScmRemoteSnapshotService - Java ETL (Dimension): Error Executing Update Statistics: "com.ibm.team.datawarehouse.service.starjobs.internal.dimensionbuild.TeamDimension"
com.ibm.team.repository.common.TeamRepositoryException: ORA-01031: insufficient privileges
Can someone give us a clue what is causing this error to be thrown? I am not seeing any Diagnostic errors that would point to this. We also checked our Data Collection jobs and they are running with no errors.
We have brought this up to our Oracle DBA but we need to confirm what is impacted and what needs more privilege in order to fix the error?
One answer
I would check the permissions that the Oracle database user that is configured to connect to the data warehouse has.
For reference you can look into this article:
More Control over the Oracle Data Warehouse Setup
https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup
especially the "DBA role required for creating the Data Warehouse" section.
Best Regards,
Francesco Chiossi