Error creating CAP draft for Entities which have key different from ID

[former_member636619]

Hi Everyone

I am facing an issue where the entities marked as draft needs to have key as id, it's failing for key of other naming convention. Any idea how to make this work?

com.sap.cds.services.impl.ContextualizedServiceException: SQLException executing >>SELECT T1.relative_ID, T1.HasActiveEntity, T1.modifiedAt, T1.workflowSubtype, T1.HasDraftEntity, T1.type, T1.createdAt, T1.IsActiveEntity, T1.createdBy, T1.documentKey, T1.name, T1.workflow_UUID, T1.modifiedBy, T1.DraftAdministrativeData_DraftUUID, T1.UUID, T1.IsActiveEntity as "IsActiveEntity", T1.HasDraftEntity as "HasDraftEntity", T1.HasActiveEntity as "HasActiveEntity", T1.DraftAdministrativeData_DraftUUID as "DraftAdministrativeData_DraftUUID" FROM (SELECT * FROM (SELECT T0.*, true as IsActiveEntity, false as HasActiveEntity, COALESCE(T1.HasActiveEntity, false) as HasDraftEntity, T1.DraftAdministrativeData_DraftUUID as DraftAdministrativeData_DraftUUID from UserService_Relatives T0 left outer join UserService_Relatives_drafts T1 on T0.ID = T1.ID) T0 WHERE T0.IsActiveEntity = ? and T0.ID = ?) T0 INNER JOIN (SELECT T0.*, true as IsActiveEntity, false as HasActiveEntity, COALESCE(T1.HasActiveEntity, false) as HasDraftEntity, T1.DraftAdministrativeData_DraftUUID as DraftAdministrativeData_DraftUUID from UserService_Documents T0 left outer join UserService_Documents_drafts T1 on T0.ID = T1.ID) T1 ON T1.relative_ID = T0.ID<< (service 'PersistenceService$Default', event 'READ', entity 'UserService.Relatives')
        at com.sap.cds.services.impl.ServiceImpl.dispatch(ServiceImpl.java:204) ~[cds-services-impl-1.9.0.jar:na]
        at com.sap.cds.services.impl.ServiceImpl.emit(ServiceImpl.java:132) ~[cds-services-impl-1.9.0.jar:na]
        at com.sap.cds.services.ServiceDelegator.emit(ServiceDelegator.java:34) ~[cds-services-api-1.9.0.jar:na]
        at com.sap.cds.services.impl.cds.CdsServiceBaseImpl.run(CdsServiceBaseImpl.java:51) ~[cds-services-impl-1.9.0.jar:na]
        at com.sap.cds.services.impl.draft.DraftHandler.executePlain(DraftHandler.java:726) ~[cds-services-impl-1.9.0.jar:na]
        at com.sap.cds.services.impl.draft.DraftHandler.execute(DraftHandler.java:584) ~[cds-services-impl-1.9.0.jar:na]
        at com.sap.cds.services.impl.draft.DraftHandler.read(DraftHandler.java:504) ~[cds-services-impl-1.9.0.jar:na]
        at com.sap.cds.services.impl.draft.DraftHandler.read(DraftHandler.java:776) ~[cds-services-impl-1.9.0.jar:na]

[marcelmerkle · Accepted solution]

Hi Yash,

this bug was fixed with cds-services version 1.11.0.

Best regards,

Marcel

[former_member636619 · Accepted solution]

Thanks a lot Marcel. That did the trick.