Issue redeploying the calculation view

[Former Member]

Hello,

I am trying to redeploy some inactive calculation view, but I am getting below error:

Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Create Scenario failed: nnColumnTable SAP<SID>:FAGLFLEXT not found (cannot get catalog object)(CalculationNode (FAGLFLEXT))nnThe following errors occured: Inconsistent calculation model (34011)nDetails (Errors):n- CalculationNode (FAGLFLEXT): ColumnTable SAP<SID>:FAGLFLEXT not found (cannot get catalog object).nnnn<?xml version="1.0" encoding="UTF-8" standalone="no"?><cubeSchema defaultLanguage="EN" defaultSchema="_SYS_BIC" operation="createCalculationScenario" version="3"><calculationScenario name="sap.hba.ecc/NewGLTotals" schema="_SYS_BIC"><scenarioHints enforceSqlExecution="true"/><dataSources><tableDataSource name="FAGLFLEXT" schema="SAP<SID>" table="FAGLFLEXT"><attributes><allAttribute /></attributes></tableDataSource><calcScenarioDataSource name="LedgerCurrencyInformation" schema="_SYS_BIC" view="sap.hba.ecc/LedgerCurrencyInformation" resolveType="mergeScenarios"><attributes><allAttribute /></attributes></calcScenarioDataSource></dataSources><calculationViews><join name="Join_2" type="inner" cardinality="1:n"><viewAttributes><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="RCLNT" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="RLDNR" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="RBUKRS" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="RYEAR" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="OBJNR00" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="OBJNR01" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="OBJNR02" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="OBJNR03" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="OBJNR04" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="OBJNR05" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="OBJNR06" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="OBJNR07" /><viewAttribute ignoreFromInputsFlag="false" isVisible="true" name="OBJNR08" /><viewAttribute ignoreFromInputsFlag="false"

But this view is present in the schema SAP<SID>. Also I have provided the _SYS_REPO access to the schema and to the user.

Can you please tell solution here.

Regards,

Saurabh

[vivekbhoj]

Hi Saurabh,

The error says table FAGLFLEXT not found.

Does this table exist in your schema?

Regards,

Vivek

[Former Member]

Hi Vivek,

Yes this is actually a table view, which exists in my schema SAP<SID>.

Regards,

Saurabh

[former_member213376]

Hi Saurabh,

     Probably your read or Select access for _SYS_BIC of SAP <SID> schema might be unchecked.

     Also try with executing this statement: " GRANT SELECT ON SCHEMA <schema Name> TO "_SYS_REPO"  with GRANT OPTION"

Regards,

Prasana Ravichandran