When doing save and activate of analytical view i am getting below error

[Former Member]

When doing save and activate of analytical view i am getting below error

Message :

Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Create Scenario: failed aCalcEngine.createScenario(): The following errors occured: Could not create repository entry for scenario (34053)nnprinting XML <?xml version="1.0" encoding="utf-8"?><cubeSchema version="3" operation="createCalculationScenario"><calculationScenario name="mypackage/ANAT" schema="_SYS_BIC"><dataSources><olapDataSource name="dataSource" schema="_SYS_BIC" view="mypackage/ANAT/olap"><attributes><allAttribute/></attributes></olapDataSource></dataSources><calculationViews><aggregation name="finalAggregation" defaultViewFlag="true"><inputs><input name="dataSource"/></inputs><viewAttributes><allViewAttribute/><viewAttribute name="SALE_PRICE"><attributeHints pushDownCountOnAttributeFlag="true"/></viewAttribute><viewAttribute name="CATEGORY"><attributeHints pushDownCountOnAttributeFlag="true"/></viewAttribute><viewAttribute name="ARTICLE_LABEL"><attributeHints pushDownCountOnAttributeFlag="true"/></viewAttribute><calculatedViewAttribute name="express" datatype="fixed" length="12"><formula>"SALE_PRICE" * 10rn</formula></calculatedViewAttribute></viewAttributes><keyfigures><keyfigure name="ARTICLE_ID" aggregationType="sum"/><keyfigure name="AMOUNT_SOLD" aggregationType="sum"/><keyfigure name="QUANTITY_SOLD" aggregationType="sum"/><keyfigure name="SHOP_ID" aggregationType="sum"/><keyfigure name="row.count" aggregationType="count" datatype="fixed" length="18"/></keyfigures><unitConversionInfos/><calculationNodeHints countStarAttribute="row.count"/></aggregation></calculationViews></calculationScenario></cubeSchema>nVersion: 42n

[Former Member]

Madhu,

There could be a missing privilege for the content owner user (_SYS_REPO) or activation user for one or more schemas referred in the Analytic Object.

1) Make sure _SYS_REPO has privilege SELECT WITH GRANT OPTION for the schemas used.

GRANT SELECT ON SCHEMA <YOUR_SCHEMA> TO _SYS_REPO WITH GRANT OPTION;

2) Make sure the user activating the Object has at least SELECT privilege over the schemas used within the scenario. SQL statement to grant this privilege would be

GRANT SELECT ON SCHEMA <YOUR_SCHEMA> TO <USER_THAT_WILL_ACTIVATE_ANALYTIC_OBJECT>;

Hope this will solve your issue.. else

[former_member184768]

Hi Madhu,

The error says 'Could not create repository entry for scenario'. Did you check the privilege for _SYS_REPO on the schema etc. Please refer to multiple threads on this topic. A quick search on SYS_REPO privilege should point you the required steps.

Secondly, did you try the SAVE and VALIDATE Analytic view before SAVE and ACTIVATE. Did the validation process throw any error.

One more point to check, please ensure that all the included objects (Attribute views, Underlying tables etc) are in active status.

Regards,

Ravi

[Former Member]

Thanks Ravindra