Job BI_PROCESS_ODSACTIVAT terminated

[Former Member]

Hi!

I am trying to activate a process chain within SAP Solution Manager.

The error I get within this job "BI_PROCESS_ODSACTIVAT":

UNCAUGHT_EXCEPTION

CX_SDB_ORA_PROGRAM_ERROR

The reason for this error:

ORA-20000: Insufficient privileges#ORA-06512: at "SYS.DBMS_STATS", line

2150#ORA-06512: at "SYS.DBMS_STATS", line 14112#ORA-06512: at line 1

Question:

What can be done to solve this error?

Thank you!

[Former Member]

Holger,

ORA-20000: Insufficient privileges#ORA-06512: at "SYS.DBMS_STATS", line
2150#ORA-06512: at "SYS.DBMS_STATS", line 14112#ORA-06512: at line 1

Try by executing catalog.sql. Check below mentioned SAP notes & threads.

948197 Merge fix for DBMS_STATS package on Oracle 9.2.x and 10.2.x

SAP Note 633914 - Error when executing DBMS_STATS

SAP Note 963760 - 'ORA-20000: Insufficient privileges' for creating statistics

SAP Note 1042182 Secondary index is inconsistent for PSA tables

Thanks

Sushil

[former_member204746]

search SAP notes with the following keywords:

ORA-06512 DBMS_STATS

you find find a few possible solutions.

[anindya_bose]

Hi

What is your oracle version? 10G?

Did use the new SAPConn role? It seems to be an issue with database statistics collection job.

Check if any database update stats job is running at the same timeb and you are using new SAPConnect role if you are in Oracle 10G.

Note 963760 might be helpful.

If not, please provide the job log and details dump

Thanks and Regards

Anindya