I'm encountering an error when trying to execute the following query:
ErrorCode: 58000 Failed to get results of query Reason: [Unable to create table : decile_table. Detailed Error: Got non-successful response. Code: 400. Response body: {"type":"http://ns.adobe.com/aep/errors/XDM-1532-400","title":"Invalid xdm:sourceProperty value","status":400,"report":{"registryRequestId":"a8c70fb9-fb6f-4f8c-9f9a-330282f5dce6","timestamp":"11-07-2024 09:27:58","detailed-message":"The provided xdm:sourceProperty value ([Ljava.lang.String;@6812fd65) is invalid. Note that the property path should start with / and not have a / at the end.","sub-errors":[]},"detail":"The provided xdm:sourceProperty value ([Ljava.lang.String;@6812fd65) is invalid. Note that the property path should start with / and not have a / at the end."}]"
I'm using the query below to create the table:
CREATE TABLE decile_table ( id TEXT PRIMARY KEY NAMESPACE 'personid13', decile1Month MAP<TEXT, INTEGER> ) WITH (LABEL='PROFILE');
This is the same query structure provided in AEP's documentation for creating a derived dataset, but it doesn’t seem to work here. I’ve tried several adjustments without success. Has anyone else encountered this, or does anyone know how to resolve it?
Thanks in advance.
