无法更新关联字段：CDS一对多关联修改报错及解决方案咨询

问题场景 #

现有两个CDS实体定义如下：

CDS实体1：PackagingIssues #

entity PackagingIssues : cuid, managed {
    PackagingIssueId  :  String;
    issueDes          :  String(80);
    postingDocument   :  Association to PostingDocuments;
}

CDS实体2：PostingDocuments #

entity PostingDocuments : cuid,managed {
    PostingDocumentName  :  String;
    packagingIssue      : Association to many PackagingIssues on 
        packagingIssue.postingDocument = $self;
}

在修改一对多关联字段packagingIssue时，遇到三类报错：

1. 添加新PackagingIssue并执行Update时报错：

2023-09-14 17:36:32.155 INFO 24764 --- [nio-8080-exec-9] c.s.c.a.o.v4.processors.CdsProcessor : Exception marked the ChangeSet 10 as cancelled: Invalid CQN: UPSERT entity 'com.sap.di.irp.packagingIssue.PackagingIssues' via association 'com.sap.di.irp.postingDocument.PostingDocuments.packagingIssue' is not allowed. The association does not cascade insert or update. (service 'PersistenceService$Default', event 'UPDATE', entity 'com.sap.di.irp.postingDocument.PostingDocuments')

2. 移除已有对象并执行Update时报错：

2023-09-13 17:57:09.198 INFO 23132 --- [io-8080-exec-10] c.s.c.a.o.v4.processors.CdsProcessor : Exception marked the ChangeSet 44 as cancelled: Invalid CQN: UPDATE entity 'com.sap.di.irp.packagingIssue.PackagingIssues' via association 'com.sap.di.irp.postingDocument.PostingDocuments.packagingIssue' is not allowed. The association does not cascade update. (service 'PersistenceService$Default', event 'UPDATE', entity 'com.sap.di.irp.postingDocument.PostingDocuments')

3. 将现有列表置空并执行Update时报错：

Error:
on marked the ChangeSet 2 as cancelled: Invalid CQN: Value for to-many association 'com.sap.di.irp.postingDocument.PostingDocuments.packagingIssue' must not be null. (service 'PersistenceService$Default', event 'UPDATE', entity 'com.sap.di.irp.postingDocument.PostingDocuments')

解决思路与方案 #

1. 配置关联级联规则解决权限报错 #

报错核心是关联未配置级联插入/更新规则，需修改CDS实体的关联定义，添加cascade属性明确级联行为：
修改PostingDocuments中的关联字段：

entity PostingDocuments : cuid,managed {
    PostingDocumentName  :  String;
    packagingIssue      : Association to many PackagingIssues on 
        packagingIssue.postingDocument = $self
        cascade insert, update, delete; // 按需添加级联规则
}

• cascade insert：允许通过主实体关联插入子实体
• cascade update：允许通过主实体关联更新子实体的关联关系
• cascade delete：允许通过主实体关联删除子实体（根据业务需求选择）

同时建议明确PackagingIssues的反向关联类型：

entity PackagingIssues : cuid, managed {
    PackagingIssueId  :  String;
    issueDes          :  String(80);
    postingDocument   :  Association to one PostingDocuments; // 明确为to one关联
}

2. 用空集合替代null解决置空报错 #

OData V4规范中，对多关联不允许直接设为null，需用**空数组[]**表示空列表。
如果是通过OData请求更新，请求体示例：

{
    "PostingDocumentName": "示例文档",
    "packagingIssue": []
}

3. 手动维护关联关系（备选方案） #

若不想使用级联操作，可单独处理子实体：

• 添加新PackagingIssue：直接插入PackagingIssues实体，指定其postingDocument关联到目标PostingDocuments
• 移除已有对象：更新对应PackagingIssues实体，将postingDocument设为null或关联到其他主实体
• 置空列表：批量更新所有关联的PackagingIssues，将它们的postingDocument字段置空

验证步骤 #

1. 重新编译部署修改后的CDS实体
2. 分别测试添加、移除、置空关联列表的操作
3. 检查数据库中关联关系是否正确更新

内容的提问来源于stack exchange，提问作者Jhunulata Mishra