Getting Following error while activating an Analytic/Calculation View or recompile a Procedure.
- Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;
- Internal Error:Create Scenario: failed aCalcEngine.createScenario(): The following errors occured:
- Index name conflicts with existing index name (2019)nDetails (Warnings):n-cubeSchema:
- Default language not set. Use 'en'.nnnprinting XML <?xml version="1.0" encoding="utf-8"?><cubeSchema version="3"
Calculation Scenario and a view with the same name are generated for example: "_SYS_BIC"."package/VIEW" while activating an Analytic/Calculation View or recompile a Procedure, it might be the reason for this error.
You can delete the generated view manually but if the Calculation Scenario and its runtime object still exist, you will get the error because of the failure of the reactivation of the Analytic/Calculation View/Procedure.
To solve this issue proceed as following:
Please check the Analytic View/Calculation View by the following SQL statement:
SELECT * FROM "_SYS_REPO"."RUNTIME_OBJECTS" where OBJECT_NAME LIKE '%OID%';
(OID is the Analytic/Calculation View's name)
You have to delete the objects in case of one or more entries in the result by the following statement:
delete from "_SYS_REPO"."RUNTIME_OBJECTS" where OBJECT_NAME like '%OID%'
Please check the Procedure by the following SQL statement:
SELECT scenario_name FROM m_ce_calcscenarios, sys.p_objects_ p WHERE scenario_name LIKE '%' || p.oid || '%' AND LOWER(p.name) LIKE LOWER('%PNAME%');
If you will get the entry with the scenario name not as (PNAME is your procedure) please delete this by the following statement:
delete from "_SYS_REPO"."RUNTIME_OBJECTS" where OBJECT_NAME like'%Scenario_Name%';
(Scenario_Name is the entry you got from previous statement)