Skip to Content
Jul 02, 2021 at 01:47 PM

DWC Business Builder Authorisation Scenario on Consumption Model error code 257

225 Views Last edit Jul 06, 2021 at 02:34 PM 2 rev

Hi all,

just tried to configure step by step SAP Modelling Guide to create an authorization scenario for a consumption model.

But if i try to apply the authorization scenario on a consumption model i am not able to save because of this error:


Correlation ID: f525bb90-489c-4d53-62c4-9ff50ed3fdcd
HTTP Status: 500 Internal Server Error
Error Code: 257
Technical Message: sql syntax error: incorrect syntax near "[": line 1 col 195 (at pos 195), Code: 257, SQL State: HY000


Based on the Demo Content I create a Data access control to restrict the employee table through Employee ID

I created 2 Business Entities Dimension Employee and an analytical dataset salesorders

applied on both business entities the authorization scenario and in the data preview everything is fine.

creating a consumption model and applying the scenario i'll get this error. Is this a bug or do i miss something.

thanks for advice greetings cornelius