Skip to Content
1
Aug 16, 2021 at 05:06 PM

CAP CDS with Fiori Elements and Hierarchy Data

870 Views Last edit Aug 16, 2021 at 05:14 PM 4 rev

Hello together,
when I try to work with hierarchy data and a Fiori Elements List Report, I will get the following error, when I try initialize the edit.


Frontend:


Backend:

[cds] - GET /hierarchy/$metadata?sap-value-list=none&sap-language=EN
[cds] - HEAD /hierarchy/
[cds] - POST /hierarchy/$batch
[cds] - > READ Hierarchy(ID=0e1dcdd0-2d91-4ad4-872a-9cd51ac8860c,IsActiveEntity=true) { '$expand': 'address' }
[cds] - POST /hierarchy/$batch
[cds] - > EDIT Hierarchy(ID=0e1dcdd0-2d91-4ad4-872a-9cd51ac8860c,IsActiveEntity=true)/hierarchyService.draftEdit 
[cds] - RangeError: Maximum call stack size exceeded
    at new Where (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/cds-services/statements/Where.js:13:1)
    at new Select (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/cds-services/statements/Select.js:20:5)
    at Function.get new [as new] (/home/user/projects/hierarchy/node_modules/@sap/cds/lib/ql/rt/Query.js:8:15)
    at Function.from (/home/user/projects/hierarchy/node_modules/@sap/cds/lib/ql/rt/SELECT.js:20:29)
    at _getSubSelectFromCQN (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/fiori/utils/handler.js:20:17)
    at _generateSubCQNs (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/fiori/utils/handler.js:39:24)
    at _generateSubCQNs (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/fiori/utils/handler.js:47:9)
    at _generateSubCQNs (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/fiori/utils/handler.js:47:9)
    at _generateSubCQNs (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/fiori/utils/handler.js:47:9)
    at _generateSubCQNs (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/fiori/utils/handler.js:47:9) {
  id: '1758731',
  level: 'ERROR',
  timestamp: 1629133058027
}
[INTERNAL ERROR] RangeError: Maximum call stack size exceeded
    at new Where (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/cds-services/statements/Where.js:13:1)
    at new Select (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/cds-services/statements/Select.js:20:5)
    at Function.get new [as new] (/home/user/projects/hierarchy/node_modules/@sap/cds/lib/ql/rt/Query.js:8:15)
    at Function.from (/home/user/projects/hierarchy/node_modules/@sap/cds/lib/ql/rt/SELECT.js:20:29)
    at _getSubSelectFromCQN (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/fiori/utils/handler.js:20:17)
    at _generateSubCQNs (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/fiori/utils/handler.js:39:24)
    at _generateSubCQNs (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/fiori/utils/handler.js:47:9)
    at _generateSubCQNs (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/fiori/utils/handler.js:47:9)
    at _generateSubCQNs (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/fiori/utils/handler.js:47:9)
    at _generateSubCQNs (/home/user/projects/hierarchy/node_modules/@sap/cds/libx/_runtime/fiori/utils/handler.js:47:9)


I use the follwing structures:

schema.cds
using {
    cuid,
    managed
} from '@sap/cds/common';

namespace hierarchy.db;

entity Hierarchy : cuid, managed {
    hierarchyName        : String;
    hierarchyDescription : String;
    costCentre           : String @assert.format : '[0-9]+';
    isActive             : Boolean default false;
    parent               : Association to Hierarchy;
    children             : Composition of many Hierarchy
                               on children.parent = $self;
}

service.cds

using {hierarchy.db as db} from '../db/schema';

service hierarchyService {
    // Hierarchy
    @odata.draft.enabled
    @Capabilities : {Deletable : false}
    entity Hierarchy                  as projection on db.Hierarchy
}

Just for clarity I use a ODataV2 Fiori Elements App.

CDS Version

I found this question but in contrast to the answer - the bug is not fixed.
https://answers.sap.com/questions/13050078/fiori-elements-problem-with-cap-hierarchical-entit.html

And the CAP CDS docu does not contain this much information about hierarchy.

Maybe David Kunz can help me again, like he did so many times before.

With friendly regards
Johannes Lussert