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

Article:TECH156913  |  Created: 2011-03-30  |  Updated: 2011-11-14  |  Article URL http://www.symantec.com/docs/TECH156913
Article Type
Technical Solution


Environment

Issue



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


Error



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.
 


Environment



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.


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.




Article URL http://www.symantec.com/docs/TECH156913


Terms of use for this information are found in Legal Notices