Jun 14, 2019 at 10:10 AM

Upgrade Marketing 1809 (OnPrem) - Error Calculation Views

370 Views

Hi Experts,

we are updating from 1702 to 1809. In the system we have Calculation Views which have the following error on activation:

A2EESCTS_HOT 546X "CA_CRM_TRANSACTIONS_TG_NONE.calculationview (sap.hana-app.cuan.common.crm.internal) activation failed [CEC-MKT-BF]"
A2EESCTS_HOT 532 "Repository: Encountered an error in repository runtime extension;Model inconsistency. Create Scenario failed:"
A2EESCTS_HOT 532 "Datatype int of CNT_ACT does not match to datatype fixed18.0 of attribute CNT_ACT in node AGGR_AN_CRM_ACT_TG_NONE(calculatio"
A2EESCTS_HOT 532 " nNode (Union_1)) "
A2EESCTS_HOT 532 "The following errors occurred: Inconsistent calculation model (34011) "
A2EESCTS_HOT 532 "Details (Errors): "
A2EESCTS_HOT 532 "- calculationNode (Union_1): Datatype int of CNT_ACT does not match to datatype fixed18.0 of attribute CNT_ACT in node AGGR_"
A2EESCTS_HOT 532 " AN_CRM_ACT_TG_NONE. "
A2EESCTS_HOT 532 "- calculationNode (Union_1): Datatype int of CNT_LEAD does not match to datatype fixed18.0 of attribute CNT_LEAD in node AGG"
A2EESCTS_HOT 532 " R_AN_CRM_LEAD_TG_NONE.

Both columns in union_1 have the data type BIGINT, so should have no problem. Now I've removed the relevant views, but according to the SUM log, they are still there:

A2EESCTS_HOT 531 "CA_CRM_TRANSACTIONS_TG_NONE.cal""culationview (sap.hana-app.cuan"".common.crm.internal) [CEC-MKT-""BF]"
A2EESCTS_HOT 531 "CA_CRM_TRANSACTIONS_TG.calculat""ionview (sap.hana-app.cuan.comm""on.crm.internal) [CEC-MKT-BF]"" "
A2EESCTS_HOT 531 "CA_CRM_RELANA_TRANSACTIONS.calc""ulationview (sap.hana-app.cuan.""common.crm.internal) [CEC-MKT-B""F]"

Is something cached during the upgrade? How can we fix the error?

Thx in advance!