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 |
Problem
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
Thank you.