error 58000 when creating a derived dataset | Community
Skip to main content
November 7, 2024
Solved

error 58000 when creating a derived dataset

  • November 7, 2024
  • 1 reply
  • 565 views

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.


This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Tof_Jossic

@maxte1 If this is still an issue, please raise a Support ticket with your full query, this may have to go to our Engineering team.

1 reply

Tof_Jossic
Adobe Employee
Tof_JossicAdobe EmployeeAccepted solution
Adobe Employee
November 25, 2024

@maxte1 If this is still an issue, please raise a Support ticket with your full query, this may have to go to our Engineering team.