It's all about the answers!

Ask a question

CLM 4.0.2 - Error seen in CCM-ETL log

Jaygee Santos (272813) | asked Dec 05 '13, 6:15 p.m.

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

permanent link
Francesco Chiossi (5.7k11119) | answered Dec 06 '13, 3:36 a.m.
Hello Jaygee,

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

especially the "DBA role required for creating the Data Warehouse" section.

Best Regards,

Francesco Chiossi

Your answer

Register or to post your answer.