Unable to roll-up from CommandCentral Storage (CCS) data sources after restoring CommandCentral Enterprise Reporter (CCER) from a backup.

Problem

Data roll-ups are failing after restoring CCER and the ER Oracle database instance from a backup.

Error Message

2011/03/25 00:33:39 - Load To Stagging Area (stderr) - DBD::Oracle::db do failed: ORA-20013: failed loading roll-up data set - stereotype: CUSTOM, data set type: CUSTOM_ATTR, error: ORA-00942: table or view does not exist
2011/03/25 00:33:39 - Load To Stagging Area (stderr) - ORA-06512: at "SAHARA.LOAD_IMPL", line 987
2011/03/25 00:33:39 - Load To Stagging Area (stderr) - ORA-06512: at "SAHARA.LOAD_API", line 181
2011/03/25 00:33:39 - Load To Stagging Area (stderr) - ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN SAHARA.LOAD_API.PerformLoad(); END;"] at E:\vendor_apps\VRTSccer\bin\import_to_staging.pl line 158.
2011/03/25 00:33:39 - Load To Stagging Area (stderr) - DBD::Oracle::db do failed: ORA-20013: failed loading roll-up data set - stereotype: CUSTOM, data set type: CUSTOM_ATTR, error: ORA-00942: table or view does not exist
2011/03/25 00:33:39 - Load To Stagging Area (stderr) - ORA-06512: at "SAHARA.LOAD_IMPL", line 987
2011/03/25 00:33:39 - Load To Stagging Area (stderr) - ORA-06512: at "SAHARA.LOAD_API", line 181
2011/03/25 00:33:39 - Load To Stagging Area (stderr) - ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN SAHARA.LOAD_API.PerformLoad(); END;"] at E:\vendor_apps\VRTSccer\bin\import_to_staging.pl line 158.
 

Cause

The CCER sahara* users do not have the correct privileges to access the tables in the ER Oracle database instance.

Solution

The Oracle DBA has to grant the sahara* users the appropriate privileges to access the tables in the ER Oracle database instance.


Applies To

CCER running on Windows 2003 server.

Oracle database server is running on Solaris server.

CCER and ER Oracle database instance were restored from a backup after a failed upgrade from version 5.1 to 5.2.

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)