3009503 - Activation of HCPR failing with error message "Attribute __numoffacttablerows is missing in node"

You might have performed an upgrade to BW4 and when trying to activate a HCPR the following error messages are displayed :

EC:2048"column store error: fail to create scenario: [34011] Inconsistent calculation model;calculationNode (BASE) -> attributes
attribute (XXXXXXX) -> expression: Expression is not valid: Evaluator: type error in expression
evaluator;string([here]to_snumc("XXXXXXX", 000011)),Details (Errors): - calculationNode (BASE) -> attributes -> attribute
expression: Expression is not valid: Evaluator: type error in expression evaluator;string([here]to_snumc("XXXXXXX$CALC",
000011)).  Details (Warnings): - scenario -> cubeSchema -> calculationScenario (XXXXXXXXXXXXXXXXXX) ->
scenarioHints -> parameter: The doRegisterDependencies parameter has been removed and will be ignored.  "
Creation of column view for HCPR_TECH_NAME failed

calculationNode (XX): Attribute __numoffacttablerows is missing in node XXXXXXXXX.

SAP Business Warehouse - All versions
SAP NetWeaver - All versions

bw, business, warehouse, hana, composite, provider, composite provider, column, store, numffacttablerow, 1rowcount, rowcount, row count, , KBA , BW4-DM-HCPR , Composite Provider , HAN-DB-ENG-BW , SAP HANA BW Engine , BW-BEX-OT-HCPR , CompositeProvider Query , Problem